Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
EMPLOYID | Employee ID |
String | 16 | View | |
PYYTDARR_1 | Pay YTD Array[1] |
Currency | 10 | View | |
PYYTDARR_2 | Pay YTD Array[2] |
Currency | 10 | View | |
PYYTDARR_3 | Pay YTD Array[3] |
Currency | 10 | View | |
PYYTDARR_4 | Pay YTD Array[4] |
Currency | 10 | View | |
PYYTDARR_5 | Pay YTD Array[5] |
Currency | 10 | View | |
PYYTDARR_6 | Pay YTD Array[6] |
Currency | 10 | View | |
PYYTDARR_7 | Pay YTD Array[7] |
Currency | 10 | View | |
PYYTDARR_8 | Pay YTD Array[8] |
Currency | 10 | View | |
PYYTDARR_9 | Pay YTD Array[9] |
Currency | 10 | View | |
PYYTDARR_10 | Pay YTD Array[10] |
Currency | 10 | View | |
PYYTDARR_11 | Pay YTD Array[11] |
Currency | 10 | View | |
PYYTDARR_12 | Pay YTD Array[12] |
Currency | 10 | View | |
PYYTDARR_13 | Pay YTD Array[13] |
Currency | 10 | View | |
PYYTDARR_14 | Pay YTD Array[14] |
Currency | 10 | View | |
PYYTDARR_15 | Pay YTD Array[15] |
Currency | 10 | View | |
PYYTDARR_16 | Pay YTD Array[16] |
Currency | 10 | View | |
PYYTDARR_17 | Pay YTD Array[17] |
Currency | 10 | View | |
PYYTDARR_18 | Pay YTD Array[18] |
Currency | 10 | View | |
PYYTDARR_19 | Pay YTD Array[19] |
Currency | 10 | View | |
PYYTDARR_20 | Pay YTD Array[20] |
Currency | 10 | View | |
PYYTDARR_21 | Pay YTD Array[21] |
Currency | 10 | View | |
PYYTDARR_22 | Pay YTD Array[22] |
Currency | 10 | View | |
PYYTDARR_23 | Pay YTD Array[23] |
Currency | 10 | View | |
PYYTDARR_24 | Pay YTD Array[24] |
Currency | 10 | View | |
PYYTDARR_25 | Pay YTD Array[25] |
Currency | 10 | View | |
DAMYTDAR_1 | Deduction Amount YTD Array[1] |
Currency | 10 | View | |
DAMYTDAR_2 | Deduction Amount YTD Array[2] |
Currency | 10 | View | |
DAMYTDAR_3 | Deduction Amount YTD Array[3] |
Currency | 10 | View | |
DAMYTDAR_4 | Deduction Amount YTD Array[4] |
Currency | 10 | View | |
DAMYTDAR_5 | Deduction Amount YTD Array[5] |
Currency | 10 | View | |
DAMYTDAR_6 | Deduction Amount YTD Array[6] |
Currency | 10 | View | |
DAMYTDAR_7 | Deduction Amount YTD Array[7] |
Currency | 10 | View | |
DAMYTDAR_8 | Deduction Amount YTD Array[8] |
Currency | 10 | View | |
DAMYTDAR_9 | Deduction Amount YTD Array[9] |
Currency | 10 | View | |
DAMYTDAR_10 | Deduction Amount YTD Array[10] |
Currency | 10 | View | |
DAMYTDAR_11 | Deduction Amount YTD Array[11] |
Currency | 10 | View | |
DAMYTDAR_12 | Deduction Amount YTD Array[12] |
Currency | 10 | View | |
DAMYTDAR_13 | Deduction Amount YTD Array[13] |
Currency | 10 | View | |
DAMYTDAR_14 | Deduction Amount YTD Array[14] |
Currency | 10 | View | |
DAMYTDAR_15 | Deduction Amount YTD Array[15] |
Currency | 10 | View | |
DAMYTDAR_16 | Deduction Amount YTD Array[16] |
Currency | 10 | View | |
DAMYTDAR_17 | Deduction Amount YTD Array[17] |
Currency | 10 | View | |
DAMYTDAR_18 | Deduction Amount YTD Array[18] |
Currency | 10 | View | |
DAMYTDAR_19 | Deduction Amount YTD Array[19] |
Currency | 10 | View | |
DAMYTDAR_20 | Deduction Amount YTD Array[20] |
Currency | 10 | View | |
DAMYTDAR_21 | Deduction Amount YTD Array[21] |
Currency | 10 | View | |
DAMYTDAR_22 | Deduction Amount YTD Array[22] |
Currency | 10 | View | |
DAMYTDAR_23 | Deduction Amount YTD Array[23] |
Currency | 10 | View | |
DAMYTDAR_24 | Deduction Amount YTD Array[24] |
Currency | 10 | View | |
DAMYTDAR_25 | Deduction Amount YTD Array[25] |
Currency | 10 | View | |
BAMYTDAR_1 | Benefit Amount YTD Array[1] |
Currency | 10 | View | |
BAMYTDAR_2 | Benefit Amount YTD Array[2] |
Currency | 10 | View | |
BAMYTDAR_3 | Benefit Amount YTD Array[3] |
Currency | 10 | View | |
BAMYTDAR_4 | Benefit Amount YTD Array[4] |
Currency | 10 | View | |
BAMYTDAR_5 | Benefit Amount YTD Array[5] |
Currency | 10 | View | |
BAMYTDAR_6 | Benefit Amount YTD Array[6] |
Currency | 10 | View | |
BAMYTDAR_7 | Benefit Amount YTD Array[7] |
Currency | 10 | View | |
BAMYTDAR_8 | Benefit Amount YTD Array[8] |
Currency | 10 | View | |
BAMYTDAR_9 | Benefit Amount YTD Array[9] |
Currency | 10 | View | |
BAMYTDAR_10 | Benefit Amount YTD Array[10] |
Currency | 10 | View | |
BAMYTDAR_11 | Benefit Amount YTD Array[11] |
Currency | 10 | View | |
BAMYTDAR_12 | Benefit Amount YTD Array[12] |
Currency | 10 | View | |
BAMYTDAR_13 | Benefit Amount YTD Array[13] |
Currency | 10 | View | |
BAMYTDAR_14 | Benefit Amount YTD Array[14] |
Currency | 10 | View | |
BAMYTDAR_15 | Benefit Amount YTD Array[15] |
Currency | 10 | View | |
BAMYTDAR_16 | Benefit Amount YTD Array[16] |
Currency | 10 | View | |
BAMYTDAR_17 | Benefit Amount YTD Array[17] |
Currency | 10 | View | |
BAMYTDAR_18 | Benefit Amount YTD Array[18] |
Currency | 10 | View | |
BAMYTDAR_19 | Benefit Amount YTD Array[19] |
Currency | 10 | View | |
BAMYTDAR_20 | Benefit Amount YTD Array[20] |
Currency | 10 | View | |
BAMYTDAR_21 | Benefit Amount YTD Array[21] |
Currency | 10 | View | |
BAMYTDAR_22 | Benefit Amount YTD Array[22] |
Currency | 10 | View | |
BAMYTDAR_23 | Benefit Amount YTD Array[23] |
Currency | 10 | View | |
BAMYTDAR_24 | Benefit Amount YTD Array[24] |
Currency | 10 | View | |
BAMYTDAR_25 | Benefit Amount YTD Array[25] |
Currency | 10 | View | |
STATXYTD_1 | State Tax YTD[1] |
Currency | 10 | View | |
STATXYTD_2 | State Tax YTD[2] |
Currency | 10 | View | |
STATXYTD_3 | State Tax YTD[3] |
Currency | 10 | View | |
STATXYTD_4 | State Tax YTD[4] |
Currency | 10 | View | |
STATXYTD_5 | State Tax YTD[5] |
Currency | 10 | View | |
STATXYTD_6 | State Tax YTD[6] |
Currency | 10 | View | |
STATXYTD_7 | State Tax YTD[7] |
Currency | 10 | View | |
STATXYTD_8 | State Tax YTD[8] |
Currency | 10 | View | |
STATXYTD_9 | State Tax YTD[9] |
Currency | 10 | View | |
STATXYTD_10 | State Tax YTD[10] |
Currency | 10 | View | |
STATXYTD_11 | State Tax YTD[11] |
Currency | 10 | View | |
STATXYTD_12 | State Tax YTD[12] |
Currency | 10 | View | |
STATXYTD_13 | State Tax YTD[13] |
Currency | 10 | View | |
STATXYTD_14 | State Tax YTD[14] |
Currency | 10 | View | |
STATXYTD_15 | State Tax YTD[15] |
Currency | 10 | View | |
STATXYTD_16 | State Tax YTD[16] |
Currency | 10 | View | |
STATXYTD_17 | State Tax YTD[17] |
Currency | 10 | View | |
STATXYTD_18 | State Tax YTD[18] |
Currency | 10 | View | |
STATXYTD_19 | State Tax YTD[19] |
Currency | 10 | View | |
STATXYTD_20 | State Tax YTD[20] |
Currency | 10 | View | |
STATXYTD_21 | State Tax YTD[21] |
Currency | 10 | View | |
STATXYTD_22 | State Tax YTD[22] |
Currency | 10 | View | |
STATXYTD_23 | State Tax YTD[23] |
Currency | 10 | View | |
STATXYTD_24 | State Tax YTD[24] |
Currency | 10 | View | |
STATXYTD_25 | State Tax YTD[25] |
Currency | 10 | View | |
LCLTXYTD_1 | Local Tax YTD[1] |
Currency | 10 | View | |
LCLTXYTD_2 | Local Tax YTD[2] |
Currency | 10 | View | |
LCLTXYTD_3 | Local Tax YTD[3] |
Currency | 10 | View | |
LCLTXYTD_4 | Local Tax YTD[4] |
Currency | 10 | View | |
LCLTXYTD_5 | Local Tax YTD[5] |
Currency | 10 | View | |
LCLTXYTD_6 | Local Tax YTD[6] |
Currency | 10 | View | |
LCLTXYTD_7 | Local Tax YTD[7] |
Currency | 10 | View | |
LCLTXYTD_8 | Local Tax YTD[8] |
Currency | 10 | View | |
LCLTXYTD_9 | Local Tax YTD[9] |
Currency | 10 | View | |
LCLTXYTD_10 | Local Tax YTD[10] |
Currency | 10 | View | |
LCLTXYTD_11 | Local Tax YTD[11] |
Currency | 10 | View | |
LCLTXYTD_12 | Local Tax YTD[12] |
Currency | 10 | View | |
LCLTXYTD_13 | Local Tax YTD[13] |
Currency | 10 | View | |
LCLTXYTD_14 | Local Tax YTD[14] |
Currency | 10 | View | |
LCLTXYTD_15 | Local Tax YTD[15] |
Currency | 10 | View | |
LCLTXYTD_16 | Local Tax YTD[16] |
Currency | 10 | View | |
LCLTXYTD_17 | Local Tax YTD[17] |
Currency | 10 | View | |
LCLTXYTD_18 | Local Tax YTD[18] |
Currency | 10 | View | |
LCLTXYTD_19 | Local Tax YTD[19] |
Currency | 10 | View | |
LCLTXYTD_20 | Local Tax YTD[20] |
Currency | 10 | View | |
LCLTXYTD_21 | Local Tax YTD[21] |
Currency | 10 | View | |
LCLTXYTD_22 | Local Tax YTD[22] |
Currency | 10 | View | |
LCLTXYTD_23 | Local Tax YTD[23] |
Currency | 10 | View | |
LCLTXYTD_24 | Local Tax YTD[24] |
Currency | 10 | View | |
LCLTXYTD_25 | Local Tax YTD[25] |
Currency | 10 | View | |
GRSWGYTD | Gross Wages YTD |
Currency | 10 | View | |
NTWGSYTD | Net Wages YTD |
Currency | 10 | View | |
FICAWYTD | FICA Withholding YTD |
Currency | 10 | View | |
FCASSYTD | FICA/Social Security Withholding YTD |
Currency | 10 | View | |
FICAMYTD | FICA/Medicare Withholding YTD |
Currency | 10 | View | |
FDWDGYTD | Federal Withholding YTD |
Currency | 10 | View | |
SWHDGYTD | State Withholding YTD |
Currency | 10 | View | |
LCWHGYTD | Local Withholding YTD |
Currency | 10 | View | |
USERID | User ID |
String | 16 | View | |
PYFYTDARR_1 | Pay Fiscal YTD Array[1] |
Currency | 10 | View | |
PYFYTDARR_2 | Pay Fiscal YTD Array[2] |
Currency | 10 | View | |
PYFYTDARR_3 | Pay Fiscal YTD Array[3] |
Currency | 10 | View | |
PYFYTDARR_4 | Pay Fiscal YTD Array[4] |
Currency | 10 | View | |
PYFYTDARR_5 | Pay Fiscal YTD Array[5] |
Currency | 10 | View | |
PYFYTDARR_6 | Pay Fiscal YTD Array[6] |
Currency | 10 | View | |
PYFYTDARR_7 | Pay Fiscal YTD Array[7] |
Currency | 10 | View | |
PYFYTDARR_8 | Pay Fiscal YTD Array[8] |
Currency | 10 | View | |
PYFYTDARR_9 | Pay Fiscal YTD Array[9] |
Currency | 10 | View | |
PYFYTDARR_10 | Pay Fiscal YTD Array[10] |
Currency | 10 | View | |
PYFYTDARR_11 | Pay Fiscal YTD Array[11] |
Currency | 10 | View | |
PYFYTDARR_12 | Pay Fiscal YTD Array[12] |
Currency | 10 | View | |
PYFYTDARR_13 | Pay Fiscal YTD Array[13] |
Currency | 10 | View | |
PYFYTDARR_14 | Pay Fiscal YTD Array[14] |
Currency | 10 | View | |
PYFYTDARR_15 | Pay Fiscal YTD Array[15] |
Currency | 10 | View | |
PYFYTDARR_16 | Pay Fiscal YTD Array[16] |
Currency | 10 | View | |
PYFYTDARR_17 | Pay Fiscal YTD Array[17] |
Currency | 10 | View | |
PYFYTDARR_18 | Pay Fiscal YTD Array[18] |
Currency | 10 | View | |
PYFYTDARR_19 | Pay Fiscal YTD Array[19] |
Currency | 10 | View | |
PYFYTDARR_20 | Pay Fiscal YTD Array[20] |
Currency | 10 | View | |
PYFYTDARR_21 | Pay Fiscal YTD Array[21] |
Currency | 10 | View | |
PYFYTDARR_22 | Pay Fiscal YTD Array[22] |
Currency | 10 | View | |
PYFYTDARR_23 | Pay Fiscal YTD Array[23] |
Currency | 10 | View | |
PYFYTDARR_24 | Pay Fiscal YTD Array[24] |
Currency | 10 | View | |
PYFYTDARR_25 | Pay Fiscal YTD Array[25] |
Currency | 10 | View | |
DAMFYTDAR_1 | Deduction Amount Fiscal YTD Array[1] |
Currency | 10 | View | |
DAMFYTDAR_2 | Deduction Amount Fiscal YTD Array[2] |
Currency | 10 | View | |
DAMFYTDAR_3 | Deduction Amount Fiscal YTD Array[3] |
Currency | 10 | View | |
DAMFYTDAR_4 | Deduction Amount Fiscal YTD Array[4] |
Currency | 10 | View | |
DAMFYTDAR_5 | Deduction Amount Fiscal YTD Array[5] |
Currency | 10 | View | |
DAMFYTDAR_6 | Deduction Amount Fiscal YTD Array[6] |
Currency | 10 | View | |
DAMFYTDAR_7 | Deduction Amount Fiscal YTD Array[7] |
Currency | 10 | View | |
DAMFYTDAR_8 | Deduction Amount Fiscal YTD Array[8] |
Currency | 10 | View | |
DAMFYTDAR_9 | Deduction Amount Fiscal YTD Array[9] |
Currency | 10 | View | |
DAMFYTDAR_10 | Deduction Amount Fiscal YTD Array[10] |
Currency | 10 | View | |
DAMFYTDAR_11 | Deduction Amount Fiscal YTD Array[11] |
Currency | 10 | View | |
DAMFYTDAR_12 | Deduction Amount Fiscal YTD Array[12] |
Currency | 10 | View | |
DAMFYTDAR_13 | Deduction Amount Fiscal YTD Array[13] |
Currency | 10 | View | |
DAMFYTDAR_14 | Deduction Amount Fiscal YTD Array[14] |
Currency | 10 | View | |
DAMFYTDAR_15 | Deduction Amount Fiscal YTD Array[15] |
Currency | 10 | View | |
DAMFYTDAR_16 | Deduction Amount Fiscal YTD Array[16] |
Currency | 10 | View | |
DAMFYTDAR_17 | Deduction Amount Fiscal YTD Array[17] |
Currency | 10 | View | |
DAMFYTDAR_18 | Deduction Amount Fiscal YTD Array[18] |
Currency | 10 | View | |
DAMFYTDAR_19 | Deduction Amount Fiscal YTD Array[19] |
Currency | 10 | View | |
DAMFYTDAR_20 | Deduction Amount Fiscal YTD Array[20] |
Currency | 10 | View | |
DAMFYTDAR_21 | Deduction Amount Fiscal YTD Array[21] |
Currency | 10 | View | |
DAMFYTDAR_22 | Deduction Amount Fiscal YTD Array[22] |
Currency | 10 | View | |
DAMFYTDAR_23 | Deduction Amount Fiscal YTD Array[23] |
Currency | 10 | View | |
DAMFYTDAR_24 | Deduction Amount Fiscal YTD Array[24] |
Currency | 10 | View | |
DAMFYTDAR_25 | Deduction Amount Fiscal YTD Array[25] |
Currency | 10 | View | |
BAMFYTDAR_1 | Benefit Amount Fiscal YTD Array[1] |
Currency | 10 | View | |
BAMFYTDAR_2 | Benefit Amount Fiscal YTD Array[2] |
Currency | 10 | View | |
BAMFYTDAR_3 | Benefit Amount Fiscal YTD Array[3] |
Currency | 10 | View | |
BAMFYTDAR_4 | Benefit Amount Fiscal YTD Array[4] |
Currency | 10 | View | |
BAMFYTDAR_5 | Benefit Amount Fiscal YTD Array[5] |
Currency | 10 | View | |
BAMFYTDAR_6 | Benefit Amount Fiscal YTD Array[6] |
Currency | 10 | View | |
BAMFYTDAR_7 | Benefit Amount Fiscal YTD Array[7] |
Currency | 10 | View | |
BAMFYTDAR_8 | Benefit Amount Fiscal YTD Array[8] |
Currency | 10 | View | |
BAMFYTDAR_9 | Benefit Amount Fiscal YTD Array[9] |
Currency | 10 | View | |
BAMFYTDAR_10 | Benefit Amount Fiscal YTD Array[10] |
Currency | 10 | View | |
BAMFYTDAR_11 | Benefit Amount Fiscal YTD Array[11] |
Currency | 10 | View | |
BAMFYTDAR_12 | Benefit Amount Fiscal YTD Array[12] |
Currency | 10 | View | |
BAMFYTDAR_13 | Benefit Amount Fiscal YTD Array[13] |
Currency | 10 | View | |
BAMFYTDAR_14 | Benefit Amount Fiscal YTD Array[14] |
Currency | 10 | View | |
BAMFYTDAR_15 | Benefit Amount Fiscal YTD Array[15] |
Currency | 10 | View | |
BAMFYTDAR_16 | Benefit Amount Fiscal YTD Array[16] |
Currency | 10 | View | |
BAMFYTDAR_17 | Benefit Amount Fiscal YTD Array[17] |
Currency | 10 | View | |
BAMFYTDAR_18 | Benefit Amount Fiscal YTD Array[18] |
Currency | 10 | View | |
BAMFYTDAR_19 | Benefit Amount Fiscal YTD Array[19] |
Currency | 10 | View | |
BAMFYTDAR_20 | Benefit Amount Fiscal YTD Array[20] |
Currency | 10 | View | |
BAMFYTDAR_21 | Benefit Amount Fiscal YTD Array[21] |
Currency | 10 | View | |
BAMFYTDAR_22 | Benefit Amount Fiscal YTD Array[22] |
Currency | 10 | View | |
BAMFYTDAR_23 | Benefit Amount Fiscal YTD Array[23] |
Currency | 10 | View | |
BAMFYTDAR_24 | Benefit Amount Fiscal YTD Array[24] |
Currency | 10 | View | |
BAMFYTDAR_25 | Benefit Amount Fiscal YTD Array[25] |
Currency | 10 | View |