GPCHTX021_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPCH_TX_CANTON	Character(2)	VARCHAR2(2) NOT NULL	Canton
3	GPCH_TX_VILLAGE_CD	Character(4)	VARCHAR2(4) NOT NULL	Municipality Code
4	GPCH_TX_TRF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tariff Group A=A Single Person B=B Sole Earner (Married) C=C Double Earner D=D Secondary Occupation K=K Cohabitants GR Only L=I1 Spouse Intl Function 0.5 GE M=I2 Spouse Intl Function 1.0 GE N=I3 Spouse Intl Function 1.5 GE O=I4 Spouse Intl Function 2.0 GE V=V Double Earner (Female) VD
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
7	GPCH_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
8	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
9	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
10	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
11	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number Default Value: 0
12	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
13	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
14	PRD_END_DT	Date(10)	DATE	Pay Period End Date
15	TERMINATION_DT	Date(10)	DATE	Termination Date
16	BEGIN_DT	Date(10)	DATE	Begin Date
17	END_DT	Date(10)	DATE	end date
18	BIRTHDATE	Date(10)	DATE	Date of Birth
19	GPCH_TX_TRF_CD	Character(10)	VARCHAR2(10) NOT NULL	Withholding Tax Tariff
20	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
21	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
22	VISA_PERMIT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Visa/Permit Type
23	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
24	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
25	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
26	GPCH_RP_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
27	GPCH_RP_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
28	GPCH_RP_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
29	GPCH_RP_AMOUNT11	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 11
30	GPCH_RP_AMOUNT14	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 14
31	GPCH_RP_AMOUNT19	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 19
32	GPCH_RP_AMOUNT20	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount 20
33	GPCH_RP_CHAR03	Character(8)	VARCHAR2(8) NOT NULL	Character 03
34	GPCH_RP_FROMDT1	Date(10)	DATE	From Date 1
35	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
36	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence