GPBR_GRFCWA_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
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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	GPBR_PR_FGTS_BASE	Number(13,2)	DECIMAL(12,2) NOT NULL	Prior Base for FGTS Calculation
12	GPBR_TDY_FGTS_BASE	Number(13,2)	DECIMAL(12,2) NOT NULL	Actual Base for FGTS Calculation
13	GPBR_COMP_FGTS_BSE	Number(13,2)	DECIMAL(12,2) NOT NULL	Compensational base for FGTS. Used at GRFC report
14	GPBR_PREV_NTF_AMT	Number(13,2)	DECIMAL(12,2) NOT NULL	Previous Notification Amount for GRFC Reporting
15	GPBR_BANKING_BLNCE	Number(13,2)	DECIMAL(12,2) NOT NULL	Banking Balance for GRFC report
16	GPBR_PR_FGTS_PCT	Number(13,2)	DECIMAL(12,2) NOT NULL	FGTS Prior Percentage for GRFC Reporting
17	GPBR_FGTS_PCT	Number(13,2)	DECIMAL(12,2) NOT NULL	FGTS Percentage for GRFC reporting.
18	GPBR_FINE_AMOUNT	Number(13,2)	DECIMAL(12,2) NOT NULL	Fine Amount for GRFC Reporting
19	GPBR_ACTUAL_SOC_CT	Number(13,2)	DECIMAL(12,2) NOT NULL	Actual Social Contribution for GRFC Reporting