GPBR_H09_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LAST_HIRE_DT	Date(10)	DATE	Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
3	TERMINATION_DT	Date(10)	DATE	Termination Date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	DATE_YEAR_VAL	Number(4,0)	SMALLINT NOT NULL	Date Year Value
9	DATE_MONTH_VAL	Number(2,0)	SMALLINT NOT NULL	Date Month Value
10	GPBR_ELEM_CODE	Character(6)	VARCHAR2(6) NOT NULL	Report Code
11	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
12	GPBR_SEQ_CODE	Character(20)	VARCHAR2(20) NOT NULL	Secuence Code
13	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
14	GPBR_QTY_PRODS	Number(12,2)	DECIMAL(11,2) NOT NULL	Quantity of Products
15	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
16	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
17	USER_FLD1	Character(25)	VARCHAR2(25) NOT NULL	User Field 1
18	USER_FLD2	Character(25)	VARCHAR2(25) NOT NULL	User Field 2
19	USER_FLD3	Character(25)	VARCHAR2(25) NOT NULL	User Field 3
20	USER_FLD4	Character(25)	VARCHAR2(25) NOT NULL	User Field 4
21	USER_FLD5	Character(25)	VARCHAR2(25) NOT NULL	User FIeld 5
22	USER_FLD6	Character(25)	VARCHAR2(25) NOT NULL	User Field 6