GPMX_RC_WRKRISK

(SQL Table)
 Index Back

Absences Report Run Control

Absences Report

  • Parent Record Of GPMX_NRP_WKR_AD GPMX_RC_WKRSK_C

    • # 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: GPMX_ESTAB_VW

    5 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
    6 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    7 GPMX_RPU_ESTABID Character(12) VARCHAR2(12) NOT NULL RPU Establishment
    8 GPMX_ESTABID_OPTN Character(1) VARCHAR2(1) NOT NULL Establishment option
    J=Job Data
    L=Location

    Default Value: L