Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

EMPL_TAX

The Employee Tax (EMPL_TAX) table stores employee federal and state W-4 information.

Costpoint Destination Table Costpoint Destination Field Costpoint Field Description Required (Y/N) Talent Management/Default Source
EMPL_TAX AEIC_EXMPT_NO AEIC exemption number N N/A
EMPL_TAX AEIC_OVRIDE_AMT AEIC override Amount N N/A
EMPL_TAX AR_SEAS_EMPL Arkansas seasonal employee code N N/A
EMPL_TAX CLASS_CD class code N N/A
EMPL_TAX CORP_OFCR_ID corporate officer ID N N/A
EMPL_TAX COVG_TYPE Coverage type N N/A
EMPL_TAX DSLE_ESS_W4_FL Disable ESS W-4 flag N N/A
EMPL_TAX EE_ER_RELATION_CD Employee/employer relationship N N/A
EMPL_TAX EMPL_ID Employee ID Y (if auto ID generation is not enabled) user_employee_id
EMPL_TAX FED_ADDTL_AMT Federal additional withholdingamount N ESS
EMPL_TAX FED_EXMPT_NO Number of federal withholding exemption claimed N ESS
EMPL_TAX FED_OVRIDE_AMT Federal withholding override amount N N/A
EMPL_TAX FED_OVRIDE_PCT Federal override percent N N/A
EMPL_TAX FUTA_TXBL_FL Federal unemployment tax flag (Y/N) N N/A
EMPL_TAX FUTURE_TXBL_FL Future use flag (Y/N) N N/A
EMPL_TAX LC1_OVRIDE_PCT Local 1 override percent N N/A
EMPL_TAX LC2_OVRIDE_PCT Local 2 override percent N N/A
EMPL_TAX LC3_OVRIDE_PCT Local 3 override percent N N/A
EMPL_TAX LC4_OVRIDE_PCT Local 4 override percent N N/A
EMPL_TAX LC5_OVRIDE_PCT Local 5 override percent N N/A
EMPL_TAX LOC1_ADDTL_AMT Locality 1 additional withholding amount N N/A
EMPL_TAX LOC1_CREDIT_NO Locality 1 number of credits claimed N N/A
EMPL_TAX LOC1_DEPEND_NO Locality 1 number of dependents claimed N N/A
EMPL_TAX LOC1_EXMPT_NO Locality 1 number of exemptions claimed N N/A
EMPL_TAX LOC1_OVRIDE_AMT Locality 1 withholding override claimed N N/A
EMPL_TAX LOC2_ADDTL_AMT Locality 2 additional withholding amount N N/A
EMPL_TAX LOC2_CREDIT_NO Locality 2 number of credits claimed N N/A
EMPL_TAX LOC2_DEPEND_NO Locality 2 number of dependents claimed N N/A
EMPL_TAX LOC2_EXMPT_NO Locality 2 number of exemptions claimed N N/A
EMPL_TAX LOC2_OVRIDE_AMT Locality 2 withholding override claimed N N/A
EMPL_TAX LOC3_ADDTL_AMT Locality 3 additional withholding amount N N/A
EMPL_TAX LOC3_CREDIT_NO Locality 3 number of credits claimed N N/A
EMPL_TAX LOC3_DEPEND_NO Locality 3 number of dependents claimed N N/A
EMPL_TAX LOC3_EXMPT_NO Locality 3 number of exemptions claimed N N/A
EMPL_TAX LOC3_OVRIDE_AMT Locality 3 withholding override claimed N N/A
EMPL_TAX LOC4_ADDTL_AMT Locality 4 additional withholding amount N N/A
EMPL_TAX LOC4_CREDIT_NO Locality 4 number of credits claimed N N/A
EMPL_TAX LOC4_DEPEND_NO Locality 4 number of dependents claimed N N/A
EMPL_TAX LOC4_EXMPT_NO Locality 4 number of exemptions claimed N N/A
EMPL_TAX LOC4_OVRIDE_AMT Locality 4 withholding override claimed N N/A
EMPL_TAX LOC5_ADDTL_AMT Locality 5 additional withholding amount N N/A
EMPL_TAX LOC5_CREDIT_NO Locality 5 number of credits claimed N N/A
EMPL_TAX LOC5_DEPEND_NO Locality 5 number of dependents claimed N N/A
EMPL_TAX LOC5_EXMPT_NO Locality 5 number of exemptions claimed N N/A
EMPL_TAX LOC5_OVRIDE_AMT Locality 5 withholding Override Claimed N N/A
EMPL_TAX MAIL_STATE_DC Tax state Y ( if the employee's pay cycle is set up for multi-state tax) user_state_abbreviation
EMPL_TAX MEDICR_TXBL_FL Medicare taxable flag (Y/N) N N/A
EMPL_TAX MN_WORKSITE_NO Minnesota worksite number N N/A
EMPL_TAX MO_PROBATION_FL MO probationary flag N N/A
EMPL_TAX MODIFIED_BY ID of the user who last created or modified row N N/A
EMPL_TAX NE_MIN_WH_FL Exempt from Nebraska minimum withholding N N/A
EMPL_TAX NRA_FL Nonresident alien flag N N/A
EMPL_TAX OWNER_FL Owner flag N N/A
EMPL_TAX PA_PSD_CD Pennsylvania resident PSD code N N/A
EMPL_TAX PA_WORK_PSD_CD Pennsylvania work location PSD code N N/A
EMPL_TAX PAY_PD_CD Pay cycle code Y CP Job Template; CP Company Default
EMPL_TAX PENSION_PLAN_FL Pension plan covered flag (Y/N) N N/A
EMPL_TAX ROWVERSION System-assigned number to handle row concurrency N N/A
EMPL_TAX S_AEIC_FIL_STAT_CD Filing Status AEIC Code N N/A
EMPL_TAX S_AK_GEO_CD Geographic code N N/A
EMPL_TAX S_AK_OCC_CD Alaska occupational code N N/A
EMPL_TAX S_FED_FIL_STAT_CD Federal filing status code N N/A
EMPL_TAX S_FED_WH_MTHD_CD Filing status federal tax withholding method code N N/A
EMPL_TAX S_LOC1_FIL_STAT_CD Filing status locality 1 code N N/A
EMPL_TAX S_LOC2_FIL_STAT_CD Filing status locality 2 code N N/A
EMPL_TAX S_LOC3_FIL_STAT_CD Filing status locality 3 code N N/A
EMPL_TAX S_LOC4_FIL_STAT_CD Filing status locality 4 code N N/A
EMPL_TAX S_LOC5_FIL_STAT_CD Filing status locality 5 code N N/A
EMPL_TAX S_ST_FIL_STAT_CD State filing status code N ESS
EMPL_TAX SPCL_DED_FL Puerto Rico special deduction fag N N/A
EMPL_TAX SS_TXBL_FL Social Security taxable flag (Y/N) N N/A
EMPL_TAX ST_ADDTL_AMT State additional withholding amount N ESS
EMPL_TAX ST_CREDIT_NO State number of credits claimed N ESS
EMPL_TAX ST_DEPEND_NO State number of dependents claimed N ESS
EMPL_TAX ST_EXMPT_NO State number of exemptions claimed N ESS
EMPL_TAX ST_OVRIDE_AMT State withholding override amount N N/A
EMPL_TAX ST_OVRIDE_PCT State override percent N N/A
EMPL_TAX SUTA_STATE_CD State unemployment tax state code Y (if SUTA_TXBL_FL field value is Y) N/A
EMPL_TAX SUTA_TXBL_FL Subject to SUTA N N/A
EMPL_TAX TAX_SVC_GRP_ID Payroll tax service group ID N N/A
EMPL_TAX TIME_STAMP Date and time of row creation or last modification Y N/A
EMPL_TAX US_CITIZEN_STAT_CD U.S. citizenship status code Y (if the SUTA_STATE_CD field value is VI) N/A
EMPL_TAX VET_EXMPT_FL Puerto Rico veteran exemption Flag N N/A
EMPL_TAX WAGE_PLN_CD Wage plan code Y (if the SUTA_STATE_CD field value is CA) N/A
EMPL_TAX WH_LOC1_CD Withholding locality 1 code N N/A
EMPL_TAX WH_LOC2_CD Withholding locality 2 code N N/A
EMPL_TAX WH_LOC3_CD Withholding locality 3 code N N/A
EMPL_TAX WH_LOC4_CD Withholding locality 4 code N N/A
EMPL_TAX WH_LOC5_CD Withholding locality 5 code N N/A
EMPL_TAX WH_STATE_CD Withholding state code N N/A