GPCH_TX_EMA_CMP

(SQL Table)
Index Back

Source Tax Data CHE

Source Tax Data CHE

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
5 BGN_DT Date(10) DATE Begin Date
6 GPCH_TX_SD_EMA Character(2) VARCHAR2(2) NOT NULL SourceTax Event.
7 GPCH_RC_DESCR1 Character(30) VARCHAR2(30) NOT NULL Signature1
8 GPCH_RP_DSH Character(10) VARCHAR2(10) NOT NULL Desrcription Short
9 END_DT Date(10) DATE end date
10 GPCH_RP_FROM_PYENT Character(10) VARCHAR2(10) NOT NULL LAW from Pay Entity
11 GPCH_RC_DESCR2 Character(30) VARCHAR2(30) NOT NULL Signature2
12 ACTION Character(3) VARCHAR2(3) NOT NULL Action