SDN_IDSDN_ENTRY_IDSDN_ID_UIDSDN_AKA_LIST_VW(SQL View) |
Index Back |
|---|---|
AKA List for a Sanction EntryAKA List for a Sanctioned Entry |
| SELECT SDN_ID , SDN_ENTRY_ID , SDN_ID_UID , SDN_TYPE , SDN_CATEGORY , SDN_LAST_NAME , SDN_FIRST_NAME , SDN_WHOLENAME FROM PS_SDN_AKA_LIST |
| # | 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_ENTRY_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Unique identifier for an Financial Sanction entry. |
| 3 | SDN_ID_UID |
Number(15,0) | DECIMAL(15) NOT NULL | Unique identifier for an ID of a given entry. |
| 4 | SDN_TYPE | Character(50) | VARCHAR2(50) NOT NULL | Type of Identification for a given Entry. |
| 5 | SDN_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | AKA Category for a given Financial Sanction Entry. |
| 6 | SDN_AKA_LAST_NAME | Character(100) | VARCHAR2(100) NOT NULL | Last name of an Financial Sanction entry. |
| 7 | SDN_AKA_FIRST_NAME | Character(100) | VARCHAR2(100) NOT NULL | First name of the Financial Sanction entry. |
| 8 | SDN_WHOLENAME | Character(100) | VARCHAR2(100) NOT NULL | Whole name of the Financial Sanction entry. |