GPDE_RC_LOCATN

(SQL Table)
 Index Back

Location Table for Run Control

This record is used on the Run Control page to store multiple locations per Operator ID/ Run Control ID. It is currently used in the eStatistic process, AL06, and stores additional values which must be reported for this process. It allows the user to input number of total hours on the last 3 days of the month, as well as special circumstances for why employees received additional payments.

  • Related Language Record: GPDE_RC_LOC_LNG

  • Parent record: GPDE_RC_PAYROLL

    • # 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: GPDE_AL_PE_LOC

    5 GPDE_RC_EE_TYPE2 Character(1) VARCHAR2(1) NOT NULL Employee Type
    1=Monthly Salary Earners
    2=Hourly Wage Earners

    Default Value: 1

    6 GPDE_ER_HRS_WK Number(6,2) DECIMAL(5,2) NOT NULL Hours per Week
    7 GPDE_ER_DD_PER_WK Number(1,0) SMALLINT NOT NULL Work Days per Week
    8 GPDE_RC_COM_IMP Character(1) VARCHAR2(1) NOT NULL impact of public on company
    1=YES
    1=YES
    2=NO
    2=NO

    Default Value: 1

    9 GPDE_AL_06_SALARY Character(1) VARCHAR2(1) NOT NULL Special Circumstances for White Collar employees.
    1=Short Time Work
    2=Strike
    3=Bad Weather
    4=Other
    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 GPDE_AL_06_WAGE Character(1) VARCHAR2(1) NOT NULL Special Circumstances for salaried Blue Collar employees.
    1=Short Time Work
    2=Strike
    3=Bad Weather
    4=Other
    12 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    13 GPDE_AL_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Germany salary admin Plan 1
    14 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    15 GPDE_AL_SAL_PLAN_1 Character(4) VARCHAR2(4) NOT NULL Germany salary admin Plan 2
    16 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description
    17 GPDE_AL_SAL_PLAN_2 Character(4) VARCHAR2(4) NOT NULL Germany salary admin Plan 2
    18 DESCR254B Character(254) VARCHAR2(254) NOT NULL Description of length 254
    19 GPDE_AL_SAL_PLAN_3 Character(4) VARCHAR2(4) NOT NULL Germany salary admin Plan 2
    20 DESCR254C Character(254) VARCHAR2(254) NOT NULL Description of length 254
    21 GPDE_AL_SAL_PLAN_4 Character(4) VARCHAR2(4) NOT NULL Germany salary admin Plan 2
    22 DESCR254_1 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    23 GPDE_MIN_WAGE Character(4) VARCHAR2(4) NOT NULL Minimum Wage
    1=Yes
    2=No
    3=Unknown

    Default Value: 2

    24 GPDE_INTGNUM Number(11,0) DECIMAL(11) NOT NULL Integration Number
    25 GPDE_INTGNUM_1 Number(11,0) DECIMAL(11) NOT NULL Integration Number
    26 GPDE_INTGNUMB Number(11,0) DECIMAL(11) NOT NULL Integration Number
    27 GPDE_INTGNUMC Number(11,0) DECIMAL(11) NOT NULL Integration Number
    28 GPDE_INTGNUMA Number(11,0) DECIMAL(11) NOT NULL Integration Number