PERS_DATA_US_VW (SQL View)	Index Back
Extension of PERSON for USA Extension of the PERSON object for US specific fields with EFFDT

PERS_DATA_US_VW

(SQL View)

Extension of PERSON for USA

Extension of the PERSON object for US specific fields with EFFDT

SELECT EMPLID ,EFFDT ,US_WORK_ELIGIBILTY ,MILITARY_STATUS ,CITIZEN_PROOF1 ,CITIZEN_PROOF2 ,MEDICARE_ENTLD_DT FROM PS_PERS_DATA_USA A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_PERS_DATA_USA B WHERE A.EMPLID = B.EMPLID AND B.EFFDT <= %CurrentDateIn)

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: PERSON.EMPLID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 US_WORK_ELIGIBILTY Character(1) VARCHAR2(1) NOT NULL Eligible to Work in U.S.
N=No
Y=Yes
Y/N Table Edit
Default Value: Y

4 MILITARY_STATUS Character(1) VARCHAR2(1) NOT NULL Veteran Status / Military Status
Default Value: 1

5 CITIZEN_PROOF1 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 1)

6 CITIZEN_PROOF2 Character(10) VARCHAR2(10) NOT NULL Citizenship (Proof 2)

7 MEDICARE_ENTLD_DT Date(10) DATE Date Entitled to Medicare

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: PERSON.EMPLID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	US_WORK_ELIGIBILTY	Character(1)	VARCHAR2(1) NOT NULL	Eligible to Work in U.S. N=No Y=Yes Y/N Table Edit Default Value: Y
4	MILITARY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Veteran Status / Military Status Default Value: 1
5	CITIZEN_PROOF1	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 1)
6	CITIZEN_PROOF2	Character(10)	VARCHAR2(10) NOT NULL	Citizenship (Proof 2)
7	MEDICARE_ENTLD_DT	Date(10)	DATE	Date Entitled to Medicare