GPBR_RC_TRCOUP

(SQL Table)
Index Back

Transport Coupon Format

Transport Coupon Format Run Control Table

  • Parent Record Of GPBR_RC_TRCOUPE
  • # 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 GPBR_LIST_OPTION Character(1) VARCHAR2(1) NOT NULL List Option Brazil Run Control
    1=All Establishments & Employees
    2=Select Establishment ID
    3=Select Employees
    4=Select Group ID
    5=Select Pay Group
    6=All Employees
    7=Select Department ID

    Default Value: 1

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

    Prompt Table: ESTAB_TBL

    5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL