TERM_PGM_DEFLVE (SQL Table)	Index Back
Final Check Lve Accr Defn Tbl This table stores the rules for how a Leave Accrual is paid out on an employee's Final Check. The configurations stored here are associated to a Final Check program.

TERM_PGM_DEFLVE

(SQL Table)

Final Check Lve Accr Defn Tbl

This table stores the rules for how a Leave Accrual is paid out on an employee's Final Check. The configurations stored here are associated to a Final Check program.

Parent record: TERM_PGM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TERM_PGM_ID Character(3) VARCHAR2(3) NOT NULL Final Check Program ID

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

4 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
Prompt Table: %RECNAME_EDIT

5 HRS_OVRD_LIMIT Number(7,2) DECIMAL(6,2) NOT NULL Hours Override Limit

6 PRORATE_ACCRUALS Character(1) VARCHAR2(1) NOT NULL Prorate Un-awarded Accruals
Y/N Table Edit
Default Value: N

7 SERVICE_ACCRUAL Character(1) VARCHAR2(1) NOT NULL Service Accrual
H=Hours of Service
M=Months of Service

8 PRCS_ON_NEGATIVE Character(1) VARCHAR2(1) NOT NULL Process On Negative
Y/N Table Edit
Default Value: N

9 ERNCD_TO_PAY_ACCR Character(3) VARCHAR2(3) NOT NULL Earnings Code To Pay Accruals
Prompt Table: EARNINGS_TBL

10 ERNCD_TO_PAY_PRORT Character(3) VARCHAR2(3) NOT NULL Earnings Code To Pay Proration
Prompt Table: EARNINGS_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TERM_PGM_ID	Character(3)	VARCHAR2(3) NOT NULL	Final Check Program ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
4	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan Prompt Table: %RECNAME_EDIT
5	HRS_OVRD_LIMIT	Number(7,2)	DECIMAL(6,2) NOT NULL	Hours Override Limit
6	PRORATE_ACCRUALS	Character(1)	VARCHAR2(1) NOT NULL	Prorate Un-awarded Accruals Y/N Table Edit Default Value: N
7	SERVICE_ACCRUAL	Character(1)	VARCHAR2(1) NOT NULL	Service Accrual H=Hours of Service M=Months of Service
8	PRCS_ON_NEGATIVE	Character(1)	VARCHAR2(1) NOT NULL	Process On Negative Y/N Table Edit Default Value: N
9	ERNCD_TO_PAY_ACCR	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code To Pay Accruals Prompt Table: EARNINGS_TBL
10	ERNCD_TO_PAY_PRORT	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code To Pay Proration Prompt Table: EARNINGS_TBL