GPS_JOB_PRV_VW(SQL View) |
Index Back |
|---|---|
GPS Job Previous Rows ViewJoin Job, Job GPS and Employee Category GPS to link employee category type to Job rows for validation. |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , C.GPS_EMP_CTGRY_TYPE FROM PS_JOB A , PS_JOB_GPS B , PS_EMPL_CTG_L1_GPS C WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = A.EFFDT AND B.EFFSEQ = A.EFFSEQ AND C.SETID = A.SETID_LBR_AGRMNT AND C.LABOR_AGREEMENT = A.LABOR_AGREEMENT AND C.EMPL_CTG = A.EMPL_CTG AND %EffdtCheck(EMPL_CTG_L1_GPS, C, A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: JOB.EMPLID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: JOB.EMPL_RCD |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: JOB.EFFSEQ |
| 5 | GPS_EMP_CTGRY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Category Type is an indicator used to determine whether certain GPS attributes are applicable, such as probation periods, pre-service periods, GPS jobs, case group and BDA date.
A=Apprentice B=Blue Collar Worker C=Civil Servant on Tenure I=Judge per Instruction J=Judge on Probation O=Other P=Civil Servant on Probation R=Civil Servant on Recall S=Public Sector Employee T=Trainee U=Judge on Tenure V=Civil Servant in Retirement W=White Collar Worker |