FSS_SDN_VW

(SQL View)
 Index Back

SDN Header / Entry View

This 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