List of objects
An IRC object corresponds to a database table. The objects are displayed on the IRC user interface while building rule conditions.
This section lists the objects that can are extracted for the Process Insight for OFAC, the friendly names, the field names in these objects and the field friendly names.
| Object name | Object Friendly name | Transaction type | Field names | Field friendly name |
|---|---|---|---|---|
| OFAC Name | OFAC Name | Master | Specially Designated National ID | |
| TITLE | Title | |||
| SDN Type | ||||
| REMARKS | Remarks | |||
| FIRST_NAME | Name 1 | |||
| LAST_NAME | Name 2 | |||
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation Date | |||
| LAST_UPDATED _BY | Last Updated By | |||
| LAST_UPDATED _DATE | Last Updated Date | |||
| PROGRAM | Program | |||
| OFAC Vessel | OFAC Vessel | Master | CALL_SIGN | Call Sign |
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation Date | |||
| VESSEL_FLAG | Flag of Vessel | |||
| GROSS_ REGISTERED_ TONNAGE | Gross Registered Tonnage | |||
| LAST_UPDATED _BY | Last Updated By | |||
| LAST_UPDATED _DATE | Last Updated Date | |||
| VESSEL_ OWNER | Owner | |||
| TONNAGE | Tonnage | |||
| Vessel ID | ||||
| VESSEL_TYPE | Vessel Type | |||
| OFAC_SDN_ LIST | OFAC SDN List | Master | CREATED_BY | Created by |
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| PUBLISH_DATE | Publish date | |||
| RECORD_ COUNT | Record count | |||
| SDN_LIST_ID | SDN list id | |||
| OFAC Identification Form | OFAC Identification Form | Master | CREATED_BY | Created by |
| CREATION_ DATE | Creation Date | |||
| EXPIRATION_ DATE | Expiration Date | |||
| ID_COUNTRY | Identification Country | |||
| Identification Form ID | ||||
| ID_NUMBER | Identification Number | |||
| ID_TYPE | Identification Type | |||
| ISSUE_DATE | Issue Date | |||
| LAST_UPDATED _BY | Last Updated By | |||
| LAST_UPDATED _DATE | Last Updated Date | |||
| OFAC AKA Name | OFAC AKA Name | Master | AKA_NAME_ID | AKA Name ID |
| CREATED_BY | Created By | |||
| CREATION_ DATE | Creation Date | |||
| FIRST_NAME | First Name | |||
| LAST_NAME | Last Name | |||
| LAST_UPDATED _BY | Last Updated By | |||
| LAST_UPDATED _DATE | Last Updated Date | |||
| AKA_ CATEGORY | AKA Category | |||
| AKA_TYPE | AKA Type | |||
| OFAC Address | OFAC Address | Master | ADDRESS_ID | Address ID |
| ADDRESS1 | Address Line 1 | |||
| ADDRESS2 | Address Line 2 | |||
| ADDRESS3 | Address Line 3 | |||
| CITY | City | |||
| COUNTRY | Country | |||
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation Date | |||
| LAST_UPDATED _BY | Last Updated By | |||
| LAST_UPDATED _DATE | Last Updated Date | |||
| POSTAL_CODE | Postal Code | |||
| STATE_OR_ PROVINCE | State or Province | |||
| OFAC_ NATIONALITY | OFAC Nationality | Master | COUNTRY | Country |
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| MAIN_ENTRY | Main entry | |||
| NATIONALITY_ID | Nationality id | |||
| OFAC_ CITIZENSHIP | OFAC Citizenship | Master | CITIZENSHIP_ID | Citizenship id |
| COUNTRY | Country | |||
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| MAIN_ENTRY | Main entry | |||
| OFAC_ COUNTRY | OFAC Country | Master | COUNTRY | Country |
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| OFAC_ PROGRAM | OFAC Program | Master | CREATED_BY | Created by |
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| PROGRAM | Program | |||
| OFAC_DATE_ OF_BIRTH_ ITEM | OFAC Date Of Birth Item | Master | CREATED_BY | Created by |
| CREATION_ DATE | Creation date | |||
| DATE_OF_ BIRTH | Date of birth | |||
| Date of birth item id | ||||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| MAIN_ENTRY | Main entry | |||
| Country | ||||
| CREATED_BY | Created by | |||
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date | |||
| OFAC_PLACE_ OF_BIRTH_ ITEM | OFAC place of birth item | Master | PLACE_OF_ BIRTH | Place of birth |
| MAIN_ENTRY | Main entry | |||
| CREATED_BY | Created by | |||
| PLACEOFBIRTH | Place of birth | |||
| Place of birth items id | ||||
| CREATION_ DATE | Creation date | |||
| LAST_UPDATED _BY | Last updated by | |||
| LAST_UPDATED _DATE | Last updated date |