SVC_BI_AUDIT_SR_STAGE
Staging table for reading audit data from SVC_SERVICE_REQUESTS_ and populating the BI table SVC_BI_AUDIT_SR. The table is partitioned for performance purposes, with each stage of the process populating a different partition of the table.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_BI_AUDIT_SR_STAGE_PK |
AUDIT_SR_STAGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| AUDIT_SR_STAGE_ID | VARCHAR2 | 256 | Yes | Derived primary key for this table. | ||
| PARTITION_CD | VARCHAR2 | 5 | Identifies the stage of processing the data, and serves as the partition value for the table. | |||
| PROCESS_ID | NUMBER | 18 | Used to sequence SR_ID for purposes of parallel processing of ranges of SRs. For example, if parallel processing 10 SRs, then the first set of SRs would be PROCESS_ID 1 to 10, the next set 11 to 20, etc. | Obsolete | ||
| AUDIT_SR_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.AUDIT_SR_ID. | |||
| SR_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.SR_ID. | |||
| AUDIT_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.AUDIT_SEQ_NO. | |||
| AUDIT_START_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR.AUDIT_START_DATE. | ||||
| AUDIT_END_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR.AUDIT_END_DATE. | ||||
| AUDIT_DURATION_MS | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.AUDIT_DURATION_MS. | |||
| LATEST_AUDIT_FLAG | VARCHAR2 | 1 | Used to stage SVC_BI_AUDIT_SR.LATEST_AUDIT_FLAG. | |||
| AUDIT_HISTORY_COMPLETE_FLAG | VARCHAR2 | 1 | Used to stage SVC_BI_AUDIT_SR.AUDIT_HISTORY_COMPLETE_FLAG. | |||
| AUDIT_PURGE_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR.AUDIT_PURGE_DATE. | ||||
| AUDIT_ACTION_TYPE | VARCHAR2 | 10 | Sourced from SVC_SERVICE_REQUESTS_.AUDIT_ACTION_TYPE_. | |||
| AUDIT_INSERT_UPDATE_FLAG | VARCHAR2 | 1 | Differentiates new audit records (I) from existing audit records (U). | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| LAST_RESOLVED_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR AUDIT_START_DATE and AUDIT_END_DATE. | ||||
| CLOSED_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR AUDIT_START_DATE and AUDIT_END_DATE. | ||||
| STATUS_CD | VARCHAR2 | 30 | Used to stage SVC_BI_AUDIT_SR.STATUS_CD. | |||
| OLD_STATUS_CD | VARCHAR2 | 30 | The previous audited value of STATUS_CD. | |||
| STATUS_TYPE_CD | VARCHAR2 | 30 | Used to stage SVC_BI_AUDIT_SR.STATUS_TYPE_CD. | |||
| OLD_STATUS_TYPE_CD | VARCHAR2 | 30 | The previous audited value of STATUS_TYPE_CD. | |||
| SEVERITY_CD | VARCHAR2 | 30 | Used to stage SVC_BI_AUDIT_SR.SEVERITY_CD. | |||
| OLD_SEVERITY_CD | VARCHAR2 | 30 | The previous audited value of SEVERITY_CD. | |||
| ASSIGNEE_RESOURCE_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.ASSIGNEE_RESOURCE_ID. | |||
| OLD_ASSIGNEE_RESOURCE_ID | NUMBER | 18 | The previous audited value of ASSIGNEE_RESOURCE_ID. | |||
| QUEUE_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.QUEUE_ID. | |||
| OLD_QUEUE_ID | NUMBER | 18 | The previous audited value of QUEUE_ID. | |||
| STATUS_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.STATUS_SEQ_NO. | |||
| STATUS_TYPE_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.STATUS_TYPE_SEQ_NO. | |||
| SEVERITY_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.SEVERITY_SEQ_NO. | |||
| ASSIGNEE_RESOURCE_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.ASSIGNEE_RESOURCE_SEQ_NO. | |||
| QUEUE_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.QUEUE_SEQ_NO. | |||
| BATCH_ID | NUMBER | 10 | Used to group SRs together for parallel processing. The first group of SRs would have BATCH_ID 1, the next group 2, etc. The maximum BATCH_ID would equal the total number of groups to process. | |||
| REOPEN_EVENT_FLAG | VARCHAR2 | 1 | Used to stage SVC_BI_AUDIT_SR.REOPEN_EVENT_FLAG. | |||
| SR_LAST_UPDATE_DATE | TIMESTAMP | Used to stage SVC_BI_AUDIT_SR.SR_LAST_UPDATE_DATE. | ||||
| CAT_PROD_HISTORY_COMPLETE_FLAG | VARCHAR2 | 1 | Used to stage SVC_BI_AUDIT_SR.CAT_PROD_HISTORY_COMPLETE_FLAG. | |||
| CATEGORY_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.CATEGORY_ID. | |||
| OLD_CATEGORY_ID | NUMBER | 18 | The previous audited value of CATEGORY_ID. | |||
| CATEGORY_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.CATEGORY_SEQ_NO. | |||
| PRODUCT_ID | NUMBER | 18 | Used to stage SVC_BI_AUDIT_SR.PRODUCT_ID. | |||
| OLD_PRODUCT_ID | NUMBER | 18 | The previous audited value of PRODUCT_ID. | |||
| PRODUCT_SEQ_NO | NUMBER | 10 | Used to stage SVC_BI_AUDIT_SR.PRODUCT_SEQ_NO. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_BI_AUDIT_SR_STAGE_N1 | Non Unique | Default | SR_ID |
| SVC_BI_AUDIT_SR_STAGE_N2 | Non Unique | Default | BATCH_ID |
| SVC_BI_AUDIT_SR_STAGE_PK | Unique | Default | AUDIT_SR_STAGE_ID |