GPCH_RP_TX07

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
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	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
11	PRD_END_DT	Date(10)	DATE	Pay Period End Date
12	HIRE_DT	Date(10)	DATE	First Start Date
13	TERMINATION_DT	Date(10)	DATE	Termination Date
14	GPCH_AL_CPAY_ENDDT	Date(10)	DATE NOT NULL	Current Pay End Date
15	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
16	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
17	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
18	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
19	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
20	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
22	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
23	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
24	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
25	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
26	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
27	GPCH_TX_CANTON	Character(2)	VARCHAR2(2) NOT NULL	Canton
28	GPCH_TX_FAK_CANTON	Character(2)	VARCHAR2(2) NOT NULL	FAK Canton
29	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
30	BIRTHDATE	Date(10)	DATE	Date of Birth
31	COUNTRY_FROM	Character(3)	VARCHAR2(3) NOT NULL	From Country
32	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
33	GPCH_TX_EXPT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Expatriate Status 0=Ignore Periods 1=Split Periods
34	GPCH_RP_CHAR01	Character(6)	VARCHAR2(6) NOT NULL	Character 01
35	GPCH_AL_FR_TRSP	Character(1)	VARCHAR2(1) NOT NULL	Free Transporattion 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
36	GPCH_AL_EXPEXP	Character(1)	VARCHAR2(1) NOT NULL	Effective expenses expat 13.1.2 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
37	GPCH_TX_CANTEEN	Character(1)	VARCHAR2(1) NOT NULL	Canteen 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
38	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
39	GPCH_AL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Expenses 13.1.1 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
40	GPCH_RP_CHAR02	Character(8)	VARCHAR2(8) NOT NULL	Character 02
41	GPCH_RP_CHAR03	Character(8)	VARCHAR2(8) NOT NULL	Character 03
42	GPCH_RP_CHAR04	Character(6)	VARCHAR2(6) NOT NULL	Character 04
43	GPCH_RP_CHAR05	Character(6)	VARCHAR2(6) NOT NULL	Character 05