PERS_DATA_MAX (SQL View)	Index Back
Pers_data_effdt Max Effdt Maximum Effdt from PERS_DATA_EFFDT. Used for cross updates and selects for EMPLOYMENT.

PERS_DATA_MAX

(SQL View)

Pers_data_effdt Max Effdt

Maximum Effdt from PERS_DATA_EFFDT. Used for cross updates and selects for EMPLOYMENT.

SELECT PER.EMPLID ,PDE.SEX ,PDE.LANG_CD ,PDE.HIGHEST_EDUC_LVL FROM PS_PERSON PER , PS_PERS_DATA_EFFDT PDE WHERE PER.EMPLID = PDE.EMPLID AND PDE.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PERS_DATA_EFFDT B WHERE B.EMPLID = PDE.EMPLID )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown

3 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese

4 HIGHEST_EDUC_LVL Character(2) VARCHAR2(2) NOT NULL Highest Education Level

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
3	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
4	HIGHEST_EDUC_LVL	Character(2)	VARCHAR2(2) NOT NULL	Highest Education Level