| AUTH_AMT | Float | 3 | The amount that the user is authorized to approve. |
| AUTH_AMT_CUR | Varchar | 3 | The three letter ISO code identifying the currency of the auth_amt. |
| BOSS_ID | Integer | 11 | A foreign key for the ext_user table identifying the user's supervisor. |
| CHANGE_TIMESTAMP | DateTime | 23 | |
| COUNTRY_ISO_CODE | Varchar | 2 | The two letter ISO code identifying the user's country. |
| COUNTRY_NAME | Varchar | 16 | The name of the country in which the user is located. |
| CREATION_TIME | DateTime | 23 | The date and time of the password creation. |
| DEFAULT_COST_CENTER_ID | Integer | 11 | A foreign key for the organization table identifying the user's cost center. |
| DEFAULT_CURRENCY | Varchar | 3 | The default currency when the user creates a new Expense report or Travel Plan. |
| EMAIL_ADDRESS | Varchar | 47 | The user's email address. |
| EMPLOYEE_NUMBER | Varchar | 26 | The user's employee number. |
| END_DATE | DateTime | 23 | |
| ER_DEFAULT_PROJECT_ID | Integer | 1 | The default project ID when a user creates a new Expense Report. |
| FIRST_NAME | Varchar | 37 | The user's first name. |
| FULL_NAME | Varchar | 37 | The user's full name. |
| IDENTITY2 | Varchar | 36 | |
| IS_ACTIVE | Integer | 1 | The active status of the user: • 1: Active • 0: Inactive |
| LAST_MODIFIED_TIME | DateTime | 23 | The date and time when the user account is modified. |
| LAST_NAME | Varchar | 37 | The user's last name. |
| LCF_TOTAL_AMT | Float | 6 | The amount of loss carried forward that the employee owes to the company |
| LCF_TOTAL_AMT_CUR | Varchar | 3 | The three letter ISO code identifying the currency of the lcf_total_amt. |
| LOCATION_ID | Integer | 1 | A foreign key for the location table identifying the location of the user's office. |
| LOGIN | Varchar | 47 | The user login credentials for the extensity application. |
| MIDDLE_INITIAL | Varchar | 1 | The user's middle name. |
| OFFICE_NAME | Varchar | 10 | The user's office location. |
| PAYROLL_SYSTEM_CODE | Integer | 3 | The payroll code for each user. For example, ADP. |
| PROXY_CAN_SUBMIT | Integer | 2 | The document submission status of a proxy user. If set to one, a proxy can submit the document. |
| PROXY_REVIEWER_CAN_SUBMIT | Integer | 2 | The document approval or response status of a proxy reviewer. If set to one, the proxy reviewer can approve or respond to a document. |
| PR_AUTH_AMT | Float | 3 | The procurement amount this user is authorized to approve. |
| PR_AUTH_AMT_CUR | Varchar | 3 | The three letter ISO code identifying the currency of pr_auth_amt. |
| SECOND_CURRENCY | Varchar | 3 | The second currency by which expenses can be reimbursed to a user. The default_currency saves the primary reimbursement currency. |
| SET_OF_BOOKS_NAME | Varchar | 17 | Name of the set of books associated with a user. |
| START_DATE | DateTime | 21 | |
| SYSTEM_CODE_1 | Varchar | 5 | A client defined code for the user. |
| SYSTEM_CODE_2 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_CODE_3 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_CODE_4 | Varchar | 25 | A client defined code for the user. |
| SYSTEM_CODE_5 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_CODE_6 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_CODE_7 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_CODE_8 | Varchar | 255 | A client defined code for the user. |
| SYSTEM_DATE_1 | Varchar | 255 | A client defined date for the user. |
| SYSTEM_DATE_2 | Varchar | 255 | A client defined date for the user. |
| TAXPAYER_ID | Varchar | 29 | An identification used for tax purposes. In the United States this VAR- Y CHAR (255) taxpayer_id is the user's social security number. |
| TITLE | Varchar | 76 | The user's title. |
| USER_ID | Integer | 11 | The primary key identifying each unique user in the system. |
| USER_LOCATION | Varchar | 13 | |
| USER_MAILSTOP | Varchar | 10 | The user's mailstop. This company code is used for hand delivered mails. |
| lastModified | DateTime | 24 | |
| VariationID | Integer | 13 | |
| ACTIVE_STATUS | Varchar | 4 | |