GPTH_PAYEE_TBL

(SQL Table)
Index Back

GP THA- Payee Lvl Data

GP THA - Payee Level Data storage table.

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

Prompt Table: PERSON

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

Default Value: %date

4 GPTH_DEL_OPT Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the delivery address for the payslip.
20=Department
30=Location
50=Home Address
60=Mail Address