GPSC_ELM_ABS_TE

(SQL View)
Index Back

Absence Take Element

Allows to create multiple Earns/Deds from one Take element.

SELECT PIN_NUM , EFFDT , GP_ORDER , ENTRY_TYPE_TAKE , PIN_TAKE_ELEM_NUM , ENTRY_TYPE_UNIT , PIN_UNIT_NUM , ENTRY_TYPE_PCT , PIN_PCT_NUM , ENTRY_TYPE_AMT , PIN_AMT_NUM , ENTRY_TYPE_RATE , PIN_RATE_NUM FROM PS_GP_ABS_TAKE_ELM WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , GP_ORDER , ENTRY_TYPE_TAKE , PIN_TAKE_ELEM_NUM , ENTRY_TYPE_UNIT , PIN_UNIT_NUM , ENTRY_TYPE_PCT , PIN_PCT_NUM , ENTRY_TYPE_AMT , PIN_AMT_NUM , ENTRY_TYPE_RATE , PIN_RATE_NUM FROM PS_GPSC_RM_ABS_EL 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 GP_ORDER Number(3,0) SMALLINT NOT NULL Utility field for data ordering
4 ENTRY_TYPE_TAKE Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_EDRUP_VW

5 PIN_TAKE_ELEM_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD8

6 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit

Prompt Table: GP_ENT_ABS5_VW

7 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit

Prompt Table: %GP_EDIT_FLD9

8 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Prompt Table: GP_ENT_ABS4_VW

9 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: %GP_EDIT_FLD10

10 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount

Prompt Table: GP_ENT_ABS8_VW

11 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount

Prompt Table: %GP_EDIT_FLD11

12 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate

Prompt Table: GP_ENT_ABS7_VW

13 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate

Prompt Table: %GP_EDIT_FLD12