FFS_ACTIVITY_TMPL_LOG
Used to store modification history for shift/mass/repeating activities.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_ACTIVITY_TMPL_LOG_PK |
LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOG_ID | NUMBER | 19 | Yes | Unique identifier of the log record. | |
| ACTION_ID | NUMBER | 19 | Unique identifier of the corresponding action. | ||
| TEMPLATE_ID | NUMBER | 8 | Yes | Unique identifier of this repeating/mass/shift activity log. | |
| USER_ID | NUMBER | 18 | Identifier of the user who created this activity template. | ||
| CREATED | TIMESTAMP | Time when the activity was created. | |||
| PARENT_TEMPLATE_ID | NUMBER | 8 | Reference to an previous activity template log record. | ||
| MASTER_TEMPLATE_ID | NUMBER | 8 | Yes | It is a 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 log belongs. | ||
| TYPE_ID | NUMBER | 5 | Reference to Activity template log Work Type List. | ||
| WORK_ZONE_ID | NUMBER | 8 | Activity template log 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 log duration in minutes. Fills with actual duration after activity start. | ||
| TIME_SLOT_ID | NUMBER | 5 | Reference to time slot during which the activity template log 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 log 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 log 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 log in the origin system. The value can be empty. | ||
| CUSTOMER_NUMBER | VARCHAR2 | 160 | Activity template log 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 log 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 log 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 log city of the customer where the activity is scheduled. Maximum field length is 60. | ||
| POSTAL_CODE | VARCHAR2 | 240 | Activity template log ZIP code of the customer where the activity is scheduled. | ||
| STATE_PROVINCE | VARCHAR2 | 240 | Activity template log state of the customer where the activity is scheduled. Maximum field length is 60. | ||
| CUSTOMER_PHONE | VARCHAR2 | 960 | Activity template log regular (land) phone number of the customer. . Encrypted. | ||
| CUSTOMER_EMAIL | VARCHAR2 | 1280 | Activity template log email address of the customer. Maximum field length is 320.Encrypted. | ||
| CUSTOMER_CELL | VARCHAR2 | 960 | Activity template log cell phone number of the customer. Encrypted. | ||
| LANGUAGE_ID | NUMBER | 3 | Yes | Activity template log language. Reference to Language.Lid. | |
| REMINDER_TIME | NUMBER | 5 | Number of minutes before the activity template log start time the customer must be notified of the activity. | ||
| TIME_ZONE_ID | NUMBER | 3 | Activity template log Time Zone. Reference to Time_Zone.Zid. | ||
| TRAVEL_AREA_ID | NUMBER | 8 | Reference to Travel Area to which actvity template log activity work zone is assigned. | ||
| TRAVEL_KEY | VARCHAR2 | 200 | Activity template log travel key. Fills automatically based on Travel key field set on Business Rules screen. | ||
| DURATION_KEY | VARCHAR2 | 200 | Activity template log duration key. Fills automatically based on Duration key field set on Business Rules screen. | ||
| COORD_STATUS | VARCHAR2 | 9 | Activity template log coordinates found staues: 'Is Found', 'Not_Found'. | ||
| COORD_ACCURACY | NUMBER | 3 | Yes | Activity template log 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 log. | ||
| COORD_Y | NUMBER | 8 | Geographic coordinates that specify the location of the activity template log. | ||
| 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 | Activity template repeating/mass activity recurrence. | ||
| 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 log 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 log is currently assigned. | |||
| FEATURES | NUMBER | 10 | Bitmask field that defines active features for this activity template log. 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 log. | ||
| TIME_OF_BOOKING | TIMESTAMP | Time when the customer booked the activity template log. 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_ACTIVITY_TMPL_LOG_N1 | Non Unique | DATA | TEMPLATE_ID |
| FFS_ACTIVITY_TMPL_LOG_PK | Unique | DATA | LOG_ID |