FFS_USER_LOG
Stores a modification history for the corresponding parent table.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_USER_LOG_PK |
LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOG_ID | NUMBER | 10 | Yes | Unique identifier of the user log record. | |
| LOG_USER_ID | NUMBER | 18 | Yes | User's log record user identifier who made chnages to user. Reference to ffs_user.uid. | |
| ACTION_ID | NUMBER | 19 | Yes | User's log record action identifier. Reference to action log. | |
| USER_ID | NUMBER | 18 | Yes | User's log record updated user ID . Reference to ffs_user.uid. | |
| REALM | VARCHAR2 | 11 | User's log record realm in Oracle Field Service. | ||
| UNAME | VARCHAR2 | 1020 | User's log record updated user name. | ||
| ULOGIN | VARCHAR2 | 1020 | User's log record updated user login. | ||
| SUSTATUS | VARCHAR2 | 8 | User's log record updated user staus. | ||
| LANGUAGE_ID | NUMBER | 3 | Yes | User's log record updated user language. Reference to language.language_id. | |
| REFRESH_RATE | NUMBER | 3 | User's log record updated user refresh rate. | ||
| TIME_FORMAT_ID | NUMBER | 10 | Yes | User's log record updated user time format. | |
| DATE_FORMAT_ID | NUMBER | 10 | Yes | User's log record updated user date format. | |
| LONG_DATE_FORMAT_ID | NUMBER | 10 | Yes | User's log record updated user long date format. | |
| TIME_ZONE_ID | NUMBER | 3 | Yes | User's log record updated user time zone. Reference to ffs_time_zones.time_zone_id. | |
| USER_TYPE_ID | NUMBER | 5 | Yes | User's log record updated user user type . Reference to ffs_catalog_user_type.type_id. | |
| LOGIN_ATTEMPTS | NUMBER | 10 | Yes | User's log record updated user amount of failed login attempts. | |
| LOGIN_BLOCKED_TO | TIMESTAMP | User's log record updated user 'Block' flag after failed login attempts. | |||
| LAST_LOGIN | TIMESTAMP | User's log record updated user last login timestamp. | |||
| LAST_PASSWORD_CHANGE | TIMESTAMP | User's log record updated user last password update timestamp. | |||
| MOBILE_RESOURCE_COUNT | NUMBER | 10 | User's log record updated user count of Resources on the Mobility Application screens (the rest will be under More button). | ||
| MOBILE_ACTIVITY_COUNT | NUMBER | 10 | User's log record updated user count of Activities on the Mobility Application screens (the rest will be under More button). | ||
| MOBILE_INVENTORY_COUNT | NUMBER | 10 | User's log record updated user count of Inventories on the Mobility Application screens (the rest will be under More button). | ||
| SUACTIONS_LINKS_NUM | NUMBER | 10 | User's log record updated user count of Action Links on the Mobility Application screens (the rest will be under More button). | ||
| SUWEEK_START | NUMBER | 3 | User's log record updated user work week start ('Monday','Sunday'). | ||
| SUOPTIONS | NUMBER | 3 | Yes | User's log record updated user options . | |
| SUCREATED | TIMESTAMP | User's log record updated user creation timestamp. | |||
| SUUPDATED | TIMESTAMP | Yes | User's log record updated user last update timestamp. | ||
| SOCIALNET_NEW_MESSAGE | NUMBER | 10 | Yes | Deprecated. Will be removed soon. | |
| DEFAULT_EXPORT_FORMAT | VARCHAR2 | 1020 | User's log record updated user default export file format. | ||
| MAIN_RESOURCE_ID | NUMBER | 8 | User's log record updated user 'main' resource for this user/technician. User can have access to several resources. Contains a reference to ffs_resource.resource_id. Used by Collaboration to identify message's recipient/sender. | ||
| DESIGN_THEME | VARCHAR2 | 1020 | User's log record updated user design theme. | ||
| ALLOW_VIBRATION | NUMBER | 3 | Yes | User's log record updated user flag to allow vibration in Mobility Application. | |
| ALLOW_DESKTOP_NOTIFICATIONS | NUMBER | 3 | Yes | User's log record updated user flag to allow desktop notifications in Mobility Application. | |
| SOUND_THEME | NUMBER | 3 | Yes | User's log record updated user Mobility Application selected sound theme. | |
| AVATAR | VARCHAR2 | 1020 | User's log record updated user image(avatar). | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_USER_LOG_N1 | Non Unique | DATA | USER_ID, LAST_LOGIN |
| FFS_USER_LOG_PK | Unique | DATA | LOG_ID |