Updated 6/27/2023

**PUB LOG Extract Source**

**H-SERIES.zip**

**P_H2_PICK.CSV  (6 hundred + rows)**

Field NameColumnLengthDRN                                                                      "FSG",12FSG_3996"FSC",24FSC_WI_FSG_3996"FSG_TITLE",396VFSG_TI_4972"FSC_TITLE"496VFSC_TI_4970

**P_H5_PICK.CSV  (93 thousand + rows)**

Field NameColumnLengthDRN                                                                      "ASSOCIATION_CAGE",15ASSOC_CD_CAGE_8855"CAGE_CODE",25CAGE_CD_9250"COMPANY",3178VADRS_NM_C_TXT_1086"CITY",436VCITY_1084"STATE",536VST_US_POSN_AB_0186“ZIP”,610VZIP_CD_4400 + ZIP_ADD_ON_4398“PROVINCE”,735VOTH_STA_PRVNC_8978“POSTAL_ZONE”,810VPOS_ZONE_2549“COUNTRY”936VCNTRY_1085

**P_H6_PICK.CSV  (79 thousand + rows)**

Field NameColumnLengthDRN                                                                      "INC",15INC_4080“ITEM_NAME”,232VSHRT_NM_2301 + NM_ROOT_RMDR_2517“FIIG”,36FIIG_4065“FIIG_4”,44FIIG_4065“FSC”,54FSG_3994 + FSC_WI_FSG_3996“IMM”650VIMM_9090

**V_H2_FSC.CSV  (6 hundred + rows)**

Field NameColumnLengthDRN                                                                      "FSC",14FSG_3994 + FSC_WI_FSG_3996“FSC_TITLE”,296VFSC_TI_4970“FSC_NOTES”,31325VFSC_NOTE_4962“FSC_INCLUSIONS”,4778VFSC_INCL_NAR_0375“FSC_EXCLUSIONS”5639VFSC_EXCL_NAR_0376

**V_H2_FSG.CSV  (6 hundred + rows)**

Field NameColumnLengthDRN                                                                      "FSC",14FSG_3994 + FSC_WI_FSG_3996“FSG_TITLE”,296VFSG_TI_4972“FSG_NOTES”31708VFSG_NOTE_4965

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

Field NameColumnLengthDRN                                                                      "DODIC",14AMMO_CD_8805“DODAC”,29FSC-AMMO_CD_8805“FSC”,34FSG_3994 + FSC_WI_FSG_3996“INC_STATUS”,41STA_CD_NM_FSC_0320“ITEM_NAME”,532VSHRT_NM_2301 + NM_ROOT_RMDR_2517“ITEM_DESCRIPTION”6840VCL_ASST_MODH3_9553

**V_H5_BUSINESS.CSV  (93 thousand + rows)**

Field NameColumnLengthDRN                                                                      "CAGE_CODE",15CAGE_CD_9250“BUSINESS_SIZE”,21SZ_OF_BUS_CD_1364“PRIMARY_BUSINESS”,31PR_BUS_CAT_CD_1365“BUSINESS_TYPE”,41TYP_BUS_CD_1366“WOMAN_OWNED”,51WMN_OWND_BUS_1367“CLEAR_TEXT”6165VORG_ID_TXT_SG_0010

**V_H5_CORPORATE.CSV  (93 thousand + rows)**

Field NameColumnLengthDRN                                                                      "CAGE_CODE",15CAGE_CD_9250“PARENT_CAGE”,25PARNT_TAXPYR_3403

“DESIGNATOR”,31CAGE_NSCM_DES_2620“TYPE”,41CAGE_TYP_CD_4238“CAGE_STATUS”,51CAGE_STAT_CD_2694“ASSOCIATION_CAGE”,65ASSOC_CD_CAGE_8855“AFFILIATION_CODE”,71TYP_CAGE_AFFL_0250“CAO”,86CAO_CD_8870“ADP”96ADP_PNT_CD_8835

**V_H5_DOMESTIC.CSV  (91 thousand + rows)**

Field NameColumnLengthDRN                                                                      "CAGE_CODE",15CAGE_CD_9250“STREET_1”,236VST_ADRS_1_1082“STREET_2”,336VST_ADRS_2_1083“PO_BOX”,436VPOBOX_1361“CITY”,536VCITY_1084“STATE”,62ST_US_POSN_AB_0186“ZIP”,710ZIP_CD_4400 + ZIP_ADD_ON_4398“COUNTRY”,836VCNTRY_1085“PHONE”,920VTEL_NBR_1359“FAX”1020VTEL_NBR_1359

**V_H5_FOREIGN.CSV  (92 thousand + rows)**

Field NameColumnLengthDRN                                                                      "CAGE_CODE",15CAGE_CD_9250“STREET_1”,236VST_ADRS_1_1082“STREET_2”,336VST_ADRS_2_1083“PO_BOX”,436VPOBOX_1361“CITY”,536VCITY_1084“PROVINCE”,635VOTH_STA_PRVNC_8978“COUNTRY”,736VCNTRY_1085“POSTAL_ZONE”,810VPOS_ZONE_2549“PHONE”,920VTEL_NBR_1359“FAX”1020VTEL_NBR_1359

**V_H6_MODIFIER.CSV  (54 thousand + rows)**

Field NameColumnLengthDRN                                                                      "INC",15INC_4080“FSC”,24FSG_3994 + FSC_WI_FSG_3996“MODIFIER”396VCL_ASST_MODH2_9554

**V_H6_NAME_INC.CSV  (79 thousand + rows)**

Field NameColumnLengthDRN                                                                      "INC",15INC_4080“INC_STATUS”,21STA_CD_NM_FSC_0320“CONCEPT_NO”,31CONCEPT_NBR_4488“FIIG”,46FIIG_4065“APP_KEY”,53APPLB_KEY_CD_0103“COND_CODE”,61FSC_COND_CD_2607“TYPE_CODE”,71ITM_NM_TYP_CD_3308“DT_ESTB_CANC”,811DT_ESTB_CANC_0308“DEFINITION”91762VITM_NM_DEF_5015

**V_H6_RELATED.CSV  (33 thousand + rows)**

Field NameColumnLengthDRN                                                                      "INC",15INC_4080“RELATED_INC”,25INC_4080“ITEM_NAME”332VSHRT_NM_2301 + NM_ROOT_RMDR_2517

**V_FSC_IMM.CSV  (49 thousand + rows)**

Field NameColumnLengthDRN                                                                      "INC",15INC_4080“FSC”,24FSG_3994 + FSC_WI_FSG_3996“IMM”350VIMM_9090