GVT_ACCR_LDGR

#	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	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
8	SERVICE_HRS	Signed Number(11,3)	DECIMAL(9,3) NOT NULL	hours of service for an employee related to benefit plan
9	HOURS_EARNED	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Hours Earned
10	HRS_TAKEN	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Hours Taken
11	GVT_HRS_CASCADED	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Store the Cascaded hours on GVT_ACCR_LDGR record
12	HRS_ADJ	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Hours Adjustment
13	GVT_HRS_BOUGHT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Hours Bought
14	GVT_HRS_SOLD	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Hours Sold
15	GVT_NONPAY_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Non-Pay Hours
16	GVT_CR_REDUC_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Credit Reduction Hours
17	GVT_FORFEIT_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Forfeited Hours
18	GVT_MUSTUSE_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Max Carryover Excess
19	EXPIRATN_DT	Date(10)	DATE	Expiration Date
20	RATE_AMOUNT	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Rate Amount
21	GVT_CARRYOVER_HRS	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Carryover Hours to adjust YTD carryover bucket
22	GVT_EXPIRE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Expiration Status Y/N Table Edit
23	GVT_EARN_HRS_AVAIL	Number(8,2)	DECIMAL(7,2) NOT NULL	Earned accrual hours available.
24	GVT_TAK_HRS_AVAIL	Number(8,2)	DECIMAL(7,2) NOT NULL	Earned accrual hours available.