Header Description Licensing Database

No Field Name Field Description1 PROG OFAC Sanctions Program that License Case relates to2 FACNO OFAC unique identifier for the Correspondence that initiated the case3 LIC_CASE_NO OFAC unique identifier for the License Case4 LICENSEE Party potential License is for5

 SIGNED_BY Licensing Division Employee (in most cases the Licensing Chief) with Auth

License decision

6 STATUS Status of License Case7 STAFF Licensing Officer that worked (is working) the License Case8 CATEGORY Category of License9 SUBCATEGORY Subcategory of License10

 DATE_CREATED Date License Case created database (system generated date that records whe

record created)

11 DATE_ISSUED Date License Case decision issued12

 CASE_DATE_CREATED Date License Case created in database (system generated date that records w

record created)

13 CASE_CREATED_BY License Officer that created License Case database record14 CASE_LICENSEE Party potential License is for15

 CASE_LICENSEE_NAME Party potential License is for (for historic records sometimes indicates party 

of)

16 CASE_CATEGORY Category of License17 LIC_SEQNO Unique identifier of sub-records for an individual License Case (e.g. an ame18 DATE_APPLIED Date Licensee (or representative of the Licensee) applied for License19 DATE_RCVD Date License Request received20

 AMENDMENT Character field that indicates whether sub-record of license record is an ame

amendment (e.g.: a, b, c, etc.)

21 DATE_EXPIRES Date License expires22

 ADDRESS1 Address line 1 of the Actual Party to the License or the Correspondent apply

Party to the license

23

 ADDRESS2 Address line 2 of the Actual Party to the License or the Correspondent apply

Party to the license

24

 ADDRESS3 Address line 3 of the Actual Party to the License or the Correspondent apply

Party to the license

Page 1 of 3
Header Description Licensing Database

No Field Name Field Description

25

 CITY City of the of the Actual Party to the License or the Correspondent applying 

Party to the license

26

 STATE State of the Actual Party to the License or the Correspondent applying on be

the license

27

 ZIP_CODE Zip Code of the Actual Party to the License or the Correspondent applying o

Party to the license

28

 COUNTRY Country of the Actual Party to the License or the Correspondent applying on 

to the license

29 DURATION If travel related license, length of trip (or number of trips)30 REPORTING Not used31 LICENSE_DOC Not used32 OTHER_LICENSEES Additional Parties to License33

 REC_LICENSEE_NAME Party potential License is for (for historic records sometimes indicates the pa

behalf of)

34 RETURNED Not Used35 DIV_UNIT Division Staff Field employee resided in when License Case was created36

 SIGNED_BY Licensing Division Employee (in most cases the Licensing Chief) with autho

License decision

37

 CHANGED_BY Licensing Officer (if any) that edited any of the case’s information after the 

38 CREATED_BY Licensing admin staff that created the License Case database record39 DATE_CHANGED Last date and time that the License Case was edited40 CSTATUS (Custom Status) - additional way to identify License Case (e.g. referenced in 41 SALUTATION Salutation of person who signed License Application42 CORRESPONDENT_FNAME First Name of the person who signed the License Application43 CORRESPONDENT_MNAME Middle Name of person who signed License Application44 CORRESPONDENT_LNAME Last Name of person who signed License Application45 SUFFIX Full name of person who signed License Application46

 CORRESPONDENT Full name of person who signed License Application - The Correspondent is 

organization. (format: Last, First Middle)

Page 2 of 3
Header Description Licensing Database

No Field Name Field Description

47

 ORGANIZATION Organization that the correspondence is being sent to (if outgoing correspon

OFAC from (if incoming correspondence). This could be a representative orgfirm, a person writing on his/her behalf, or a legal entity such as an NGO. OrParty are different. If an Organization sends an application for its own benefiOrganization. If a person sends an application requesting a response for him/Correspondent.

48

 EXEC_SECNO If the correspondence that initiated the License Case contained a pre-populat

(originated in an "Outside of OFAC" database system), that number is captur

49

 FOIA_NUMBER If the correspondence that initiated the License Case contained a pre-populat

(originated in an "Outside of OFAC" database system), that number is captur

50 RESPONSE_DUE_DATE Date that a response is due to the applicant51 PHONE_COUNTRY Actual Party’s (or Actual Party’s correspondent) Country Code52 PHONE_AREA Actual Party’s (or Actual Party’s correspondent) Area Code53 PHONE_EXCHANGE Actual Party’s (or Actual Party’s correspondent) Phone Exchange54 PHONE_NUMBER Actual Party’s (or Actual Party’s correspondent) Phone Number55 PHONE_EXTENSION Actual Party’s (or Actual Party’s correspondent) Phone Extension56 FAX_COUNTRY Actual Party’s (or Actual Party’s correspondent) Country Code57 FAX_AREA Actual Party’s (or Actual Party’s correspondent) Fax Area Code58 FAX_EXCHANGE Actual Party’s (or Actual Party’s correspondent) Fax Exchange59 FAX_NUMBER Actual Party’s (or Actual Party’s correspondent) Fax Phone Number60 PHONE_INTERNATIONAL Actual Party’s (or Actual Party’s correspondent) International or Domestic P61 FAX_INTERNATIONAL Actual Party’s (or Actual Party’s correspondent) International or Domestic F62 REQUEST_TYPE Type of request that initiated the License Case (e.g. "License Application")63

 TRANSACTION_AMOUNT Requested funds transfer amount for requests related to NGO, family remitta

and university/research institutions. Note: This field is not intended for litigalawyers that represent SDNs requesting authorization to represent SDNs and legal services).

64

 FUNDS_TRANSFER_AMOUNT For Wire Transfer Licenses, Amount of money sent from the originator to th

65

 COUNTRY_CODE Country address of Actual Party to the License (or the Correspondent applyi

Party to the License)

Page 3 of 3