FFS_VISIT

Contains visits automatically created by the system.

Details

  • Schema: FUSION

  • Object owner: FFS

  • Object type: TABLE

  • Tablespace: DATA

Primary Key

Name Columns

FFS_VISIT_PK

VISIT_ID

Columns

Name Datatype Length Precision Not-null Comments
ARCH_DATE DATE Yes DB record partitioning date. Set automatically by DB Optimization job.
VISIT_ID NUMBER 10 Yes Unique identifier of the visit.
VISIT_DATE DATE Date the visit record belongs to.
VISIT_STATUS VARCHAR2 9 Status of the visit determined based on activities it consists of (pending, started, cancelled, notdone, completed).
VISIT_MASTER_ACTIVITY_ID NUMBER 10 Yes Identifier of the first activity in the visit.
VISIT_OPTIONS NUMBER 3 Bitmask. Set of flags related to messages generated for the visit.
VISIT_RESOURCE_TIME_ZONE_ID NUMBER 3 Time zone automatically determined based on the master activity.
VISIT_CONFIRMED NUMBER 3 Defines if the visit was confirmed by customer.
VISIT_TIME_DELIVERED_START TIMESTAMP Start of the time window delivered to customer.
VISIT_TIME_DELIVERED_END TIMESTAMP End of the time window delivered to customer.
VISIT_KEY VARCHAR2 1020 Visit key calculated based on configured formula.
UPDATE_FLAGS NUMBER 10 Visit update trigger flags. Set automatically after Visit creation.
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_VISIT_N1 Non Unique DATA VISIT_DATE
FFS_VISIT_PK Unique DATA VISIT_ID