BDGT_BENEF_TBL (SQL Table)	Index Back
Budget Benefit Table This record is the child to the BDGT_BENEF_GRP record which defines Budget Benefit Groups that help estimate the cost of employees who are enrolled in a number of different plan types.

BDGT_BENEF_TBL

(SQL Table)

Budget Benefit Table

This record is the child to the BDGT_BENEF_GRP record which defines Budget Benefit Groups that help estimate the cost of employees who are enrolled in a number of different plan types.

Related Language Record: BDGT_BENEF_LANG

Parent record: BDGT_BENEF_GRP

# 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 NOT NULL Effective Date
Default Value: %Date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	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 NOT NULL	Effective Date Default Value: %Date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description