GPES_LBR_BNF_CU (SQL Table)	Index Back
Labor Agreement CUI Benefits This record houses the CUI (care of minors affected by cancer or another serious illness) Benefit percentage. This information is used in Social Security formulas.

GPES_LBR_BNF_CU

(SQL Table)

Labor Agreement CUI Benefits

This record houses the CUI (care of minors affected by cancer or another serious illness) Benefit percentage. This information is used in Social Security formulas.

Parent record: GPES_LBR_AGRMNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_VLD_HR_14

2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 GPES_BNF_CUI_TO Number(3,0) SMALLINT NOT NULL CUI (care of minors affected by cancer or another serious illness) Complementary Benefits TO. This field houses the day until the CUI Complementary Benefits percentage applies. It is defined in days.

5 GPES_BNF_CUI_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL CUI (care of minors affected by cancer or another serious illness) complementary Benefits. This field houses the percentage to be applied over the employee benefits base during CUI. This percentage is equal to SS statutory benefits + Company Complementary Benefits (no mandatory and defined by LA).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_VLD_HR_14
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	GPES_BNF_CUI_TO	Number(3,0)	SMALLINT NOT NULL	CUI (care of minors affected by cancer or another serious illness) Complementary Benefits TO. This field houses the day until the CUI Complementary Benefits percentage applies. It is defined in days.
5	GPES_BNF_CUI_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	CUI (care of minors affected by cancer or another serious illness) complementary Benefits. This field houses the percentage to be applied over the employee benefits base during CUI. This percentage is equal to SS statutory benefits + Company Complementary Benefits (no mandatory and defined by LA).