PY_LDTLCD_RCVW3

(SQL View)
Index Back

Load Time & Labor

Load Time & Labor Earnings Codes (Seperate Check Grouping 3)

SELECT OPRID ,RUN_CNTL_ID ,PY_LDTL_SEPCHK_GRP ,ERNCD ,PPA_IND FROM PS_PY_LDTLCD_RC WHERE PY_LDTL_SEPCHK_GRP = '3'

  • Parent record: PY_LDTL_RC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PY_LDTL_SEPCHK_GRP Character(1) VARCHAR2(1) NOT NULL Separate Check Group Code
    0=Filter Source
    1=Separate Check Grouping 1
    2=Separate Check Grouping 2
    3=Separate Check Grouping 3

    Default Value: 3

    4 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL

    5 PPA_IND Character(1) VARCHAR2(1) NOT NULL Prior Period Adjustments Only

    Y/N Table Edit

    Default Value: N