GPNL_RC_SOC

(SQL Table)
 Index Back

Social Security Run Control

Contains fields that are used as input parameters for Social Security reports. Input data is retrieved from this record when a report is requested from the Process Scheduler.

  • Parent Record Of GPNL_RC_SSN_LST

    • # 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: GPNL_ESTB_VW

    5 GPNL_SOC_NUM Character(20) VARCHAR2(20) NOT NULL Social Security Number

    Prompt Table: GPNL_SOC_NUM_VW

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

    Prompt Table: GB_GROUP_SEC_VW

    7 GB_EFFDT Date(10) DATE Group As Of Date
    8 GB_REFINE_DATE Date(10) DATE Refinement Date
    9 GPNL_BLD_GRP Character(1) VARCHAR2(1) NOT NULL Rebuild Group

    Y/N Table Edit

    10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    11 BEGIN_DT Date(10) DATE Begin Date
    12 END_DT Date(10) DATE end date
    13 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact - Vacancy Announcement

    Prompt Table: PERS_SRCH_GBL

    14 GPNL_FILE_NAME Character(50) VARCHAR2(50) NOT NULL File Name
    15 GPNL_FILE_PATH Character(250) VARCHAR2(250) NOT NULL File Path
    16 GPNL_RPT_FILTER1 Character(1) VARCHAR2(1) NOT NULL Filter by
    1=EmplID
    2=Group
    3=Social Security Nr.
    17 GPNL_RPT_FILTER2 Character(1) VARCHAR2(1) NOT NULL Filter by 2
    1=EmplID
    2=Group
    18 GPNL_PIN_AC1_NUM Number(8,0) INTEGER NOT NULL This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
    19 GPNL_PIN_AC2_NUM Number(8,0) INTEGER NOT NULL This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
    20 GPNL_PCT_13TH_ACM Number(6,2) DECIMAL(5,2) NOT NULL 13th Month Allowance Percentage
    21 GPNL_PCT_HOLID_ACM Number(6,2) DECIMAL(5,2) NOT NULL Holiday Allowance Percentage
    22 GPNL_Y_N Character(1) VARCHAR2(1) NOT NULL This field is used in reporting
    N=N
    Y=Y

    Default Value: Y