SDN_POB_LIST_VW (SQL View)	Index Back
Place of Birth List List of Places of Birth noted for the given Financial Sanction entry.

SDN_POB_LIST_VW

(SQL View)

Place of Birth List

List of Places of Birth noted for the given Financial Sanction entry.

SELECT SDN_ID ,SDN_ID_UID ,BIRTHPLACE ,SDN_MAIN_ENTRY FROM PS_SDN_POB_LIST

# 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_ID_UID Number(15,0) DECIMAL(15) NOT NULL Unique identifier for an ID of a given entry.

3 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

4 SDN_MAIN_ENTRY Character(5) VARCHAR2(5) NOT NULL Signifies whether a list item entry is the main entry or not.

#	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_ID_UID	Number(15,0)	DECIMAL(15) NOT NULL	Unique identifier for an ID of a given entry.
3	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
4	SDN_MAIN_ENTRY	Character(5)	VARCHAR2(5) NOT NULL	Signifies whether a list item entry is the main entry or not.