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: Pathname

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

Leave a Reply

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