GPES_LBR_RL_VW (SQL View)	Index Back
Labor Agreement RL View This view retrieves the Labor Agreement RL percentage. This information is used in Social Security formulas.

GPES_LBR_RL_VW

(SQL View)

Labor Agreement RL View

This view retrieves the Labor Agreement RL percentage. This information is used in Social Security formulas.

SELECT A.SETID , A.LABOR_AGREEMENT , A.EFFDT , B.GPES_BNF_RL_TO , A.EFF_STATUS , B.GPES_BNF_RL_PCT FROM PS_GPES_LBR_AGRMNT A , PS_GPES_LBR_BNF_RL B WHERE A.SETID = B.SETID AND A.LABOR_AGREEMENT = B.LABOR_AGREEMENT AND A.EFFDT = B.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EFFDT Date(10) DATE Effective Date

4 GPES_BNF_RL_TO Number(3,0) SMALLINT NOT NULL RL Complementary Benefits TO. This field houses the day until the RL Complementary Benefits percentage applies. It is defined in days.

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

6 GPES_BNF_RL_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL RL Complementary Benefits. This field houses the percentage to be applied over the employee benefits base during RL. 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_LAB_VLD_VW
2	LABOR_AGREEMENT	Character(6)	VARCHAR2(6) NOT NULL	Labor Agreement
3	EFFDT	Date(10)	DATE	Effective Date
4	GPES_BNF_RL_TO	Number(3,0)	SMALLINT NOT NULL	RL Complementary Benefits TO. This field houses the day until the RL Complementary Benefits percentage applies. It is defined in days.
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
6	GPES_BNF_RL_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	RL Complementary Benefits. This field houses the percentage to be applied over the employee benefits base during RL. This percentage is equal to SS statutory benefits + Company Complementary Benefits (no mandatory and defined by LA).