SVC_DLM_METRICS
Used for storing information of each job run that will be used in DLM metrics dashboards.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_DLM_METRICS_PK |
METRICS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| METRICS_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| PROCESS_ID | NUMBER | 18 | Yes | Job ID of the scheduled job. | |
| STRIPE_CD | VARCHAR2 | 30 | Yes | Lookup code that indicates the stripe code, such as CRM, HCM, HRHD. | |
| PARENT_ENTITY_NAME | VARCHAR2 | 64 | Yes | Name of object that is impacted, e.g., ServiceRequest, HRHelpDeskRequest, InternalServiceRequest. | |
| CHILD_ENTITY_NAME | VARCHAR2 | 64 | Name of child object that is impacted. | ||
| ACTION_ID | NUMBER | 18 | Yes | Action id from SVC_AP_ACTIONS table. | |
| POLICY_NAME | VARCHAR2 | 400 | Name of the policy. | ||
| OBJECT_ENTITY_TYPE | VARCHAR2 | 64 | Yes | Job definition name. | |
| OPERATION_TYPE | VARCHAR2 | 30 | Column to identify purge, archive and update jobs. | ||
| JOB_STATUS | VARCHAR2 | 30 | Job completion status. | ||
| FAILURE_REASON | VARCHAR2 | 1500 | Job failure reason. | ||
| PREVIEW_FLAG | VARCHAR2 | 1 | Indicates if the job is excuted in preview only mode. | ||
| DATA_ARCHIVAL_FLAG | VARCHAR2 | 1 | Indicates if archival flag is enabled in the policy. | ||
| DISABLED_CUSTOM_LOGIC_FLAG | VARCHAR2 | 1 | Indicates if disable custom logic is enabled or not in the policy. | ||
| EXCLUDE_ATTACH_ARCHIVE_FLAG | VARCHAR2 | 1 | Yes | Indicates if attachments are excluded while archiving data. | |
| PURGE_ONLY_ATTACHMENT_FLAG | VARCHAR2 | 1 | Indicates if purge only attachment Flag is enabled. | ||
| IMPACTED_RECORD_COUNT | NUMBER | 18 | Yes | Number of rows purged, archived or updated. | |
| IMPACTED_ATTACHMENTS_COUNT | NUMBER | 18 | Number of attachments that are impacted. | ||
| IMPACTED_ATTACHMENT_SIZE | NUMBER | 18 | Total size of impacted attachments. | ||
| EXTERNAL_STORAGE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates if external storage is enabled for archival. | ||
| JOB_START_TIME | TIMESTAMP | Time when the Job started running. | |||
| JOB_END_TIME | TIMESTAMP | Time when the job is completed. | |||
| 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 |
|---|---|---|---|
| SVC_DLM_METRICS_N1 | Non Unique | Default | OBJECT_ENTITY_TYPE, OPERATION_TYPE |
| SVC_DLM_METRICS_N10 | Non Unique | Default | JOB_END_TIME |
| SVC_DLM_METRICS_N11 | Non Unique | Default | JOB_STATUS |
| SVC_DLM_METRICS_N12 | Non Unique | Default | PROCESS_ID, STRIPE_CD, PARENT_ENTITY_NAME, CHILD_ENTITY_NAME |
| SVC_DLM_METRICS_N2 | Non Unique | Default | PARENT_ENTITY_NAME |
| SVC_DLM_METRICS_N3 | Non Unique | Default | ACTION_ID, POLICY_NAME |
| SVC_DLM_METRICS_N4 | Non Unique | Default | PREVIEW_FLAG |
| SVC_DLM_METRICS_N5 | Non Unique | Default | PURGE_ONLY_ATTACHMENT_FLAG |
| SVC_DLM_METRICS_N6 | Non Unique | Default | IMPACTED_RECORD_COUNT |
| SVC_DLM_METRICS_N7 | Non Unique | Default | IMPACTED_ATTACHMENTS_COUNT |
| SVC_DLM_METRICS_N8 | Non Unique | Default | IMPACTED_ATTACHMENT_SIZE |
| SVC_DLM_METRICS_N9 | Non Unique | Default | JOB_START_TIME |
| SVC_DLM_METRICS_PK | Unique | Default | METRICS_ID |