HR_LBRJB_LY3_VW

(SQL View)
 Index Back

Labor Job Codes


SELECT DISTINCT A.JOBCODE ,A.LABOR_AGREEMENT ,A.SETID ,A.EFFDT , A.SETID_JOBCODE , A. LABOR_JOB_CLASS , A.EMPL_CTG FROM PS_HR_LBR_JOBCODE A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HR_LBR_JOBCODE B WHERE A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.SETID = B.SETID AND A.SETID_JOBCODE = B.SETID_JOBCODE AND A.JOBCODE = B.JOBCODE AND A. LABOR_JOB_CLASS = B.LABOR_JOB_CLASS AND A.EMPL_CTG = B.EMPL_CTG AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: TL_JOBCODE_VW

2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: HR_LABOR_AGRMNT

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

Prompt Table: SET_VLD_HR_02

6 LABOR_JOB_CLASS Character(10) VARCHAR2(10) NOT NULL Labor job class

Prompt Table: LBR_JOB_CLS_TBL

7 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

Prompt Table: EMPL_CTG_L1