EIS Report Columns
Description
- Categories
- EIS
EIS eXpress report column definitions: one row per column of an EIS report (eis_rs_report_columns), including disabled and hidden columns.
Enabled blank means the column was removed from the report and EIS does not select it. Displayed blank means EIS selects the column but hides it, mostly ids without a display order.
Calculation is the select expression of a derived column as EIS runs it: unqualified column names refer to the report view, and :Parameter Name tokens are replaced by the parameter values as literals. XXEIS Reference flags calculations that use an object of the XXEIS schema, which remains a dependency on EIS code after a migration.
Data Type is set on derived columns and blank on most others, whose type is View Column Data Type: the type registered for the EIS view column, which can differ from the database view. Group Function is shown for group-by reports only, as EIS ignores it on the others.
Executed within Days keeps the reports run from eXpress or XL Connect in that window. EIS purges its run history; EIS Execution History shows the earliest retained run.
Enabled blank means the column was removed from the report and EIS does not select it. Displayed blank means EIS selects the column but hides it, mostly ids without a display order.
Calculation is the select expression of a derived column as EIS runs it: unqualified column names refer to the report view, and :Parameter Name tokens are replaced by the parameter values as literals. XXEIS Reference flags calculations that use an object of the XXEIS schema, which remains a dependency on EIS code after a migration.
Data Type is set on derived columns and blank on most others, whose type is View Column Data Type: the type registered for the EIS view column, which can differ from the database view. Group Function is shown for group-by reports only, as EIS ignores it on the others.
Executed within Days keeps the reports run from eXpress or XL Connect in that window. EIS purges its run history; EIS Execution History shows the earliest retained run.
SQL 41 lines
select era.application_name application, errc.category_name category, err.report_name, err.report_id "EIS Report ID", err.view_name, xxen_util.yes(err.seeded_flag) seeded, errco.display_order, errco.display_name, errco.column_name, xxen_util.yes(errco.derived_flag) derived, errco.calculation_column calculation, xxen_util.yes(case when regexp_like(errco.calculation_column,'xxeis\.','i') then 'Y' end) "XXEIS Reference", errco.data_type, ervc.data_type view_column_data_type, errco.data_format format, decode(err.group_by_flag,'Y',errco.group_function) group_function, xxen_util.yes(nvl(errco.enabled_flag,'Y')) enabled, xxen_util.yes(errco.display_flag) displayed, ervc_comp.component_name component, ervc_comp.alias_name component_alias from xxeis.eis_rs_reports err, xxeis.eis_rs_applications era, xxeis.eis_rs_report_categories errc, xxeis.eis_rs_report_columns errco, xxeis.eis_rs_view_columns ervc, xxeis.eis_rs_view_components ervc_comp where 1=1 and err.application_id=era.application_id and err.category_id=errc.category_id(+) and err.report_id=errco.report_id and errco.view_column_id=ervc.view_column_id(+) and errco.view_component_id=ervc_comp.view_component_id(+) order by era.application_name, errc.category_name, err.report_name, errco.display_order, errco.column_id |
Parameters 7
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Application | LOV |
| |
| Category | LOV |
| |
| Report Name | LOV |
| |
| Seeded | LOV Oracle |
| |
| Executed within Days | Number |
| |
| Derived | LOV Oracle |
| |
| XXEIS Reference | LOV |
|