[Home] [Help]
[Dependency Information]
[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:
APPS
RCI_ORG_CERT_SUMM_F
|
|
|
|