GPDE_BV_RT_VW (SQL View)	Index Back
BVV Contribution Classes The Field BVV_CLASS is not required for the entry of Contribution Class 0.

GPDE_BV_RT_VW

(SQL View)

BVV Contribution Classes

The Field BVV_CLASS is not required for the entry of Contribution Class 0.

SELECT GPDE_BV_CLASS , EFFDT , GPDE_BV_EE_DM , CURRENCY_CD FROM PS_GPDE_BV_RT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPDE_BV_CLASS Number(2,0) SMALLINT NOT NULL BVV Contribution Class

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GPDE_BV_EE_DM Number(8,2) DECIMAL(7,2) NOT NULL BVV Employee Contribution

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPDE_BV_CLASS	Number(2,0)	SMALLINT NOT NULL	BVV Contribution Class
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPDE_BV_EE_DM	Number(8,2)	DECIMAL(7,2) NOT NULL	BVV Employee Contribution
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code