GPHK_ABS_ENT_VW (SQL View)	Index Back
GPHK - Hong Kong Abs Entl View This view retrieves pin numbers specific to Absence Entitlement.

GPHK_ABS_ENT_VW

(SQL View)

GPHK - Hong Kong Abs Entl View

This view retrieves pin numbers specific to Absence Entitlement.

SELECT b.pin_num , b.pin_nm , b.descr FROM PS_GP_PIN b WHERE b.pin_type = 'AE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

3 GPHK_DESCR Character(30) VARCHAR2(30) NOT NULL This object is a copy of the standard DESCR field, however it contains additional labels not available on the standard.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
3	GPHK_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This object is a copy of the standard DESCR field, however it contains additional labels not available on the standard.