OFFICE OF FOREIGN ASSETS CONTROL U.S. TREASURY DEPARTMENT NON-PLC PALESTINIAN LEGISLATIVE COUNCIL (NS-PLC) LIST DATA SPECIFICATION First Released: 06/11/2008 Format *.del consists of records separated by carriage returns (ASCII character 13), with fields (values) within records delimited by the "@" symbol (ASCII character 64). Text values are enclosed by quotation marks (")(ASCII character 34). Format *.ff consists of records separated by carriage returns, with fields within the records beginning at fixed locations. Format *.csv consists of records separated by carriage returns (ASCII character 13), with fields (values) within records delimited by the "," (comma) symbol (ASCII character 44). Format *.PIP consists of records separated by carriage returns (ASCII character 13), with fields (values) within records delimited by the "|" symbol (ASCII character 124). Null values for all four formats consist of "-0-" (ASCII characters 45, 48, 45). The @ Delimited (.del), Comma Separated Values (.csv), Pipe (|) delimited (.pip) and Fixed-Field (.ff) releases consist of three ASCII text files--a main file listing the name of the PLC and other information unique to that entity (PLC.*), a file of addresses (add.*), and a file of alternate names (alt.*). Addresses and alternate names are linked to particular PLC using unique integer values in a linking or primary key column. The integers used are assigned for linking purposes only and do not represent an official reference to that entity. Releases of the database-format files are intended as a service to the user community. All of OF AC's's lists are drawn from the same underlying data and every effort has been made to ensure consistency. Due to the nature, urgency, and sensitivity of the programs which OF AC'S administers and enforces, it may not always be possible to provide advanced notice to users of format changes to the database structure. The files associated with each release are: @ delimited: PLC_PRIM.DEL, PLC_ADD.DEL, PLC_AKA.DEL | delimited: PLC_PRIM.PIP, PLC_ADD.PIP, PLC_AKA.PIP fixed field: PLC_PRIM.FF, PLC_ADD.FF, PLC_AKA.FF Comma delimited: PLC_PRIM.CSV, PLC_ADD.CSV, PLC_AKA.CSV MY: NS_PLC.XML Misc: PLC_spec.txt (this file), nsplc.xsd (MY PLC schema), PLC_list.txt (ASCII version of the PLC list, non-delimited), PLC_list.pdf (PD version of the PLC list) [Each Zip Archive contains a total of 33 files] FORMAT PLC @ DELIMITED Main table, text file name PLC_PRIM.DEL Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number unique record identifier/unique listing identifier 2 PLC_Name text 350 name of PLC 3 PLC_Type text 12 type of PLC 4 Program text 50 sanctions program name 5 Title text 200 title of an individual 6 Call_Sign text 8 vessel call sign 7 Vess_type text 25 vessel type 8 Tonnage text 14 vessel tonnage 9 GRT text 8 gross registered tonnage 10 Vess_flag text 40 vessel flag 11 Vess_owner text 150 vessel owner 12 remarks text 1000 remarks on PLC Address table, text file name PLC_ADD.DEL Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 Ent_num number link to unique listing 2 Add_num number unique record identifier 3 Address text 750 street address of PLC 4 City text 50 city of address 5 Country text 250 country of address 6 Add_remarks text 200 remarks on address Alternate identity table, text file name PLC_AKA.DEL Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number link to unique listing 2 alt_num number unique record identifier 3 alt_type text 8 type of alternate identity (aka, fka, nka) 4 alt_name text 350 alternate identity name 5 alt_remarks text 200 remarks on alternate identity Record separator: carriage return field (value) delimiter: @ text value quotes: " null: -0- FORMAT PLC | DELIMITED Main table, text file name PLC_PRIM.PIP Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number unique record identifier/unique listing identifier 2 PLC_Name text 350 name of PLC 3 PLC_Type text 12 type of PLC 4 Program text 50 sanctions program name 5 Title text 200 title of an individual 6 Call_Sign text 8 vessel call sign 7 Vess_type text 25 vessel type 8 Tonnage text 14 vessel tonnage 9 GRT text 8 gross registered tonnage 10 Vess_flag text 40 vessel flag 11 Vess_owner text 150 vessel owner 12 remarks text 1000 remarks on PLC Address table, text file name PLC_ADD.PIP Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 Ent_num number link to unique listing 2 Add_num number unique record identifier 3 Address text 750 street address of PLC 4 City text 50 city of address 5 Country text 250 country of address 6 Add_remarks text 200 remarks on address Alternate identity table, text file name PLC_AKA.PIP Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number link to unique listing 2 alt_num number unique record identifier 3 alt_type text 8 type of alternate identity (aka, fka, nka) 4 alt_name text 350 alternate identity name 5 alt_remarks text 200 remarks on alternate identity Record separator: carriage return field (value) delimiter: | text value quotes: " null: -0- FORMAT PLC FIXED FIELD Main table, text file name PLC_PRIM.FF Column Posi- sequence Column name Type Size tion Description -------- ----------- ------- ---- ---- --------------------- 1 ent_num number 10 10 unique record identifier/unique listing identifier 2 PLC_Name text 350 11 name of PLC 3 PLC_Type text 12 361 type of PLC 4 Program text 50 373 sanctions program name 5 Title text 200 423 title of an individual 6 Call_Sign text 8 623 vessel call sign 7 Vess_type text 25 631 vessel type 8 Tonnage text 14 656 vessel tonnage 9 GRT text 8 670 gross registered tonnage 10 Vess_flag text 40 678 vessel flag 11 Vess_owner text 150 718 vessel owner 12 Remarks text 1000 868 remarks on PLC END OF ROW 1868 Address table, text file name PLC_ADD.FF Column Posi- sequence Column name Type Size tion Description -------- ----------- ------- ---- ---- --------------------- 1 Ent_num number 10 1 link to unique listing 2 Add_num number 10 11 unique record identifier 3 Address text 750 21 street address of PLC 4 City text 50 771 city of address 5 Country text 250 821 country of address 6 Add_remarks text 200 1071 remarks on address END OF ROW 1271 Alternate identity table, text file name PLC_AKA.FF Column Posi- sequence Column name Type Size tion Description -------- ----------- ------- ---- ---- --------------------- 1 ent_num number 10 1 link to unique listing 2 alt_num number 10 11 unique record identifier 3 alt_type text 8 21 type of alternate identity (aka, fka, nka) 4 alt_name text 350 29 alternate identity name 5 alt_remarks text 200 379 remarks on alternate identity END OF ROW 579 Record separator: carriage return null: -0- FORMAT PLC CSV Main table, text file name PLC.CSV Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number unique record identifier/unique listing identifier 2 PLC_Name text 350 name of PLC 3 PLC_Type text 12 type of PLC 4 Program text 50 sanctions program name 5 Title text 200 title of an individual 6 Call_Sign text 8 vessel call sign 7 Vess_type text 25 vessel type 8 Tonnage text 14 vessel tonnage 9 GRT text 8 gross registered tonnage 10 Vess_flag text 40 vessel flag 11 Vess_owner text 150 vessel owner 12 Remarks text 1000 remarks on PLC Address table, text file name ADD.CSV Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 Ent_num number link to unique listing 2 Add_num number unique record identifier 3 Address text 750 street address of PLC 4 City text 50 city of address 5 Country text 250 country of address 6 Add_remarks text 200 remarks on address Alternate identity table, text file name ALT.CSV Column sequence Column name Type Size Description -------- ------------ ------- ---- --------------------- 1 ent_num number link to unique listing 2 alt_num number unique record identifier 3 alt_type text 8 type of alternate identity (aka, fka, nka) 4 alt_name text 350 alternate identity name 5 alt_remarks text 200 remarks on alternate identity Record separator: carriage return field (value) delimiter: , text value quotes: " null: -0-