1. Tables and Views for Sales, Fusion Service, and Field Service
  2. FFS_USER

FFS_USER

Contains all users registered in the system.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_USER_PK

USER_ID

Columns

Name Datatype Length Precision Not-null Comments
USER_ID NUMBER 18 Yes Unique identifier for the user created in the system.
PIN_HASH VARCHAR2 512 PIN hash based on random salt. Used for encryption on Mobility.
STATUS VARCHAR2 8 User's account status. Allowed Values: ( 'active', 'inactive','deleted' ).
LANGUAGE_ID NUMBER 3 Yes User language. F.K. language.lid.
REFRESH_RATE NUMBER 3 Refresh rate of appointments grid in mins.
TIME_FORMAT_ID NUMBER 10 Yes User's account time format . Allowed Values: ( '12-hour', '24-hour' ).
DATE_FORMAT_ID NUMBER 10 Yes User's account date format . Allowed Values: Allowed Values: ('dd/mm/yy', 'mm/dd/yy','dd.mm.yy','yyyy/mm/dd').
LONG_DATE_FORMAT_ID NUMBER 10 Yes User's account long date format .
TIME_ZONE_ID NUMBER 3 Unique identifier for the time zone created in the system.
USER_TYPE_ID NUMBER 5 Reference to the user type ID -> FFS_UTYPE->TYPE_ID.
LOGIN_ATTEMPTS NUMBER 10 Store number of serial failed logins.
LOGIN_BLOCKED_TO TIMESTAMP User login block time. (When number of serial failed logins exceed company->max_login_attempts).
LAST_LOGIN TIMESTAMP Last Value of the Login Date and Time.
MOBILE_RESOURCE_COUNT NUMBER 10 User's amount of resouces showed in Mobile application without pressing 'More' button.
MOBILE_ACTIVITY_COUNT NUMBER 10 User's amount of activities showed in Mobile application without pressing 'More' button.
MOBILE_INVENTORY_COUNT NUMBER 10 User's amount of inventory showed in Mobile application wothout pressing 'More' button.
ACTIONS_LINKS_NUM NUMBER 10 Yes Number of action displaing on appointment grid.
WEEK_START NUMBER 3 Yes User's week start day ('Monday','Sunday').
OPTIONS NUMBER 3 Yes User's options based on selected resource type.
CREATED TIMESTAMP User's creation time in GMT time zone.
UPDATED TIMESTAMP Yes User's last update time in GMT time zone.
SOCIALNET_NEW_MESSAGE NUMBER 10 Yes Deprecated. Will be removed soon.
PENDING_SURVEYS NUMBER 10 Yes Surveys functionality will be deprecated soon.
OVERDUE_SURVEYS NUMBER 10 Yes Surveys functionality will be deprecated soon.
DEFAULT_EXPORT_FORMAT VARCHAR2 1020 It is a default format of a result file for exporting operations.
MAIN_RESOURCE_ID NUMBER 8 Identifier of the 'main' resource for this user/technician.
DESIGN_THEME NUMBER 10 User's selected Mobile application design theme.
ALLOW_VIBRATION NUMBER 3 Yes Allow user's Mobile application to vibrate upon receiving updates.
ALLOW_DESKTOP_NOTIFICATIONS NUMBER 3 Yes Allow user's Mobile application to show desktop notifications upon receiving updates.
SOUND_THEME NUMBER 3 Yes User's sound upon receving new nofications in Mobile application..
AVATAR VARCHAR2 1020 Graphical representation of the user.
ORGANIZATION_UNIT_ID NUMBER 8 Associated resource ID to calculate OrganizationID if user hasn't got main_resource_id.
COLOR VARCHAR2 6 User's Mobile Application selected color.
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_PK Unique DATA USER_ID