Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP32
Product: SmartList (1493)
Series:
Display Name: SmartList Payroll Employee Summary
Physical Name: ASIEXP32
Technical Name: ASI_UPR_Employee_SUM_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 YEAR1 Year Integer Year 4 3 EMPLCLAS Employee Class String STR15_Employee_Class 15 4 INACTIVE Inactive Boolean CB_Inactive 0 5 LASTNAME Last Name String STR20 20 6 FRSTNAME First Name String STR15 15 7 MIDLNAME Middle Name String STR15 15 8 SOCSCNUM Social Security Number String STR15_Social_Security_Number 15 9 BRTHDATE Birth Date Date DT 8 10 GENDER Gender Integer DDL_Gender 0 11 ETHNORGN Ethnic Origin Integer DDL_Ethnic Origin 0 12 Calc_Min_Wage_Bal Calc Min Wage Bal Boolean CB_CalcMinWageBal 0 13 DEPRTMNT Department String STR6_Payroll_Code 6 14 JOBTITLE Job Title String STR6_Payroll_Code 6 15 WCACFPAY Which Cash Account For Pay Integer GB 0 16 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Payroll Employee Summary'].ACTINDX AS 'SmartList Payroll Employee Summary-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP32 AS ['SmartList Payroll Employee Summary']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payroll Employee Summary'].ACTINDX = ['Account Index Master'].ACTINDX17 WKHRPRYR Work Hours Per Year Integer INT4_U0 4 18 STRTDATE Start Date Date DT 8 19 DEMPINAC Date Employee Inactivated Date DT 8 20 RSNEMPIN Reason Employee Inactivated String STR30 30 21 MINETPAY Minimum Net Pay Currency DLR11_$U2 14 22 SUTASTAT Suta State String STR2_State_Code 2 23 WRKRCOMP Workers Comp String STR6_Payroll_Code 6 24 ATACRVAC Auto Accrue Vacation Boolean CB_Accrue_Vacation: 0 25 VACCRAMT Vacation Accrual Amount Long Integer LI6_U2 6 26 VACCRMTH Vacation Accrual Method Integer GB 0 27 VACAPRYR Vacation Hours Per Year Long Integer LI6_U2 6 28 VACAVLBL Vacation Available Long Integer LI6_S2 6 29 ATACRSTM Auto Accrue Sick Time Boolean CB_Accrue_Sick_Time: 0 30 STMACMTH Sick Time Accrual Method Integer GB 0 31 SKTMACAM Sick Time Accrual Amount Long Integer LI6_U2 6 32 SIKTIMAV Sick Time Available Long Integer LI6_S2 6 33 SKTMHPYR Sick Time Hours Per Year Long Integer LI6_U2 6 34 USERDEF1 User Defined 1 String STR20 20 35 USERDEF2 User Defined 2 String STR20 20 36 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SmartList Payroll Employee Summary'].NOTEINDX AS 'SmartList Payroll Employee Summary-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP32 AS ['SmartList Payroll Employee Summary']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Payroll Employee Summary'].NOTEINDX = ['Record Notes Master'].NOTEINDX37 LPCHKNUM Last Paycheck Number String Check_Number 20 38 LSTPCKDT Last Paycheck Date Date DT 8 39 LPCHKAMT Last Paycheck Amount Currency DLR11_$S2 14 40 GROSWAGS_1 Gross Wages[1] Currency DLR11_$S2 14 41 GROSWAGS_2 Gross Wages[2] Currency DLR11_$S2 14 42 GROSWAGS_3 Gross Wages[3] Currency DLR11_$S2 14 43 GROSWAGS_4 Gross Wages[4] Currency DLR11_$S2 14 44 GROSWAGS_5 Gross Wages[5] Currency DLR11_$S2 14 45 GROSWAGS_6 Gross Wages[6] Currency DLR11_$S2 14 46 GROSWAGS_7 Gross Wages[7] Currency DLR11_$S2 14 47 GROSWAGS_8 Gross Wages[8] Currency DLR11_$S2 14 48 GROSWAGS_9 Gross Wages[9] Currency DLR11_$S2 14 49 GROSWAGS_10 Gross Wages[10] Currency DLR11_$S2 14 50 GROSWAGS_11 Gross Wages[11] Currency DLR11_$S2 14 51 GROSWAGS_12 Gross Wages[12] Currency DLR11_$S2 14 52 Federal_Wages_1 Federal Wages[1] Currency DLR11_$S2 14 53 Federal_Wages_2 Federal Wages[2] Currency DLR11_$S2 14 54 Federal_Wages_3 Federal Wages[3] Currency DLR11_$S2 14 55 Federal_Wages_4 Federal Wages[4] Currency DLR11_$S2 14 56 Federal_Wages_5 Federal Wages[5] Currency DLR11_$S2 14 57 Federal_Wages_6 Federal Wages[6] Currency DLR11_$S2 14 58 Federal_Wages_7 Federal Wages[7] Currency DLR11_$S2 14 59 Federal_Wages_8 Federal Wages[8] Currency DLR11_$S2 14 60 Federal_Wages_9 Federal Wages[9] Currency DLR11_$S2 14 61 Federal_Wages_10 Federal Wages[10] Currency DLR11_$S2 14 62 Federal_Wages_11 Federal Wages[11] Currency DLR11_$S2 14 63 Federal_Wages_12 Federal Wages[12] Currency DLR11_$S2 14 64 Federal_Tips_1 Federal Tips[1] Currency DLR11_$S2 14 65 Federal_Tips_2 Federal Tips[2] Currency DLR11_$S2 14 66 Federal_Tips_3 Federal Tips[3] Currency DLR11_$S2 14 67 Federal_Tips_4 Federal Tips[4] Currency DLR11_$S2 14 68 Federal_Tips_5 Federal Tips[5] Currency DLR11_$S2 14 69 Federal_Tips_6 Federal Tips[6] Currency DLR11_$S2 14 70 Federal_Tips_7 Federal Tips[7] Currency DLR11_$S2 14 71 Federal_Tips_8 Federal Tips[8] Currency DLR11_$S2 14 72 Federal_Tips_9 Federal Tips[9] Currency DLR11_$S2 14 73 Federal_Tips_10 Federal Tips[10] Currency DLR11_$S2 14 74 Federal_Tips_11 Federal Tips[11] Currency DLR11_$S2 14 75 Federal_Tips_12 Federal Tips[12] Currency DLR11_$S2 14 76 FDWTHLDG_1 Federal Withholding[1] Currency DLR11_$S2 14 77 FDWTHLDG_2 Federal Withholding[2] Currency DLR11_$S2 14 78 FDWTHLDG_3 Federal Withholding[3] Currency DLR11_$S2 14 79 FDWTHLDG_4 Federal Withholding[4] Currency DLR11_$S2 14 80 FDWTHLDG_5 Federal Withholding[5] Currency DLR11_$S2 14 81 FDWTHLDG_6 Federal Withholding[6] Currency DLR11_$S2 14 82 FDWTHLDG_7 Federal Withholding[7] Currency DLR11_$S2 14 83 FDWTHLDG_8 Federal Withholding[8] Currency DLR11_$S2 14 84 FDWTHLDG_9 Federal Withholding[9] Currency DLR11_$S2 14 85 FDWTHLDG_10 Federal Withholding[10] Currency DLR11_$S2 14 86 FDWTHLDG_11 Federal Withholding[11] Currency DLR11_$S2 14 87 FDWTHLDG_12 Federal Withholding[12] Currency DLR11_$S2 14 88 FICASSWG_1 FICA/Social Security Wages[1] Currency DLR11_$S2 14 89 FICASSWG_2 FICA/Social Security Wages[2] Currency DLR11_$S2 14 90 FICASSWG_3 FICA/Social Security Wages[3] Currency DLR11_$S2 14 91 FICASSWG_4 FICA/Social Security Wages[4] Currency DLR11_$S2 14 92 FICASSWG_5 FICA/Social Security Wages[5] Currency DLR11_$S2 14 93 FICASSWG_6 FICA/Social Security Wages[6] Currency DLR11_$S2 14 94 FICASSWG_7 FICA/Social Security Wages[7] Currency DLR11_$S2 14 95 FICASSWG_8 FICA/Social Security Wages[8] Currency DLR11_$S2 14 96 FICASSWG_9 FICA/Social Security Wages[9] Currency DLR11_$S2 14 97 FICASSWG_10 FICA/Social Security Wages[10] Currency DLR11_$S2 14 98 FICASSWG_11 FICA/Social Security Wages[11] Currency DLR11_$S2 14 99 FICASSWG_12 FICA/Social Security Wages[12] Currency DLR11_$S2 14 100 FICAMWGS_1 FICA/Medicare Wages[1] Currency DLR11_$S2 14 101 FICAMWGS_2 FICA/Medicare Wages[2] Currency DLR11_$S2 14 102 FICAMWGS_3 FICA/Medicare Wages[3] Currency DLR11_$S2 14 103 FICAMWGS_4 FICA/Medicare Wages[4] Currency DLR11_$S2 14 104 FICAMWGS_5 FICA/Medicare Wages[5] Currency DLR11_$S2 14 105 FICAMWGS_6 FICA/Medicare Wages[6] Currency DLR11_$S2 14 106 FICAMWGS_7 FICA/Medicare Wages[7] Currency DLR11_$S2 14 107 FICAMWGS_8 FICA/Medicare Wages[8] Currency DLR11_$S2 14 108 FICAMWGS_9 FICA/Medicare Wages[9] Currency DLR11_$S2 14 109 FICAMWGS_10 FICA/Medicare Wages[10] Currency DLR11_$S2 14 110 FICAMWGS_11 FICA/Medicare Wages[11] Currency DLR11_$S2 14 111 FICAMWGS_12 FICA/Medicare Wages[12] Currency DLR11_$S2 14 112 FICASSWH_1 FICA/Social Security Withholding[1] Currency DLR11_$S2 14 113 FICASSWH_2 FICA/Social Security Withholding[2] Currency DLR11_$S2 14 114 FICASSWH_3 FICA/Social Security Withholding[3] Currency DLR11_$S2 14 115 FICASSWH_4 FICA/Social Security Withholding[4] Currency DLR11_$S2 14 116 FICASSWH_5 FICA/Social Security Withholding[5] Currency DLR11_$S2 14 117 FICASSWH_6 FICA/Social Security Withholding[6] Currency DLR11_$S2 14 118 FICASSWH_7 FICA/Social Security Withholding[7] Currency DLR11_$S2 14 119 FICASSWH_8 FICA/Social Security Withholding[8] Currency DLR11_$S2 14 120 FICASSWH_9 FICA/Social Security Withholding[9] Currency DLR11_$S2 14 121 FICASSWH_10 FICA/Social Security Withholding[10] Currency DLR11_$S2 14 122 FICASSWH_11 FICA/Social Security Withholding[11] Currency DLR11_$S2 14 123 FICASSWH_12 FICA/Social Security Withholding[12] Currency DLR11_$S2 14 124 FICAMWDG_1 FICA/Medicare Withholding[1] Currency DLR11_$S2 14 125 FICAMWDG_2 FICA/Medicare Withholding[2] Currency DLR11_$S2 14 126 FICAMWDG_3 FICA/Medicare Withholding[3] Currency DLR11_$S2 14 127 FICAMWDG_4 FICA/Medicare Withholding[4] Currency DLR11_$S2 14 128 FICAMWDG_5 FICA/Medicare Withholding[5] Currency DLR11_$S2 14 129 FICAMWDG_6 FICA/Medicare Withholding[6] Currency DLR11_$S2 14 130 FICAMWDG_7 FICA/Medicare Withholding[7] Currency DLR11_$S2 14 131 FICAMWDG_8 FICA/Medicare Withholding[8] Currency DLR11_$S2 14 132 FICAMWDG_9 FICA/Medicare Withholding[9] Currency DLR11_$S2 14 133 FICAMWDG_10 FICA/Medicare Withholding[10] Currency DLR11_$S2 14 134 FICAMWDG_11 FICA/Medicare Withholding[11] Currency DLR11_$S2 14 135 FICAMWDG_12 FICA/Medicare Withholding[12] Currency DLR11_$S2 14 136 SUTAWAGS_1 Suta Wages[1] Currency DLR11_$S2 14 137 SUTAWAGS_2 Suta Wages[2] Currency DLR11_$S2 14 138 SUTAWAGS_3 Suta Wages[3] Currency DLR11_$S2 14 139 SUTAWAGS_4 Suta Wages[4] Currency DLR11_$S2 14 140 SUTAWAGS_5 Suta Wages[5] Currency DLR11_$S2 14 141 SUTAWAGS_6 Suta Wages[6] Currency DLR11_$S2 14 142 SUTAWAGS_7 Suta Wages[7] Currency DLR11_$S2 14 143 SUTAWAGS_8 Suta Wages[8] Currency DLR11_$S2 14 144 SUTAWAGS_9 Suta Wages[9] Currency DLR11_$S2 14 145 SUTAWAGS_10 Suta Wages[10] Currency DLR11_$S2 14 146 SUTAWAGS_11 Suta Wages[11] Currency DLR11_$S2 14 147 SUTAWAGS_12 Suta Wages[12] Currency DLR11_$S2 14 148 FUTAWAGS_1 Futa Wages[1] Currency DLR11_$S2 14 149 FUTAWAGS_2 Futa Wages[2] Currency DLR11_$S2 14 150 FUTAWAGS_3 Futa Wages[3] Currency DLR11_$S2 14 151 FUTAWAGS_4 Futa Wages[4] Currency DLR11_$S2 14 152 FUTAWAGS_5 Futa Wages[5] Currency DLR11_$S2 14 153 FUTAWAGS_6 Futa Wages[6] Currency DLR11_$S2 14 154 FUTAWAGS_7 Futa Wages[7] Currency DLR11_$S2 14 155 FUTAWAGS_8 Futa Wages[8] Currency DLR11_$S2 14 156 FUTAWAGS_9 Futa Wages[9] Currency DLR11_$S2 14 157 FUTAWAGS_10 Futa Wages[10] Currency DLR11_$S2 14 158 FUTAWAGS_11 Futa Wages[11] Currency DLR11_$S2 14 159 FUTAWAGS_12 Futa Wages[12] Currency DLR11_$S2 14 160 NETWAGES_1 Net Wages[1] Currency DLR11_$S2 14 161 NETWAGES_2 Net Wages[2] Currency DLR11_$S2 14 162 NETWAGES_3 Net Wages[3] Currency DLR11_$S2 14 163 NETWAGES_4 Net Wages[4] Currency DLR11_$S2 14 164 NETWAGES_5 Net Wages[5] Currency DLR11_$S2 14 165 NETWAGES_6 Net Wages[6] Currency DLR11_$S2 14 166 NETWAGES_7 Net Wages[7] Currency DLR11_$S2 14 167 NETWAGES_8 Net Wages[8] Currency DLR11_$S2 14 168 NETWAGES_9 Net Wages[9] Currency DLR11_$S2 14 169 NETWAGES_10 Net Wages[10] Currency DLR11_$S2 14 170 NETWAGES_11 Net Wages[11] Currency DLR11_$S2 14 171 NETWAGES_12 Net Wages[12] Currency DLR11_$S2 14 172 Reported_Tips12_1 Reported Tips Array[1] Currency DLR11_$S2 14 173 Reported_Tips12_2 Reported Tips Array[2] Currency DLR11_$S2 14 174 Reported_Tips12_3 Reported Tips Array[3] Currency DLR11_$S2 14 175 Reported_Tips12_4 Reported Tips Array[4] Currency DLR11_$S2 14 176 Reported_Tips12_5 Reported Tips Array[5] Currency DLR11_$S2 14 177 Reported_Tips12_6 Reported Tips Array[6] Currency DLR11_$S2 14 178 Reported_Tips12_7 Reported Tips Array[7] Currency DLR11_$S2 14 179 Reported_Tips12_8 Reported Tips Array[8] Currency DLR11_$S2 14 180 Reported_Tips12_9 Reported Tips Array[9] Currency DLR11_$S2 14 181 Reported_Tips12_10 Reported Tips Array[10] Currency DLR11_$S2 14 182 Reported_Tips12_11 Reported Tips Array[11] Currency DLR11_$S2 14 183 Reported_Tips12_12 Reported Tips Array[12] Currency DLR11_$S2 14 184 Charged_Tips12_1 Charged Tips Array[1] Currency DLR11_$S2 14 185 Charged_Tips12_2 Charged Tips Array[2] Currency DLR11_$S2 14 186 Charged_Tips12_3 Charged Tips Array[3] Currency DLR11_$S2 14 187 Charged_Tips12_4 Charged Tips Array[4] Currency DLR11_$S2 14 188 Charged_Tips12_5 Charged Tips Array[5] Currency DLR11_$S2 14 189 Charged_Tips12_6 Charged Tips Array[6] Currency DLR11_$S2 14 190 Charged_Tips12_7 Charged Tips Array[7] Currency DLR11_$S2 14 191 Charged_Tips12_8 Charged Tips Array[8] Currency DLR11_$S2 14 192 Charged_Tips12_9 Charged Tips Array[9] Currency DLR11_$S2 14 193 Charged_Tips12_10 Charged Tips Array[10] Currency DLR11_$S2 14 194 Charged_Tips12_11 Charged Tips Array[11] Currency DLR11_$S2 14 195 Charged_Tips12_12 Charged Tips Array[12] Currency DLR11_$S2 14 196 Federal_Tax_On_Tips_1 Federal Tax On Tips[1] Currency DLR11_$S2 14 197 Federal_Tax_On_Tips_2 Federal Tax On Tips[2] Currency DLR11_$S2 14 198 Federal_Tax_On_Tips_3 Federal Tax On Tips[3] Currency DLR11_$S2 14 199 Federal_Tax_On_Tips_4 Federal Tax On Tips[4] Currency DLR11_$S2 14 200 Federal_Tax_On_Tips_5 Federal Tax On Tips[5] Currency DLR11_$S2 14 201 Federal_Tax_On_Tips_6 Federal Tax On Tips[6] Currency DLR11_$S2 14 202 Federal_Tax_On_Tips_7 Federal Tax On Tips[7] Currency DLR11_$S2 14 203 Federal_Tax_On_Tips_8 Federal Tax On Tips[8] Currency DLR11_$S2 14 204 Federal_Tax_On_Tips_9 Federal Tax On Tips[9] Currency DLR11_$S2 14 205 Federal_Tax_On_Tips_10 Federal Tax On Tips[10] Currency DLR11_$S2 14 206 Federal_Tax_On_Tips_11 Federal Tax On Tips[11] Currency DLR11_$S2 14 207 Federal_Tax_On_Tips_12 Federal Tax On Tips[12] Currency DLR11_$S2 14 208 FICASS_Tips_1 FICA/SS Tips[1] Currency DLR11_$S2 14 209 FICASS_Tips_2 FICA/SS Tips[2] Currency DLR11_$S2 14 210 FICASS_Tips_3 FICA/SS Tips[3] Currency DLR11_$S2 14 211 FICASS_Tips_4 FICA/SS Tips[4] Currency DLR11_$S2 14 212 FICASS_Tips_5 FICA/SS Tips[5] Currency DLR11_$S2 14 213 FICASS_Tips_6 FICA/SS Tips[6] Currency DLR11_$S2 14 214 FICASS_Tips_7 FICA/SS Tips[7] Currency DLR11_$S2 14 215 FICASS_Tips_8 FICA/SS Tips[8] Currency DLR11_$S2 14 216 FICASS_Tips_9 FICA/SS Tips[9] Currency DLR11_$S2 14 217 FICASS_Tips_10 FICA/SS Tips[10] Currency DLR11_$S2 14 218 FICASS_Tips_11 FICA/SS Tips[11] Currency DLR11_$S2 14 219 FICASS_Tips_12 FICA/SS Tips[12] Currency DLR11_$S2 14 220 FICASS_Tax_On_Tips_1 FICA/SS Tax On Tips[1] Currency DLR11_$S2 14 221 FICASS_Tax_On_Tips_2 FICA/SS Tax On Tips[2] Currency DLR11_$S2 14 222 FICASS_Tax_On_Tips_3 FICA/SS Tax On Tips[3] Currency DLR11_$S2 14 223 FICASS_Tax_On_Tips_4 FICA/SS Tax On Tips[4] Currency DLR11_$S2 14 224 FICASS_Tax_On_Tips_5 FICA/SS Tax On Tips[5] Currency DLR11_$S2 14 225 FICASS_Tax_On_Tips_6 FICA/SS Tax On Tips[6] Currency DLR11_$S2 14 226 FICASS_Tax_On_Tips_7 FICA/SS Tax On Tips[7] Currency DLR11_$S2 14 227 FICASS_Tax_On_Tips_8 FICA/SS Tax On Tips[8] Currency DLR11_$S2 14 228 FICASS_Tax_On_Tips_9 FICA/SS Tax On Tips[9] Currency DLR11_$S2 14 229 FICASS_Tax_On_Tips_10 FICA/SS Tax On Tips[10] Currency DLR11_$S2 14 230 FICASS_Tax_On_Tips_11 FICA/SS Tax On Tips[11] Currency DLR11_$S2 14 231 FICASS_Tax_On_Tips_12 FICA/SS Tax On Tips[12] Currency DLR11_$S2 14 232 Uncollected_FICASS_Tax_1 Uncollected FICA/SS Tax[1] Currency DLR11_$S2 14 233 Uncollected_FICASS_Tax_2 Uncollected FICA/SS Tax[2] Currency DLR11_$S2 14 234 Uncollected_FICASS_Tax_3 Uncollected FICA/SS Tax[3] Currency DLR11_$S2 14 235 Uncollected_FICASS_Tax_4 Uncollected FICA/SS Tax[4] Currency DLR11_$S2 14 236 Uncollected_FICASS_Tax_5 Uncollected FICA/SS Tax[5] Currency DLR11_$S2 14 237 Uncollected_FICASS_Tax_6 Uncollected FICA/SS Tax[6] Currency DLR11_$S2 14 238 Uncollected_FICASS_Tax_7 Uncollected FICA/SS Tax[7] Currency DLR11_$S2 14 239 Uncollected_FICASS_Tax_8 Uncollected FICA/SS Tax[8] Currency DLR11_$S2 14 240 Uncollected_FICASS_Tax_9 Uncollected FICA/SS Tax[9] Currency DLR11_$S2 14 241 Uncollected_FICASS_Tax_10 Uncollected FICA/SS Tax[10] Currency DLR11_$S2 14 242 Uncollected_FICASS_Tax_11 Uncollected FICA/SS Tax[11] Currency DLR11_$S2 14 243 Uncollected_FICASS_Tax_12 Uncollected FICA/SS Tax[12] Currency DLR11_$S2 14 244 FICAMed_Tips_1 FICA/Med Tips[1] Currency DLR11_$S2 14 245 FICAMed_Tips_2 FICA/Med Tips[2] Currency DLR11_$S2 14 246 FICAMed_Tips_3 FICA/Med Tips[3] Currency DLR11_$S2 14 247 FICAMed_Tips_4 FICA/Med Tips[4] Currency DLR11_$S2 14 248 FICAMed_Tips_5 FICA/Med Tips[5] Currency DLR11_$S2 14 249 FICAMed_Tips_6 FICA/Med Tips[6] Currency DLR11_$S2 14 250 FICAMed_Tips_7 FICA/Med Tips[7] Currency DLR11_$S2 14 251 FICAMed_Tips_8 FICA/Med Tips[8] Currency DLR11_$S2 14 252 FICAMed_Tips_9 FICA/Med Tips[9] Currency DLR11_$S2 14 253 FICAMed_Tips_10 FICA/Med Tips[10] Currency DLR11_$S2 14 254 FICAMed_Tips_11 FICA/Med Tips[11] Currency DLR11_$S2 14 255 FICAMed_Tips_12 FICA/Med Tips[12] Currency DLR11_$S2 14 256 FICAMed_Tax_On_Tips_1 FICA/Med Tax On Tips[1] Currency DLR11_$S2 14 257 FICAMed_Tax_On_Tips_2 FICA/Med Tax On Tips[2] Currency DLR11_$S2 14 258 FICAMed_Tax_On_Tips_3 FICA/Med Tax On Tips[3] Currency DLR11_$S2 14 259 FICAMed_Tax_On_Tips_4 FICA/Med Tax On Tips[4] Currency DLR11_$S2 14 260 FICAMed_Tax_On_Tips_5 FICA/Med Tax On Tips[5] Currency DLR11_$S2 14 261 FICAMed_Tax_On_Tips_6 FICA/Med Tax On Tips[6] Currency DLR11_$S2 14 262 FICAMed_Tax_On_Tips_7 FICA/Med Tax On Tips[7] Currency DLR11_$S2 14 263 FICAMed_Tax_On_Tips_8 FICA/Med Tax On Tips[8] Currency DLR11_$S2 14 264 FICAMed_Tax_On_Tips_9 FICA/Med Tax On Tips[9] Currency DLR11_$S2 14 265 FICAMed_Tax_On_Tips_10 FICA/Med Tax On Tips[10] Currency DLR11_$S2 14 266 FICAMed_Tax_On_Tips_11 FICA/Med Tax On Tips[11] Currency DLR11_$S2 14 267 FICAMed_Tax_On_Tips_12 FICA/Med Tax On Tips[12] Currency DLR11_$S2 14 268 Uncollected_FICAMed_Tax_1 Uncollected FICA/Med Tax[1] Currency DLR11_$S2 14 269 Uncollected_FICAMed_Tax_2 Uncollected FICA/Med Tax[2] Currency DLR11_$S2 14 270 Uncollected_FICAMed_Tax_3 Uncollected FICA/Med Tax[3] Currency DLR11_$S2 14 271 Uncollected_FICAMed_Tax_4 Uncollected FICA/Med Tax[4] Currency DLR11_$S2 14 272 Uncollected_FICAMed_Tax_5 Uncollected FICA/Med Tax[5] Currency DLR11_$S2 14 273 Uncollected_FICAMed_Tax_6 Uncollected FICA/Med Tax[6] Currency DLR11_$S2 14 274 Uncollected_FICAMed_Tax_7 Uncollected FICA/Med Tax[7] Currency DLR11_$S2 14 275 Uncollected_FICAMed_Tax_8 Uncollected FICA/Med Tax[8] Currency DLR11_$S2 14 276 Uncollected_FICAMed_Tax_9 Uncollected FICA/Med Tax[9] Currency DLR11_$S2 14 277 Uncollected_FICAMed_Tax_10 Uncollected FICA/Med Tax[10] Currency DLR11_$S2 14 278 Uncollected_FICAMed_Tax_11 Uncollected FICA/Med Tax[11] Currency DLR11_$S2 14 279 Uncollected_FICAMed_Tax_12 Uncollected FICA/Med Tax[12] Currency DLR11_$S2 14 280 Reported_Receipts12_1 Reported Receipts Array[1] Currency DLR11_$S2 14 281 Reported_Receipts12_2 Reported Receipts Array[2] Currency DLR11_$S2 14 282 Reported_Receipts12_3 Reported Receipts Array[3] Currency DLR11_$S2 14 283 Reported_Receipts12_4 Reported Receipts Array[4] Currency DLR11_$S2 14 284 Reported_Receipts12_5 Reported Receipts Array[5] Currency DLR11_$S2 14 285 Reported_Receipts12_6 Reported Receipts Array[6] Currency DLR11_$S2 14 286 Reported_Receipts12_7 Reported Receipts Array[7] Currency DLR11_$S2 14 287 Reported_Receipts12_8 Reported Receipts Array[8] Currency DLR11_$S2 14 288 Reported_Receipts12_9 Reported Receipts Array[9] Currency DLR11_$S2 14 289 Reported_Receipts12_10 Reported Receipts Array[10] Currency DLR11_$S2 14 290 Reported_Receipts12_11 Reported Receipts Array[11] Currency DLR11_$S2 14 291 Reported_Receipts12_12 Reported Receipts Array[12] Currency DLR11_$S2 14 292 Charged_Receipts12_1 Charged Receipts Array[1] Currency DLR11_$S2 14 293 Charged_Receipts12_2 Charged Receipts Array[2] Currency DLR11_$S2 14 294 Charged_Receipts12_3 Charged Receipts Array[3] Currency DLR11_$S2 14 295 Charged_Receipts12_4 Charged Receipts Array[4] Currency DLR11_$S2 14 296 Charged_Receipts12_5 Charged Receipts Array[5] Currency DLR11_$S2 14 297 Charged_Receipts12_6 Charged Receipts Array[6] Currency DLR11_$S2 14 298 Charged_Receipts12_7 Charged Receipts Array[7] Currency DLR11_$S2 14 299 Charged_Receipts12_8 Charged Receipts Array[8] Currency DLR11_$S2 14 300 Charged_Receipts12_9 Charged Receipts Array[9] Currency DLR11_$S2 14 301 Charged_Receipts12_10 Charged Receipts Array[10] Currency DLR11_$S2 14 302 Charged_Receipts12_11 Charged Receipts Array[11] Currency DLR11_$S2 14 303 Charged_Receipts12_12 Charged Receipts Array[12] Currency DLR11_$S2 14 304 Allocated_Tips_Array_1 Allocated Tips Array[1] Currency DLR11_$S2 14 305 Allocated_Tips_Array_2 Allocated Tips Array[2] Currency DLR11_$S2 14 306 Allocated_Tips_Array_3 Allocated Tips Array[3] Currency DLR11_$S2 14 307 Allocated_Tips_Array_4 Allocated Tips Array[4] Currency DLR11_$S2 14 308 Allocated_Tips_Array_5 Allocated Tips Array[5] Currency DLR11_$S2 14 309 Allocated_Tips_Array_6 Allocated Tips Array[6] Currency DLR11_$S2 14 310 Allocated_Tips_Array_7 Allocated Tips Array[7] Currency DLR11_$S2 14 311 Allocated_Tips_Array_8 Allocated Tips Array[8] Currency DLR11_$S2 14 312 Allocated_Tips_Array_9 Allocated Tips Array[9] Currency DLR11_$S2 14 313 Allocated_Tips_Array_10 Allocated Tips Array[10] Currency DLR11_$S2 14 314 Allocated_Tips_Array_11 Allocated Tips Array[11] Currency DLR11_$S2 14 315 Allocated_Tips_Array_12 Allocated Tips Array[12] Currency DLR11_$S2 14 316 EXMFRFED Exempt From Federal Boolean CB_Exempt_From_Federal_Withholding 0 317 FDFLGSTS Federal Filing Status String STR6_Payroll_Code 6 318 FEDEXMPT Federal Exemptions Integer INT2_U0 2 319 ADFDWHDG Additional Federal Withholding Currency DLR11_$S2 14 320 ESTFEDWH Estimated Federal Withholding Currency DLR11_$U2 14 321 STATECD State Code String STR2_State_Code 2 322 LOCALTAX Local Tax String STR6_Payroll_Code 6 323 W2BF942E W2 Box For 942 Employee Boolean CB_942_Employee 0 324 W2BFDCSD W2 Box For Deceased Boolean CB_Deceased 0 325 W2BFDCMP W2 Box For Deferred Compensation Boolean CB_Deferred_Compensation 0 326 W2BFLREP W2 Box For Legal Representative Boolean CB_Legal_Representative 0 327 W2BFPPLN W2 Box For Pension Plan Boolean CB_Pension_Plan 0 328 W2BFSTEM W2 Box For Statutory Employee Boolean CB_Statutory_Employee 0 329 MCRQGEMP Medicare Qualified Govt Employee Boolean CB_Medicare_Qualified_Govt_Employee 0 330 EICFLGST EIC Filing Status String STR6_Payroll_Code 6 331 NYTXDiff Withhold NY Tax Diff Boolean CB_Withhold_NY_Diff 0 332 ADRSCODE Address Code String STR15_Address_Code 15 333 ALTERNATENAME Alternate Name String STR20 20 334 BENADJDATE Ben Adj Date Date DT 8 335 BENEFITEXPIRE_I Benefit Expire Date DT 8 336 BIRTHDAY Birth Day Integer INT 0 337 BIRTHMONTH Birth Month Integer INT 0 338 CHANGEBY_I Change By String STR15_User_ID 15 339 CHANGEDATE_I Change Date Date DT 8 340 CITIZEN Citizen Boolean CB_Citizen 0 341 DATEOFLASTREVIEW_I Date Of Last Review Date DT 8 342 DATEOFNEXTREVIEW_I Date Of Next Review Date DT 8 343 DISABLEDVETERAN Disabled Veteran Boolean CB_DisableVet 0 344 DIVISIONCODE_I Division Code String STR6_Payroll_Code 6 345 FEDCLSSCD Federal Classification Code String STR10_LBAU 10 346 HANDICAPPED Handicapped Boolean CB_Handicap 0 347 HRSTATUS HR Status Integer DDL_HRStatus 0 348 I9RENEW I9renew Date DT 8 349 LASTDAYWORKED_I Last Day Worked Date DT 8 350 LOCATNID Location ID String STR15_Location_ID 15 351 MARITALSTATUS MaritalStatus Integer DDL_MaritalStatus 0 352 NICKNAME NickName String STR20 20 353 NOTEINDX2 Note Index2 Currency DLR14 14 354 Primary_Pay_Record Primary Pay Record String STR6_Payroll_Code 6 355 RATECLSS Rate Class String STR15 15 356 SMOKER_I Smoker Boolean CB_Smoker 0 357 SPOUSE Spouse String STR15 15 358 SPOUSESSN Spouse SSN String STR15_Social_Security_Number 15 359 SUPERVISORCODE_I Supervisor Code String STR6_U 6 360 EMPLOYMENTTYPE Type of Employment Integer DDL_Employment_Type 0 361 UNIONCD Union Code String STR6 6 362 UNIONEMPLOYEE Union Employee Boolean CB_Union_Emp 0 363 VERIFIED Verified Boolean CB_Verifed 0 364 VETERAN Veteran Boolean CB_Military 0 365 VIETNAMVETERAN Vietnam Veteran Boolean CB_Vietnam 0 366 OTHERVET Other Veterans Boolean CB_OtherVet 0 367 WRNSTFLSBLWZR Warn Sick Time Falls Below Zero Boolean CB_WarnSickTimeFallsBelowZero 0 368 WRNVCNFLSBLWZR Warn Vacation Falls Below Zero Boolean CB_WarnVacationFallsBelowZero 0 369 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 370 ASI_Order_By ASI_Order_By Long Integer LI_14 14 371 ASI_Document_Status ASI_Document_Status Integer INT 0