GPGB_ACTSCON_VW (SQL View)	Index Back
Active SCON View Holds active Scheme Contracted Out Numbers.

GPGB_ACTSCON_VW

(SQL View)

Active SCON View

Holds active Scheme Contracted Out Numbers.

SELECT GPGB_SCON , GPGB_SCON_DESCR FROM PS_GPGB_SCON_TBL WHERE GPGB_ACTIVE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPGB_SCON Character(9) VARCHAR2(9) NOT NULL SCON - Scheme Contracted Out Number

2 GPGB_SCON_DESCR Character(30) VARCHAR2(30) NOT NULL SCON Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPGB_SCON	Character(9)	VARCHAR2(9) NOT NULL	SCON - Scheme Contracted Out Number
2	GPGB_SCON_DESCR	Character(30)	VARCHAR2(30) NOT NULL	SCON Description