[Home] [Help] [Dependency Information]
Object Name: | RCI_ORG_CERT_SUMM_F |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.RCI_ORG_CERT_SUMM_F |
Subobject Name: | |
Status: | VALID |
This fact table stores the summary data related to the Organization Certification summary report
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RCI_ORG_CERT_SUMM_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 | |
NATURAL_ACCOUNT_ID | NUMBER | natural account identifier | ||
CERTIFICATION_ID | NUMBER | Yes | Process Certification identifier | |
CERTIFICATION_TYPE | VARCHAR2 | (30) | Financial Certification type | |
CERTIFICATION_STATUS | VARCHAR2 | (30) | Financial Certification status | |
CERTIFICATION_PERIOD_NAME | VARCHAR2 | (15) | Financial Certification Period Name from GL Periods | |
CERTIFICATION_PERIOD_SET_NAME | VARCHAR2 | (15) | Financial Certification Period Set Name from GL Periods | |
CERTIFICATION_OWNER_ID | NUMBER | Financial Certification Owner partyId | ||
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
ORG_CERTIFICATION_STATUS | VARCHAR2 | (30) | Organization Certification status | |
ORG_CERTIFIED_BY | NUMBER | column to store partyId of the person who certifies the Organization | ||
ORG_CERTIFIED_ON | DATE | Column to store the date that the Organization was certified on | ||
ORG_CERTIFIED_WITH_ISSUES | VARCHAR2 | (240) | column to store whether this Organization is Certified with Issues | |
ORG_CERTIFIED | VARCHAR2 | (240) | column to store whether this Organization is Certified | |
ORG_NOT_CERTIFIED | VARCHAR2 | (240) | column to store whether this Organization is Not Certified | |
PROCESS_ID | NUMBER | Process identifier | ||
PROC_CERTIFIED_WITH_ISSUES | NUMBER | column to indicate whether this Process is Certified with Issues | ||
PROC_CERTIFIED | NUMBER | column to indicate whether this Process is Certified | ||
PROC_NOT_CERTIFIED | NUMBER | column to indicate whether this Process is Not Certified | ||
PROC_W_INEFF_CTRLS | NUMBER | column to indicate whether this Process has ineffective Controls | ||
UNMITIGATED_RISKS | NUMBER | column to indicate whether this Organization has unmitigated Risks | ||
INEFFECTIVE_CONTROLS | NUMBER | column to indicate whether this Organization has Ineffective Controls | ||
OPEN_ISSUES | NUMBER | column to indicate whether this Organization has Open Issues | ||
PERIOD_YEAR | NUMBER | (15) | column to indicate the Period Year for the Financial Certification | |
PERIOD_NUM | NUMBER | (15) | column to indicate the Period Number for the Financial Certification | |
QUARTER_NUM | NUMBER | (15) | column to indicate the Quarter Number for the Financial Certification | |
ENT_PERIOD_ID | NUMBER | column to indicate the Enterprise Period Identifier from the FII tbls | ||
ENT_QTR_ID | NUMBER | column to indicate the Enterprise Quarter Identifier from the FII tbls | ||
ENT_YEAR_ID | NUMBER | column to indicate the Enterprise Year Identifier from the FII tbls | ||
REPORT_DATE_JULIAN | NUMBER | column to indicate the Julian Date from the FII tbls | ||
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
, NATURAL_ACCOUNT_ID
, CERTIFICATION_ID
, CERTIFICATION_TYPE
, CERTIFICATION_STATUS
, CERTIFICATION_PERIOD_NAME
, CERTIFICATION_PERIOD_SET_NAME
, CERTIFICATION_OWNER_ID
, ORGANIZATION_ID
, ORG_CERTIFICATION_STATUS
, ORG_CERTIFIED_BY
, ORG_CERTIFIED_ON
, ORG_CERTIFIED_WITH_ISSUES
, ORG_CERTIFIED
, ORG_NOT_CERTIFIED
, PROCESS_ID
, PROC_CERTIFIED_WITH_ISSUES
, PROC_CERTIFIED
, PROC_NOT_CERTIFIED
, PROC_W_INEFF_CTRLS
, UNMITIGATED_RISKS
, INEFFECTIVE_CONTROLS
, OPEN_ISSUES
, 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_SUMM_F;
AMW.RCI_ORG_CERT_SUMM_F does not reference any database object
AMW.RCI_ORG_CERT_SUMM_F is referenced by following:
|
|
|