GPGB_SS_TYPE_VW (SQL View)	Index Back
Share Scheme Types View View of active Share Scheme Types

GPGB_SS_TYPE_VW

(SQL View)

Share Scheme Types View

View of active Share Scheme Types

SELECT GPGB_SS_TYPE_ID ,DESCR FROM PS_GPGB_SS_TYPES WHERE EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPGB_SS_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Identifies a Share Scheme (Save, Buy or Other) and associated Inland Revenue contribution limits

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPGB_SS_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a Share Scheme (Save, Buy or Other) and associated Inland Revenue contribution limits
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description