BN_PERSON (SQL Table)	Index Back
Benefits specific data This record contains benefits-specific data for a given person. The BN_TOGGLE field is used by Benefits Self Service to force a save. Its value has nothing to do with the other two fields.

BN_PERSON

(SQL Table)

Benefits specific data

This record contains benefits-specific data for a given person. The BN_TOGGLE field is used by Benefits Self Service to force a save. Its value has nothing to do with the other two fields.

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 HIGHLY_COMP_EMPL_P Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligible non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE
Default Value: N

3 HIGHLY_COMP_EMPL_C Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained.
E=Eligile non-Officer, non 5%
H=Highly Compensated Employee
N=Not Eligible for the Plan
O=Eligible Officer, not HCE

4 BN_TOGGLE Character(1) VARCHAR2(1) NOT NULL This is a "dummy" field used only to force PeopleTools save processing in a component. We have several pages that contain enterable fields only for derived/work records, yet we need Tools to fire SaveXXX events. The only way to make this happen is to change a field value on a "real" database record in the component. This field is used as a dummy field on a real record, whose value is toggled between "Y" and "N" in order to force Tools save processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	HIGHLY_COMP_EMPL_P	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the year prior to the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained. E=Eligible non-Officer, non 5% H=Highly Compensated Employee N=Not Eligible for the Plan O=Eligible Officer, not HCE Default Value: N
3	HIGHLY_COMP_EMPL_C	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not an employee is considered highly compensated according to U.S. Government regulations in the current year, and is used for managing Section 401savings plans or Section 129 spending accounts. The valid values, as delivered, are Not Eligible (N), Highly Compensated (H), Eligible Non-Officer,Non5% (E), and Eligible Officer (O). This field is system-maintained. E=Eligile non-Officer, non 5% H=Highly Compensated Employee N=Not Eligible for the Plan O=Eligible Officer, not HCE
4	BN_TOGGLE	Character(1)	VARCHAR2(1) NOT NULL	This is a "dummy" field used only to force PeopleTools save processing in a component. We have several pages that contain enterable fields only for derived/work records, yet we need Tools to fire SaveXXX events. The only way to make this happen is to change a field value on a "real" database record in the component. This field is used as a dummy field on a real record, whose value is toggled between "Y" and "N" in order to force Tools save processing.