GPCH_IF_TX07_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date Default Value: %Date
4	END_DT	Date(10)	DATE NOT NULL	end date Default Value: %Date
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	GPCH_EG_DOMAINID	Number(3,0)	SMALLINT NOT NULL	Domain Set ID for the ELM Domain Sets
7	GPCH_IF_VER	Number(3,0)	SMALLINT NOT NULL	Version Field Default Value: 1
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
11	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
12	GPCH_TX_CANTON	Character(2)	VARCHAR2(2) NOT NULL	Canton
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	GPCH_AL_PAGE_NUM	Number(4,0)	SMALLINT NOT NULL	PAge number Field
15	GPCH_IF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status F=Finalized O=Open Default Value: O
16	GPCH_RP_SRC_IND	Character(1)	VARCHAR2(1) NOT NULL	source Indicator S=System U=User Default Value: U
17	GPCH_RP_TX7_DATA	Long Character	CLOB	form XML Data
18	GPCH_RP_PRINT_FL	Character(1)	VARCHAR2(1) NOT NULL	Print LAW