[Home] [Help] [Dependency Information]
Object Name: | RCI_SIG_ACCT_EVAL_F |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.RCI_SIG_ACCT_EVAL_F |
Subobject Name: | |
Status: | VALID |
This fact table stores the summary data related to the Significant Account Evaluation report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RCI_SIG_ACCT_EVAL_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPORT_DATE_JULIAN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATEMENT_GROUP_ID | NUMBER | identifier column for statement group | ||
FINANCIAL_STATEMENT_ID | NUMBER | identifier column for financial statement | ||
FINANCIAL_ITEM_ID | NUMBER | identifier column for financial item | ||
ACCOUNT_GROUP_ID | NUMBER | identifier column for account group | ||
CERT_STATUS | VARCHAR2 | (30) | column to store Certification Status | |
CERT_TYPE | VARCHAR2 | (30) | column to store Certification Type | |
CERTIFICATION_ID | NUMBER | identifier column for Certification | ||
SIG_ACCT_ID | NUMBER | identifier column for Significant Account | ||
ORGANIZATION_ID | NUMBER | identifier column for Organization | ||
PROCESS_ID | NUMBER | identifier column for Process | ||
ACCT_EVAL_RESULT_CODE | VARCHAR2 | (30) | column to store Account Evaluation Result Code | |
ACCT_EVAL_E | NUMBER | column to store whether account is evaluated as Effective | ||
ACCT_EVAL_IE | NUMBER | column to store whether account is evaluated as Ineffective | ||
ACCT_EVAL_NE | NUMBER | column to store whether account is Not Evaluated | ||
ORGS_WITH_INEFF_CTRLS | NUMBER | column to store organization count with ineffective controls | ||
PROC_CERT_RESULT_CWI | NUMBER | column to store whether process is Certified with issues | ||
PROC_CERT_RESULT_C | NUMBER | column to store whether process is Certified | ||
PROC_CERT_RESULT_NC | NUMBER | column to store whether process is Not Certified | ||
UNMITI_RISKS | NUMBER | column to unmitigated risks count | ||
INEFF_CTRLS | NUMBER | column to ineffective controls 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 STATEMENT_GROUP_ID
, FINANCIAL_STATEMENT_ID
, FINANCIAL_ITEM_ID
, ACCOUNT_GROUP_ID
, CERT_STATUS
, CERT_TYPE
, CERTIFICATION_ID
, SIG_ACCT_ID
, ORGANIZATION_ID
, PROCESS_ID
, ACCT_EVAL_RESULT_CODE
, ACCT_EVAL_E
, ACCT_EVAL_IE
, ACCT_EVAL_NE
, ORGS_WITH_INEFF_CTRLS
, PROC_CERT_RESULT_CWI
, PROC_CERT_RESULT_C
, PROC_CERT_RESULT_NC
, UNMITI_RISKS
, INEFF_CTRLS
, 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_SIG_ACCT_EVAL_F;
AMW.RCI_SIG_ACCT_EVAL_F does not reference any database object
AMW.RCI_SIG_ACCT_EVAL_F is referenced by following:
|
|
|