GPBR_NRP_RCR_VW

(SQL View)
Index Back

Abs Benefits By Disability BRA

Absence Code Mapping Request for Benefits by Disability Run Control Table.

SELECT OPRID ,RUN_CNTL_ID ,PIN_NUM + 50000000 ,GPBR_ABSENCE_CODE FROM PS_GPBR_RC_RBD_ACM

  • Parent record: GPBR_RC_RBD
  • # 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GP_PIN_ABSTK_VW

    4 GPBR_ABSENCE_CODE Character(2) VARCHAR2(2) NOT NULL Absence Code
    10=Sickness
    20=Work Accident
    30=Vacations