GPBR_RC_PIS

(SQL Table)
Index Back

PIS Run Control Parameters

PIS Run Control Parameters

  • Parent Record Of GPBR_RC_PIS_EMP
  • # 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_YEAR_REFER Character(4) VARCHAR2(4) NOT NULL Reference Year
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 ACTIVE_PIS_BRA Number(1,0) SMALLINT NOT NULL PIS Activated

    1/0 Table Edit (1=True, 0=False)

    Default Value: 0

    6 GPBR_PIS_OPTNS Character(2) VARCHAR2(2) NOT NULL Criteria Options for PIS Assignment
    01=Select Establishments ID
    02=Select Employees
    03=Select Group ID

    Default Value: 01