GP Tables

ASIEXP32 - SmartList Payroll Employee Summary

Dynamics GP table ASIEXP32 (SmartList Payroll Employee Summary) contains 371 columns including EMPLOYID, YEAR1, EMPLCLAS....

SQL Query Builder

371 Columns

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

Related Tables

Tables that share columns with ASIEXP32. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

ACTINDX

AAG10001 AAG20001 AAG20011 AAG30001 AAG40001 AAG50001 AAG60001 AAG70001

USERDEF1

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

USERDEF2

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

EMPLOYID

AAG10001 AAG20001 AAG30001 AAG40001 AHPSLH01 ASIEXP05 ASIEXP10 ASIEXP18

ADRSCODE

ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18

ASI_Favorite_Sequence

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

ASI_Order_By

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08

YEAR1

ASIEXP13 ASIEXP18 CPO10113 CPO10114 CPO40002 CPO40003 EDCVAT02 EDCVAT03

INACTIVE

AAG00400 AAG00401 ASIEXP02 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP10