GP_RGST_RC_ORG

(SQL Table)
 Index Back

Payroll Register Org Units

This table defines what detailed organizational units to print for the Payroll Results Register

  • Parent record: GP_PSLP_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).

    Default Value: GP_RGST_RC.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: GP_RGST_RC.RUN_CNTL_ID

    3 GP_RGST_SEG_SELECT Character(4) VARCHAR2(4) NOT NULL The type of segment selection for the payroll results register.
    COMP=Company
    DEPT=Department
    ESTB=Establishment
    LOCN=Location
    PAYG=Pay Group
    PYEN=Pay Entity
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUSUNIT_HR_VW

    5 ORG_LINK_UNIT Character(12) VARCHAR2(12) NOT NULL Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID

    Prompt Table: %GP_EDIT_FLD1