FFS_ACTIVITY_TMPL
Contains shift, mass, and repeating activities.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_ACTIVITY_TMPL_PK |
TEMPLATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | 8 | Yes | Unique identifier of this repeating/mass/shift activity. | |
| USER_ID | NUMBER | 18 | Identifier of the user who created this activity template. | ||
| CREATED | TIMESTAMP | Activity template creation date. | |||
| PARENT_TEMPLATE_ID | NUMBER | 8 | Reference to an previous template record. | ||
| MASTER_TEMPLATE_ID | NUMBER | 8 | Yes | Reference to an initial template record. | |
| TEAM_RESOURCE_ID | NUMBER | 8 | Activity Team holder resource reference. Used for teamwork activities. | ||
| SHIFT_ID | NUMBER | 8 | Reference to shift which activity template belongs. | ||
| TYPE_ID | NUMBER | 5 | Reference to Activity template Work Type List. | ||
| WORK_ZONE_ID | NUMBER | 8 | Activity template work zone reference . It is a read-only field that is automatically assigned to an activity, based on the company setting 'work zone key' and the activity properties. | ||
| DURATION | NUMBER | 5 | Activity template duration in minutes. Fills with actual duration after activity start. | ||
| TIME_SLOT_ID | NUMBER | 5 | Reference to time slot during which the activity template is completed. The time slot also indicates the service window for the activity. This time is displayed in the time zone of the resource to which the activity is assigned. | ||
| SERVICE_WINDOW_START | NUMBER | 5 | Activity template Service window start time. Service window is returned in the time zone of the resource to which the activity is currently assigned. | ||
| SERVICE_WINDOW_END | NUMBER | 5 | Activity template Service window end time. Service window is returned in the time zone of the resource to which the activity is currently assigned. | ||
| ACTIVITY_NUMBER | VARCHAR2 | 160 | Identifier of the activity template in the origin system. The value can be empty. | ||
| CUSTOMER_NUMBER | VARCHAR2 | 160 | Activity template account number of the customer. This field is used by integrations as a placeholder for the external identifier of the Account ID in the application. This parameter has no business significance in Oracle Field Service and can be left empty. Maximum field length is 40. | ||
| CUSTOMER_NAME | VARCHAR2 | 1680 | Activity template name of the customer. Maximum field length is 420.Encrypted. | ||
| LOCATION_ID | NUMBER | 10 | Deprecated. Will be removed soon. | ||
| STREET_ADDRESS | VARCHAR2 | 960 | Activity template street address of the customer. This field is used for geocoding and must contain a valid address. Maximum field length is 240. Encrypted. | ||
| CITY | VARCHAR2 | 240 | Activity template city of the customer where the activity is scheduled. Maximum field length is 60. | ||
| POSTAL_CODE | VARCHAR2 | 240 | Activity template ZIP code of the customer where the activity is scheduled. | ||
| STATE_PROVINCE | VARCHAR2 | 240 | Activity template state of the customer where the activity is scheduled. Maximum field length is 60. | ||
| CUSTOMER_PHONE | VARCHAR2 | 960 | Activity template regular (land) phone number of the customer. . Encrypted. | ||
| CUSTOMER_EMAIL | VARCHAR2 | 1280 | Activity template email address of the customer. Maximum field length is 320.Encrypted. | ||
| CUSTOMER_CELL | VARCHAR2 | 960 | Activity template cell phone number of the customer. Encrypted. | ||
| LANGUAGE_ID | NUMBER | 3 | Yes | Activity template language. Reference to Language.Lid. | |
| REMINDER_TIME | NUMBER | 5 | Yes | Number of minutes before the activity template start time the customer must be notified of the activity. | |
| TIME_ZONE_ID | NUMBER | 3 | Activity template Time Zone. Reference to Time_Zone.Zid. | ||
| COORD_STATUS | VARCHAR2 | 9 | Activity template coordinates found staues: 'Is Found', 'Not_Found'. | ||
| COORD_ACCURACY | NUMBER | 3 | Yes | Activity template accuracy Level Of Geocoding Coordinates Not Valid - -1 Undefined - 0 Country - 1 State - 2 County - 3 City - 4 Zip - 5 Route - 6 Street - 7 Intersection - 8 Address - 9. | |
| COORD_X | NUMBER | 8 | Geographic coordinates that specify the location of the activity template. | ||
| COORD_Y | NUMBER | 8 | Geographic coordinates that specify the location of the activity template. | ||
| OPTIONS | NUMBER | 5 | Bitmask. Set of options defining a behaviour of this activity. | ||
| START_DATE | DATE | Start date this activity takes effect from. | |||
| END_DATE | DATE | Last date until which this activity takes place. Optional. | |||
| RECURRENCE | VARCHAR2 | 6 | Value of this parameter along with the 'Recur Every' parameter defines the time between each recurrence of the assignment (none, daily, weekly). | ||
| WEEKDAYS | NUMBER | 3 | Bitmask. Defines days of week this activity takes place. | ||
| RECUR_EVERY | NUMBER | 3 | Time between each recurrence of the assignment. Depending on the value selected for 'recurrence', the value of the parameter indicates the time between recurrence in days or weeks. | ||
| SLA_START | TIMESTAMP | Time when the service level agreement (SLA) window starts. SLA window is returned in the time zone of the resource to which the activity template is currently assigned. | |||
| SLA_END | TIMESTAMP | Time when the service level agreement (SLA) window ends. The time is displayed in 'YYYY-MM-DD HH:MM:SS' format. SLA window is returned in the time zone of the resource to which the activity template is currently assigned. | |||
| FEATURES | NUMBER | 10 | Bitmask field that defines active features for this activity template. This value is copied from a selected activity type on Create/Update actions. | ||
| POINTS | NUMBER | 5 | Number of Points that represent efforts required to perform this activity template. | ||
| TIME_OF_BOOKING | TIMESTAMP | Time when the customer booked the activity template. The time is displayed in the time zone of the customer. | |||
| 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. | ||
| COORD_VIEWPORT_RADIUS | NUMBER | 6 | Radius of activity location viewport returned by geoprovider in meters. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether the record is logically deleted (Y - soft deleted, N or NULL - active). |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_ACTIVITY_TMPL_N1 | Non Unique | Default | MASTER_TEMPLATE_ID |
| FFS_ACTIVITY_TMPL_N2 | Non Unique | Default | PARENT_TEMPLATE_ID |
| FFS_ACTIVITY_TMPL_PK | Unique | Default | TEMPLATE_ID, ORA_SEED_SET1 |
| FFS_ACTIVITY_TMPL_PK1 | Unique | Default | TEMPLATE_ID, ORA_SEED_SET2 |