PERSON_IDLANGUAGE_CDRB_CAL_PRSN_LV(SQL View) |
Index Back |
|---|---|
Person Name ViewPerson Name View used in My Calendar application |
| SELECT W.PERSON_ID , D.LANGUAGE_CD , D.DESCR FROM PS_RB_WORKER W , PS_RD_PERSON P , PS_RD_PERSON_NAME N , PS_DEPT_TBL_LANG D WHERE W.PERSON_ID = N.PERSON_ID AND N.PRIMARY_IND = 'Y' AND W.PERSON_ID = P.PERSON_ID AND W.SETID_DEPT = D.SETID AND W.DEPTID = D.DEPTID AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_DEPT_TBL D2 WHERE D2.SETID = D.SETID AND D2.DEPTID = D.DEPTID AND D2.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |