SETIDJOBCODETRN_PROGRAMHR_CP_JOBCDTR_P(SQL View) |
Index Back |
|---|---|
Job Code Training ProgramJob Code Training Program view used as a prompt table for Career Planning Self Service product |
| SELECT A.SETID , A.JOBCODE , A.TRN_PROGRAM FROM PS_JOBCD_TRN_PROG A WHERE A.EFFDT= ( SELECT MAX(B.EFFDT) FROM PS_JOBCD_TRN_PROG B WHERE B.SETID=A.SETID AND B.JOBCODE=A.JOBCODE AND B.TRN_PROGRAM = A.TRN_PROGRAM AND B.EFFDT<=%CurrentDateIn) |
| # | 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 | TRN_PROGRAM |
Character(6) | VARCHAR2(6) NOT NULL | Training Program |