GVT_CURV_LNG_VW(SQL View) |
Index Back |
---|---|
GVT CURRENT Personal Data VwPERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. You can create only one PERSONAL_DATA record per person. Related Language view for GVT_CURR_PERS_V. |
SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , AL.LANGUAGE_CD , A.BIRTHPLACE FROM PS_GVT_PERS_DATA A , PS_GVT_PERS_LANG AL , PS_GVT_JOB B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT <= %CurrentDateIn AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_GVT_JOB WHERE EMPLID = B.EMPLID AND EMPL_RCD = B.EMPL_RCD AND EFFDT = B.EFFDT AND GVT_STATUS_TYPE IN ('COM', 'COR')) AND A.EMPLID = AL.EMPLID AND A.EFFDT = AL.EFFDT AND A.EMPL_RCD = AL.EMPL_RCD AND A.EFFSEQ = AL.EFFSEQ |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW |
2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | BIRTHPLACE | Character(30) | VARCHAR2(30) NOT NULL | Birth Location |