SDN_HEADER_VW

(SQL View)
Index Back

Header view with Entry IDs

Header view with Entry IDs

SELECT H.SDN_ID , E.SDN_ENTRY_ID , H.SDN_PUBLISH_DATE , H.SDN_RECORD_COUNT , H.SDN_ACTIVE , E.SDN_FIRST_NAME , E.SDN_LAST_NAME , E.SDN_TITLE , E.SDN_TYPE FROM PS_SDN_HEADER H , PS_SDN_ENTRY E WHERE E.SDN_ID = H.SDN_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_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.
4 SDN_RECORD_COUNT Number(10,0) DECIMAL(10) NOT NULL Record count provided on the loaded Financial Sanction list.
5 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
6 SDN_FIRST_NAME Character(100) VARCHAR2(100) NOT NULL First name of the Financial Sanction entry.
7 SDN_LAST_NAME Character(100) VARCHAR2(100) NOT NULL Last name of an Financial Sanction entry.
8 SDN_TITLE Character(100) VARCHAR2(100) NOT NULL Title for an Financial Sanction entry.
9 SDN_TYPE Character(50) VARCHAR2(50) NOT NULL Type of Identification for a given Entry.