BDGT_BENEF_GRP (SQL Table)	Index Back
Budget Benefit Group This record is used to allow the user to assign specific benefit plan types to a Budget Benefit Group. These groups can then be used in estimating the cost of an employee during an encumbrancing process.

BDGT_BENEF_GRP

(SQL Table)

Budget Benefit Group

This record is used to allow the user to assign specific benefit plan types to a Budget Benefit Group. These groups can then be used in estimating the cost of an employee during an encumbrancing process.

Parent Record Of BDGT_BENEF_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BDGT_BENEF_GRP Character(10) VARCHAR2(10) NOT NULL Budget Benefit Group

2 EFFDT Date(10) DATE 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BDGT_BENEF_GRP	Character(10)	VARCHAR2(10) NOT NULL	Budget Benefit Group
2	EFFDT	Date(10)	DATE	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.