​Employee ID-Max size 20 characters. Unique and primary identifier of an employee record. Hardcoded once saved.

Department ID tied to an employee. Max 20 characters. A valid Department ID must exist in the Department table

Employee First Name- Max 30 characters

Employee's reimbursement currency ID,- Max size 10 characters- a valid currency ID must exist in the currency table

Employee Other ID 2 - No Used- Max 50 characters

Account Type, Max 1 character - Currently unused

Entry Type- defines user's access to time/expense modules - Values: 'T'- Time, 'E'- Expense, ''B'- Both Time and Expense, 'X'- No entry allowed, 'N' No entry required.

Employee Zip Code 2- Max 4 characters-Not used

Employee original hire date - previous date of service- in case an employee was rehired. Format YYYY-MM-DD. Max 10 characters

Employee city- not used- max size 100 characters

Address 1 - Max size 100 Characters

Email 4 - Max size 60 Characters-Not Used

Ignore not used- Routing Number, max size 24 characters

 ​Employee Type ID associated with an employee. Max size 20 characters. A valid Employee Type ID must exist in the EmployeeType table.

T&E Access Rights ID assigned to an employee. Max 20 characters. A valid ID must exist in the TeSecurityRoleGrp table

Phone Number 2 - Max size 20 Characters

Indicates if a user is an admin - Default should be only N-not an admin. Y indicates a user has some kind of Admin rights assigned under roles

Employee State-max size 200 characters

Job Title assigned to an employee. Max 100 characters

Employee hire date- Format YYYY-MM-DD, Max 10 characters

Record last update date- format YYYY-MM-DD. Max 10 characters- not used

Employee Email Address 1 (Main Email) - Max size 60 Characters

Time Zone ID - the default is set as America/New_York. Check for the additional values

Login Type. Values: S - SAML SSO L - For DATABASICS Login Authentication (Default) B - DATABASICS SSO (DBSSO) D - DATABASICS Login with Dual Factor Authentication

Typically used to define an alternate ID of an employee - Max size 20 characters

Not used ignore- Payment Type - Max size one character - - Currently unused and defaulted to 'M'

Role Number. Filter field to search employees belonging to a specific role by ID

Address 2 - Max size 100 Characters

 ​Employee's middle initial. Max 1 character.

Employee Country-not used- Max size 3 characters, default USA

Employee part time flag. Values: 'P'- Part Time and 'F' for Full Time

Account Number, Max size 70 characters - Currently unused

Fax Number - Max size 20 Characters

Location ID assigned to an employee- Max size 20 Characters. A valid Location ID must exist in the Location table

Employee Zip Code- Max 7 characters-not used

Operation Unit ID assigned to an employee - Max size is 20 Characters. A valid OptCode must exist in the OpUnit table

Email 3 - Max size 60 Characters-Not Used

Phone Number - Max size 20 Characters

Notes on an Employee record. Max 255 characters

Employee Last Name - Max 35 characters

Employee Termination Date, format YYYY-MM-DD. -Max size 10 characters

Labor GL Account-Max 20 characters- Not Used

Employee's Function ID, Max 20 characters. A valid Function ID must exist in the Function table

Vendor ID assigned to an employee - Max size 20 Characters- A valid vendor ID must exist in the Vendor table

Login Id assigned to an employee- Max 30 characters- must be unique

Timesheet Reporting Period ID assigned to an employee- Max 20 characters. A valid reporting period ID must exist in the TimeReportingType table.

Employee Exempt/Non Exempt flag. - Values: 'Y' for Exempt and 'N' for Not Exempt

Employee other ID 1-No Used-Max characters 50

Email 2 - Max size 60 Characters- Not Used

Employee hire date from - Format YYYY-MM-DD, Max 10 characters

Employee hire date to - Format YYYY-MM-DD, Max 10 characters

Employee end date from - Format YYYY-MM-DD, Max 10 characters

Employee end date to - Format YYYY-MM-DD, Max 10 characters