PA_ACCUMS(SQL Table) |
Index Back |
|---|---|
Cash Balance HistoryThis is an employee table containing Cash Balance History. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan | |
| 2 | Character(10) | VARCHAR2(10) NOT NULL | Function Result Name | |
| 3 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 4 | Date(10) | DATE | Start Date for Gen Standing PO | |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | ACCUM_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Accumulation Period
A=Employee's Anniversary Year C=Calendar Year M=Calendar Month O=Other Year P=Plan Year |
| 7 | BEG_BALANCE | Number(14,2) | DECIMAL(13,2) NOT NULL | Beginning Balance |
| 8 | EARNINGS | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Earnings |
| 9 | BALANCE_INTEREST | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Balance Interest for Period |
| 10 | BALANCE_INT_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Balance Interest Rate |
| 11 | CREDIT_PRD | Number(14,2) | DECIMAL(13,2) NOT NULL | Credit for Period |
| 12 | CREDIT_ADJ_PRD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Credit Adjustment for Period |
| 13 | CREDIT_INT_ADJ | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Credit Interest Adjustments |
| 14 | CREDIT_INT_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Credit Interest Rate |
| 15 | CONTRIBUTION_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Contribution Rate |
| 16 | CONTRIB_RATE_ABOVE | Number(6,2) | DECIMAL(5,2) NOT NULL | Above Threshold Contrib Rate |
| 17 | ACCUM_INTEREST | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Accumulated Interest |
| 18 | ACCUM_CREDITS | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Accumulated Credits |
| 19 | END_BALANCE | Number(14,2) | DECIMAL(13,2) NOT NULL | Ending Balance |