HR_LBR_JOBCD_V2

(SQL View)
Index Back

Labor Agreement JobCode View

This view reverses the names of the two SetID fields so that the Labor Agreement SetID is returned in the SETID_LBR_AGRMNT field, and the JobCode SetID is returned in the SETID field.

SELECT SETID , LABOR_AGREEMENT , EFFDT , SETID_JOBCODE , JOBCODE , LABOR_JOB_CLASS , EMPL_CTG , HIER_SEQ_NUM , SETID_SALARY , SAL_ADMIN_PLAN , GRADE FROM PS_HR_LBR_JOBCODE

  • Parent record: HR_LABOR_AGRMNT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_LBR_AGRMNT Character(5) VARCHAR2(5) NOT NULL Labor Agreement SetID
    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 Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: TL_JOBCODE_VW

    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

    8 HIER_SEQ_NUM Number(4,0) SMALLINT NOT NULL Bumping Sequence
    9 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID

    Prompt Table: HR_LBR_SETID_VW

    10 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: HR_LBR_SAL_VW

    11 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: HR_LBR_GRD_VW