This is a dummy view to use as a work record for the chart grid on the benefits enrollment summary page.

BNE_CHART_WRK

(SQL View)

SELECT ' ' , ' ' , ' ' FROM PS_INSTALLATION WHERE 1=2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PLAN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Plan Type Description

2 TOTAL_YOUR_COST Signed Number(9,2) DECIMAL(7,2) NOT NULL Total Your Cost

3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PLAN_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Plan Type Description
2	TOTAL_YOUR_COST	Signed Number(9,2)	DECIMAL(7,2) NOT NULL	Total Your Cost
3	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description