Employee Metadata Repository

Data Element

Element Description

Data Type

Character Length

Required Field

EmployeeId

Unique Employee Identification

String

14

Yes

ActionCode

Action Code

String

6

Yes

AssignedTo PlantNumber

Employee Plant Number

String

10

Yes

AutoAllowance

Auto Allowance

String

120

Yes

BranchNumber

Assigned Branch Number

String

4

Yes

City

Employee City

String

50

Yes

Commission PayFrequency

Commission Pay Frequency

String

8

Yes

CompanyCode

Company Code

String

4

Yes

CompanyName

Company Name

String

50

Yes

Company SeniorityDate

Company Seniority Date

Date

N/A

Yes

CostCenterDescription

Cost Center Description

String

50

Yes

DateOfBirth

Employees' Date Of Birth

Date

N/A

Yes

Department Description

Department Description

String

50

Yes

DepartmentId

Department Identification

String

10

Yes

Department

Department

String

60

Yes

DisplayName

Display Name

String

250

Yes

DistrictCode

District Code

String

50

Yes

EffectiveDate

Effective Date

Date

N/A

Yes

EltLeader

ELT Leader

String

250

Yes

EmailAddress

Email Address

String

128

Yes

EmailGroupLocation

Email Group Location

String

50

Yes

EmployeeStatusCode

Employee Status Code

String

1

Yes

EmployeeType

Employee Type

String

50

Yes

FileNumber

File Number

String

50

Yes

FirstName

Employees' First name

String

50

Yes

FullLegalName

Employees' Full Legal Name

String

250

Yes

FullTimePartTime Description

Full-Time/Part-Time Description

String

10

Yes

FullTimePart TimeIndicator

Full-Time/Part-Time Indicator

String

2

Yes

Gender

Gender

String

1

Yes

HireDate

Employee Hire Date

Date

N/A

Yes

HomeCountry

Home Country

String

3

Yes

HomeDepartmentId

Home Department Identification

String

10

Yes

HomePhone

Home Contact Number

String

50

Yes

IsContractor

Is Employee a Contractor?

String

2

Yes

IsManager

Is Employee a Manager?

String

2

Yes

IsRescind

Is Employee Rescinded?

String

2

Yes

JobCode

Employee Job Code

String

8

Yes

JobFamily

Employee Job Family

String

50

Yes

JobFunction

Job Function

String

50

Yes

JobTitle

Job Title

String

64

Yes

LastName

Employees' Last Name

String

64

Yes

LocationDescription

Location Description

String

64

Yes

LocationId

Location Id

String

5

Yes

ManagerLevel

Manager Level

String

50

Yes

ManagerName

Manager Name

String

250

Yes

MiddleName

Employees' Middle Name

String

50

Yes

NameSuffix

Name Suffix

String

50

Yes

NextEvaluationDate

Next Evaluation Date

Date

N/A

Yes

NumberOfDirectReports

Number Of Direct Reports

String

10

Yes

PayGroupCode

Pay Group Code

String

50

Yes

PersonalEmail

Employees' Personal Email

String

128

Yes

PositionEffectiveDate

Position Effective Date

Date

N/A

Yes

PositionId

Position Id

String

50

Yes

PreferredFirstName

Preferred First Name

String

50

Yes

PreferredName

Preferred Name

String

250

Yes

RegularTempIndicator

Regular/Temporary Indicator

Boolean

1

Yes

RehireDate

Re-hire Date

Date

N/A

Yes

Reporting CompanyName

Reporting Company Name

String

50

Yes

ReportingLocationId

Reporting Location Identification

String

50

Yes

Reporting LocationDescription

Reporting Location Description

String

50

Yes

ReportsToId

Reports To Identification

String

50

Yes

SapCostCenter

SAP Cost Center

String

50

Yes

SapCompanyCode

SAP Company Code

String

5

Yes

SamAccountName

Sam Account Name

String

10

Yes

SltDesignation

Slt Designation

String

100

Yes

StandardHours

Standard Hours

String

50

Yes

Region

Region

String

50

Yes

StateCode

State Code

String

2

Yes

Street1

Street1

String

50

Yes

Street2

Street2

String

50

Yes

SupervisorId

Supervisor Identification

String

11

Yes

TerminationDate

Employee Termination Date

Date

N/A

Yes

TerritoryStartDate

Territory Start Date

Date

N/A

Yes

UID

User Identification

String

10

Yes

UserName

User Name

String

10

Yes

UserPrimary HomeAddrAsWorkAddr

Employees' Primary Home Address As Work Address

String

1

Yes

VendorName

Vendor Name

String

80

Yes

VendorNumber

Vendor Number

String

50

Yes

WorkCity

Work City

String

50

Yes

WorkCountry

Work Country

String

3

Yes

WorkPhone

Work Phone

String

50

Yes

WorkStateCode

Work State Code

String

2

Yes

WorkStreet1

Work Street1

String

50

Yes

WorkStreet2

WorkStreet2

String

50

Yes

WorkZip

Work Zip code

String

12

Yes

Zip

Employee Zip code

String

12

Yes