GPSC_ELM_PO

(SQL View)
 Index Back

Proration Rule Definition.

Proration rule definitions - Main Record.

SELECT PIN_NUM , EFFDT , EFF_STATUS , ENTRY_TYPE_ELEM , PIN_NUMERATOR_NUM , ENTRY_TYPE_ELEM2 , PIN_DENOMIN_NUM , DENOM_USES_NUMER , GP_VERSION FROM PS_GP_PRORATION WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , EFF_STATUS , ENTRY_TYPE_ELEM , PIN_NUMERATOR_NUM , ENTRY_TYPE_ELEM2 , PIN_DENOMIN_NUM , DENOM_USES_NUMER , GP_VERSION FROM PS_GPSC_RM_PO 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_PRO_VW

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

Prompt Table: %GP_EDIT_FLD1

6 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_PRO_VW

7 PIN_DENOMIN_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD2

8 DENOM_USES_NUMER Character(1) VARCHAR2(1) NOT NULL Denominator Schedule
N=Use All Schedules in Segment
Y=Use Last Schedule in Segment
9 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.