GP_NRP_ABLD3_VW

(SQL View)
Index Back

ExportRecord - GP_ABS_LVDN_ENT

ExportRecord - GP_ABS_LVDN_ENT

SELECT COUNTRY , LVDN_PRGM_ID , LVDN_PIN_NUM_ELIG + 50000000 , LVDN_PIN_NUM_DON + 50000000 , LVDN_PIN_NUM_RECV + 50000000 , LVDN_PIN_NUM_RET + 50000000 FROM PS_GP_ABS_LVDN_ENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 LVDN_PRGM_ID Character(10) VARCHAR2(10) NOT NULL Leave Program
3 LVDN_PIN_NUM_ELIG Number(8,0) INTEGER NOT NULL Eligible Entitlement

Prompt Table: GP_PIN_AE0_VW

4 LVDN_PIN_NUM_DON Number(8,0) INTEGER NOT NULL Target Donate Entitlement

Prompt Table: GP_ABSLD_AE0_VW

5 LVDN_PIN_NUM_RECV Number(8,0) INTEGER NOT NULL Target Receive Entitlement

Prompt Table: GP_ABSLD_AE0_VW

6 LVDN_PIN_NUM_RET Number(8,0) INTEGER NOT NULL Target Return Entitlement

Prompt Table: GP_ABSLD_AE0_VW