SDN_HEADER_VW(SQL View) |
Index Back |
---|---|
Header view with Entry IDsHeader 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. |