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

The Employee (EMPL) table stores basic information about the employees.

Costpoint Destination Table Costpoint Destination Field Costpoint Field Description Required (Y/N) Talent Management/Default Source
EMPL <CP Job Template ID> CP job template N Custom Field
EMPL ADJ_HIRE_DT Adjusted hire date N N/A
EMPL BADGE_GROUP SFT badge group Y (if Badge ID is specified) CP Job Template
EMPL BADGE_ID SFT badge ID Y (if Badge Group is specified) CP Job Template
EMPL BIRTH_CITY_NAME City of birth N N/A
EMPL BIRTH_COUNTRY_CD Country of birth N N/A
EMPL BIRTH_DT Birth date Y (if licensed for HR or Payroll) user_date_of_birth
EMPL BIRTH_MAIL_STATE_DC State/province of birth N N/A
EMPL BLIND_FL Blind flag N N/A
EMPL CITY_NAME City name N user_city
EMPL CLOCK_FL SFT clock user N CP Job Template
EMPL COMPANY_ID Company ID Y req_company_code
EMPL CONT_NAME_1 Contact name 1 N ESS
EMPL CONT_NAME_2 Contact name 2 N ESS
EMPL CONT_PHONE_1 Contact phone number 1 N ESS
EMPL CONT_PHONE_2 Contact phone number 2 N ESS
EMPL CONT_REL_1 Contact 1 - relationship to employee N ESS
EMPL CONT_REL_2 Contact 2 -relationship to employee N ESS
EMPL CONTRACTOR_FL Subcontractor N CP Job Template
EMPL COUNTRY_CD Country code Y (if a state/province is specified) user_country_abbreviation
EMPL COUNTY_NAME County name N <Not used>
EMPL DISABLED_FL Disabled flag N "N"
EMPL ELIG_AUTO_PAY_FL Eligible For auto-pay flag N "N"
EMPL EMAIL_ID Email ID N N/A
EMPL EMPL_ID Employee ID Y (if auto ID generation is not enabled) user_employee_id
EMPL EMPL_SOURCE_CD Employee source N "TALENT MANAGEMENT"
EMPL ESS_PIN_ID ESS PIN ID N No (no longer used)
EMPL FIRST_NAME First name Y user_firstname
EMPL HOME_EMAIL_ID Home email address N user_email
EMPL HRSMART_EXPORT_DT Date and time the employee was last exported to SilkRoad N N/A
EMPL HUA_ID HUA user ID N user_id
EMPL HUA_ID_ACTV_MAP_FL Active HUA ID mapping N N/A
EMPL LAST_DAY_DT Last day worked N N/A
EMPL LAST_FIRST_NAME Employee name (Last/First/Mid) Y  Calculated
EMPL LAST_NAME Last name Y user_lastname
EMPL LAST_REVIEW_DT Last review date N N/A
EMPL LN_1_ADR Address line 1 N user_address_one
EMPL LN_2_ADR Address line 2 N user_address_two
EMPL LN_3_ADR Address line 3 N user_address_three
EMPL LOCATOR_CD Locator code N CP Job Template
EMPL LOGIN_ID SFT login ID N N/A
EMPL LV_PD_CD Leave cycle Y CP Job Template
EMPL MAIL_STATE_DC Mail state Y (if country code is "USA") user_state_abbreviation
EMPL MARITAL_CD Marital code N "U"
EMPL MES_FL Manufacturing execution N CP Job Template
EMPL MGR_EMPL_ID Manager N N/A
EMPL MID_NAME Middle Name N user_middlename
EMPL MODIFIED_BY ID of the user who last created or modified row N N/A
EMPL MOS_REVIEW_NO Months between Reviews N N/A
EMPL NAME_PRFX_CD Name prefix code N N/A
EMPL NAME_SFX_CD Name suffix code N N/A
EMPL NEXT_REVIEW_DT Next review date N N/A
EMPL NOTES Notes N N/A
EMPL ORIG_HIRE_DT Original hire date Y candidate_start_date
EMPL PAY_PD_REG_HRS_NO Pay period regular hours N N/A
EMPL PIN_UPDATED_FL ESS PIN updated flag (Y/N) N N/A
EMPL PLANT_ID Plant ID N CP Job Template
EMPL POSTAL_CD Postal code N user_zipcode
EMPL PR_SERV_EMPL_ID Payroll service employee ID N N/A
EMPL PREF_NAME Preferred name N N/A
EMPL PRIR_NAME Prior name N N/A
EMPL ROWVERSION System-assigned number to handle row concurrency N N/A
EMPL S_EMPL_STATUS_CD Employee status code Y "ACT"
EMPL S_ESS_COS_CD ESS class of service code N N/A
EMPL S_RACE_CD Employee's race code Y (if licensed for HR) user_eeoc_race
EMPL SEX_CD Sex code Y (if licensed for HR) user_eeoc_gender
EMPL SFT_FL Shop floor time user N CP Job Template
EMPL SPVSR_NAME Supervisor name N CP Job Template
EMPL SR_EXPORT_DT Date and time the employee was last exported to SilkRoad N N/A
EMPL SSN_ID Social security number Y national_identifier or “999-99-9999”
EMPL TAXBLE_ENTITY_ID Taxable entity (Company ID) Y Custom Field
EMPL TERM_DT Termination date N N/A
EMPL TIME_ENTRY_TYPE Time entry type N CP Job Template, "PUNCHED"
EMPL TIME_STAMP Date and time of row creation or last modification N N/A
EMPL TS_PD_CD Timesheet period code Y CP Job Template
EMPL TS_PD_REG_HRS_NO Timesheet period regular hours N 0
EMPL UNION_EMPL_FL Union employee flag (Y/N) N CP Job Template, "N"
EMPL UNIT_AMT Unit amount N 0
EMPL VET_RELEASE_DT Active military duty discharge or release date N N/A
EMPL VET_STATUS_A Armed Forces Service medal veteran N user_eeoc_veteran
EMPL VET_STATUS_D Veteran status Disabled N user_eeoc_veteran
EMPL VET_STATUS_O Active wartime or campaign badge veteran

(Other protected veteran)

N user_eeoc_veteran
EMPL VET_STATUS_R Reservist N N/A
EMPL VET_STATUS_S Special disabled veteran N N/A
EMPL VET_STATUS_V Vietnam era veteran N N/A
EMPL VISA_DT Visa expiration date N N/A
EMPL VISA_TYPE_CD Visa type code N N/A
EMPL VET_STATUS_NP Not a protected veteran N user_eeoc_veteran
EMPL VET_STATUS_RS Recently separated veteran N user_eeoc_veteran
EMPL VET_STATUS_DECLINED Declined to provide a veteran status N N/A
EMPL VET_STATUS_P Protected veteran (declined to self-identify) N user_eeoc_veteran