GPES_EST_ACM_VW(SQL View) |
Index Back |
|---|---|
Accumulators for an earningGiven an earning, this view retrieves all the accumulators that such earning contributes to. |
| SELECT DISTINCT ACM.PIN_NUM , %Substring(PIN.PIN_CODE, 1, LENGTH(PIN_NM)) , PIN.PIN_NM , ACM.PIN_MBR_NUM , ACM.BGN_DT , ACM.END_DT , ACM.ENTRY_TYPE_ELEM , ACM.ACM_SIGN , ACM.ENTRY_TYPE_PCT , ACM.PCT_TO_ACM , ACM.PIN_PCT_NUM FROM PS_GP_ACM_MBR ACM , PS_GP_PIN PIN WHERE ACM.PIN_NUM = PIN.PIN_NUM AND PIN.COUNTRY='ESP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_CODE | Character(22) | VARCHAR2(22) NOT NULL | Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN) |
| 3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 4 | PIN_MBR_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 8 | ACM_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Sign
A=Add S=Subtract |
| 9 | ENTRY_TYPE_PCT | Character(3) | VARCHAR2(3) NOT NULL | Entry Pype Percent Option |
| 10 | PCT_TO_ACM | Number(10,6) | DECIMAL(9,6) NOT NULL | Percent to Accumulate |
| 11 | PIN_PCT_NUM | Number(8,0) | INTEGER NOT NULL | Percent to Accum Element |