WCS_CFG_PGLT_VW (SQL View)	Index Back
Compensation Chart Pagelets Lists pagelets configured and available for compensation components.

WCS_CFG_PGLT_VW

(SQL View)

Compensation Chart Pagelets

Lists pagelets configured and available for compensation components.

SELECT PCFG.PNLGRPNAME , PCFG.PTPPB_PAGELET_ID , PTPGLT.DESCR , PCFG.DEFAULT_IND FROM PS_WCS_PGLT_CONFIG PCFG , PS_PTPPB_PAGELET PTPGLT WHERE PCFG.PTPPB_PAGELET_ID = PTPGLT.PTPPB_PAGELET_ID

Related Language Record: WCS_CFG_PGLT_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

2 PTPPB_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
2	PTPPB_PAGELET_ID	Character(30)	VARCHAR2(30) NOT NULL	Pagelet ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DEFAULT_IND	Character(1)	VARCHAR2(1) NOT NULL	An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.