SmartList Payroll Employee Summary (ASIEXP32)

azurecurveProductsSmartList (1493)PathnameSmartList Payroll Employee Summary (ASIEXP32)

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_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2YEAR1 SearchYearIntegerYear4
3EMPLCLAS SearchEmployee ClassStringSTR15_Employee_Class15
4INACTIVE SearchInactiveBooleanCB_Inactive0
5LASTNAME SearchLast NameStringSTR2020
6FRSTNAME SearchFirst NameStringSTR1515
7MIDLNAME SearchMiddle NameStringSTR1515
8SOCSCNUM SearchSocial Security NumberStringSTR15_Social_Security_Number15
9BRTHDATE SearchBirth DateDateDT8
10GENDER SearchGenderIntegerDDL_Gender0
11ETHNORGN SearchEthnic OriginIntegerDDL_Ethnic Origin0
12Calc_Min_Wage_Bal SearchCalc Min Wage BalBooleanCB_CalcMinWageBal0
13DEPRTMNT SearchDepartmentStringSTR6_Payroll_Code6
14JOBTITLE SearchJob TitleStringSTR6_Payroll_Code6
15WCACFPAY SearchWhich Cash Account For PayIntegerGB0
16ACTINDX SearchAccount IndexLong IntegerLI_1414
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'].ACTINDX
17WKHRPRYR SearchWork Hours Per YearIntegerINT4_U04
18STRTDATE SearchStart DateDateDT8
19DEMPINAC SearchDate Employee InactivatedDateDT8
20RSNEMPIN SearchReason Employee InactivatedStringSTR3030
21MINETPAY SearchMinimum Net PayCurrencyDLR11_$U214
22SUTASTAT SearchSuta StateStringSTR2_State_Code2
23WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
24ATACRVAC SearchAuto Accrue VacationBooleanCB_Accrue_Vacation:0
25VACCRAMT SearchVacation Accrual AmountLong IntegerLI6_U26
26VACCRMTH SearchVacation Accrual MethodIntegerGB0
27VACAPRYR SearchVacation Hours Per YearLong IntegerLI6_U26
28VACAVLBL SearchVacation AvailableLong IntegerLI6_S26
29ATACRSTM SearchAuto Accrue Sick TimeBooleanCB_Accrue_Sick_Time:0
30STMACMTH SearchSick Time Accrual MethodIntegerGB0
31SKTMACAM SearchSick Time Accrual AmountLong IntegerLI6_U26
32SIKTIMAV SearchSick Time AvailableLong IntegerLI6_S26
33SKTMHPYR SearchSick Time Hours Per YearLong IntegerLI6_U26
34USERDEF1 SearchUser Defined 1StringSTR2020
35USERDEF2 SearchUser Defined 2StringSTR2020
36NOTEINDX SearchNote IndexCurrencyDLR1414
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'].NOTEINDX
37LPCHKNUM SearchLast Paycheck NumberStringCheck_Number20
38LSTPCKDT SearchLast Paycheck DateDateDT8
39LPCHKAMT SearchLast Paycheck AmountCurrencyDLR11_$S214
40GROSWAGS_1 SearchGross Wages[1]CurrencyDLR11_$S214
41GROSWAGS_2 SearchGross Wages[2]CurrencyDLR11_$S214
42GROSWAGS_3 SearchGross Wages[3]CurrencyDLR11_$S214
43GROSWAGS_4 SearchGross Wages[4]CurrencyDLR11_$S214
44GROSWAGS_5 SearchGross Wages[5]CurrencyDLR11_$S214
45GROSWAGS_6 SearchGross Wages[6]CurrencyDLR11_$S214
46GROSWAGS_7 SearchGross Wages[7]CurrencyDLR11_$S214
47GROSWAGS_8 SearchGross Wages[8]CurrencyDLR11_$S214
48GROSWAGS_9 SearchGross Wages[9]CurrencyDLR11_$S214
49GROSWAGS_10 SearchGross Wages[10]CurrencyDLR11_$S214
50GROSWAGS_11 SearchGross Wages[11]CurrencyDLR11_$S214
51GROSWAGS_12 SearchGross Wages[12]CurrencyDLR11_$S214
52Federal_Wages_1 SearchFederal Wages[1]CurrencyDLR11_$S214
53Federal_Wages_2 SearchFederal Wages[2]CurrencyDLR11_$S214
54Federal_Wages_3 SearchFederal Wages[3]CurrencyDLR11_$S214
55Federal_Wages_4 SearchFederal Wages[4]CurrencyDLR11_$S214
56Federal_Wages_5 SearchFederal Wages[5]CurrencyDLR11_$S214
57Federal_Wages_6 SearchFederal Wages[6]CurrencyDLR11_$S214
58Federal_Wages_7 SearchFederal Wages[7]CurrencyDLR11_$S214
59Federal_Wages_8 SearchFederal Wages[8]CurrencyDLR11_$S214
60Federal_Wages_9 SearchFederal Wages[9]CurrencyDLR11_$S214
61Federal_Wages_10 SearchFederal Wages[10]CurrencyDLR11_$S214
62Federal_Wages_11 SearchFederal Wages[11]CurrencyDLR11_$S214
63Federal_Wages_12 SearchFederal Wages[12]CurrencyDLR11_$S214
64Federal_Tips_1 SearchFederal Tips[1]CurrencyDLR11_$S214
65Federal_Tips_2 SearchFederal Tips[2]CurrencyDLR11_$S214
66Federal_Tips_3 SearchFederal Tips[3]CurrencyDLR11_$S214
67Federal_Tips_4 SearchFederal Tips[4]CurrencyDLR11_$S214
68Federal_Tips_5 SearchFederal Tips[5]CurrencyDLR11_$S214
69Federal_Tips_6 SearchFederal Tips[6]CurrencyDLR11_$S214
70Federal_Tips_7 SearchFederal Tips[7]CurrencyDLR11_$S214
71Federal_Tips_8 SearchFederal Tips[8]CurrencyDLR11_$S214
72Federal_Tips_9 SearchFederal Tips[9]CurrencyDLR11_$S214
73Federal_Tips_10 SearchFederal Tips[10]CurrencyDLR11_$S214
74Federal_Tips_11 SearchFederal Tips[11]CurrencyDLR11_$S214
75Federal_Tips_12 SearchFederal Tips[12]CurrencyDLR11_$S214
76FDWTHLDG_1 SearchFederal Withholding[1]CurrencyDLR11_$S214
77FDWTHLDG_2 SearchFederal Withholding[2]CurrencyDLR11_$S214
78FDWTHLDG_3 SearchFederal Withholding[3]CurrencyDLR11_$S214
79FDWTHLDG_4 SearchFederal Withholding[4]CurrencyDLR11_$S214
80FDWTHLDG_5 SearchFederal Withholding[5]CurrencyDLR11_$S214
81FDWTHLDG_6 SearchFederal Withholding[6]CurrencyDLR11_$S214
82FDWTHLDG_7 SearchFederal Withholding[7]CurrencyDLR11_$S214
83FDWTHLDG_8 SearchFederal Withholding[8]CurrencyDLR11_$S214
84FDWTHLDG_9 SearchFederal Withholding[9]CurrencyDLR11_$S214
85FDWTHLDG_10 SearchFederal Withholding[10]CurrencyDLR11_$S214
86FDWTHLDG_11 SearchFederal Withholding[11]CurrencyDLR11_$S214
87FDWTHLDG_12 SearchFederal Withholding[12]CurrencyDLR11_$S214
88FICASSWG_1 SearchFICA/Social Security Wages[1]CurrencyDLR11_$S214
89FICASSWG_2 SearchFICA/Social Security Wages[2]CurrencyDLR11_$S214
90FICASSWG_3 SearchFICA/Social Security Wages[3]CurrencyDLR11_$S214
91FICASSWG_4 SearchFICA/Social Security Wages[4]CurrencyDLR11_$S214
92FICASSWG_5 SearchFICA/Social Security Wages[5]CurrencyDLR11_$S214
93FICASSWG_6 SearchFICA/Social Security Wages[6]CurrencyDLR11_$S214
94FICASSWG_7 SearchFICA/Social Security Wages[7]CurrencyDLR11_$S214
95FICASSWG_8 SearchFICA/Social Security Wages[8]CurrencyDLR11_$S214
96FICASSWG_9 SearchFICA/Social Security Wages[9]CurrencyDLR11_$S214
97FICASSWG_10 SearchFICA/Social Security Wages[10]CurrencyDLR11_$S214
98FICASSWG_11 SearchFICA/Social Security Wages[11]CurrencyDLR11_$S214
99FICASSWG_12 SearchFICA/Social Security Wages[12]CurrencyDLR11_$S214
100FICAMWGS_1 SearchFICA/Medicare Wages[1]CurrencyDLR11_$S214
101FICAMWGS_2 SearchFICA/Medicare Wages[2]CurrencyDLR11_$S214
102FICAMWGS_3 SearchFICA/Medicare Wages[3]CurrencyDLR11_$S214
103FICAMWGS_4 SearchFICA/Medicare Wages[4]CurrencyDLR11_$S214
104FICAMWGS_5 SearchFICA/Medicare Wages[5]CurrencyDLR11_$S214
105FICAMWGS_6 SearchFICA/Medicare Wages[6]CurrencyDLR11_$S214
106FICAMWGS_7 SearchFICA/Medicare Wages[7]CurrencyDLR11_$S214
107FICAMWGS_8 SearchFICA/Medicare Wages[8]CurrencyDLR11_$S214
108FICAMWGS_9 SearchFICA/Medicare Wages[9]CurrencyDLR11_$S214
109FICAMWGS_10 SearchFICA/Medicare Wages[10]CurrencyDLR11_$S214
110FICAMWGS_11 SearchFICA/Medicare Wages[11]CurrencyDLR11_$S214
111FICAMWGS_12 SearchFICA/Medicare Wages[12]CurrencyDLR11_$S214
112FICASSWH_1 SearchFICA/Social Security Withholding[1]CurrencyDLR11_$S214
113FICASSWH_2 SearchFICA/Social Security Withholding[2]CurrencyDLR11_$S214
114FICASSWH_3 SearchFICA/Social Security Withholding[3]CurrencyDLR11_$S214
115FICASSWH_4 SearchFICA/Social Security Withholding[4]CurrencyDLR11_$S214
116FICASSWH_5 SearchFICA/Social Security Withholding[5]CurrencyDLR11_$S214
117FICASSWH_6 SearchFICA/Social Security Withholding[6]CurrencyDLR11_$S214
118FICASSWH_7 SearchFICA/Social Security Withholding[7]CurrencyDLR11_$S214
119FICASSWH_8 SearchFICA/Social Security Withholding[8]CurrencyDLR11_$S214
120FICASSWH_9 SearchFICA/Social Security Withholding[9]CurrencyDLR11_$S214
121FICASSWH_10 SearchFICA/Social Security Withholding[10]CurrencyDLR11_$S214
122FICASSWH_11 SearchFICA/Social Security Withholding[11]CurrencyDLR11_$S214
123FICASSWH_12 SearchFICA/Social Security Withholding[12]CurrencyDLR11_$S214
124FICAMWDG_1 SearchFICA/Medicare Withholding[1]CurrencyDLR11_$S214
125FICAMWDG_2 SearchFICA/Medicare Withholding[2]CurrencyDLR11_$S214
126FICAMWDG_3 SearchFICA/Medicare Withholding[3]CurrencyDLR11_$S214
127FICAMWDG_4 SearchFICA/Medicare Withholding[4]CurrencyDLR11_$S214
128FICAMWDG_5 SearchFICA/Medicare Withholding[5]CurrencyDLR11_$S214
129FICAMWDG_6 SearchFICA/Medicare Withholding[6]CurrencyDLR11_$S214
130FICAMWDG_7 SearchFICA/Medicare Withholding[7]CurrencyDLR11_$S214
131FICAMWDG_8 SearchFICA/Medicare Withholding[8]CurrencyDLR11_$S214
132FICAMWDG_9 SearchFICA/Medicare Withholding[9]CurrencyDLR11_$S214
133FICAMWDG_10 SearchFICA/Medicare Withholding[10]CurrencyDLR11_$S214
134FICAMWDG_11 SearchFICA/Medicare Withholding[11]CurrencyDLR11_$S214
135FICAMWDG_12 SearchFICA/Medicare Withholding[12]CurrencyDLR11_$S214
136SUTAWAGS_1 SearchSuta Wages[1]CurrencyDLR11_$S214
137SUTAWAGS_2 SearchSuta Wages[2]CurrencyDLR11_$S214
138SUTAWAGS_3 SearchSuta Wages[3]CurrencyDLR11_$S214
139SUTAWAGS_4 SearchSuta Wages[4]CurrencyDLR11_$S214
140SUTAWAGS_5 SearchSuta Wages[5]CurrencyDLR11_$S214
141SUTAWAGS_6 SearchSuta Wages[6]CurrencyDLR11_$S214
142SUTAWAGS_7 SearchSuta Wages[7]CurrencyDLR11_$S214
143SUTAWAGS_8 SearchSuta Wages[8]CurrencyDLR11_$S214
144SUTAWAGS_9 SearchSuta Wages[9]CurrencyDLR11_$S214
145SUTAWAGS_10 SearchSuta Wages[10]CurrencyDLR11_$S214
146SUTAWAGS_11 SearchSuta Wages[11]CurrencyDLR11_$S214
147SUTAWAGS_12 SearchSuta Wages[12]CurrencyDLR11_$S214
148FUTAWAGS_1 SearchFuta Wages[1]CurrencyDLR11_$S214
149FUTAWAGS_2 SearchFuta Wages[2]CurrencyDLR11_$S214
150FUTAWAGS_3 SearchFuta Wages[3]CurrencyDLR11_$S214
151FUTAWAGS_4 SearchFuta Wages[4]CurrencyDLR11_$S214
152FUTAWAGS_5 SearchFuta Wages[5]CurrencyDLR11_$S214
153FUTAWAGS_6 SearchFuta Wages[6]CurrencyDLR11_$S214
154FUTAWAGS_7 SearchFuta Wages[7]CurrencyDLR11_$S214
155FUTAWAGS_8 SearchFuta Wages[8]CurrencyDLR11_$S214
156FUTAWAGS_9 SearchFuta Wages[9]CurrencyDLR11_$S214
157FUTAWAGS_10 SearchFuta Wages[10]CurrencyDLR11_$S214
158FUTAWAGS_11 SearchFuta Wages[11]CurrencyDLR11_$S214
159FUTAWAGS_12 SearchFuta Wages[12]CurrencyDLR11_$S214
160NETWAGES_1 SearchNet Wages[1]CurrencyDLR11_$S214
161NETWAGES_2 SearchNet Wages[2]CurrencyDLR11_$S214
162NETWAGES_3 SearchNet Wages[3]CurrencyDLR11_$S214
163NETWAGES_4 SearchNet Wages[4]CurrencyDLR11_$S214
164NETWAGES_5 SearchNet Wages[5]CurrencyDLR11_$S214
165NETWAGES_6 SearchNet Wages[6]CurrencyDLR11_$S214
166NETWAGES_7 SearchNet Wages[7]CurrencyDLR11_$S214
167NETWAGES_8 SearchNet Wages[8]CurrencyDLR11_$S214
168NETWAGES_9 SearchNet Wages[9]CurrencyDLR11_$S214
169NETWAGES_10 SearchNet Wages[10]CurrencyDLR11_$S214
170NETWAGES_11 SearchNet Wages[11]CurrencyDLR11_$S214
171NETWAGES_12 SearchNet Wages[12]CurrencyDLR11_$S214
172Reported_Tips12_1 SearchReported Tips Array[1]CurrencyDLR11_$S214
173Reported_Tips12_2 SearchReported Tips Array[2]CurrencyDLR11_$S214
174Reported_Tips12_3 SearchReported Tips Array[3]CurrencyDLR11_$S214
175Reported_Tips12_4 SearchReported Tips Array[4]CurrencyDLR11_$S214
176Reported_Tips12_5 SearchReported Tips Array[5]CurrencyDLR11_$S214
177Reported_Tips12_6 SearchReported Tips Array[6]CurrencyDLR11_$S214
178Reported_Tips12_7 SearchReported Tips Array[7]CurrencyDLR11_$S214
179Reported_Tips12_8 SearchReported Tips Array[8]CurrencyDLR11_$S214
180Reported_Tips12_9 SearchReported Tips Array[9]CurrencyDLR11_$S214
181Reported_Tips12_10 SearchReported Tips Array[10]CurrencyDLR11_$S214
182Reported_Tips12_11 SearchReported Tips Array[11]CurrencyDLR11_$S214
183Reported_Tips12_12 SearchReported Tips Array[12]CurrencyDLR11_$S214
184Charged_Tips12_1 SearchCharged Tips Array[1]CurrencyDLR11_$S214
185Charged_Tips12_2 SearchCharged Tips Array[2]CurrencyDLR11_$S214
186Charged_Tips12_3 SearchCharged Tips Array[3]CurrencyDLR11_$S214
187Charged_Tips12_4 SearchCharged Tips Array[4]CurrencyDLR11_$S214
188Charged_Tips12_5 SearchCharged Tips Array[5]CurrencyDLR11_$S214
189Charged_Tips12_6 SearchCharged Tips Array[6]CurrencyDLR11_$S214
190Charged_Tips12_7 SearchCharged Tips Array[7]CurrencyDLR11_$S214
191Charged_Tips12_8 SearchCharged Tips Array[8]CurrencyDLR11_$S214
192Charged_Tips12_9 SearchCharged Tips Array[9]CurrencyDLR11_$S214
193Charged_Tips12_10 SearchCharged Tips Array[10]CurrencyDLR11_$S214
194Charged_Tips12_11 SearchCharged Tips Array[11]CurrencyDLR11_$S214
195Charged_Tips12_12 SearchCharged Tips Array[12]CurrencyDLR11_$S214
196Federal_Tax_On_Tips_1 SearchFederal Tax On Tips[1]CurrencyDLR11_$S214
197Federal_Tax_On_Tips_2 SearchFederal Tax On Tips[2]CurrencyDLR11_$S214
198Federal_Tax_On_Tips_3 SearchFederal Tax On Tips[3]CurrencyDLR11_$S214
199Federal_Tax_On_Tips_4 SearchFederal Tax On Tips[4]CurrencyDLR11_$S214
200Federal_Tax_On_Tips_5 SearchFederal Tax On Tips[5]CurrencyDLR11_$S214
201Federal_Tax_On_Tips_6 SearchFederal Tax On Tips[6]CurrencyDLR11_$S214
202Federal_Tax_On_Tips_7 SearchFederal Tax On Tips[7]CurrencyDLR11_$S214
203Federal_Tax_On_Tips_8 SearchFederal Tax On Tips[8]CurrencyDLR11_$S214
204Federal_Tax_On_Tips_9 SearchFederal Tax On Tips[9]CurrencyDLR11_$S214
205Federal_Tax_On_Tips_10 SearchFederal Tax On Tips[10]CurrencyDLR11_$S214
206Federal_Tax_On_Tips_11 SearchFederal Tax On Tips[11]CurrencyDLR11_$S214
207Federal_Tax_On_Tips_12 SearchFederal Tax On Tips[12]CurrencyDLR11_$S214
208FICASS_Tips_1 SearchFICA/SS Tips[1]CurrencyDLR11_$S214
209FICASS_Tips_2 SearchFICA/SS Tips[2]CurrencyDLR11_$S214
210FICASS_Tips_3 SearchFICA/SS Tips[3]CurrencyDLR11_$S214
211FICASS_Tips_4 SearchFICA/SS Tips[4]CurrencyDLR11_$S214
212FICASS_Tips_5 SearchFICA/SS Tips[5]CurrencyDLR11_$S214
213FICASS_Tips_6 SearchFICA/SS Tips[6]CurrencyDLR11_$S214
214FICASS_Tips_7 SearchFICA/SS Tips[7]CurrencyDLR11_$S214
215FICASS_Tips_8 SearchFICA/SS Tips[8]CurrencyDLR11_$S214
216FICASS_Tips_9 SearchFICA/SS Tips[9]CurrencyDLR11_$S214
217FICASS_Tips_10 SearchFICA/SS Tips[10]CurrencyDLR11_$S214
218FICASS_Tips_11 SearchFICA/SS Tips[11]CurrencyDLR11_$S214
219FICASS_Tips_12 SearchFICA/SS Tips[12]CurrencyDLR11_$S214
220FICASS_Tax_On_Tips_1 SearchFICA/SS Tax On Tips[1]CurrencyDLR11_$S214
221FICASS_Tax_On_Tips_2 SearchFICA/SS Tax On Tips[2]CurrencyDLR11_$S214
222FICASS_Tax_On_Tips_3 SearchFICA/SS Tax On Tips[3]CurrencyDLR11_$S214
223FICASS_Tax_On_Tips_4 SearchFICA/SS Tax On Tips[4]CurrencyDLR11_$S214
224FICASS_Tax_On_Tips_5 SearchFICA/SS Tax On Tips[5]CurrencyDLR11_$S214
225FICASS_Tax_On_Tips_6 SearchFICA/SS Tax On Tips[6]CurrencyDLR11_$S214
226FICASS_Tax_On_Tips_7 SearchFICA/SS Tax On Tips[7]CurrencyDLR11_$S214
227FICASS_Tax_On_Tips_8 SearchFICA/SS Tax On Tips[8]CurrencyDLR11_$S214
228FICASS_Tax_On_Tips_9 SearchFICA/SS Tax On Tips[9]CurrencyDLR11_$S214
229FICASS_Tax_On_Tips_10 SearchFICA/SS Tax On Tips[10]CurrencyDLR11_$S214
230FICASS_Tax_On_Tips_11 SearchFICA/SS Tax On Tips[11]CurrencyDLR11_$S214
231FICASS_Tax_On_Tips_12 SearchFICA/SS Tax On Tips[12]CurrencyDLR11_$S214
232Uncollected_FICASS_Tax_1 SearchUncollected FICA/SS Tax[1]CurrencyDLR11_$S214
233Uncollected_FICASS_Tax_2 SearchUncollected FICA/SS Tax[2]CurrencyDLR11_$S214
234Uncollected_FICASS_Tax_3 SearchUncollected FICA/SS Tax[3]CurrencyDLR11_$S214
235Uncollected_FICASS_Tax_4 SearchUncollected FICA/SS Tax[4]CurrencyDLR11_$S214
236Uncollected_FICASS_Tax_5 SearchUncollected FICA/SS Tax[5]CurrencyDLR11_$S214
237Uncollected_FICASS_Tax_6 SearchUncollected FICA/SS Tax[6]CurrencyDLR11_$S214
238Uncollected_FICASS_Tax_7 SearchUncollected FICA/SS Tax[7]CurrencyDLR11_$S214
239Uncollected_FICASS_Tax_8 SearchUncollected FICA/SS Tax[8]CurrencyDLR11_$S214
240Uncollected_FICASS_Tax_9 SearchUncollected FICA/SS Tax[9]CurrencyDLR11_$S214
241Uncollected_FICASS_Tax_10 SearchUncollected FICA/SS Tax[10]CurrencyDLR11_$S214
242Uncollected_FICASS_Tax_11 SearchUncollected FICA/SS Tax[11]CurrencyDLR11_$S214
243Uncollected_FICASS_Tax_12 SearchUncollected FICA/SS Tax[12]CurrencyDLR11_$S214
244FICAMed_Tips_1 SearchFICA/Med Tips[1]CurrencyDLR11_$S214
245FICAMed_Tips_2 SearchFICA/Med Tips[2]CurrencyDLR11_$S214
246FICAMed_Tips_3 SearchFICA/Med Tips[3]CurrencyDLR11_$S214
247FICAMed_Tips_4 SearchFICA/Med Tips[4]CurrencyDLR11_$S214
248FICAMed_Tips_5 SearchFICA/Med Tips[5]CurrencyDLR11_$S214
249FICAMed_Tips_6 SearchFICA/Med Tips[6]CurrencyDLR11_$S214
250FICAMed_Tips_7 SearchFICA/Med Tips[7]CurrencyDLR11_$S214
251FICAMed_Tips_8 SearchFICA/Med Tips[8]CurrencyDLR11_$S214
252FICAMed_Tips_9 SearchFICA/Med Tips[9]CurrencyDLR11_$S214
253FICAMed_Tips_10 SearchFICA/Med Tips[10]CurrencyDLR11_$S214
254FICAMed_Tips_11 SearchFICA/Med Tips[11]CurrencyDLR11_$S214
255FICAMed_Tips_12 SearchFICA/Med Tips[12]CurrencyDLR11_$S214
256FICAMed_Tax_On_Tips_1 SearchFICA/Med Tax On Tips[1]CurrencyDLR11_$S214
257FICAMed_Tax_On_Tips_2 SearchFICA/Med Tax On Tips[2]CurrencyDLR11_$S214
258FICAMed_Tax_On_Tips_3 SearchFICA/Med Tax On Tips[3]CurrencyDLR11_$S214
259FICAMed_Tax_On_Tips_4 SearchFICA/Med Tax On Tips[4]CurrencyDLR11_$S214
260FICAMed_Tax_On_Tips_5 SearchFICA/Med Tax On Tips[5]CurrencyDLR11_$S214
261FICAMed_Tax_On_Tips_6 SearchFICA/Med Tax On Tips[6]CurrencyDLR11_$S214
262FICAMed_Tax_On_Tips_7 SearchFICA/Med Tax On Tips[7]CurrencyDLR11_$S214
263FICAMed_Tax_On_Tips_8 SearchFICA/Med Tax On Tips[8]CurrencyDLR11_$S214
264FICAMed_Tax_On_Tips_9 SearchFICA/Med Tax On Tips[9]CurrencyDLR11_$S214
265FICAMed_Tax_On_Tips_10 SearchFICA/Med Tax On Tips[10]CurrencyDLR11_$S214
266FICAMed_Tax_On_Tips_11 SearchFICA/Med Tax On Tips[11]CurrencyDLR11_$S214
267FICAMed_Tax_On_Tips_12 SearchFICA/Med Tax On Tips[12]CurrencyDLR11_$S214
268Uncollected_FICAMed_Tax_1 SearchUncollected FICA/Med Tax[1]CurrencyDLR11_$S214
269Uncollected_FICAMed_Tax_2 SearchUncollected FICA/Med Tax[2]CurrencyDLR11_$S214
270Uncollected_FICAMed_Tax_3 SearchUncollected FICA/Med Tax[3]CurrencyDLR11_$S214
271Uncollected_FICAMed_Tax_4 SearchUncollected FICA/Med Tax[4]CurrencyDLR11_$S214
272Uncollected_FICAMed_Tax_5 SearchUncollected FICA/Med Tax[5]CurrencyDLR11_$S214
273Uncollected_FICAMed_Tax_6 SearchUncollected FICA/Med Tax[6]CurrencyDLR11_$S214
274Uncollected_FICAMed_Tax_7 SearchUncollected FICA/Med Tax[7]CurrencyDLR11_$S214
275Uncollected_FICAMed_Tax_8 SearchUncollected FICA/Med Tax[8]CurrencyDLR11_$S214
276Uncollected_FICAMed_Tax_9 SearchUncollected FICA/Med Tax[9]CurrencyDLR11_$S214
277Uncollected_FICAMed_Tax_10 SearchUncollected FICA/Med Tax[10]CurrencyDLR11_$S214
278Uncollected_FICAMed_Tax_11 SearchUncollected FICA/Med Tax[11]CurrencyDLR11_$S214
279Uncollected_FICAMed_Tax_12 SearchUncollected FICA/Med Tax[12]CurrencyDLR11_$S214
280Reported_Receipts12_1 SearchReported Receipts Array[1]CurrencyDLR11_$S214
281Reported_Receipts12_2 SearchReported Receipts Array[2]CurrencyDLR11_$S214
282Reported_Receipts12_3 SearchReported Receipts Array[3]CurrencyDLR11_$S214
283Reported_Receipts12_4 SearchReported Receipts Array[4]CurrencyDLR11_$S214
284Reported_Receipts12_5 SearchReported Receipts Array[5]CurrencyDLR11_$S214
285Reported_Receipts12_6 SearchReported Receipts Array[6]CurrencyDLR11_$S214
286Reported_Receipts12_7 SearchReported Receipts Array[7]CurrencyDLR11_$S214
287Reported_Receipts12_8 SearchReported Receipts Array[8]CurrencyDLR11_$S214
288Reported_Receipts12_9 SearchReported Receipts Array[9]CurrencyDLR11_$S214
289Reported_Receipts12_10 SearchReported Receipts Array[10]CurrencyDLR11_$S214
290Reported_Receipts12_11 SearchReported Receipts Array[11]CurrencyDLR11_$S214
291Reported_Receipts12_12 SearchReported Receipts Array[12]CurrencyDLR11_$S214
292Charged_Receipts12_1 SearchCharged Receipts Array[1]CurrencyDLR11_$S214
293Charged_Receipts12_2 SearchCharged Receipts Array[2]CurrencyDLR11_$S214
294Charged_Receipts12_3 SearchCharged Receipts Array[3]CurrencyDLR11_$S214
295Charged_Receipts12_4 SearchCharged Receipts Array[4]CurrencyDLR11_$S214
296Charged_Receipts12_5 SearchCharged Receipts Array[5]CurrencyDLR11_$S214
297Charged_Receipts12_6 SearchCharged Receipts Array[6]CurrencyDLR11_$S214
298Charged_Receipts12_7 SearchCharged Receipts Array[7]CurrencyDLR11_$S214
299Charged_Receipts12_8 SearchCharged Receipts Array[8]CurrencyDLR11_$S214
300Charged_Receipts12_9 SearchCharged Receipts Array[9]CurrencyDLR11_$S214
301Charged_Receipts12_10 SearchCharged Receipts Array[10]CurrencyDLR11_$S214
302Charged_Receipts12_11 SearchCharged Receipts Array[11]CurrencyDLR11_$S214
303Charged_Receipts12_12 SearchCharged Receipts Array[12]CurrencyDLR11_$S214
304Allocated_Tips_Array_1 SearchAllocated Tips Array[1]CurrencyDLR11_$S214
305Allocated_Tips_Array_2 SearchAllocated Tips Array[2]CurrencyDLR11_$S214
306Allocated_Tips_Array_3 SearchAllocated Tips Array[3]CurrencyDLR11_$S214
307Allocated_Tips_Array_4 SearchAllocated Tips Array[4]CurrencyDLR11_$S214
308Allocated_Tips_Array_5 SearchAllocated Tips Array[5]CurrencyDLR11_$S214
309Allocated_Tips_Array_6 SearchAllocated Tips Array[6]CurrencyDLR11_$S214
310Allocated_Tips_Array_7 SearchAllocated Tips Array[7]CurrencyDLR11_$S214
311Allocated_Tips_Array_8 SearchAllocated Tips Array[8]CurrencyDLR11_$S214
312Allocated_Tips_Array_9 SearchAllocated Tips Array[9]CurrencyDLR11_$S214
313Allocated_Tips_Array_10 SearchAllocated Tips Array[10]CurrencyDLR11_$S214
314Allocated_Tips_Array_11 SearchAllocated Tips Array[11]CurrencyDLR11_$S214
315Allocated_Tips_Array_12 SearchAllocated Tips Array[12]CurrencyDLR11_$S214
316EXMFRFED SearchExempt From FederalBooleanCB_Exempt_From_Federal_Withholding0
317FDFLGSTS SearchFederal Filing StatusStringSTR6_Payroll_Code6
318FEDEXMPT SearchFederal ExemptionsIntegerINT2_U02
319ADFDWHDG SearchAdditional Federal WithholdingCurrencyDLR11_$S214
320ESTFEDWH SearchEstimated Federal WithholdingCurrencyDLR11_$U214
321STATECD SearchState CodeStringSTR2_State_Code2
322LOCALTAX SearchLocal TaxStringSTR6_Payroll_Code6
323W2BF942E SearchW2 Box For 942 EmployeeBooleanCB_942_Employee0
324W2BFDCSD SearchW2 Box For DeceasedBooleanCB_Deceased0
325W2BFDCMP SearchW2 Box For Deferred CompensationBooleanCB_Deferred_Compensation0
326W2BFLREP SearchW2 Box For Legal RepresentativeBooleanCB_Legal_Representative0
327W2BFPPLN SearchW2 Box For Pension PlanBooleanCB_Pension_Plan0
328W2BFSTEM SearchW2 Box For Statutory EmployeeBooleanCB_Statutory_Employee0
329MCRQGEMP SearchMedicare Qualified Govt EmployeeBooleanCB_Medicare_Qualified_Govt_Employee0
330EICFLGST SearchEIC Filing StatusStringSTR6_Payroll_Code6
331NYTXDiff SearchWithhold NY Tax DiffBooleanCB_Withhold_NY_Diff0
332ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
333ALTERNATENAME SearchAlternate NameStringSTR2020
334BENADJDATE SearchBen Adj DateDateDT8
335BENEFITEXPIRE_I SearchBenefit ExpireDateDT8
336BIRTHDAY SearchBirth DayIntegerINT0
337BIRTHMONTH SearchBirth MonthIntegerINT0
338CHANGEBY_I SearchChange ByStringSTR15_User_ID15
339CHANGEDATE_I SearchChange DateDateDT8
340CITIZEN SearchCitizenBooleanCB_Citizen0
341DATEOFLASTREVIEW_I SearchDate Of Last ReviewDateDT8
342DATEOFNEXTREVIEW_I SearchDate Of Next ReviewDateDT8
343DISABLEDVETERAN SearchDisabled VeteranBooleanCB_DisableVet0
344DIVISIONCODE_I SearchDivision CodeStringSTR6_Payroll_Code6
345FEDCLSSCD SearchFederal Classification CodeStringSTR10_LBAU10
346HANDICAPPED SearchHandicappedBooleanCB_Handicap0
347HRSTATUS SearchHR StatusIntegerDDL_HRStatus0
348I9RENEW SearchI9renewDateDT8
349LASTDAYWORKED_I SearchLast Day WorkedDateDT8
350LOCATNID SearchLocation IDStringSTR15_Location_ID15
351MARITALSTATUS SearchMaritalStatusIntegerDDL_MaritalStatus0
352NICKNAME SearchNickNameStringSTR2020
353NOTEINDX2 SearchNote Index2CurrencyDLR1414
354Primary_Pay_Record SearchPrimary Pay RecordStringSTR6_Payroll_Code6
355RATECLSS SearchRate ClassStringSTR1515
356SMOKER_I SearchSmokerBooleanCB_Smoker0
357SPOUSE SearchSpouseStringSTR1515
358SPOUSESSN SearchSpouse SSNStringSTR15_Social_Security_Number15
359SUPERVISORCODE_I SearchSupervisor CodeStringSTR6_U6
360EMPLOYMENTTYPE SearchType of EmploymentIntegerDDL_Employment_Type0
361UNIONCD SearchUnion CodeStringSTR66
362UNIONEMPLOYEE SearchUnion EmployeeBooleanCB_Union_Emp0
363VERIFIED SearchVerifiedBooleanCB_Verifed0
364VETERAN SearchVeteranBooleanCB_Military0
365VIETNAMVETERAN SearchVietnam VeteranBooleanCB_Vietnam0
366OTHERVET SearchOther VeteransBooleanCB_OtherVet0
367WRNSTFLSBLWZR SearchWarn Sick Time Falls Below ZeroBooleanCB_WarnSickTimeFallsBelowZero0
368WRNVCNFLSBLWZR SearchWarn Vacation Falls Below ZeroBooleanCB_WarnVacationFallsBelowZero0
369ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
370ASI_Order_By SearchASI_Order_ByLong IntegerLI_1414
371ASI_Document_Status SearchASI_Document_StatusIntegerINT0
azurecurveProductsSmartList (1493)PathnameSmartList Payroll Employee Summary (ASIEXP32)

Leave a Reply

Your email address will not be published. Required fields are marked *