GP_PKG_PO1_VW(SQL View) |
Index Back |
|---|---|
Proration Rule Pkg ViewProration view used for packaging. |
| SELECT PIN_NUM + 50000000 , EFFDT , EFF_STATUS , ENTRY_TYPE_ELEM , PIN_NUMERATOR_NUM , ENTRY_TYPE_ELEM2 , PIN_DENOMIN_NUM , DENOM_USES_NUMER , GP_VERSION FROM PS_GP_PRORATION |
| # | 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 |
| 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 |
| 8 | DENOM_USES_NUMER | Character(1) | VARCHAR2(1) NOT NULL |
Denominator Schedule
N=Use All Schedules in Segment Y=Use Last Schedule in Segment Y/N Table Edit |
| 9 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |