GPSC_SSB_JOB_VW(SQL View) |
Index Back |
|---|---|
Job Data View.Job Data View. |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.JOB_INDICATOR , A.COMPANY , A.PAY_SYSTEM_FLG , A.GP_PAYGROUP , B.DESCR FROM PS_JOB A , PS_JOBCODE_TBL B WHERE A.EFFDT=( SELECT MAX(JOB.EFFDT) FROM PS_JOB JOB WHERE JOB.EMPLID=A.EMPLID AND JOB.EMPL_RCD=A.EMPL_RCD AND JOB.EFFDT<=%CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(JOB1.EFFSEQ) FROM PS_JOB JOB1 WHERE JOB1.EMPLID = A.EMPLID AND JOB1.EMPL_RCD = A.EMPL_RCD AND JOB1.EFFDT = A.EFFDT) AND A.SETID_JOBCODE = B.SETID AND A.JOBCODE = B.JOBCODE AND %EffdtCheck(JOBCODE_TBL, B, A.EFFDT) AND B.EFF_STATUS = 'A' AND A.ACTION <> 'TER' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PER_ORG_ASGN.EMPLID Prompt Table: PERS_SRCH_GBL |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 7 | PAY_SYSTEM_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface |
| 8 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |