GPBR_RC_DIRF_A

(SQL Table)
Index Back

Run Control DIRF Mensual Main

Run Control DIRF Mensual Main Record

  • Parent Record Of GPBR_RC_DIRF_PG GPBR_RC_DIRF_RT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    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: GPBR_ESTAB_VW

    5 FROM_DATE Date(10) DATE NOT NULL From Date
    6 THRU_DATE Date(10) DATE NOT NULL Thru Date
    7 GPBR_SORTID Character(10) VARCHAR2(10) NOT NULL SORT ID

    Prompt Table: GPBR_SORTID
    Set Control Field: GPBR_SORTID

    8 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest

    Default Value: EMP

    9 GPBR_RC_SELECT Character(1) VARCHAR2(1) NOT NULL Selector of parameter Run Type or Pay Group
    P=By Pay Group
    R=By Run Type

    Default Value: R