ASIEXP32 - SmartList Payroll Employee Summary | Prospr

ASIEXP32 - SmartList Payroll Employee Summary

Query Builder

Select * from ASIEXP32

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
YEAR1	Year	Integer	2	View
EMPLCLAS	Employee Class	String	16	View
INACTIVE	Inactive	Boolean	2	View
LASTNAME	Last Name	String	22	View
FRSTNAME	First Name	String	16	View
MIDLNAME	Middle Name	String	16	View
SOCSCNUM	Social Security Number	String	16	View
BRTHDATE	Birth Date	Date	4	View
GENDER	Gender 1 is male 2 is female 3 is N/A.	Integer	2	View
ETHNORGN	Ethnic Origin 1. White 2. American Indian or Alaskan Native 3. Black or African American 4. Asian 5. Hispanic or Latino 6. Two or more races 7. N/A 8. Native Hawaiian or Pacific Islander	Integer	2	View
Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	2	View
DEPRTMNT	Department	String	8	View
JOBTITLE	Job Title	String	8	View
WCACFPAY	Which Cash Account For Pay	Integer	2	View
ACTINDX	Account Index	Long Integer	4	View
WKHRPRYR	Work Hours Per Year	Integer	2	View
STRTDATE	Start Date	Date	4	View
DEMPINAC	Date Employee Inactivated	Date	4	View
RSNEMPIN	Reason Employee Inactivated	String	32	View
MINETPAY	Minimum Net Pay	Currency	10	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
ATACRVAC	Auto Accrue Vacation	Boolean	2	View
VACCRAMT	Vacation Accrual Amount	Long Integer	4	View
VACCRMTH	Vacation Accrual Method	Integer	2	View
VACAPRYR	Vacation Hours Per Year	Long Integer	4	View
VACAVLBL	Vacation Available	Long Integer	4	View
ATACRSTM	Auto Accrue Sick Time	Boolean	2	View
STMACMTH	Sick Time Accrual Method 0 is by Hours Worked 1 is by Amount.	Integer	2	View
SKTMACAM	Sick Time Accrual Amount	Long Integer	4	View
SIKTIMAV	Sick Time Available	Long Integer	4	View
SKTMHPYR	Sick Time Hours Per Year	Long Integer	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
NOTEINDX	Note Index	Currency	10	View
LPCHKNUM	Last Paycheck Number	String	22	View
LSTPCKDT	Last Paycheck Date	Date	4	View
LPCHKAMT	Last Paycheck Amount	Currency	10	View
GROSWAGS_1	Gross Wages[1]	Currency	10	View
GROSWAGS_2	Gross Wages[2]	Currency	10	View
GROSWAGS_3	Gross Wages[3]	Currency	10	View
GROSWAGS_4	Gross Wages[4]	Currency	10	View
GROSWAGS_5	Gross Wages[5]	Currency	10	View
GROSWAGS_6	Gross Wages[6]	Currency	10	View
GROSWAGS_7	Gross Wages[7]	Currency	10	View
GROSWAGS_8	Gross Wages[8]	Currency	10	View
GROSWAGS_9	Gross Wages[9]	Currency	10	View
GROSWAGS_10	Gross Wages[10]	Currency	10	View
GROSWAGS_11	Gross Wages[11]	Currency	10	View
GROSWAGS_12	Gross Wages[12]	Currency	10	View
Federal_Wages_1	Federal Wages[1]	Currency	10	View
Federal_Wages_2	Federal Wages[2]	Currency	10	View
Federal_Wages_3	Federal Wages[3]	Currency	10	View
Federal_Wages_4	Federal Wages[4]	Currency	10	View
Federal_Wages_5	Federal Wages[5]	Currency	10	View
Federal_Wages_6	Federal Wages[6]	Currency	10	View
Federal_Wages_7	Federal Wages[7]	Currency	10	View
Federal_Wages_8	Federal Wages[8]	Currency	10	View
Federal_Wages_9	Federal Wages[9]	Currency	10	View
Federal_Wages_10	Federal Wages[10]	Currency	10	View
Federal_Wages_11	Federal Wages[11]	Currency	10	View
Federal_Wages_12	Federal Wages[12]	Currency	10	View
Federal_Tips_1	Federal Tips[1]	Currency	10	View
Federal_Tips_2	Federal Tips[2]	Currency	10	View
Federal_Tips_3	Federal Tips[3]	Currency	10	View
Federal_Tips_4	Federal Tips[4]	Currency	10	View
Federal_Tips_5	Federal Tips[5]	Currency	10	View
Federal_Tips_6	Federal Tips[6]	Currency	10	View
Federal_Tips_7	Federal Tips[7]	Currency	10	View
Federal_Tips_8	Federal Tips[8]	Currency	10	View
Federal_Tips_9	Federal Tips[9]	Currency	10	View
Federal_Tips_10	Federal Tips[10]	Currency	10	View
Federal_Tips_11	Federal Tips[11]	Currency	10	View
Federal_Tips_12	Federal Tips[12]	Currency	10	View
FDWTHLDG_1	Federal Withholding[1]	Currency	10	View
FDWTHLDG_2	Federal Withholding[2]	Currency	10	View
FDWTHLDG_3	Federal Withholding[3]	Currency	10	View
FDWTHLDG_4	Federal Withholding[4]	Currency	10	View
FDWTHLDG_5	Federal Withholding[5]	Currency	10	View
FDWTHLDG_6	Federal Withholding[6]	Currency	10	View
FDWTHLDG_7	Federal Withholding[7]	Currency	10	View
FDWTHLDG_8	Federal Withholding[8]	Currency	10	View
FDWTHLDG_9	Federal Withholding[9]	Currency	10	View
FDWTHLDG_10	Federal Withholding[10]	Currency	10	View
FDWTHLDG_11	Federal Withholding[11]	Currency	10	View
FDWTHLDG_12	Federal Withholding[12]	Currency	10	View
FICASSWG_1	FICA/Social Security Wages[1]	Currency	10	View
FICASSWG_2	FICA/Social Security Wages[2]	Currency	10	View
FICASSWG_3	FICA/Social Security Wages[3]	Currency	10	View
FICASSWG_4	FICA/Social Security Wages[4]	Currency	10	View
FICASSWG_5	FICA/Social Security Wages[5]	Currency	10	View
FICASSWG_6	FICA/Social Security Wages[6]	Currency	10	View
FICASSWG_7	FICA/Social Security Wages[7]	Currency	10	View
FICASSWG_8	FICA/Social Security Wages[8]	Currency	10	View
FICASSWG_9	FICA/Social Security Wages[9]	Currency	10	View
FICASSWG_10	FICA/Social Security Wages[10]	Currency	10	View
FICASSWG_11	FICA/Social Security Wages[11]	Currency	10	View
FICASSWG_12	FICA/Social Security Wages[12]	Currency	10	View
FICAMWGS_1	FICA/Medicare Wages[1]	Currency	10	View
FICAMWGS_2	FICA/Medicare Wages[2]	Currency	10	View
FICAMWGS_3	FICA/Medicare Wages[3]	Currency	10	View
FICAMWGS_4	FICA/Medicare Wages[4]	Currency	10	View
FICAMWGS_5	FICA/Medicare Wages[5]	Currency	10	View
FICAMWGS_6	FICA/Medicare Wages[6]	Currency	10	View
FICAMWGS_7	FICA/Medicare Wages[7]	Currency	10	View
FICAMWGS_8	FICA/Medicare Wages[8]	Currency	10	View
FICAMWGS_9	FICA/Medicare Wages[9]	Currency	10	View
FICAMWGS_10	FICA/Medicare Wages[10]	Currency	10	View
FICAMWGS_11	FICA/Medicare Wages[11]	Currency	10	View
FICAMWGS_12	FICA/Medicare Wages[12]	Currency	10	View
FICASSWH_1	FICA/Social Security Withholding[1]	Currency	10	View
FICASSWH_2	FICA/Social Security Withholding[2]	Currency	10	View
FICASSWH_3	FICA/Social Security Withholding[3]	Currency	10	View
FICASSWH_4	FICA/Social Security Withholding[4]	Currency	10	View
FICASSWH_5	FICA/Social Security Withholding[5]	Currency	10	View
FICASSWH_6	FICA/Social Security Withholding[6]	Currency	10	View
FICASSWH_7	FICA/Social Security Withholding[7]	Currency	10	View
FICASSWH_8	FICA/Social Security Withholding[8]	Currency	10	View
FICASSWH_9	FICA/Social Security Withholding[9]	Currency	10	View
FICASSWH_10	FICA/Social Security Withholding[10]	Currency	10	View
FICASSWH_11	FICA/Social Security Withholding[11]	Currency	10	View
FICASSWH_12	FICA/Social Security Withholding[12]	Currency	10	View
FICAMWDG_1	FICA/Medicare Withholding[1]	Currency	10	View
FICAMWDG_2	FICA/Medicare Withholding[2]	Currency	10	View
FICAMWDG_3	FICA/Medicare Withholding[3]	Currency	10	View
FICAMWDG_4	FICA/Medicare Withholding[4]	Currency	10	View
FICAMWDG_5	FICA/Medicare Withholding[5]	Currency	10	View
FICAMWDG_6	FICA/Medicare Withholding[6]	Currency	10	View
FICAMWDG_7	FICA/Medicare Withholding[7]	Currency	10	View
FICAMWDG_8	FICA/Medicare Withholding[8]	Currency	10	View
FICAMWDG_9	FICA/Medicare Withholding[9]	Currency	10	View
FICAMWDG_10	FICA/Medicare Withholding[10]	Currency	10	View
FICAMWDG_11	FICA/Medicare Withholding[11]	Currency	10	View
FICAMWDG_12	FICA/Medicare Withholding[12]	Currency	10	View
SUTAWAGS_1	Suta Wages[1]	Currency	10	View
SUTAWAGS_2	Suta Wages[2]	Currency	10	View
SUTAWAGS_3	Suta Wages[3]	Currency	10	View
SUTAWAGS_4	Suta Wages[4]	Currency	10	View
SUTAWAGS_5	Suta Wages[5]	Currency	10	View
SUTAWAGS_6	Suta Wages[6]	Currency	10	View
SUTAWAGS_7	Suta Wages[7]	Currency	10	View
SUTAWAGS_8	Suta Wages[8]	Currency	10	View
SUTAWAGS_9	Suta Wages[9]	Currency	10	View
SUTAWAGS_10	Suta Wages[10]	Currency	10	View
SUTAWAGS_11	Suta Wages[11]	Currency	10	View
SUTAWAGS_12	Suta Wages[12]	Currency	10	View
FUTAWAGS_1	Futa Wages[1]	Currency	10	View
FUTAWAGS_2	Futa Wages[2]	Currency	10	View
FUTAWAGS_3	Futa Wages[3]	Currency	10	View
FUTAWAGS_4	Futa Wages[4]	Currency	10	View
FUTAWAGS_5	Futa Wages[5]	Currency	10	View
FUTAWAGS_6	Futa Wages[6]	Currency	10	View
FUTAWAGS_7	Futa Wages[7]	Currency	10	View
FUTAWAGS_8	Futa Wages[8]	Currency	10	View
FUTAWAGS_9	Futa Wages[9]	Currency	10	View
FUTAWAGS_10	Futa Wages[10]	Currency	10	View
FUTAWAGS_11	Futa Wages[11]	Currency	10	View
FUTAWAGS_12	Futa Wages[12]	Currency	10	View
NETWAGES_1	Net Wages[1]	Currency	10	View
NETWAGES_2	Net Wages[2]	Currency	10	View
NETWAGES_3	Net Wages[3]	Currency	10	View
NETWAGES_4	Net Wages[4]	Currency	10	View
NETWAGES_5	Net Wages[5]	Currency	10	View
NETWAGES_6	Net Wages[6]	Currency	10	View
NETWAGES_7	Net Wages[7]	Currency	10	View
NETWAGES_8	Net Wages[8]	Currency	10	View
NETWAGES_9	Net Wages[9]	Currency	10	View
NETWAGES_10	Net Wages[10]	Currency	10	View
NETWAGES_11	Net Wages[11]	Currency	10	View
NETWAGES_12	Net Wages[12]	Currency	10	View
Reported_Tips12_1	Reported Tips Array[1]	Currency	10	View
Reported_Tips12_2	Reported Tips Array[2]	Currency	10	View
Reported_Tips12_3	Reported Tips Array[3]	Currency	10	View
Reported_Tips12_4	Reported Tips Array[4]	Currency	10	View
Reported_Tips12_5	Reported Tips Array[5]	Currency	10	View
Reported_Tips12_6	Reported Tips Array[6]	Currency	10	View
Reported_Tips12_7	Reported Tips Array[7]	Currency	10	View
Reported_Tips12_8	Reported Tips Array[8]	Currency	10	View
Reported_Tips12_9	Reported Tips Array[9]	Currency	10	View
Reported_Tips12_10	Reported Tips Array[10]	Currency	10	View
Reported_Tips12_11	Reported Tips Array[11]	Currency	10	View
Reported_Tips12_12	Reported Tips Array[12]	Currency	10	View
Charged_Tips12_1	Charged Tips Array[1]	Currency	10	View
Charged_Tips12_2	Charged Tips Array[2]	Currency	10	View
Charged_Tips12_3	Charged Tips Array[3]	Currency	10	View
Charged_Tips12_4	Charged Tips Array[4]	Currency	10	View
Charged_Tips12_5	Charged Tips Array[5]	Currency	10	View
Charged_Tips12_6	Charged Tips Array[6]	Currency	10	View
Charged_Tips12_7	Charged Tips Array[7]	Currency	10	View
Charged_Tips12_8	Charged Tips Array[8]	Currency	10	View
Charged_Tips12_9	Charged Tips Array[9]	Currency	10	View
Charged_Tips12_10	Charged Tips Array[10]	Currency	10	View
Charged_Tips12_11	Charged Tips Array[11]	Currency	10	View
Charged_Tips12_12	Charged Tips Array[12]	Currency	10	View
Federal_Tax_On_Tips_1	Federal Tax On Tips[1]	Currency	10	View
Federal_Tax_On_Tips_2	Federal Tax On Tips[2]	Currency	10	View
Federal_Tax_On_Tips_3	Federal Tax On Tips[3]	Currency	10	View
Federal_Tax_On_Tips_4	Federal Tax On Tips[4]	Currency	10	View
Federal_Tax_On_Tips_5	Federal Tax On Tips[5]	Currency	10	View
Federal_Tax_On_Tips_6	Federal Tax On Tips[6]	Currency	10	View
Federal_Tax_On_Tips_7	Federal Tax On Tips[7]	Currency	10	View
Federal_Tax_On_Tips_8	Federal Tax On Tips[8]	Currency	10	View
Federal_Tax_On_Tips_9	Federal Tax On Tips[9]	Currency	10	View
Federal_Tax_On_Tips_10	Federal Tax On Tips[10]	Currency	10	View
Federal_Tax_On_Tips_11	Federal Tax On Tips[11]	Currency	10	View
Federal_Tax_On_Tips_12	Federal Tax On Tips[12]	Currency	10	View
FICASS_Tips_1	FICA/SS Tips[1]	Currency	10	View
FICASS_Tips_2	FICA/SS Tips[2]	Currency	10	View
FICASS_Tips_3	FICA/SS Tips[3]	Currency	10	View
FICASS_Tips_4	FICA/SS Tips[4]	Currency	10	View
FICASS_Tips_5	FICA/SS Tips[5]	Currency	10	View
FICASS_Tips_6	FICA/SS Tips[6]	Currency	10	View
FICASS_Tips_7	FICA/SS Tips[7]	Currency	10	View
FICASS_Tips_8	FICA/SS Tips[8]	Currency	10	View
FICASS_Tips_9	FICA/SS Tips[9]	Currency	10	View
FICASS_Tips_10	FICA/SS Tips[10]	Currency	10	View
FICASS_Tips_11	FICA/SS Tips[11]	Currency	10	View
FICASS_Tips_12	FICA/SS Tips[12]	Currency	10	View
FICASS_Tax_On_Tips_1	FICA/SS Tax On Tips[1]	Currency	10	View
FICASS_Tax_On_Tips_2	FICA/SS Tax On Tips[2]	Currency	10	View
FICASS_Tax_On_Tips_3	FICA/SS Tax On Tips[3]	Currency	10	View
FICASS_Tax_On_Tips_4	FICA/SS Tax On Tips[4]	Currency	10	View
FICASS_Tax_On_Tips_5	FICA/SS Tax On Tips[5]	Currency	10	View
FICASS_Tax_On_Tips_6	FICA/SS Tax On Tips[6]	Currency	10	View
FICASS_Tax_On_Tips_7	FICA/SS Tax On Tips[7]	Currency	10	View
FICASS_Tax_On_Tips_8	FICA/SS Tax On Tips[8]	Currency	10	View
FICASS_Tax_On_Tips_9	FICA/SS Tax On Tips[9]	Currency	10	View
FICASS_Tax_On_Tips_10	FICA/SS Tax On Tips[10]	Currency	10	View
FICASS_Tax_On_Tips_11	FICA/SS Tax On Tips[11]	Currency	10	View
FICASS_Tax_On_Tips_12	FICA/SS Tax On Tips[12]	Currency	10	View
Uncollected_FICASS_Tax_1	Uncollected FICA/SS Tax[1]	Currency	10	View
Uncollected_FICASS_Tax_2	Uncollected FICA/SS Tax[2]	Currency	10	View
Uncollected_FICASS_Tax_3	Uncollected FICA/SS Tax[3]	Currency	10	View
Uncollected_FICASS_Tax_4	Uncollected FICA/SS Tax[4]	Currency	10	View
Uncollected_FICASS_Tax_5	Uncollected FICA/SS Tax[5]	Currency	10	View
Uncollected_FICASS_Tax_6	Uncollected FICA/SS Tax[6]	Currency	10	View
Uncollected_FICASS_Tax_7	Uncollected FICA/SS Tax[7]	Currency	10	View
Uncollected_FICASS_Tax_8	Uncollected FICA/SS Tax[8]	Currency	10	View
Uncollected_FICASS_Tax_9	Uncollected FICA/SS Tax[9]	Currency	10	View
Uncollected_FICASS_Tax_10	Uncollected FICA/SS Tax[10]	Currency	10	View
Uncollected_FICASS_Tax_11	Uncollected FICA/SS Tax[11]	Currency	10	View
Uncollected_FICASS_Tax_12	Uncollected FICA/SS Tax[12]	Currency	10	View
FICAMed_Tips_1	FICA/Med Tips[1]	Currency	10	View
FICAMed_Tips_2	FICA/Med Tips[2]	Currency	10	View
FICAMed_Tips_3	FICA/Med Tips[3]	Currency	10	View
FICAMed_Tips_4	FICA/Med Tips[4]	Currency	10	View
FICAMed_Tips_5	FICA/Med Tips[5]	Currency	10	View
FICAMed_Tips_6	FICA/Med Tips[6]	Currency	10	View
FICAMed_Tips_7	FICA/Med Tips[7]	Currency	10	View
FICAMed_Tips_8	FICA/Med Tips[8]	Currency	10	View
FICAMed_Tips_9	FICA/Med Tips[9]	Currency	10	View
FICAMed_Tips_10	FICA/Med Tips[10]	Currency	10	View
FICAMed_Tips_11	FICA/Med Tips[11]	Currency	10	View
FICAMed_Tips_12	FICA/Med Tips[12]	Currency	10	View
FICAMed_Tax_On_Tips_1	FICA/Med Tax On Tips[1]	Currency	10	View
FICAMed_Tax_On_Tips_2	FICA/Med Tax On Tips[2]	Currency	10	View
FICAMed_Tax_On_Tips_3	FICA/Med Tax On Tips[3]	Currency	10	View
FICAMed_Tax_On_Tips_4	FICA/Med Tax On Tips[4]	Currency	10	View
FICAMed_Tax_On_Tips_5	FICA/Med Tax On Tips[5]	Currency	10	View
FICAMed_Tax_On_Tips_6	FICA/Med Tax On Tips[6]	Currency	10	View
FICAMed_Tax_On_Tips_7	FICA/Med Tax On Tips[7]	Currency	10	View
FICAMed_Tax_On_Tips_8	FICA/Med Tax On Tips[8]	Currency	10	View
FICAMed_Tax_On_Tips_9	FICA/Med Tax On Tips[9]	Currency	10	View
FICAMed_Tax_On_Tips_10	FICA/Med Tax On Tips[10]	Currency	10	View
FICAMed_Tax_On_Tips_11	FICA/Med Tax On Tips[11]	Currency	10	View
FICAMed_Tax_On_Tips_12	FICA/Med Tax On Tips[12]	Currency	10	View
Uncollected_FICAMed_Tax_1	Uncollected FICA/Med Tax[1]	Currency	10	View
Uncollected_FICAMed_Tax_2	Uncollected FICA/Med Tax[2]	Currency	10	View
Uncollected_FICAMed_Tax_3	Uncollected FICA/Med Tax[3]	Currency	10	View
Uncollected_FICAMed_Tax_4	Uncollected FICA/Med Tax[4]	Currency	10	View
Uncollected_FICAMed_Tax_5	Uncollected FICA/Med Tax[5]	Currency	10	View
Uncollected_FICAMed_Tax_6	Uncollected FICA/Med Tax[6]	Currency	10	View
Uncollected_FICAMed_Tax_7	Uncollected FICA/Med Tax[7]	Currency	10	View
Uncollected_FICAMed_Tax_8	Uncollected FICA/Med Tax[8]	Currency	10	View
Uncollected_FICAMed_Tax_9	Uncollected FICA/Med Tax[9]	Currency	10	View
Uncollected_FICAMed_Tax_10	Uncollected FICA/Med Tax[10]	Currency	10	View
Uncollected_FICAMed_Tax_11	Uncollected FICA/Med Tax[11]	Currency	10	View
Uncollected_FICAMed_Tax_12	Uncollected FICA/Med Tax[12]	Currency	10	View
Reported_Receipts12_1	Reported Receipts Array[1]	Currency	10	View
Reported_Receipts12_2	Reported Receipts Array[2]	Currency	10	View
Reported_Receipts12_3	Reported Receipts Array[3]	Currency	10	View
Reported_Receipts12_4	Reported Receipts Array[4]	Currency	10	View
Reported_Receipts12_5	Reported Receipts Array[5]	Currency	10	View
Reported_Receipts12_6	Reported Receipts Array[6]	Currency	10	View
Reported_Receipts12_7	Reported Receipts Array[7]	Currency	10	View
Reported_Receipts12_8	Reported Receipts Array[8]	Currency	10	View
Reported_Receipts12_9	Reported Receipts Array[9]	Currency	10	View
Reported_Receipts12_10	Reported Receipts Array[10]	Currency	10	View
Reported_Receipts12_11	Reported Receipts Array[11]	Currency	10	View
Reported_Receipts12_12	Reported Receipts Array[12]	Currency	10	View
Charged_Receipts12_1	Charged Receipts Array[1]	Currency	10	View
Charged_Receipts12_2	Charged Receipts Array[2]	Currency	10	View
Charged_Receipts12_3	Charged Receipts Array[3]	Currency	10	View
Charged_Receipts12_4	Charged Receipts Array[4]	Currency	10	View
Charged_Receipts12_5	Charged Receipts Array[5]	Currency	10	View
Charged_Receipts12_6	Charged Receipts Array[6]	Currency	10	View
Charged_Receipts12_7	Charged Receipts Array[7]	Currency	10	View
Charged_Receipts12_8	Charged Receipts Array[8]	Currency	10	View
Charged_Receipts12_9	Charged Receipts Array[9]	Currency	10	View
Charged_Receipts12_10	Charged Receipts Array[10]	Currency	10	View
Charged_Receipts12_11	Charged Receipts Array[11]	Currency	10	View
Charged_Receipts12_12	Charged Receipts Array[12]	Currency	10	View
Allocated_Tips_Array_1	Allocated Tips Array[1]	Currency	10	View
Allocated_Tips_Array_2	Allocated Tips Array[2]	Currency	10	View
Allocated_Tips_Array_3	Allocated Tips Array[3]	Currency	10	View
Allocated_Tips_Array_4	Allocated Tips Array[4]	Currency	10	View
Allocated_Tips_Array_5	Allocated Tips Array[5]	Currency	10	View
Allocated_Tips_Array_6	Allocated Tips Array[6]	Currency	10	View
Allocated_Tips_Array_7	Allocated Tips Array[7]	Currency	10	View
Allocated_Tips_Array_8	Allocated Tips Array[8]	Currency	10	View
Allocated_Tips_Array_9	Allocated Tips Array[9]	Currency	10	View
Allocated_Tips_Array_10	Allocated Tips Array[10]	Currency	10	View
Allocated_Tips_Array_11	Allocated Tips Array[11]	Currency	10	View
Allocated_Tips_Array_12	Allocated Tips Array[12]	Currency	10	View
EXMFRFED	Exempt From Federal	Boolean	2	View
FDFLGSTS	Federal Filing Status	String	8	View
FEDEXMPT	Federal Exemptions	Integer	2	View
ADFDWHDG	Additional Federal Withholding	Currency	10	View
ESTFEDWH	Estimated Federal Withholding	Currency	10	View
STATECD	State Code	String	4	View
LOCALTAX	Local Tax	String	8	View
W2BF942E	W2 Box For 942 Employee	Boolean	2	View
W2BFDCSD	W2 Box For Deceased	Boolean	2	View
W2BFDCMP	W2 Box For Deferred Compensation	Boolean	2	View
W2BFLREP	W2 Box For Legal Representative	Boolean	2	View
W2BFPPLN	W2 Box For Pension Plan	Boolean	2	View
W2BFSTEM	W2 Box For Statutory Employee	Boolean	2	View
MCRQGEMP	Medicare Qualified Govt Employee	Boolean	2	View
EICFLGST	EIC Filing Status	String	8	View
NYTXDiff	Withhold NY Tax Diff	Boolean	2	View
ADRSCODE	Address Code	String	16	View
ALTERNATENAME	Alternate Name	String	22	View
BENADJDATE	Ben Adj Date	Date	4	View
BENEFITEXPIRE_I	Benefit Expire	Date	4	View
BIRTHDAY	Birth Day	Integer	2	View
BIRTHMONTH	Birth Month	Integer	2	View
CHANGEBY_I	Change By	String	16	View
CHANGEDATE_I	Change Date	Date	4	View
CITIZEN	Citizen	Boolean	2	View
DATEOFLASTREVIEW_I	Date Of Last Review	Date	4	View
DATEOFNEXTREVIEW_I	Date Of Next Review	Date	4	View
DISABLEDVETERAN	Disabled Veteran	Boolean	2	View
DIVISIONCODE_I	Division Code	String	8	View
FEDCLSSCD	Federal Classification Code	String	12	View
HANDICAPPED	Handicapped	Boolean	2	View
HRSTATUS	HR Status 1. Active 2. Family Leave 3. Leave of Absence 4. Maternity 5. Retired 6. Separated 7. Suspended 8. Terminated 9. Other In SBM, this field is not available.	Integer	2	View
I9RENEW	I9renew	Date	4	View
LASTDAYWORKED_I	Last Day Worked	Date	4	View
LOCATNID	Location ID	String	16	View
MARITALSTATUS	MaritalStatus 1. Married 2. Single 3. N/A	Integer	2	View
NICKNAME	NickName	String	22	View
NOTEINDX2	Note Index2	Currency	10	View
Primary_Pay_Record	Primary Pay Record	String	8	View
RATECLSS	Rate Class	String	16	View
SMOKER_I	Smoker	Boolean	2	View
SPOUSE	Spouse	String	16	View
SPOUSESSN	Spouse SSN	String	16	View
SUPERVISORCODE_I	Supervisor Code	String	8	View
EMPLOYMENTTYPE	Type of Employment 1. Full Time Regular 2. Full Time Temp 3. Part Time Regular 4. Part Time Temp 5. Intern In SBM, this field is not available. 6. Other	Integer	2	View
UNIONCD	Union Code	String	8	View
UNIONEMPLOYEE	Union Employee	Boolean	2	View
VERIFIED	Verified	Boolean	2	View
VETERAN	Veteran	Boolean	2	View
VIETNAMVETERAN	Vietnam Veteran	Boolean	2	View
OTHERVET	Other Veterans	Boolean	2	View
WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	2	View
WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	2	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View

ASIEXP32 - SmartList Payroll Employee Summary

Query Builder

Customer Service

Information

My Account

Contact Us