FFS_RESOURCE_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_RESOURCE_LOG_PK |
LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LOG_ID | NUMBER | 10 | Yes | Unique identifier of the log record. | |
| ACTION_ID | NUMBER | 19 | Reference to action log identifier. | ||
| USER_ID | NUMBER | 18 | Yes | Reference to user which made changes. | |
| RESOURCE_ID | NUMBER | 8 | Yes | Identifier of the resource the log record is created for. | |
| PACTIVE | VARCHAR2 | 1 | Resource log record resource status flag (active,inactive). | ||
| PARENT | NUMBER | 8 | Yes | F.k. provider.pid. Contains id of the parent provider. If this provider is top provider then parent=0. | |
| EXTERNAL_ID | VARCHAR2 | 128 | External ID (Using via angel.com). Technician number (Charter). | ||
| PTYPE | NUMBER | 10 | Yes | Provider log record provider type. | |
| PCAPACITY_BUCKET | NUMBER | 10 | Yes | Provider log record assigned capacity bucket. | |
| PNAME | VARCHAR2 | 160 | Provider log record Name of reouce in Resource Tree. | ||
| ORGANIZATION_ID | NUMBER | 5 | ID of the organization this resource belongs to. | ||
| PLANGUAGE | NUMBER | 3 | Yes | Provider language. F.k. language.lid. | |
| PTIME_FID | NUMBER | 10 | Yes | Unique identifier of a preferred time format for the resource. | |
| PDATE_FID | NUMBER | 10 | Yes | Unique identifier of a preferred date format for the resource. | |
| TIME_ZONE | NUMBER | 3 | Yes | Provider time zone. F.k. time_zone.zid. | |
| VARCHAR2 | 1020 | Resource log record resource email. | |||
| PPHONE | VARCHAR2 | 64 | Provider log record ground phone. | ||
| CREATED | TIMESTAMP | Resource log record resource creation time. | |||
| UPDATED | TIMESTAMP | Yes | Resource last update time in GMT time zone. | ||
| TRAVEL_KEY | VARCHAR2 | 200 | Resource travel key. Calculated automatically based on configured 'Resource Travel Key' on Business Rules screen. | ||
| PDURATIONKEY | VARCHAR2 | 200 | Resource duration key. Calculated automatically based on configured 'Resource Duration Key' on Business Rules screen. | ||
| PSTARTTIMEKEY | VARCHAR2 | 200 | Resource Start Time key. Calculated automatically based on configured 'Start Time Key' on Business Rules screen. | ||
| P_RPRID | NUMBER | 8 | Provider log record routing profile. | ||
| PFEATURES | NUMBER | 10 | List of features configured for selected resource type. | ||
| PCOLOR | VARCHAR2 | 6 | Resource's color on Resource Tree screen in case of resource incopmliance. | ||
| PINITIAL_RATIO_READ_ONLY | NUMBER | 3 | Initial ratio read only if set, initial ratio for activity duration cannot be modified. | ||
| PINITIAL_RATIO | NUMBER | Yes | Initial ratio for activity duration for new provider. | ||
| SKIP_DAYS_FOR_STATS | NUMBER | 5 | Yes | Skip first n days for learning statistics. | |
| SKIP_DAYS_UPDATED | TIMESTAMP | Last date when skip_days_for_stats was updated. | |||
| 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_RESOURCE_LOG_PK | Unique | DATA | LOG_ID |