[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RCI_PROC_CERT_SUM_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPORT_DATE_JULIAN |
Name | Datatype | Length | Mandatory | 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 |
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;
AMW.RCI_PROC_CERT_SUM_F does not reference any database object
AMW.RCI_PROC_CERT_SUM_F is referenced by following:
|
|
|