SAE_PERSNID_VW

(SQL View)
Index Back

SAIP person national ID view

Person National ID view for SAIP

SELECT EMPLID , COUNTRY , NATIONAL_ID_TYPE , NATIONAL_ID , SSN_KEY_FRA , PRIMARY_NID , TAX_REF_ID_SGP , 'A' SAE_MODE FROM PS_PERS_NID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
5 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security # Key
6 PRIMARY_NID Character(1) VARCHAR2(1) NOT NULL Primary ID
7 TAX_REF_ID_SGP Character(1) VARCHAR2(1) NOT NULL Tax Reference Id - Singapore
8 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
A=Add
C=Change
D=Delete