EMPLIDEMPL_RCDLANGUAGE_CDHCDL_MJOB_LANG(SQL View) |
Index Back |
|---|---|
Delegation Muti Job Lang ViewDelegation Muti Job Language View |
| SELECT A.EMPLID ,A.EMPL_RCD ,B.LANGUAGE_CD ,A.SETID_DEPT ,B.DESCR ,C.DESCR FROM PS_HCDL_ALL_JOB_VW A , PS_DEPT_TBL_LANG B , PS_JOBCODE_LANG C WHERE A.SETID_DEPT = B.SETID AND A.DEPTID = B.DEPTID AND A.SETID_JOBCODE = C.SETID AND A.JOBCODE = C.JOBCODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 5 | DEPTNAME | Character(30) | VARCHAR2(30) NOT NULL | Department |
| 6 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |