PERS_NID_VW2 (SQL View)	Index Back
PERS_NID Record View on the PERS_NID record used for SOA services.

PERS_NID_VW2

(SQL View)

PERS_NID Record

View on the PERS_NID record used for SOA services.

SELECT EMPLID , COUNTRY , NATIONAL_ID_TYPE , NATIONAL_ID , SSN_KEY_FRA , PRIMARY_NID , TAX_REF_ID_SGP , ' ' , %DateNull , LASTUPDDTTM , LASTUPDOPRID FROM PS_PERS_NID

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: NID_TYPE_VW

3 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE
Prompt Table: NID_TYPE1_VW

4 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

5 SSN_KEY_FRA Character(2) VARCHAR2(2) NOT NULL Social Security Number Key

6 PRIMARY_NID Character(1) VARCHAR2(1) NOT NULL Primary ID
Y/N Table Edit
Default Value: N

7 TAX_REF_ID_SGP Character(1) VARCHAR2(1) NOT NULL Tax Reference Id - Singapore
Y/N Table Edit
Default Value: N

8 NID_SPECIAL_CHAR Character(20) VARCHAR2(20) NOT NULL NID as Stored

9 NID_EXPIRY_DATE Date(10) DATE National ID Expiry Date

10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: NID_TYPE_VW
3	NATIONAL_ID_TYPE	Character(6)	VARCHAR2(6) NOT NULL	National ID Type Default Value: NID_TYPE2_VW.NATIONAL_ID_TYPE Prompt Table: NID_TYPE1_VW
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	SSN_KEY_FRA	Character(2)	VARCHAR2(2) NOT NULL	Social Security Number Key
6	PRIMARY_NID	Character(1)	VARCHAR2(1) NOT NULL	Primary ID Y/N Table Edit Default Value: N
7	TAX_REF_ID_SGP	Character(1)	VARCHAR2(1) NOT NULL	Tax Reference Id - Singapore Y/N Table Edit Default Value: N
8	NID_SPECIAL_CHAR	Character(20)	VARCHAR2(20) NOT NULL	NID as Stored
9	NID_EXPIRY_DATE	Date(10)	DATE	National ID Expiry Date
10	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.