DBA Data[Home] [Help] [Dependency Information]

TABLE: AMW.AMW_CERT_DASHBOARD_SUM

Object Details
Object Name: AMW_CERT_DASHBOARD_SUM
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_CERT_DASHBOARD_SUM
Subobject Name:
Status: VALID


This is a denormalized table for certification dashboard. It stores the certification overall information.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_CERT_DASHBOARD_SUM_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCERTIFICATION_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

AMW.AMW_CERT_DASHBOARD_SUM does not reference any database object

AMW.AMW_CERT_DASHBOARD_SUM is referenced by following:

SchemaAPPS
SynonymAMW_CERT_DASHBOARD_SUM