**PUB LOG Extract Source**

**Management.zip**

**V_FLIS_MANAGEMENT.CSV  (15 million + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"EFFECTIVE_DATE",211EFF_DT_2128"MOE",32MOE_CD_2833"AAC",41AAC_2507"SOS",53SOS_CD_3690"SOSM",63SOSM_CD_2948"UI",72UI_3050"UI_CONV_FAC",85VUI_CONV_FAC_3053"UNIT_PRICE",912VUNIT_PR_7075"QUP",101QUP_6106"CIIC",111CIIC_2863"SLC",121SLC_2943"REP_REC_CODE",131RECOV_CD_SOC_2781"MGMT_CTL",147Service specific from V_FLIS_MGMT* below"REP_NET_PR",151REP_NET_PR_5235"USC"161USI_SVC_CD_0745

**V_FLIS_MANAGEMENT_FUTURE.CSV  (134 thousand + rows, varies up/down)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"EFFECTIVE_DATE",211EFF_DT_2128"MOE",32MOE_CD_2833"AAC",41AAC_2507"SOS",53SOS_CD_3690"UI",62UI_3050"UNIT_PRICE",712VUNIT_PR_7075"QUP",81QUP_6106"CIIC",91CIIC_2863"SLC",101SLC_2943"REP_REC_CODE",111RECOV_CD_SOC_2781"REP_NET_PR",121REP_NET_PR_5235"USC"131USI_SVC_CD_0745

**V_FLIS_PHRASE.CSV  (3 million + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"MOE",22MOE_CD_2833"USC",31USI_SVC_CD_0745"PHRS_CD",41PHRS_CD_2862"PHRASE_STATEMENT",549Vnone"ORDER_OF_USE",63OOU_0793"JUMP_TO_CODE",73JTC_0792"QPA",83QTY_PER_ASBL_0106"UM",92UNIT_MEAS_CD_0107"TECH_DOC_NBR",1020VTECH_DOC_NBR_2893"QNTV_EXPRSN"1113VQNTV_EXPRSN_8575

**V_MGMT_AIR_FORCE.CSV  (2 million + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"FUND",22FUND_CD_AF_2695"BUDGET",31BDGT_CD_AF_3765"MMAC",42MMAC_AF_2836"PVC",51PVC_AF_0858"ERRC"61ERRC_CD_AF_2655

**V_MGMT_ARMY.CSV  (1 million + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"MATCAT_1",21MAJ_MCC_AR_9256"MATCAT_2",31AR_MCC_AP_SUB_2163"MATCAT_3",41AR_MCC_USE_CD_2161"MATCAT_4_5",52AR_MCC_SG_CD1_2167"ARC"61ACTG_RQMT_AR_2665

**V_MGMT_COAST_GUARD.CSV  (26 thousand + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"IAC",21INV_ACT_CG_0708"SNC",31SER_NO_CTL_CG_0763"SMCC"41SP_MAT_CONT_0121

**V_MGMT_MARINE_CORPS.CSV  (700 thousand + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"SAC",21STRS_ACT_MC_3311"CEC",31CMBT_ESTL_MC_3311"MEC",41ECH_CD_MC_3150"MIC",51MAT_IDEN_MC_4126"OTC",61OPRTL_TST_MC_0572"PCC"71PHY_CTGY_MC_0573

**V_MGMT_NAVY.CSV  (4 million + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"COG",22COG_CD_NVY_2608"SMIC",32SMIC_NVY_2834"IRRC",42IRRC_NVY_0132"SMCC"51SP_MAT_CONT_0121

**V_SOCOM_MANAGEMENT.CSV  (12 thousand + rows)**

Field NameColumnLengthDRN                                                                      "NIIN",19NCB_CD_4130 + I_I_NBR_4131"ICP",21SO_MCC_INV_CD_2787"A_L",31SO_MCC_AP_CD_2789"REP",41SO_MCC_REP_CD_2792"W_ESDC",52SO_MCC_WS_CD_2797"AR",61ACT_RQ_CD_SOC_2783"COS"71SO_CL_SUP_CD_2776