PY_LDTL_RC

(SQL Table)
 Index Back

Load Process Run Control

Load Process Run Control

  • Parent Record Of PY_LDTLCD_RC PY_LDTLCD_RCVW0 PY_LDTLCD_RCVW1 PY_LDTLCD_RCVW2 PY_LDTLCD_RCVW3 PY_LDTLEMP_RC PY_LDTLEMP_WRK1 PY_LDTLEMP_WRK2 PY_LDTLPGRP_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: PAY_RUN_TBL

    5 PROCESS_ON_OFF Character(1) VARCHAR2(1) NOT NULL Process On-Cycle or Off-Cycle
    F=Process Off-Cycle Checks
    O=Process On-Cycle Checks
    6 OK_TO_PAY Character(1) VARCHAR2(1) NOT NULL OK to Pay

    Y/N Table Edit

    Default Value: Y

    7 REPEAT_REQ_CD Character(1) VARCHAR2(1) NOT NULL Refresh Request
    A=All Between Range
    D=By Range of Dates
    N=None
    R=By Request Number
    T=By Last Request

    Default Value: N

    8 REQ_SRC Character(1) VARCHAR2(1) NOT NULL Request Source
    C=Pay Calculation
    F=Final Check
    O=On-Line Check
    U=User

    Default Value: U

    9 PY_LDTL_PRCS_OPT Character(1) VARCHAR2(1) NOT NULL Time and Labor Load Processing Option
    A=Load All Time
    F=Load Filtered Time
    P=Load Prior Period Time

    Default Value: A

    10 PY_LDTL_SEPCHK Character(1) VARCHAR2(1) NOT NULL Load Time to Paysheets on Separate Checks

    Y/N Table Edit

    Default Value: N

    11 FROMDATE Date(10) DATE From Date
    12 THRUDATE Date(10) DATE End Date