GPDE_AL_XML_LOC

(SQL Table)
 Index Back

Locations per AL06 Ticket

This record stores the various locations and their details per a given ticket for the AL06 pocess (Payroll Statistics). We need to store this to be able to compare whether or not another run is trying to run for the exact same population.

  • Related Language Record: GPDE_AL_XML_LNG

  • Parent record: GPDE_RC_PAYROLL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPDE_ELSTER_TKT Character(20) VARCHAR2(20) NOT NULL Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER.
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

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

    Prompt Table: GPDE_AL_PE_LOC

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

    Default Value: 1

    5 GPDE_AL_06_29TH Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours Blue Collar employees worked on the 29th of the month.
    6 GPDE_AL_06_30TH Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours Blue Collar employees worked on the 30th of the month.
    7 GPDE_AL_06_31ST Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours Blue Collar employees worked on the 31th of the month.
    8 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
    9 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    10 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
    11 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    12 GPDE_ER_HRS_WK Number(6,2) DECIMAL(5,2) NOT NULL Hours per Week