HR_LBR_JOBCD_VW

(SQL View)
 Index Back

Labor Agreement Job Code View


SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , A.SETID_JOBCODE , A.JOBCODE , B.DESCR , A.EMPL_CTG , A.SETID_SALARY , A.SAL_ADMIN_PLAN , A.GRADE FROM PS_HR_LBR_JOBCODE A , PS_JOBCODE_TBL B WHERE A.EFFDT = ( SELECT MAX(A_SUB.EFFDT) FROM PS_HR_LBR_JOBCODE A_SUB WHERE A_SUB.SETID = A.SETID AND A_SUB.LABOR_AGREEMENT = A.LABOR_AGREEMENT AND A_SUB.SETID_JOBCODE = A.SETID_JOBCODE AND A_SUB.JOBCODE = A.JOBCODE AND A_SUB.LABOR_JOB_CLASS = A.LABOR_JOB_CLASS AND A_SUB.EMPL_CTG = A.EMPL_CTG AND A_SUB.EFFDT <= %CurrentDateIn) AND B.JOBCODE = A.JOBCODE AND B.SETID = A.SETID_JOBCODE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B_SUB.EFFDT) FROM PS_JOBCODE_TBL B_SUB WHERE B_SUB.SETID = B.SETID AND B_SUB.JOBCODE = B.JOBCODE AND B_SUB.EFFDT <= A.EFFDT)

  • Parent record: HR_LABOR_AGRMNT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: HR_LABOR_AGRMNT

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: SET_VLD_HR_02

    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: TL_JOBCODE_VW

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
    8 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    9 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
    10 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade