eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AMW.AMW_PROC_CERT_EVAL_SUM

Object Details

Object Name:	AMW_PROC_CERT_EVAL_SUM
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_PROC_CERT_EVAL_SUM
Subobject Name:
Status:	VALID

This is a denormalized table for process evaluation summary. It stores the certification and evaluation information for each process in certification scope.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_PROC_CERT_EVAL_SUM_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CERTIFICATION_ID ORGANIZATION_ID PROCESS_ID
AMW_PROC_CERT_EVAL_SUM_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID PROCESS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CERTIFICATION_ID	NUMBER		Yes	Certification identifier.
PROCESS_ID	NUMBER		Yes	Process identifier.
ORGANIZATION_ID	NUMBER		Yes	Organization identifier.
SUB_PROCESS_CERT	NUMBER			Number of sub processes certified.
TOTAL_SUB_PROCESS_CERT	NUMBER			Number of sub processes.
ORG_PROCESS_CERT	NUMBER			Number of organizations where the global process is certified.
TOTAL_ORG_PROCESS_CERT	NUMBER			Number of organizations where the global process exists.
UNMITIGATED_RISKS	NUMBER			Number of unmitigated risks associated to the process.
INEFFECTIVE_CONTROLS	NUMBER			Number of ineffective controls associated to the process.
OPEN_FINDINGS	NUMBER			Number of findings associated to the process.
OPEN_ISSUES	NUMBER			Number of issues associated to the process.
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.
GLOBAL_PROCESS	VARCHAR2	(15)		Flag to indicate if the process is a global process.
CERTIFICATION_OPINION_ID	NUMBER			Opinion identifier of the certification result.
EVALUATION_OPINION_ID	NUMBER			Opinion identifier of the last evaluation result.
SUB_PROCS_CERTIFIED_PRCNT	NUMBER			Percentage of the sub processes certified.
ORG_PROCS_CERTIFIED_PRCNT	NUMBER			Percentage of the organizations where the global process is certified.
UNMITIGATED_RISKS_PRCNT	NUMBER			Percentage of unmitigated risks.
INEFFECTIVE_CONTROLS_PRCNT	NUMBER			Percentage of ineffective controls.
EVALUATED_RISKS	NUMBER			Number of risks that are evaluated
TOTAL_RISKS	NUMBER			Total number of risks
EVALUATED_CONTROLS	VARCHAR2	(240)		Number of evaluated controls
TOTAL_CONTROLS	NUMBER			Total number of controls
EVALUATION_OPINION_LOG_ID	NUMBER			opinion log id for the evaluation
PROCESS_ORG_REV_ID	NUMBER			Process revision identifier.
SUB_PROCESS_CERT_ISSUES	NUMBER			Number of sub processes that are certified with issues
ORG_PROCESS_CERT_ISSUES	NUMBER			number of organization process that are certified with issues

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CERTIFICATION_ID
,      PROCESS_ID
,      ORGANIZATION_ID
,      SUB_PROCESS_CERT
,      TOTAL_SUB_PROCESS_CERT
,      ORG_PROCESS_CERT
,      TOTAL_ORG_PROCESS_CERT
,      UNMITIGATED_RISKS
,      INEFFECTIVE_CONTROLS
,      OPEN_FINDINGS
,      OPEN_ISSUES
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      ORIG_SYSTEM_REFERENCE
,      GLOBAL_PROCESS
,      CERTIFICATION_OPINION_ID
,      EVALUATION_OPINION_ID
,      SUB_PROCS_CERTIFIED_PRCNT
,      ORG_PROCS_CERTIFIED_PRCNT
,      UNMITIGATED_RISKS_PRCNT
,      INEFFECTIVE_CONTROLS_PRCNT
,      EVALUATED_RISKS
,      TOTAL_RISKS
,      EVALUATED_CONTROLS
,      TOTAL_CONTROLS
,      EVALUATION_OPINION_LOG_ID
,      PROCESS_ORG_REV_ID
,      SUB_PROCESS_CERT_ISSUES
,      ORG_PROCESS_CERT_ISSUES
FROM AMW.AMW_PROC_CERT_EVAL_SUM;

Dependencies

[top of page]

AMW.AMW_PROC_CERT_EVAL_SUM does not reference any database object

AMW.AMW_PROC_CERT_EVAL_SUM is referenced by following:

APPS: AMW_PROC_CERT_EVAL_SUM