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

Leave a Reply

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