JOBCODELANGUAGE_CDBEN_JOBCODE_VWL(SQL View) |
Index Back |
|---|---|
BEN Jobcode Related Language R |
| SELECT JB.JOBCODE ,JBL.LANGUAGE_CD FROM PS_JOBCODE_TBL JB ,PS_JOBCODE_LANG JBL WHERE JBL.JOBCODE=JB.JOBCODE AND JB.SETID=JBL.SETID AND JB.EFFDT=( SELECT MAX(JD.EFFDT) FROM PS_JOBCODE_TBL JD WHERE JD.SETID=JB.SETID AND JD.JOBCODE=JB.JOBCODE AND JD.EFFDT<=%CurrentDateIn) AND JBL.EFFDT=JB.EFFDT AND JB.EFF_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |