GP_PRORATION(SQL Table) |
Index Back |
|---|---|
Proration Rule Definition.Proration rule definitions - Main Record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Default Value: 999999 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Default Value: CT0 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
Default Value: CT0 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 Default Value: N |
| 9 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |