FSS_SDN_VW(SQL View) |
Index Back |
---|---|
SDN Header / Entry ViewThis view provides a view of the Header and Entry tables joined. This will be used for generating the index information. |
SELECT E.SDN_ID , E.SDN_ENTRY_ID , A.SDN_ID_UID , E.SDN_LIST_TYPE , E.SDN_PUBLISH_DATE , E.LOAD_DTTM , E.SDN_ACTIVE , E.SDN_FIRST_NAME , E.SDN_LAST_NAME , E.SDN_WHOLENAME , E.SDN_TITLE , E.SDN_TYPE , E.SDN_REMARKS , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.CITY , A.STATE_PROVINCE , A.POSTAL , A.COUNTRY_NAME FROM PS_SDN_HDR_ENTR_VW E LEFT OUTER JOIN PS_SDN_ADDRESS_LST A ON A.SDN_ID = E.SDN_ID AND A.SDN_ENTRY_ID = E.SDN_ENTRY_ID |
# | 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_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 |
5 | SDN_PUBLISH_DATE | Date(10) | DATE | Publish date given on the loaded Financial Sanction list. |
6 | LOAD_DTTM | DateTime(26) | TIMESTAMP | Load Date and Time |
7 | 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 |
8 | SDN_FIRST_NAME | Character(100) | VARCHAR2(100) NOT NULL | First name of the Financial Sanction entry. |
9 | SDN_LAST_NAME | Character(100) | VARCHAR2(100) NOT NULL | Last name of an Financial Sanction entry. |
10 | SDN_WHOLENAME | Character(100) | VARCHAR2(100) NOT NULL | Whole name of the Financial Sanction entry. |
11 | SDN_TITLE | Character(100) | VARCHAR2(100) NOT NULL | Title for an Financial Sanction entry. |
12 | SDN_TYPE | Character(50) | VARCHAR2(50) NOT NULL | Type of Identification for a given Entry. |
13 | SDN_REMARKS | Character(150) | VARCHAR2(150) NOT NULL | Remarks for a given Financial Sanction entry. |
14 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
15 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
16 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
17 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
18 | STATE_PROVINCE | Character(25) | VARCHAR2(25) NOT NULL | State or Province |
19 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
20 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |