XM_EXT_USER

Entity Name XM_EXT_USER
Entity Type Independent
Definition This table identifies each user in the extensity application.

Attributes

Attribute Datatype Width Definition
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