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 | LAST_PROC_DT | Date(10) | DATE | Last Proc Date |
7 | 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 |
8 | BEG_BALANCE | Number(14,2) | DECIMAL(13,2) NOT NULL | Beginning Balance |
9 | EARNINGS | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Earnings |
10 | BALANCE_INTEREST | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Balance Interest |
11 | BALANCE_INT_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Interest Rate |
12 | CREDIT_PRD | Number(14,2) | DECIMAL(13,2) NOT NULL | Credit for Period |
13 | CREDIT_ADJ_PRD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Credit Adjustments |
14 | CREDIT_INT_ADJ | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Interest Adjustments |
15 | CREDIT_INT_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Credit Interest Rate |
16 | CONTRIBUTION_RATE | Number(6,2) | DECIMAL(5,2) NOT NULL | Contribution Rate |
17 | CONTRIB_RATE_ABOVE | Number(6,2) | DECIMAL(5,2) NOT NULL | Above Threshold Contrib Rate |
18 | ACCUM_INTEREST | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Accumulated Interest |
19 | ACCUM_CREDITS | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Accumulated Credits |
20 | END_BALANCE | Number(14,2) | DECIMAL(13,2) NOT NULL | Ending Balance |