[Home] [Help] [Dependency Information]
Object Name: | AMW_CERT_DASHBOARD_SUM |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.AMW_CERT_DASHBOARD_SUM |
Subobject Name: | |
Status: | VALID |
This is a denormalized table for certification dashboard. It stores the certification overall information.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMW_CERT_DASHBOARD_SUM_U1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CERTIFICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CERTIFICATION_ID | NUMBER | Yes | Certification identifier. | |
NEW_PROCESSES_ADDED | NUMBER | Number of global processes added. | ||
PROCESSES_REMOVED | NUMBER | Number of global processes removed. | ||
PROCESSES_CHANGED | NUMBER | Number of global processes changed. | ||
NEW_ORG_PROCESSES_ADDED | NUMBER | Number of organization processes added. | ||
ORG_PROCESSES_REMOVED | NUMBER | Number of organization processes removed. | ||
ORG_PROCESSES_CHANGED | NUMBER | Number of organization processes changed. | ||
NEW_RISKS_ADDED | NUMBER | Number of risks added. | ||
RISKS_REMOVED | NUMBER | Number of risks removed. | ||
RISKS_CHANGED | NUMBER | Number of risks changed. | ||
RISKS_WITH_NO_CONTROLS | NUMBER | Number of risks with no controls. | ||
NEW_CONTROLS_ADDED | NUMBER | Number of controls added. | ||
CONTROLS_REMOVED | NUMBER | Number of controls removed. | ||
CONTROLS_CHANGED | NUMBER | Number of controls changed. | ||
PROCESSES_NOT_CERT | NUMBER | Number of global processes not certified. | ||
PROCESSES_CERT_ISSUES | NUMBER | Number of global processes certified with issues. | ||
ORG_PROCESS_NOT_CERT | NUMBER | Number of organization processes not certified. | ||
ORG_PROCESS_CERT_ISSUES | NUMBER | Number of organization processes certified with issues. | ||
PROC_INEFF_CONTROL | NUMBER | Number of global processes with ineffective controls. | ||
ORG_PROC_INEFF_CONTROL | NUMBER | Number of organization processes with ineffective controls. | ||
UNMITIGATED_RISKS | NUMBER | Number of unmitigated risks. | ||
INEFFECTIVE_CONTROLS | NUMBER | Number of ineffective controls. | ||
CREATED_BY | NUMBER | Yes | Standard who column. | |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column. | |
SECURITY_GROUP_ID | NUMBER | Used for hosting environments. | ||
OBJECT_VERSION_NUMBER | NUMBER | Object version number for locking. | ||
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (30) | Original system reference. | |
ORGS_IN_SCOPE | NUMBER | Number of organizations in certification scope. | ||
ORGS_PENDING_IN_SCOPE | NUMBER | Number of organizations not certified. | ||
PERIOD_START_DATE | DATE | Period start date. | ||
ORG_CERT_ISSUES | NUMBER | organization certified with issues | ||
ORG_INEFFECTIVE | NUMBER | organizations are evaluated as ineffective | ||
ORGS_PENDING_CERTIFICATION | NUMBER | organizations haven't been certified yet |
Cut, paste (and edit) the following text to query this object:
SELECT CERTIFICATION_ID
, NEW_PROCESSES_ADDED
, PROCESSES_REMOVED
, PROCESSES_CHANGED
, NEW_ORG_PROCESSES_ADDED
, ORG_PROCESSES_REMOVED
, ORG_PROCESSES_CHANGED
, NEW_RISKS_ADDED
, RISKS_REMOVED
, RISKS_CHANGED
, RISKS_WITH_NO_CONTROLS
, NEW_CONTROLS_ADDED
, CONTROLS_REMOVED
, CONTROLS_CHANGED
, PROCESSES_NOT_CERT
, PROCESSES_CERT_ISSUES
, ORG_PROCESS_NOT_CERT
, ORG_PROCESS_CERT_ISSUES
, PROC_INEFF_CONTROL
, ORG_PROC_INEFF_CONTROL
, UNMITIGATED_RISKS
, INEFFECTIVE_CONTROLS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, ORIG_SYSTEM_REFERENCE
, ORGS_IN_SCOPE
, ORGS_PENDING_IN_SCOPE
, PERIOD_START_DATE
, ORG_CERT_ISSUES
, ORG_INEFFECTIVE
, ORGS_PENDING_CERTIFICATION
FROM AMW.AMW_CERT_DASHBOARD_SUM;
AMW.AMW_CERT_DASHBOARD_SUM does not reference any database object
AMW.AMW_CERT_DASHBOARD_SUM is referenced by following:
|
|
|