SDN_IDESDN=Enterprise SDN
EU=EU
OFAC=OFAC
A=Active
I=Inactive
SDN_HEADER(SQL Table) |
Index Back |
|---|---|
Financial Sanction List HeaderHeader record for list of Financial Sanction entries. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SDN_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Unique Identifier for a loaded Financial Sanction list. |
| 2 | SDN_LIST_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Types of lists that can be loaded into the system.
ESDN=Enterprise SDN EU=EU OFAC=OFAC |
| 3 | SDN_PUBLISH_DATE | Date(10) | DATE | Publish date given on the loaded Financial Sanction list. |
| 4 | LOAD_DTTM | DateTime(26) | TIMESTAMP | Load Date and Time |
| 5 | SDN_RECORD_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Record count provided on the loaded Financial Sanction list. |
| 6 | SDN_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether this version of the Financial Sanctions list is active or not. Only one list can be active at any given time.
A=Active I=Inactive |