EnterpriseReportPage (ver10.0.0)
This table stores the metadata information of the Enterprise Reports (which is required to construct the URL needed to access the report in APEX).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| ApexApplicationID | 10.0.0 | Number(16) | APEX application ID of the report. |
| ApexPageID | 10.0.0 | Number(16) | APEX page ID of the report. |
CategoryCode | 10.0.0 | Varchar2(50) | Category code to which the report belongs to. Required. |
Description | 10.0.0 | Varchar2(250) | The description of the enterprise report that describes the report function. |
| EnterpriseReportPageID | 10.0.0 | Number(16) | Unique sequential number generated by the application. Indexed. Required. |
Name | 10.0.0 | Varchar2(50) | Name of the enterprise report. Required. |
| Publish | 10.0.0 | Number(1,0) | The current publish state of the report. Valid values: 0=Not Published,1=Published. Defaults to 0. Required. |
WhenCreated | 10.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
WhenModified | 10.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
WhoCreated | 10.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 10.0.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |