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.RCI_PROC_CERT_SUM_F

Object Details

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

This fact table stores the summary data related to the Process Certification report

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCI_PROC_CERT_SUM_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_DATE_JULIAN

Columns

Name	Datatype	Length	Comments
CERTIFICATION_ID	NUMBER		identifier column for Certification
ORGANIZATION_ID	NUMBER		identifier column for Organization
PROCESS_ID	NUMBER		identifier column for Process
CERT_STATUS	VARCHAR2	(30)	column to store Certification Status
CERT_TYPE	VARCHAR2	(30)	column to store Certification Type
CERT_RESULT	VARCHAR2	(30)	column to store Certification Result
CERT_RESULT_CWI	NUMBER		column to store whether the Certification is with issues
CERT_RESULT_C	NUMBER		column to store whether the Certification is certified
CERT_RESULT_NC	NUMBER		column to store whether the Certification is not certified
RISKS_WITH_INEFF_CTRLS	NUMBER		column to store risk count with ineffective controls
RISK_EVAL_M	NUMBER		column to store whether risk is evaluated as Mitigated
RISK_EVAL_SM	NUMBER		column to store whether risk is evaluated as Somewhat Mitigated
RISK_EVAL_SE	NUMBER		column to store whether risk is evaluated as Somewhat Exposed
RISK_EVAL_FE	NUMBER		column to store whether risk is evaluated as Fully Exposed
RISK_EVAL_NE	NUMBER		column to store whether risk is Not Evaluated
CTRL_EVAL_E	NUMBER		column to store whether control is evaluated as Effective
CTRL_EVAL_MW	NUMBER		column to store whether control is evaluated as Materially Weak
CTRL_EVAL_D	NUMBER		column to store whether control is evaluated as Deficient
CTRL_EVAL_SD	NUMBER		column to store whether control is evaluated as Significantly Deficient
CTRL_EVAL_NE	NUMBER		column to store whether control is Not Evaluated
OPEN_ISSUES	NUMBER		column to store open issues count
PERIOD_YEAR	NUMBER	(15)	column for year from FII time tables
PERIOD_NUM	NUMBER	(15)	column for period number from FII time tables
QUARTER_NUM	NUMBER	(15)	column for quarter number from FII time tables
ENT_PERIOD_ID	NUMBER		column for enterprise period identifier from FII time tables
ENT_QTR_ID	NUMBER		column for enterprise quarter identifier from FII time tables
ENT_YEAR_ID	NUMBER		column for enterprise year identifier from FII time tables
REPORT_DATE_JULIAN	NUMBER		column to store julian date for certification period end date
CREATED_BY	NUMBER		WHO column
LAST_UPDATE_LOGIN	NUMBER		WHO column
CREATION_DATE	DATE		WHO column
LAST_UPDATED_BY	NUMBER		WHO column
LAST_UPDATE_DATE	DATE		WHO column

Query Text

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


SELECT CERTIFICATION_ID
,      ORGANIZATION_ID
,      PROCESS_ID
,      CERT_STATUS
,      CERT_TYPE
,      CERT_RESULT
,      CERT_RESULT_CWI
,      CERT_RESULT_C
,      CERT_RESULT_NC
,      RISKS_WITH_INEFF_CTRLS
,      RISK_EVAL_M
,      RISK_EVAL_SM
,      RISK_EVAL_SE
,      RISK_EVAL_FE
,      RISK_EVAL_NE
,      CTRL_EVAL_E
,      CTRL_EVAL_MW
,      CTRL_EVAL_D
,      CTRL_EVAL_SD
,      CTRL_EVAL_NE
,      OPEN_ISSUES
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
,      REPORT_DATE_JULIAN
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM AMW.RCI_PROC_CERT_SUM_F;

Dependencies

[top of page]

AMW.RCI_PROC_CERT_SUM_F does not reference any database object

AMW.RCI_PROC_CERT_SUM_F is referenced by following:

APPS: RCI_PROC_CERT_SUM_F