[Home] [Help] [Dependency Information]
Object Name: | RCI_ORG_CERT_CTRLS_F |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.RCI_ORG_CERT_CTRLS_F |
Subobject Name: | |
Status: | VALID |
This fact table stores the summary data related to the Control Detail report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RCI_ORG_CERT_CTRLS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REPORT_DATE_JULIAN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FIN_CERTIFICATION_ID | NUMBER | Yes | financial statement certification identifier | |
CERTIFICATION_ID | NUMBER | Yes | process certification identifier | |
CERTIFICATION_STATUS | VARCHAR2 | (30) | financial statement certification status | |
CERTIFICATION_TYPE | VARCHAR2 | (30) | financial statement certification type | |
CERTIFICATION_PERIOD_NAME | VARCHAR2 | (15) | financial statement certification period name | |
CERTIFICATION_PERIOD_SET_NAME | VARCHAR2 | (15) | financial statement certification period set name | |
ORGANIZATION_ID | NUMBER | Yes | organization identifier | |
PROCESS_ID | NUMBER | process identifier | ||
NATURAL_ACCOUNT_ID | NUMBER | natural account identifier | ||
CONTROL_ID | NUMBER | control identifier | ||
CONTROL_REV_ID | NUMBER | control revision indentifier | ||
CONTROL_TYPE | VARCHAR2 | (30) | control type | |
CONTROL_LOCATION | VARCHAR2 | (30) | control location | |
AUTOMATION_TYPE | VARCHAR2 | (30) | control automation type | |
CONTROL_FREQUENCY | NUMBER | control frequency | ||
KEY_CONTROL | VARCHAR2 | (2) | indicates whether this control is a key control or not | |
DISCLOSURE_CONTROL | VARCHAR2 | (2) | indicates whether this control is a disclosure control or not | |
LATEST_REV_NUM | NUMBER | indicates the latest revision number for this control | ||
AUDIT_RESULT_CODE | VARCHAR2 | (30) | stores the audit result code for this control | |
LAST_EVALUATED_BY_ID | NUMBER | stores the last evaluated person id for this control | ||
LAST_EVALUATED_ON | DATE | stores the last evaluated date for this control | ||
OP_EFF_ID | NUMBER | stores the operating effectiveness identifier for this control | ||
DES_EFF_ID | NUMBER | stores the design effectiveness identifier for this control | ||
PERIOD_YEAR | NUMBER | (15) | period year for the financial certification | |
PERIOD_NUM | NUMBER | (15) | period number for the financial certification | |
QUARTER_NUM | NUMBER | (15) | quarter number for the financial certification | |
ENT_PERIOD_ID | NUMBER | enterprise period id for the financial certification from FII tbls. | ||
ENT_QTR_ID | NUMBER | enterprise quarter id for the financial certification from FII tbls. | ||
ENT_YEAR_ID | NUMBER | enterprise year id for the financial certification from FII tbls. | ||
REPORT_DATE_JULIAN | NUMBER | stores the julian date for the financial certification period | ||
CREATION_DATE | DATE | Yes | WHO column | |
CREATED_BY | NUMBER | Yes | WHO column | |
LAST_UPDATE_DATE | DATE | Yes | WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | WHO column | |
LAST_UPDATE_LOGIN | NUMBER | WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT FIN_CERTIFICATION_ID
, CERTIFICATION_ID
, CERTIFICATION_STATUS
, CERTIFICATION_TYPE
, CERTIFICATION_PERIOD_NAME
, CERTIFICATION_PERIOD_SET_NAME
, ORGANIZATION_ID
, PROCESS_ID
, NATURAL_ACCOUNT_ID
, CONTROL_ID
, CONTROL_REV_ID
, CONTROL_TYPE
, CONTROL_LOCATION
, AUTOMATION_TYPE
, CONTROL_FREQUENCY
, KEY_CONTROL
, DISCLOSURE_CONTROL
, LATEST_REV_NUM
, AUDIT_RESULT_CODE
, LAST_EVALUATED_BY_ID
, LAST_EVALUATED_ON
, OP_EFF_ID
, DES_EFF_ID
, PERIOD_YEAR
, PERIOD_NUM
, QUARTER_NUM
, ENT_PERIOD_ID
, ENT_QTR_ID
, ENT_YEAR_ID
, REPORT_DATE_JULIAN
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AMW.RCI_ORG_CERT_CTRLS_F;
AMW.RCI_ORG_CERT_CTRLS_F does not reference any database object
AMW.RCI_ORG_CERT_CTRLS_F is referenced by following:
|
|
|