SDN_HDR_ENTR_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 H.SDN_ID , E.SDN_ENTRY_ID , H.SDN_LIST_TYPE , H.SDN_PUBLISH_DATE , H.LOAD_DTTM , H.SDN_ACTIVE , E.SDN_FIRST_NAME , E.SDN_LAST_NAME , E.SDN_WHOLENAME , E.SDN_TITLE , E.SDN_TYPE , E.SDN_REMARKS FROM PS_SDN_HEADER H , PS_SDN_ENTRY E WHERE E.SDN_ID = H.SDN_ID AND H.SDN_ACTIVE ='Y'

# 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_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
4 SDN_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.
5 LOAD_DTTM DateTime(26) TIMESTAMP Load Date and Time
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
7 SDN_FIRST_NAME Character(100) VARCHAR2(100) NOT NULL First name of the Financial Sanction entry.
8 SDN_LAST_NAME Character(100) VARCHAR2(100) NOT NULL Last name of an Financial Sanction entry.
9 SDN_WHOLENAME Character(100) VARCHAR2(100) NOT NULL Whole name of the Financial Sanction entry.
10 SDN_TITLE Character(100) VARCHAR2(100) NOT NULL Title for an Financial Sanction entry.
11 SDN_TYPE Character(50) VARCHAR2(50) NOT NULL Type of Identification for a given Entry.
12 SDN_REMARKS Character(150) VARCHAR2(150) NOT NULL Remarks for a given Financial Sanction entry.