Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
EMPLOYID | Employee ID |
String | 16 | View | |
PYCDDSAR_1 | Pay Code Description Array[1] |
String | 32 | View | |
PYCDDSAR_2 | Pay Code Description Array[2] |
String | 32 | View | |
PYCDDSAR_3 | Pay Code Description Array[3] |
String | 32 | View | |
PYCDDSAR_4 | Pay Code Description Array[4] |
String | 32 | View | |
PYCDDSAR_5 | Pay Code Description Array[5] |
String | 32 | View | |
PYCDDSAR_6 | Pay Code Description Array[6] |
String | 32 | View | |
PYCDDSAR_7 | Pay Code Description Array[7] |
String | 32 | View | |
PYCDDSAR_8 | Pay Code Description Array[8] |
String | 32 | View | |
PYCDDSAR_9 | Pay Code Description Array[9] |
String | 32 | View | |
PYCDDSAR_10 | Pay Code Description Array[10] |
String | 32 | View | |
PYCDDSAR_11 | Pay Code Description Array[11] |
String | 32 | View | |
PYCDDSAR_12 | Pay Code Description Array[12] |
String | 32 | View | |
PYCDDSAR_13 | Pay Code Description Array[13] |
String | 32 | View | |
PYCDDSAR_14 | Pay Code Description Array[14] |
String | 32 | View | |
PYCDDSAR_15 | Pay Code Description Array[15] |
String | 32 | View | |
PYCDDSAR_16 | Pay Code Description Array[16] |
String | 32 | View | |
PYCDDSAR_17 | Pay Code Description Array[17] |
String | 32 | View | |
PYCDDSAR_18 | Pay Code Description Array[18] |
String | 32 | View | |
PYCDDSAR_19 | Pay Code Description Array[19] |
String | 32 | View | |
PYCDDSAR_20 | Pay Code Description Array[20] |
String | 32 | View | |
PYCDDSAR_21 | Pay Code Description Array[21] |
String | 32 | View | |
PYCDDSAR_22 | Pay Code Description Array[22] |
String | 32 | View | |
PYCDDSAR_23 | Pay Code Description Array[23] |
String | 32 | View | |
PYCDDSAR_24 | Pay Code Description Array[24] |
String | 32 | View | |
PYCDDSAR_25 | Pay Code Description Array[25] |
String | 32 | View | |
deddesar_1 | Deduction Description Array[1] |
String | 32 | View | |
deddesar_2 | Deduction Description Array[2] |
String | 32 | View | |
deddesar_3 | Deduction Description Array[3] |
String | 32 | View | |
deddesar_4 | Deduction Description Array[4] |
String | 32 | View | |
deddesar_5 | Deduction Description Array[5] |
String | 32 | View | |
deddesar_6 | Deduction Description Array[6] |
String | 32 | View | |
deddesar_7 | Deduction Description Array[7] |
String | 32 | View | |
deddesar_8 | Deduction Description Array[8] |
String | 32 | View | |
deddesar_9 | Deduction Description Array[9] |
String | 32 | View | |
deddesar_10 | Deduction Description Array[10] |
String | 32 | View | |
deddesar_11 | Deduction Description Array[11] |
String | 32 | View | |
deddesar_12 | Deduction Description Array[12] |
String | 32 | View | |
deddesar_13 | Deduction Description Array[13] |
String | 32 | View | |
deddesar_14 | Deduction Description Array[14] |
String | 32 | View | |
deddesar_15 | Deduction Description Array[15] |
String | 32 | View | |
deddesar_16 | Deduction Description Array[16] |
String | 32 | View | |
deddesar_17 | Deduction Description Array[17] |
String | 32 | View | |
deddesar_18 | Deduction Description Array[18] |
String | 32 | View | |
deddesar_19 | Deduction Description Array[19] |
String | 32 | View | |
deddesar_20 | Deduction Description Array[20] |
String | 32 | View | |
deddesar_21 | Deduction Description Array[21] |
String | 32 | View | |
deddesar_22 | Deduction Description Array[22] |
String | 32 | View | |
deddesar_23 | Deduction Description Array[23] |
String | 32 | View | |
deddesar_24 | Deduction Description Array[24] |
String | 32 | View | |
deddesar_25 | Deduction Description Array[25] |
String | 32 | View | |
BENDESAR_1 | Benefit Description Array[1] |
String | 32 | View | |
BENDESAR_2 | Benefit Description Array[2] |
String | 32 | View | |
BENDESAR_3 | Benefit Description Array[3] |
String | 32 | View | |
BENDESAR_4 | Benefit Description Array[4] |
String | 32 | View | |
BENDESAR_5 | Benefit Description Array[5] |
String | 32 | View | |
BENDESAR_6 | Benefit Description Array[6] |
String | 32 | View | |
BENDESAR_7 | Benefit Description Array[7] |
String | 32 | View | |
BENDESAR_8 | Benefit Description Array[8] |
String | 32 | View | |
BENDESAR_9 | Benefit Description Array[9] |
String | 32 | View | |
BENDESAR_10 | Benefit Description Array[10] |
String | 32 | View | |
BENDESAR_11 | Benefit Description Array[11] |
String | 32 | View | |
BENDESAR_12 | Benefit Description Array[12] |
String | 32 | View | |
BENDESAR_13 | Benefit Description Array[13] |
String | 32 | View | |
BENDESAR_14 | Benefit Description Array[14] |
String | 32 | View | |
BENDESAR_15 | Benefit Description Array[15] |
String | 32 | View | |
BENDESAR_16 | Benefit Description Array[16] |
String | 32 | View | |
BENDESAR_17 | Benefit Description Array[17] |
String | 32 | View | |
BENDESAR_18 | Benefit Description Array[18] |
String | 32 | View | |
BENDESAR_19 | Benefit Description Array[19] |
String | 32 | View | |
BENDESAR_20 | Benefit Description Array[20] |
String | 32 | View | |
BENDESAR_21 | Benefit Description Array[21] |
String | 32 | View | |
BENDESAR_22 | Benefit Description Array[22] |
String | 32 | View | |
BENDESAR_23 | Benefit Description Array[23] |
String | 32 | View | |
BENDESAR_24 | Benefit Description Array[24] |
String | 32 | View | |
BENDESAR_25 | Benefit Description Array[25] |
String | 32 | View | |
TIMECODEDESCARRAY_1 | Time Code Description Array[1] |
String | 32 | View | |
TIMECODEDESCARRAY_2 | Time Code Description Array[2] |
String | 32 | View | |
TIMECODEDESCARRAY_3 | Time Code Description Array[3] |
String | 32 | View | |
TIMECODEDESCARRAY_4 | Time Code Description Array[4] |
String | 32 | View | |
TIMECODEDESCARRAY_5 | Time Code Description Array[5] |
String | 32 | View | |
TIMECODEDESCARRAY_6 | Time Code Description Array[6] |
String | 32 | View | |
TIMECODEDESCARRAY_7 | Time Code Description Array[7] |
String | 32 | View | |
TIMECODEDESCARRAY_8 | Time Code Description Array[8] |
String | 32 | View | |
TIMECODEDESCARRAY_9 | Time Code Description Array[9] |
String | 32 | View | |
TIMECODEDESCARRAY_10 | Time Code Description Array[10] |
String | 32 | View | |
TIMECODEDESCARRAY_11 | Time Code Description Array[11] |
String | 32 | View | |
TIMECODEDESCARRAY_12 | Time Code Description Array[12] |
String | 32 | View | |
TIMECODEDESCARRAY_13 | Time Code Description Array[13] |
String | 32 | View | |
TIMECODEDESCARRAY_14 | Time Code Description Array[14] |
String | 32 | View | |
TIMECODEDESCARRAY_15 | Time Code Description Array[15] |
String | 32 | View | |
TIMECODEDESCARRAY_16 | Time Code Description Array[16] |
String | 32 | View | |
TIMECODEDESCARRAY_17 | Time Code Description Array[17] |
String | 32 | View | |
TIMECODEDESCARRAY_18 | Time Code Description Array[18] |
String | 32 | View | |
TIMECODEDESCARRAY_19 | Time Code Description Array[19] |
String | 32 | View | |
TIMECODEDESCARRAY_20 | Time Code Description Array[20] |
String | 32 | View | |
TIMECODEDESCARRAY_21 | Time Code Description Array[21] |
String | 32 | View | |
TIMECODEDESCARRAY_22 | Time Code Description Array[22] |
String | 32 | View | |
TIMECODEDESCARRAY_23 | Time Code Description Array[23] |
String | 32 | View | |
TIMECODEDESCARRAY_24 | Time Code Description Array[24] |
String | 32 | View | |
TIMECODEDESCARRAY_25 | Time Code Description Array[25] |
String | 32 | View | |
PAYARRCD_1 | Pay Code Array[1] |
String | 8 | View | |
PAYARRCD_2 | Pay Code Array[2] |
String | 8 | View | |
PAYARRCD_3 | Pay Code Array[3] |
String | 8 | View | |
PAYARRCD_4 | Pay Code Array[4] |
String | 8 | View | |
PAYARRCD_5 | Pay Code Array[5] |
String | 8 | View | |
PAYARRCD_6 | Pay Code Array[6] |
String | 8 | View | |
PAYARRCD_7 | Pay Code Array[7] |
String | 8 | View | |
PAYARRCD_8 | Pay Code Array[8] |
String | 8 | View | |
PAYARRCD_9 | Pay Code Array[9] |
String | 8 | View | |
PAYARRCD_10 | Pay Code Array[10] |
String | 8 | View | |
PAYARRCD_11 | Pay Code Array[11] |
String | 8 | View | |
PAYARRCD_12 | Pay Code Array[12] |
String | 8 | View | |
PAYARRCD_13 | Pay Code Array[13] |
String | 8 | View | |
PAYARRCD_14 | Pay Code Array[14] |
String | 8 | View | |
PAYARRCD_15 | Pay Code Array[15] |
String | 8 | View | |
PAYARRCD_16 | Pay Code Array[16] |
String | 8 | View | |
PAYARRCD_17 | Pay Code Array[17] |
String | 8 | View | |
PAYARRCD_18 | Pay Code Array[18] |
String | 8 | View | |
PAYARRCD_19 | Pay Code Array[19] |
String | 8 | View | |
PAYARRCD_20 | Pay Code Array[20] |
String | 8 | View | |
PAYARRCD_21 | Pay Code Array[21] |
String | 8 | View | |
PAYARRCD_22 | Pay Code Array[22] |
String | 8 | View | |
PAYARRCD_23 | Pay Code Array[23] |
String | 8 | View | |
PAYARRCD_24 | Pay Code Array[24] |
String | 8 | View | |
PAYARRCD_25 | Pay Code Array[25] |
String | 8 | View | |
DEDCDARR_1 | Deduction Code Array[1] |
String | 8 | View | |
DEDCDARR_2 | Deduction Code Array[2] |
String | 8 | View | |
DEDCDARR_3 | Deduction Code Array[3] |
String | 8 | View | |
DEDCDARR_4 | Deduction Code Array[4] |
String | 8 | View | |
DEDCDARR_5 | Deduction Code Array[5] |
String | 8 | View | |
DEDCDARR_6 | Deduction Code Array[6] |
String | 8 | View | |
DEDCDARR_7 | Deduction Code Array[7] |
String | 8 | View | |
DEDCDARR_8 | Deduction Code Array[8] |
String | 8 | View | |
DEDCDARR_9 | Deduction Code Array[9] |
String | 8 | View | |
DEDCDARR_10 | Deduction Code Array[10] |
String | 8 | View | |
DEDCDARR_11 | Deduction Code Array[11] |
String | 8 | View | |
DEDCDARR_12 | Deduction Code Array[12] |
String | 8 | View | |
DEDCDARR_13 | Deduction Code Array[13] |
String | 8 | View | |
DEDCDARR_14 | Deduction Code Array[14] |
String | 8 | View | |
DEDCDARR_15 | Deduction Code Array[15] |
String | 8 | View | |
DEDCDARR_16 | Deduction Code Array[16] |
String | 8 | View | |
DEDCDARR_17 | Deduction Code Array[17] |
String | 8 | View | |
DEDCDARR_18 | Deduction Code Array[18] |
String | 8 | View | |
DEDCDARR_19 | Deduction Code Array[19] |
String | 8 | View | |
DEDCDARR_20 | Deduction Code Array[20] |
String | 8 | View | |
DEDCDARR_21 | Deduction Code Array[21] |
String | 8 | View | |
DEDCDARR_22 | Deduction Code Array[22] |
String | 8 | View | |
DEDCDARR_23 | Deduction Code Array[23] |
String | 8 | View | |
DEDCDARR_24 | Deduction Code Array[24] |
String | 8 | View | |
DEDCDARR_25 | Deduction Code Array[25] |
String | 8 | View | |
BNFCDARR_1 | Benefit Code Array[1] |
String | 8 | View | |
BNFCDARR_2 | Benefit Code Array[2] |
String | 8 | View | |
BNFCDARR_3 | Benefit Code Array[3] |
String | 8 | View | |
BNFCDARR_4 | Benefit Code Array[4] |
String | 8 | View | |
BNFCDARR_5 | Benefit Code Array[5] |
String | 8 | View | |
BNFCDARR_6 | Benefit Code Array[6] |
String | 8 | View | |
BNFCDARR_7 | Benefit Code Array[7] |
String | 8 | View | |
BNFCDARR_8 | Benefit Code Array[8] |
String | 8 | View | |
BNFCDARR_9 | Benefit Code Array[9] |
String | 8 | View | |
BNFCDARR_10 | Benefit Code Array[10] |
String | 8 | View | |
BNFCDARR_11 | Benefit Code Array[11] |
String | 8 | View | |
BNFCDARR_12 | Benefit Code Array[12] |
String | 8 | View | |
BNFCDARR_13 | Benefit Code Array[13] |
String | 8 | View | |
BNFCDARR_14 | Benefit Code Array[14] |
String | 8 | View | |
BNFCDARR_15 | Benefit Code Array[15] |
String | 8 | View | |
BNFCDARR_16 | Benefit Code Array[16] |
String | 8 | View | |
BNFCDARR_17 | Benefit Code Array[17] |
String | 8 | View | |
BNFCDARR_18 | Benefit Code Array[18] |
String | 8 | View | |
BNFCDARR_19 | Benefit Code Array[19] |
String | 8 | View | |
BNFCDARR_20 | Benefit Code Array[20] |
String | 8 | View | |
BNFCDARR_21 | Benefit Code Array[21] |
String | 8 | View | |
BNFCDARR_22 | Benefit Code Array[22] |
String | 8 | View | |
BNFCDARR_23 | Benefit Code Array[23] |
String | 8 | View | |
BNFCDARR_24 | Benefit Code Array[24] |
String | 8 | View | |
BNFCDARR_25 | Benefit Code Array[25] |
String | 8 | View | |
TIMECODEARRAY_1 | Time Code Array[1] |
String | 8 | View | |
TIMECODEARRAY_2 | Time Code Array[2] |
String | 8 | View | |
TIMECODEARRAY_3 | Time Code Array[3] |
String | 8 | View | |
TIMECODEARRAY_4 | Time Code Array[4] |
String | 8 | View | |
TIMECODEARRAY_5 | Time Code Array[5] |
String | 8 | View | |
TIMECODEARRAY_6 | Time Code Array[6] |
String | 8 | View | |
TIMECODEARRAY_7 | Time Code Array[7] |
String | 8 | View | |
TIMECODEARRAY_8 | Time Code Array[8] |
String | 8 | View | |
TIMECODEARRAY_9 | Time Code Array[9] |
String | 8 | View | |
TIMECODEARRAY_10 | Time Code Array[10] |
String | 8 | View | |
TIMECODEARRAY_11 | Time Code Array[11] |
String | 8 | View | |
TIMECODEARRAY_12 | Time Code Array[12] |
String | 8 | View | |
TIMECODEARRAY_13 | Time Code Array[13] |
String | 8 | View | |
TIMECODEARRAY_14 | Time Code Array[14] |
String | 8 | View | |
TIMECODEARRAY_15 | Time Code Array[15] |
String | 8 | View | |
TIMECODEARRAY_16 | Time Code Array[16] |
String | 8 | View | |
TIMECODEARRAY_17 | Time Code Array[17] |
String | 8 | View | |
TIMECODEARRAY_18 | Time Code Array[18] |
String | 8 | View | |
TIMECODEARRAY_19 | Time Code Array[19] |
String | 8 | View | |
TIMECODEARRAY_20 | Time Code Array[20] |
String | 8 | View | |
TIMECODEARRAY_21 | Time Code Array[21] |
String | 8 | View | |
TIMECODEARRAY_22 | Time Code Array[22] |
String | 8 | View | |
TIMECODEARRAY_23 | Time Code Array[23] |
String | 8 | View | |
TIMECODEARRAY_24 | Time Code Array[24] |
String | 8 | View | |
TIMECODEARRAY_25 | Time Code Array[25] |
String | 8 | View | |
STATXARR_1 | State Tax Array[1] |
String | 4 | View | |
STATXARR_2 | State Tax Array[2] |
String | 4 | View | |
STATXARR_3 | State Tax Array[3] |
String | 4 | View | |
STATXARR_4 | State Tax Array[4] |
String | 4 | View | |
STATXARR_5 | State Tax Array[5] |
String | 4 | View | |
STATXARR_6 | State Tax Array[6] |
String | 4 | View | |
STATXARR_7 | State Tax Array[7] |
String | 4 | View | |
STATXARR_8 | State Tax Array[8] |
String | 4 | View | |
STATXARR_9 | State Tax Array[9] |
String | 4 | View | |
STATXARR_10 | State Tax Array[10] |
String | 4 | View | |
STATXARR_11 | State Tax Array[11] |
String | 4 | View | |
STATXARR_12 | State Tax Array[12] |
String | 4 | View | |
STATXARR_13 | State Tax Array[13] |
String | 4 | View | |
STATXARR_14 | State Tax Array[14] |
String | 4 | View | |
STATXARR_15 | State Tax Array[15] |
String | 4 | View | |
STATXARR_16 | State Tax Array[16] |
String | 4 | View | |
STATXARR_17 | State Tax Array[17] |
String | 4 | View | |
STATXARR_18 | State Tax Array[18] |
String | 4 | View | |
STATXARR_19 | State Tax Array[19] |
String | 4 | View | |
STATXARR_20 | State Tax Array[20] |
String | 4 | View | |
STATXARR_21 | State Tax Array[21] |
String | 4 | View | |
STATXARR_22 | State Tax Array[22] |
String | 4 | View | |
STATXARR_23 | State Tax Array[23] |
String | 4 | View | |
STATXARR_24 | State Tax Array[24] |
String | 4 | View | |
STATXARR_25 | State Tax Array[25] |
String | 4 | View | |
LCLTXARR_1 | Local Tax Array[1] |
String | 8 | View | |
LCLTXARR_2 | Local Tax Array[2] |
String | 8 | View | |
LCLTXARR_3 | Local Tax Array[3] |
String | 8 | View | |
LCLTXARR_4 | Local Tax Array[4] |
String | 8 | View | |
LCLTXARR_5 | Local Tax Array[5] |
String | 8 | View | |
LCLTXARR_6 | Local Tax Array[6] |
String | 8 | View | |
LCLTXARR_7 | Local Tax Array[7] |
String | 8 | View | |
LCLTXARR_8 | Local Tax Array[8] |
String | 8 | View | |
LCLTXARR_9 | Local Tax Array[9] |
String | 8 | View | |
LCLTXARR_10 | Local Tax Array[10] |
String | 8 | View | |
LCLTXARR_11 | Local Tax Array[11] |
String | 8 | View | |
LCLTXARR_12 | Local Tax Array[12] |
String | 8 | View | |
LCLTXARR_13 | Local Tax Array[13] |
String | 8 | View | |
LCLTXARR_14 | Local Tax Array[14] |
String | 8 | View | |
LCLTXARR_15 | Local Tax Array[15] |
String | 8 | View | |
LCLTXARR_16 | Local Tax Array[16] |
String | 8 | View | |
LCLTXARR_17 | Local Tax Array[17] |
String | 8 | View | |
LCLTXARR_18 | Local Tax Array[18] |
String | 8 | View | |
LCLTXARR_19 | Local Tax Array[19] |
String | 8 | View | |
LCLTXARR_20 | Local Tax Array[20] |
String | 8 | View | |
LCLTXARR_21 | Local Tax Array[21] |
String | 8 | View | |
LCLTXARR_22 | Local Tax Array[22] |
String | 8 | View | |
LCLTXARR_23 | Local Tax Array[23] |
String | 8 | View | |
LCLTXARR_24 | Local Tax Array[24] |
String | 8 | View | |
LCLTXARR_25 | Local Tax Array[25] |
String | 8 | View | |
USERID | User ID |
String | 16 | View |