GVT_ACCR_ADJ

#	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 Record
3	GVT_ERN_ACCR_CLASS	Character(6)	VARCHAR2(6) NOT NULL	Earnings Accrual Class
4	EFFDT	Date(10)	DATE	Effective Date
5	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code
6	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
7	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
8	GVT_ADJ_DT	Date(10)	DATE	Adjustment Date Default Value: %date
9	ADJ_REASON	Character(50)	VARCHAR2(50) NOT NULL	Adjustment Reason
10	GVT_ADJ_APPLIED	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Applied Y/N Table Edit Default Value: N
11	SERVICE_HRS	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	hours of service for an employee related to benefit plan
12	HOURS_EARNED	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Hours Earned
13	HRS_TAKEN	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Taken
14	HRS_ADJ	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Hours Adjustment
15	GVT_HRS_BOUGHT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Hours Bought
16	GVT_HRS_SOLD	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Hours Sold
17	GVT_NONPAY_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Non-Pay Hours
18	GVT_CR_REDUC_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Credit Reduction Hours
19	GVT_FORFEIT_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Forfeited Hours
20	GVT_MUSTUSE_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Max Carryover Excess
21	EXPIRATN_DT	Date(10)	DATE	Expiration Date
22	RATE_AMOUNT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Rate Amount
23	GVT_CARRYOVER_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Carryover Hours to adjust YTD carryover bucket