SETIDJOBCODEEFFDTDefault Value: %date
GPFR_DSN_JCD_VW(SQL View) |
Index Back |
|---|---|
View to fetch Jobcode detailsView to fetch Jobcode details |
| SELECT JBCD.SETID ,JBCD.JOBCODE ,JBCD.EFFDT , JBCD.INSEE_CD_FRA ,%Coalesce(JBLNG.DESCR ,JBCD.DESCR) FROM PS_JOBCODE_TBL JBCD LEFT OUTER JOIN PS_JOBCODE_LANG JBLNG ON (JBCD.SETID = JBLNG.SETID AND JBCD.JOBCODE = JBLNG.JOBCODE AND JBLNG.LANGUAGE_CD = 'FRA' AND JBCD.EFFDT = JBLNG.EFFDT ) WHERE JBCD.EFF_STATUS = 'A' AND JBCD.EFFDT = ( SELECT MAX(JBCD_B.EFFDT) FROM PS_JOBCODE_TBL JBCD_B WHERE JBCD_B.JOBCODE = JBCD.JOBCODE AND JBCD_B.SETID = JBCD.SETID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | INSEE_CD_FRA | Character(4) | VARCHAR2(4) NOT NULL | Insee Code - FRA |
| 5 | GPFR_DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Description |