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

Ignore - not used

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

Employee other ID 1-No Used-Max characters 50

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

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.

Email 4 - Max size 60 Characters-Not Used

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

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

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

Ignore not used- Routing Number, max size 24 characters

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

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

Job Title assigned to an employee. Max 100 characters

Employee Zip Code 2- Max 4 characters-Not used

Employee First Name- Max 30 characters

Employee original hire date - previous date of service- in case an employee was rehired. Format YYYY-MM-DD. Max 10 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

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

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

Employee Zip Code- Max 7 characters-not used

Employee State-max size 200 characters

 ​Employee's middle initial. Max 1 character.

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

Email 3 - Max size 60 Characters-Not Used

Account Number, Max size 70 characters

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

Employee Email Address 1 (Main Email) - Max size 60 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 Last Name - Max 35 characters

Fax Number - Max size 20 Characters

Employee Other ID 2 - No Used- Max 50 characters

Notes on an Employee record. Max 255 characters

Address 2 - Max size 100 Characters

Active Status. Value Y for Active and N for Inactive.

Email 2 - Max size 60 Characters- Not Used

Address 1 - Max size 100 Characters

Not used ignore- Payment Type - Max size 1 character

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

Employee Country-not used- Max size 3 characters

Phone Number 2 - Max size 20 Characters

Labor GL Account-Max 20 characters- Not Used

Phone Number - Max size 20 Characters

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

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

Account Type, Max 1 character

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

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

Employee city- not used- max size 100 characters