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 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
2 | FUNCTN_RESULT_NM | Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | START_DATE | 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 |