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