CALC_NAMECALC_SEQ_NUMEMPLIDBENEFIT_PLANFUNCTN_RESULT_NMCALENDAR_YRPA_CLC_SOC_AY(SQL Table) |
Index Back |
|---|---|
Calc Results Social SecurityThis is an employee table containing Calc Results for Social Security. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 2 | CALC_SEQ_NUM |
Number(9,0) | DECIMAL(9) NOT NULL | Calc Seq Num |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 5 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 6 | CALENDAR_YR |
Number(4,0) | SMALLINT NOT NULL | Year |
| 7 | EARNED_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Actual Employee Earnings |
| 8 | TWB_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Taxable Wage Base Amount |
| 9 | CVRD_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Taxable Earnings |
| 10 | USAW_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | US Average Wage Base Amount |
| 11 | IDXD_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Indexed Amount |
| 12 | HIGH_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Indexed Amount Used in PIA clc |
| 13 | SOC_SEC_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Social Security Earnings Flag |