EMPLIDEMPL_RCDEFFDTDefault Value: %date
GPDE_BACODE_VW(SQL View) |
Index Back |
|---|---|
BA-Code ViewBA-Code View |
| SELECT JOB.EMPLID ,JOB.EMPL_RCD ,JOB.EFFDT ,JC.BA_CD ,JC.JOBCODE ,JC.DESCR FROM PS_JOBCODE_TBL JC , PS_JOB JOB WHERE JOB.REG_REGION = 'DEU' AND JOB.EFFSEQ = ( SELECT MAX(J1.EFFSEQ) FROM PS_JOB J1 WHERE J1.EMPLID = JOB.EMPLID AND J1.EMPL_RCD = JOB.EMPL_RCD AND J1.EFFDT = JOB.EFFDT ) AND JOB.JOBCODE = JC.JOBCODE AND JOB.SETID_JOBCODE = JC.SETID AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.JOBCODE = JC.JOBCODE AND JC1.SETID = JC.SETID AND JC1.EFFDT <= JOB.EFFDT ) AND JC.EFF_STATUS <> 'I' |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | BA_CD | Character(5) | VARCHAR2(5) NOT NULL | BA Code |
| 5 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |