CALC_NAMECALC_SEQ_NUMBENEFIT_PLANFUNCTN_RESULT_NMEMPLIDSTART_DTPA_CLC_FAE_AY(SQL Table) |
Index Back |
|---|---|
Calc Results Final Avg EarningThis is an employee table containing Calc Results for Final Average Earnings. |
| # | 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 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 4 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | START_DT |
Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | LAST_PROC_DT | Date(10) | DATE | Last Proc Dt |
| 9 | ERN_GEN_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Generated Earnings |
| 10 | ERN_PRD_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Accumulated Earnings |
| 11 | ERN_ADJ_AMT | Number(14,2) | DECIMAL(13,2) NOT NULL | Adjusted Accum Amounts |
| 12 | PROJECTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Projected period determinant |
| 13 | DENOMINTR | Signed Number(8,3) | DECIMAL(6,3) NOT NULL | Denominator for period |