GP_RUNCTL_SQR

(SQL Table)
 Index Back

Main SQR run control record

Main, level 0 SQR run control record, used in all SQRs.

  • Parent Record Of GPGB_PEN_RUNCTL GPGB_PROF GPGB_PROF_NRVW GPGB_REP_PROF GPGB_RUNCTL_SQR GP_RUNCTL_SQR01 GP_RUNCTL_SQR02

    • # 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

    Prompt Table: %EDITTABLE

    4 PYGRP_LIST_OPTION Character(1) VARCHAR2(1) NOT NULL Field used in controlling report generation
    1=Entire Calendar Group
    2=Selected Pay Groups
    3=Selected Payees

    Default Value: 1

    5 EE_LVL_SORT_OPTION Character(2) VARCHAR2(2) NOT NULL Indicates whether to payee associated data should be sorted by EMPLID or NAME
    10=Employee ID
    20=Name

    Default Value: 10

    6 RUN_OPTIONS Character(2) VARCHAR2(2) NOT NULL Elements To Report
    10=All Main Elements
    20=Earnings, Deductions & Arrears
    30=Accumulators Only
    40=Earnings Only
    50=Deductions Only
    60=Earnings & Deductions