GPCH_RP_TX7_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
4	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
8	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
11	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
12	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
13	PRD_END_DT	Date(10)	DATE	Pay Period End Date
14	HIRE_DT	Date(10)	DATE	First Start Date
15	TERMINATION_DT	Date(10)	DATE	Termination Date
16	GPCH_AL_CPAY_ENDDT	Date(10)	DATE NOT NULL	Current Pay End Date
17	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
18	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
19	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
20	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
21	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
22	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
23	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
24	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
25	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
26	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
27	GPCH_AH_NNSS	Character(20)	VARCHAR2(20) NOT NULL	New Social Insurance ID
28	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
29	GPCH_TX_CANTON	Character(2)	VARCHAR2(2) NOT NULL	Canton
30	GPCH_TX_FAK_CANTON	Character(2)	VARCHAR2(2) NOT NULL	FAK Canton
31	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
32	BIRTHDATE	Date(10)	DATE	Date of Birth
33	COUNTRY_FROM	Character(3)	VARCHAR2(3) NOT NULL	From Country
34	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
35	GPCH_TX_EXPT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Expatriate Status 0=Ignore Periods 1=Split Periods
36	GPCH_RP_CHAR01	Character(6)	VARCHAR2(6) NOT NULL	Character 01
37	GPCH_AL_FR_TRSP	Character(1)	VARCHAR2(1) NOT NULL	Free Transporattion 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
38	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
39	GPCH_TX_CANTEEN	Character(1)	VARCHAR2(1) NOT NULL	Canteen 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
40	ADDRESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Address Type
41	GPCH_AL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Expenses 13.1.1 0=Follow Accumulator 1=Always Check 2=Never Check 3=Default
42	GPCH_RP_CHAR02	Character(8)	VARCHAR2(8) NOT NULL	Character 02
43	GPCH_RP_CHAR03	Character(8)	VARCHAR2(8) NOT NULL	Character 03
44	GPCH_RP_CHAR04	Character(6)	VARCHAR2(6) NOT NULL	Character 04
45	GPCH_RP_CHAR05	Character(6)	VARCHAR2(6) NOT NULL	Character 05