GPCHTXX21_TMP

(SQL Table)
Index Back

Temp Record for GPCHTX02

Temp Record for GPCHTX02

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
5 BEGIN_DT Date(10) DATE Begin Date
6 END_DT Date(10) DATE end date
7 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton
8 HIRE_DT Date(10) DATE First Start Date
9 GPCH_TX_TRF_CD Character(10) VARCHAR2(10) NOT NULL Withholding Tax Tariff