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

TABLE: AMW.RCI_SIG_ACCT_EVAL_F

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


This fact table stores the summary data related to the Significant Account Evaluation report


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCI_SIG_ACCT_EVAL_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_DATE_JULIAN
Columns
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
Query Text

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;

Dependencies

[top of page]

AMW.RCI_SIG_ACCT_EVAL_F does not reference any database object

AMW.RCI_SIG_ACCT_EVAL_F is referenced by following:

SchemaAPPS
SynonymRCI_SIG_ACCT_EVAL_F