GVT_PAYROLL_DTA

(SQL Table)
 Index Back

EE Paycheck Delivery Data

EE Paycheck Delivery Data This record will be used to store paycheck delivery information

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 PAYCHECK_DIST_OPTN Character(1) VARCHAR2(1) NOT NULL Distribution Mail Option
    1=Company Distribution
    2=Postal Service
    I=Company Distribution
    X=Postal Service

    Default Value: I

    6 PAYCHECK_ADDR_OPTN Character(1) VARCHAR2(1) NOT NULL Paycheck Address Option
    1=Home Address
    2=Mailing Address
    3=Check Address
    C=Check Address
    E=Select on Payroll Options Page
    H=Home Address
    M=Mailing Address

    Default Value: H

    7 PAYCHECK_LOCN_OPTN Character(1) VARCHAR2(1) NOT NULL Location Option
    D=Home Department Location
    E=Select on Payroll Options Page
    J=Job Location
    O=Other Location

    Default Value: D

    8 DED_TAKEN Character(1) VARCHAR2(1) NOT NULL Deductions Taken
    D=Deduction Table Governs
    N=None
    R=No Override
    S=Deduction Table Subset Governs

    Default Value: R

    9 DED_SUBSET_ID Character(3) VARCHAR2(3) NOT NULL Deduction Subset ID

    Prompt Table: DED_SUBSET_TBL

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

    Prompt Table: SET_LOC_VW

    11 MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Mail Drop ID
    12 PAYCHECK_NAME Character(50) VARCHAR2(50) NOT NULL Paycheck Name
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    18 CITY Character(30) VARCHAR2(30) NOT NULL City
    19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    26 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    30 PRIM_PAYGROUP Character(3) VARCHAR2(3) NOT NULL Primary PayGroup

    Prompt Table: PRIM_PAYGRP_VW