EXM_PREFERENCES
This table contains the session preferences of expense entry users.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EXM_PREFERENCES_PK |
PREFERENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PREFERENCE_ID | NUMBER | 18 | Yes | Unique identifier of a person's preferences. | |
| MOBILE_PHONE_NUMBER | VARCHAR2 | 60 | Stores the mobile phone number provided by the user for sending SMS text notifications. | ||
| SMS_NOTIFICATIONS_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether SMS text notifications are enabled for the user. | ||
| COMMUTE_TO_ADDRESS | VARCHAR2 | 4000 | Stores the last used work address provided by the user for calculating commute distance. | ||
| COMMUTE_FROM_ADDRESS | VARCHAR2 | 4000 | Stores the last used home address provided by the user for calculating commute distance. | ||
| APPROVER_FLAG | VARCHAR2 | 1 | Indicates whether a person has received requests to approve expense reports, cash advance requests, or both. | ||
| PERSON_ID | NUMBER | 18 | Yes | Identifier of the person whose preferences are stored. | |
| APPROVER_ID | NUMBER | 18 | Not currently used. | ||
| EXPENSE_TEMPLATE_ID | NUMBER | 18 | Identifier of the last used expense template. | ||
| PURPOSE | VARCHAR2 | 240 | Not currently used. | ||
| SOURCE | VARCHAR2 | 30 | Not currently used. | ||
| LOCATION_ID | NUMBER | 18 | Identifier of the last used expense location. | ||
| VEHICLE_CATEGORY | VARCHAR2 | 30 | Default vehicle category for a mileage expense. | ||
| VEHICLE_TYPE | VARCHAR2 | 30 | Default vehicle type for a mileage expense. | ||
| FUEL_TYPE | VARCHAR2 | 30 | Default fuel type for a mileage expense. | ||
| TIME_FORMAT | VARCHAR2 | 30 | Not currently used. | ||
| DEFAULT_EXCHANGE_RATE_FLAG | VARCHAR2 | 1 | Not currently used. | ||
| ENABLE_ALLOCATIONS_FLAG | VARCHAR2 | 1 | Not currently used. | ||
| REPORT_CREATION_CODE | VARCHAR2 | 30 | When expense reports are automatically created from trips by the application. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| EXPENSE_START_DATE | DATE | Start date of the last expense item created. | |||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Receipt currency of the last expense item created. | ||
| EXCHANGE_RATE | NUMBER | Not currently used. | |||
| EXPENSE_LOCATION | VARCHAR2 | 80 | Expense location that was used in the last expense report. | ||
| VALIDATE_FLAG | VARCHAR2 | 1 | Indicator of whether an expense item is validated on saving the item. | ||
| REIMBURSEMENT_CURRENCY_CODE | VARCHAR2 | 15 | Reimbursement currency used for the last expense report created. | ||
| LAST_EXP_WORKAREA_VISIT_DATE | TIMESTAMP | Date and time of the user's last visit to the Expenses work area. | |||
| AUTO_SUBMIT_FLAG | VARCHAR2 | 1 | Indicates if the AUTO SUBMIT job should pick up the user's expenses for report creation. The value can be set at user level. The column will have a null value by default and null is treated as Y. If the value is null or Y, autosubmit will pickup expenses for the user, else it would not. | ||
| COMMUTE_DISTANCE | NUMBER | Last calculated commute distance based on addresses entered by employee. | |||
| TERMS_AGREEMENT_DATE | DATE | Date when the user agreed to the terms and conditions for using Expenses. | |||
| ONBOARDING_STATUS_CODE | VARCHAR2 | 30 | Code that identifies the onboarding status of the user. | ||
| AUTO_SUBMIT_RUN_DAY_CODE | VARCHAR2 | 30 | Code that identifies the day of the week when the auto submit process runs for the user. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| EXM_PREFERENCES | exm_expense_templates | EXPENSE_TEMPLATE_ID |
| EXM_PREFERENCES | per_persons | PERSON_ID |
| EXM_PREFERENCES | per_persons | APPROVER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_PREFERENCES_PK | Unique | Default | PREFERENCE_ID |
| EXM_PREFERENCES_U1 | Unique | Default | PERSON_ID |
| EXM_PREFERENCES_U2 | Unique | Default | PREFERENCE_ID, PERSON_ID |