DEFINITION_NAMEC=Consolidated Contributions
E=Consolidated Earnings
L=Level Rate
N=No Credit
S=Step Rate
U=User Code
Prompt Table: PA_401A17_PARMS
Prompt Table: PA_CUSTOM
Prompt Table: PA_PROJECTION
Y/N Table Edit
PA_ACCT_BAL(SQL Table) |
Index Back |
|---|---|
Employee AccountsThis is a setup table for Employee Accounts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEFINITION_NAME |
Character(10) | VARCHAR2(10) NOT NULL | VARCHAR2(10) NOT NULL |
| 2 | CREDIT_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Credit is Based on
C=Consolidated Contributions E=Consolidated Earnings |
| 3 | CREDIT_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Credit according to
L=Level Rate N=No Credit S=Step Rate U=User Code |
| 4 | CONS_DEDUCT_NAME | Character(10) | VARCHAR2(10) NOT NULL | Consolidated Deduction Name |
| 5 | LIMIT_401A17_NAME | Character(10) | VARCHAR2(10) NOT NULL |
401(a)17 Limit Name
Prompt Table: PA_401A17_PARMS |
| 6 | CUSTOM_STMT_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Custom Statement Name
Prompt Table: PA_CUSTOM |
| 7 | PROJECT_METHOD | Character(10) | VARCHAR2(10) NOT NULL |
Projection Method Name
Prompt Table: PA_PROJECTION |
| 8 | APPLY_401A17 | Character(1) | VARCHAR2(1) NOT NULL |
Apply 401(a)(17)
Y/N Table Edit |