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

TABLE: AMW.AMW_ORG_CERT_EVAL_SUM

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


this is a summary table to store the organization certification detail information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_ORG_CERT_EVAL_SUM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCERTIFICATION_ID
AMW_ORG_CERT_EVAL_SUM_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
CERT_ORG_SUM_ID NUMBER

primary key
CERTIFICATION_ID NUMBER

certification identifier
ORGANIZATION_ID NUMBER

organization id
SUB_ORG_CERT NUMBER

certified sub organization
TOTAL_SUB_ORG NUMBER

total number of sub organizations
PROCESSES_CERTIFIED NUMBER

number of certified processes
TOTAL_PROCESSES NUMBER

total number of processes
EVALUATED_PROCESSES NUMBER

number of evaluated processes
INEFF_PROCESSES NUMBER

processes which are evaluated as ineffective
UNMITIGATED_RISKS NUMBER

risks which are evaluated as unmitigated
EVALUATED_RISKS NUMBER

number of risks which are evaluated
TOTAL_RISKS NUMBER

total number of risks within the current organization certification
INEFFECTIVE_CONTROLS NUMBER

number of controls which are evaluated as ineffective
EVALUATED_CONTROLS NUMBER

number of controls which are evaluated
TOTAL_CONTROLS NUMBER

total number of controls within the current organization certification
OPEN_FINDINGS NUMBER

total number of open findings
OPEN_ISSUES NUMBER

total number of open issues
TOP_ORG_PROCESSES NUMBER

number of top org processes
TOP_ORG_PROC_PENDING_CERT NUMBER

total number of top organization process which are not certified
CERTIFICATION_OPINION_ID NUMBER

opinion id for the certification
EVALUATION_OPINION_ID NUMBER

opinion id for the evaluation
EVALUATION_OPINION_LOG_ID NUMBER

opinion log id for the evalution
CREATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
OBJECT_VERSION_NUMBER NUMBER

Object version number for locking
SUB_ORG_CERT_ISSUES NUMBER

Sub Organizations Certified with Issues
PROC_CERT_ISSUES NUMBER

Processes Certified with Issues
INEFF_PROCESSES_PRCNT NUMBER

percentage of ineffectived processes
UNMITIGATED_RISKS_PRCNT NUMBER

percentage of unmitigated risks
INEFF_CONTROLS_PRCNT NUMBER

percentage of ineffective controls
Query Text

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


SELECT CERT_ORG_SUM_ID
,      CERTIFICATION_ID
,      ORGANIZATION_ID
,      SUB_ORG_CERT
,      TOTAL_SUB_ORG
,      PROCESSES_CERTIFIED
,      TOTAL_PROCESSES
,      EVALUATED_PROCESSES
,      INEFF_PROCESSES
,      UNMITIGATED_RISKS
,      EVALUATED_RISKS
,      TOTAL_RISKS
,      INEFFECTIVE_CONTROLS
,      EVALUATED_CONTROLS
,      TOTAL_CONTROLS
,      OPEN_FINDINGS
,      OPEN_ISSUES
,      TOP_ORG_PROCESSES
,      TOP_ORG_PROC_PENDING_CERT
,      CERTIFICATION_OPINION_ID
,      EVALUATION_OPINION_ID
,      EVALUATION_OPINION_LOG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SUB_ORG_CERT_ISSUES
,      PROC_CERT_ISSUES
,      INEFF_PROCESSES_PRCNT
,      UNMITIGATED_RISKS_PRCNT
,      INEFF_CONTROLS_PRCNT
FROM AMW.AMW_ORG_CERT_EVAL_SUM;

Dependencies

[top of page]

AMW.AMW_ORG_CERT_EVAL_SUM does not reference any database object

AMW.AMW_ORG_CERT_EVAL_SUM is referenced by following:

SchemaAPPS
SynonymAMW_ORG_CERT_EVAL_SUM