GPSC_ELM_ABS_TN (SQL View)	Index Back
Absence Take Entitlement Allows mapping of various entitlement for one take.

GPSC_ELM_ABS_TN

(SQL View)

Absence Take Entitlement

Allows mapping of various entitlement for one take.

SELECT PIN_NUM , EFFDT , PRIORITY , PIN_ENT_NUM FROM PS_GP_ABS_TAKE_ENT WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , PRIORITY , PIN_ENT_NUM FROM PS_GPSC_RM_ABS_TE WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

4 PIN_ENT_NUM Number(8,0) INTEGER NOT NULL Element number field
Prompt Table: %GP_EDIT_FLD1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
4	PIN_ENT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: %GP_EDIT_FLD1