1. Application Developer's Guide
  2. System Reports

14 System Reports

The Oracle Life Sciences Data Hub (Oracle LSH) generates reports on demand that provide an audit trail of the activities performed using Oracle LSH and present information on the state of the system's various components.

This chapter contains the following sections:

Running and Saving System Reports

Information on where to run each report is included in the section on the report.

You can run a report only if you have security access to the screen from which it is launched and to the metadata included in the report.

To generate a system report:

  1. In the relevant screen, select Reports from the Actions drop-down and click Go. The system displays the reports that are available in your current context.
  2. Select the report you want and click Generate Report. If the report has parameters, enter values for the parameters. The system generates the report and displays it in PDF format.
  3. To open the report in a separate window, click Export and then click Open.
  4. To save the report to your personal computer, do one of the following:

    • Click Export and then click Save.

    • Click Save a Copy in the PDF toolbar.

    You can print the local copy if required.

Note:

After saving the report to your local machine, you can add it as a validation supporting document to a defined object, if appropriate. The report is then stored in Oracle LSH.

Parent topic: System Reports

Alphabetical Listing of Reports

Oracle LSH provides the following System reports. Click a report name to view more information.

Parent topic: System Reports

Security Reports

This section contains the following reports:

Parent topic: System Reports

Blinding Rights Report

The Blinding Rights report lists each user-defined security role that has blinding-related privileges.

The report includes a section for each of the following:

  • Read Unblind Rights for Table Instances

  • Unblind Rights for Table Instances

  • Blind Break Rights for Table Instances

  • Read Unblind Rights for Outputs

  • Unblind Rights for Outputs

  • Blind Break Rights for Outputs

In each section, the reports display all roles that have the relevant operation assigned, and the subtype the assignment applies to.

To run the Blinding Rights report, click the Security tab, then click the Roles subtab and follow instructions in Running and Saving System Reports.

Parent topic: Security Reports

Operations for a Role Report

The Operations for a Role report displays all the operations associated with a user-defined security role in Oracle LSH.

For each operation, the report displays the following information:

  • Subtype

  • Object Type

  • Operation

  • Timestamp of Assignment of Operation

To run the Operations for a Role report, click the Security tab, then click the Roles subtab and follow instructions in Running and Saving System Reports.

Parent topic: Security Reports

User Group Assignments Report

The User Group Assignments report displays information on every user group assigned to a particular object. You can choose to include only current assignments or all past assignments.

The following information is displayed for each User Group:

  • Group Name

  • Activity Type (Inherited, Assigned, Revoked, Unassigned, or Unrevoked)

  • Activity Timestamp

  • Group Assigned By

To run the User Group Assignments report, navigate to the Properties screen of the Domain, Application Area, Work Area, or object definition or instance whose user group assignments you want to see, and follow instructions in Running and Saving System Reports.

See Header Information for Object Instances for details on the header section.

Parent topic: Security Reports

Users in Group Report

The Users in Group report lists the roles assigned to a selected user group as well as the users assigned to a particular role. For each role and user, the report displays the following information:

  • Role

  • Description of Role

  • User ID

  • Timestamp of Assignment

  • Added by

  • Timestamp of Removal

  • Removed by

To run the Users in Group report, click the Security tab, then click the User Groups subtab and follow instructions in Running and Saving System Reports. If you want to include users added or removed in the past, select the corresponding checkbox.

Parent topic: Security Reports

Data Blinding Reports

This section contains the following reports:

Parent topic: System Reports

Blind Breaks Report

The Blind Breaks report displays information about each time real data has been accessed from a Table instance, including:

  • Each time a job has been run against a selected blinded Table instance in Blind Break mode to display real data

  • Each time an IDE (integrated development environment such as SAS) has been launched with the Blind Break setting set to Real (Blind Break)

  • Each time a visualization (through an external tool such as Oracle Business Intelligence Enterprise Edition) has been launched with the Blind Break setting set to Real (Blind Break)

  • Each time data has been browsed with the Blind Break setting set to Real (Blind Break)

The Blind Breaks report displays the following details:

  • Header Information—Details of Containership, Instances and Definitions. See Header Information for Object Instances for details on the header section.

  • Blind Breaks—Job ID or Activity Type, Blind break TimeStamp, Blind Break By, Instance Name, Instance Type, Instance Validation Status

To run the Blind Breaks (or Blindbreak) report, navigate to the table instance and follow instructions in Running and Saving System Reports.

Parent topic: Data Blinding Reports

Blinded Table Instances Audit Report

The Blinded Table Instances Audit report displays all Table instances whose blinding flag or blinding status has been changed in a particular Work Area. For each such Table instance, the report details every change to the blinding flag or blinding status. For each change, the report displays the following information:

  • Containership—Domain, Application Area Name, Work Area Name

  • Table Instance Details—Table Instance Name, Version, Validation Status, Action Type, Timestamp, Action By

To run a Blinded Table Instances Audit report, navigate to the Work Area's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Data Blinding Reports

Blinded Table Instances Report

The Blinded Table Instances report displays details of all Table instances in a Work Area, regardless of their Blinding Status, and displays their Blinding Flag setting and Blinding Status.

The report has the following information for each Table instance:

  • Containership—Domain, Application Area Name and Work Area Name

  • Table Instance Details—Table Instance Name, Version, Validation Status, Source Definition Name, Source Definition Version, Created Time Stamp, Blinding Flag, and Blinding Status.

To run a Blinded Table Instances report, navigate to the Work Area's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Data Blinding Reports

Unblinded Outputs Report

The Unblinded Outputs report displays all jobs run on real, unblinded data in a particular Table instance.

The Unblinded Outputs report has the following sections:

  • Header Information—Details of Containership, Instances and Definitions. See Header Information for Object Instances for details on the header section.

  • Jobs and Output Details—The report displays the following details for each job: Job ID, Job Submission Timestamp, Job Submitted by, Output Name, Output Creation Timestamp, Owning Executable Instance, Executable Type, Executable Validation Status.

  • Table Instance Status—The report displays the following details for the source Table instance at the time of job submission: Job ID, Validation Status, Blinding Flag, Blinding Status.

To run an Unblinded Outputs report, navigate to the table instance's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Data Blinding Reports

Container Reports

This section contains the following reports:

Parent topic: System Reports

Application Area Library Report

The Application Area Library report displays information on objects contained in a particular Application Area. You can select the types of objects to include in the report. The report lists objects by their type.Besides information on Domain, Application Area Name and Work Area Name, the report lists the following for each object:

  • Name

  • Description

  • Version

  • Status

  • Checked In or Out?

  • Check out by

  • Validation Status

To run an Application Area Library report, navigate to the application area's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Container Reports

Domain Library Report

The Domain Library report displays information on objects contained in a particular Domain. You can select the types of objects to include in the report. The report lists objects by their type.

For each object, the report displays the Domain name and Classification in addition to the following information:

  • Name

  • Description

  • Version

  • Status

  • Checked In or Out?

  • Check out by

  • Validation Status

To run a Domain Library report, navigate to the domains's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Container Reports

Work Area - All Instances Report

The Work Area - All Instances report details every object instance in a selected work area.

The report provides Containership information such as Domain Name, Application Area Name, Work Area Name, Validation Status, and Classification. It also contains the following information on every instance:

Instance Details

  • Instance Name

  • Instance Version

  • Last Modified by

  • Last Modified TS

  • Source Definition Name

  • Source Definition Version

  • Checked In or Out?

  • Definition's Application Area

  • Definition's Domain

To run a Work Area-All Instances report, navigate to the work area's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Container Reports

Work Area Cloning Report

The Work Area Cloning report details the complete cloning history of a selected work area.

The report provides Containership information such as Domain Name, Application Area Name, Work Area Name, Validation Status, and Classification. It also contains the following information on every cloned work area:

Parent topic: Container Reports

Work Area Details

  • Clone Work Area Name

  • Description

  • Status

  • Validation Status

  • Usage Intent

  • Cloned from Work Area Version

  • Cloned Timestamp

  • Clone Labels (if any)

  • Cloned by

  • Version Label

To run a Work Area Cloning report, navigate to the work area's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Work Area Cloning Report

Work Area Installation History Report

The Work Area Installation History report is a record of every installation in the selected Work Area.

The report provides Containership information such as Domain Name, Application Area Name, Work Area Name, Validation Status, and Classification. It also contains the following information for every installation:

Parent topic: Container Reports

Installation Details

  • Installation Attempt

  • Install Status

  • Install Mode

  • Force to regenerate scripts

  • Installed By

  • Installation Timestamp

To run a Work Area Installation History report, navigate to the work area's Properties screen and follow instructions in Running and Saving System Reports.

Work Area Version History Report

The Work Area Version History report is a record of every version of the selected Work Area.

The report provides Containership information such as Domain Name, Application Area Name, Work Area Name, Validation Status, and Classification. It also provides the following information for every version of the work area:

Parent topic: Container Reports

Version Details

  • Version

  • Description

  • Status

  • Validation Status

  • Usage Intent

  • Version Label

  • Last Modified Timestamp

  • Last Modified By

  • Cloned from Version

To run a Work Area Version History report, navigate to the work area's Properties screen and follow instructions in Running and Saving System Reports.

Object Metadata Reports

Oracle LSH object metadata reports present an overview of an object's history and current status.

This section contains the following:

Parent topic: System Reports

Common Header Information

This section contains the following:

Parent topic: Object Metadata Reports

Header Information for Object Definitions

Header information for object definitions is divided into two parts:

  • Containership—Domain Name and Application Area Name.

  • Definition Details—Name, Description, Latest Version, Creation Time, Created by, Checked in or out?, Last Modified Time, Last Modified by, Validation Status, Classification

Header Information for Object Instances

Header information for object instances is divided into three parts:

  • Containership—Domain Name, Application Area Name and Work Area Name.

  • Instance Details—Instance Name, Description, Version, Last Modified Time, Last Modified by, Validation Status, Classification.

  • Definition Details—Definition Name, Description, Latest Version, Checked in or out?, Checked out by, Last Modified Time, Last Modified by.

All Instances of a Definition Report

The All Instances of a Definition report contains information on all the object instances that are based on or point to a selected definition.

The report displays information in the format described in Header Information for Object Instances.

To run an All Instances of a Definition report, navigate to the definition's Properties screen and follow instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Data Mart Report

A Data Mart report contains information about the current status of a single Data Mart definition. This is the same information that is available in the Data Mart's Properties screen and its subtabs.

For information on a Data Mart's version history, see Object Version History Report . For information on Data Marts, see Defining Data Marts.

The Data Mart report has three sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Attributes—A table displaying the values of the attributes Data Mart Type, File Name, File Name Extension, and Mode.

  • Child Objects—Tables displaying information about each of the following Data Mart components:

    Note:

    These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Data Mart or to a particular component.

    • Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, and SAS Library Name.

      Note:

      All Data Mart Table Descriptors are of type Source, not Target.

    • Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.

    • Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.

To generate a Data Mart report, navigate to the Data Mart's Properties screen. Select Definition Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Data Mart Instance Report

The Data Mart Instance report includes all the definitional information that pertains to the instance, including information about the underlying Data Mart definition. See Data Mart Report for definition related information.

The Data Mart Instance report contains the information available in the Data Mart instance's Properties screen and its subtabs. It has four sections:

  • Header—See Header Information for Object Instances for details on the header section.

  • Attributes—A table displaying values of the attributes Data Mart Type, File Name, File Name Extension, and Mode.

  • Child Objects—Tables displaying information about each of the Data Mart components- Table Descriptors, Parameters, Planned Output. See Data Mart Report for details of these components. Additionally, you can see mapping information about Table Descriptors.

  • Mapping Information—Detailed mapping information for the Data Mart instance. This section has two subsections.

    • The first subsection displays the following information: TD Table Definition Name, Description, Latest Version, Checked In or Out, Checked out by, Last Modified Time, Last Modified by, Validation Status.

    • The second subsection displays details about the tables that the Table Descriptors are mapped to. This table has two parts, one for the Table Descriptor and the other for the Table instance.

      • Table Descriptor—Consisting of the Column Name and Data Type.

      • Table Instance—Consisting of the Column Name, Format String, Default Value, Data Type and Mapping Status.

To generate a Data Mart Instance report, navigate to the Data Mart instance's Properties screen. Select Definition Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Load Set Report

A Load Set report contains information about the current status of a single Load Set definition. This is the same information that is available in the Load Set's Properties screen and its subtabs. For information on a Load Set's version history, see Object Version History Report .

For information on Load Sets, see Defining Load Sets

The Load Set report has three sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Attributes—The second section displays the values of the attributes Adapter Type, Remote Location Name, Database Schema, Study Name, View Type, Design Sub-System, and Yes or No settings for Save to File/Save Input File?.

  • Child Objects—The third section displays tables with information about each of the following Load Set components.

    Note:

    Child Object tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Load Set or to a particular component.

    • Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, and SAS Name.

    • Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.

To generate a Load Set report, navigate to the Load Set's Properties screen. Select Definition Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Load Set Instance Report

The Load Set Instance report includes all the definitional information pertaining to the instance, including information about the underlying Load Set definition.

The Load Set Instance report contains the same information available in the Load Set instance's Properties screen and its subtabs. It has four sections.

  • Header—See Header Information for Object Instances for details on the header section.

  • Attributes—The second section displays a table with values of the attributes Database Schema, Study Name, View Type, Design Sub-System, and Yes or No settings for Save to File/Save Input File?.

  • Child Objects— Similar to the Load Set report, the third section displays tables with information about Table Descriptors and Parameters. See Load Set Report for details on Child Objects.

  • Mapping Information—Similar to the Data Mart Instance report, the last section presents mapping information for the Load Set instance in two subsections. See Data Mart Instance Report for details.

To generate a Load Set Instance report, navigate to the Load Set Instance's Properties screen. Select Definition Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Object Validation Report

The Object Validation report displays information about the validation life cycle of a selected object instance. The report reflects changes to the object instance's validation status and lists all supporting documents and supporting outputs associated with the object instance.

The report has the following sections:

  • Header—See Header Information for Object Instances for details on the header section.

  • Validation Status—For each change in the validation cycle, the report displays the following: Validation Status, Status Update Timestamp, Updated by, and Comments.

  • Supporting Document—For each supporting document, the report displays the following information: Name, File Name, Description, Version, Uploaded by, Status, Validation Status at Time of Upload.

  • Supporting Outputs—For each supporting output, the report displays the following information: Output Name, Job ID, Description, Added by, Status, Validation Status at Time of Adding.

To generate an Object Validation report, navigate to the object instance's Properties scree. Select Validation Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Object Version History Report

The Object Version History report is a record of every version of the selected object definition.

The Object Version History report has two sections.

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Version History—The second section displays the following details about the object: Version, Description, Status, Validation Status, Copied from Version, Version Label, Last Modified Timestamp, Last Modified by, Check in/Check out comments, if any.

To generate an Object Validation report, navigate to the Properties screen of an object instance definition. Select Version History Report from the list of reports available for object instances while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Program Report

A Program report contains information about a single Program definition. For information on a Program's version history, see Object Version History Report.

For information on Programs, see Defining Programs.

The Program report contains the same information that is present in the Program's Properties screen and its subtabs. It has three sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Attributes—The second section displays a table with the value of the attribute Program Type.

  • Child Objects—The third section displays tables with information about each of the following Program components:

    Note:

    Child Object tables display all possible information for each component. However, some of the table columns may not be applicable to particular types of Programs or components.

    • Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, and SAS Name.

    • Parameters. For each Parameter, the report displays the Prompt, Default Value, and Yes or No settings for Visible?, and Required?.

    • Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Primary?, Error if generated?, and Error if not generated?.

    • Source Code. For each Source Code, the report displays the Source Code Name, Description, Yes or No settings for Primary?, Share Type, File Type, Yes or No settings for Sharable?, File Name, Source Code Shared From?, and the actual source code.

To generate a Program report, navigate to the Program's Properties screen. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Program Instance Report

The Program Instance report includes the definitional information pertaining to the instance, including information about the underlying Program definition. See Program Report for details on Program definitions.

The Program Instance report contains the same information available in the Program instance's Properties screen and its subtabs. It has four sections:

  • Header—See Header Information for Object Instances for details on the header section.

  • Attributes—The second section displays a table with the value of the attribute Program Type.

  • Child Objects—Similar to the Program report, the third section displays tables with information about the following Program components—Table Descriptors, Parameters, Planned Output and Source Code. See Program Report for details.

  • Mapping Information— Similar to the mapping information of the Data Mart Instance report, the last section presents mapping information for the Program instance in two subsections. See Data Mart Instance Report for details.

To generate a Program Instance report, navigate to the Properties screen of a Program Instance. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Report Set Report

The Report Set report contains information about the current status of a single Report Set including its child objects. The report contains the same information that is available in the Report Set's Properties screen and its subtabs. You can choose whether or not to include information on Post-Processing and Overlay Template Parameters for the Report Set and each Report Set Entry.

For information on a Report Set's version history, see Object Version History Report.

For more information on Report Sets, see Defining Report Sets.

The Report Set report has following sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Attributes—The second section displays Attribute values- Title, Yes or No settings for Strict Numbering?, and Yes or No settings for Unique Numbering?.

    If you selected Post-Processing Parameters or Overlay Template Parameters, the report displays these both at the Report Set level and for each Report Set Entry (see below).

  • Child Objects—The third section displays tables with information about the following components.

    • Planned Output. For each Planned Output, the report displays Name, File Name, Yes or No settings for Primary?, Yes or No settings for Error if generated?, and Error if not generated?.

    • Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.

    • Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.

    • Parameters. For each Parameter, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.

Parent topic: Object Metadata Reports

Report Set Entries

The Report Set report also displays tables with information about each Report Set Entry in numerical order.

  • Report Set Entry Number. For the Report Set Entry identified by its number and title, the report displays the Entry Name, Title, Yes or No settings for Pre Narrative?, Yes or No settings for Post Narrative?, Placeholder, Yes or No settings for Has Children?, and Yes or No settings for Omitted?.

    The Pre and Post narratives are also shown with the Report Set Entry's details.

  • Post-Processing. For Post-processing, the report displays Parameter, Yes or No settings for Default?, Yes or No settings for Value Propagation?, Yes or No settings for Visible?, and Yes or No settings for Required?.

  • Overlay Templates. For each Overlay Template, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.

  • Parameters. For each Parameter, the report displays Prompt, Yes or No settings for Default?, Yes or No settings for Read Only?, Yes or No settings for Visible?, and Yes or No settings for Required?.

Parent topic: Report Set Report

Program Instance Under Report Set Entry (Full Title)

When a Report Set Entry within a Report Set contains a Program instance, the report details the Program definition that the particular Program instance points to.

  • Table Descriptors. For each Table Descriptor, the report displays the Name, Yes or No settings for Is Target?, Oracle Name, SAS Name, SAS Library Name, Mapping Status, Mapped to Table Instance, TI (Table Instance) Work Area, TI (Table Instance) Application Area, TI (Table Instance) Domain.

  • Parameters. For each Program instance Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.

  • Planned Output. For each Planned Output, the report displays the Name, File Name, Yes or No settings for Error if generated?, and Error if not generated?.

  • Source Code. For Source Code, the report displays the Name, Description, Yes or No settings for Primary?, Share Type, File Type, Yes or No settings for Sharable?, File Name, Source Code Shared From location and the actual source code.

To generate a Report Set report, navigate to the Properties screen of a Report Set. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

You can select any or all of the following optional components to include in the Report Set Definition report—Post Processing Parameters, Overlay Templates Parameters, Narratives.

Parent topic: Report Set Report

Report Set Instance Report

The Report Set Instance report includes all the definitional information that pertains to the instance, including information about the underlying Report Set definition. See Report Set Report.

The Report Set instance report contains the same information that is available in the Report Set instance's Properties screen and its subtabs. It has three sections.

  • Header—See Header Information for Object Instances for details on the header section.

  • Attributes—The second section displays a table with values of the attributes Title, Strict Numbering, and Unique Numbering.

  • Child Objects—Similar to the Report Set report, the third section displays tables with information about each of the following components—Planned Output, Post-Processing, Overlay Templates and Parameters. See the section on Child Objects in the Report Set Report for details. Additionally, you can see mapping information about Table Descriptors.

Parent topic: Object Metadata Reports

Report Set Entries

Similar to the Report Set report, the Report Set Instance report also displays tables with information about each Report Set Entry in numerical order. See the section on Report Set Entries in the Report Set Report for details.

Program Instance Under Report Set Entry (Full Title)

When a Report Set Entry within a Report Set contains a Program instance, the report details the Program definition that the particular Program instance points to.

The Program Instance details are displayed in the following subsections—Table Descriptors, Parameters, Planned Output, Source Code and Mapping Details. See the section on Program Instance under Report Set Entry in the Report Set Report for details.

Mapping Details provides information about the tables mapped with the Table Descriptors of the Program Instance in two parts:

  • Table Descriptor—Column Name, Data Type

  • Table Instance—Column Name, Format String, Default Value, Data Type, Mapping Status

To generate a Report Set Instance report, navigate to the Properties screen of a Report Set Instance. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

You can select any or all of the following optional components to include in the Report Set Instance report—Post Processing Parameters, Overlay Templates Parameters, Narratives.

Table Report

A Table report contains information about the current status of a single Table definition. This is the same information that is available in the Table's Properties screen and its subtabs.

For information on Tables, see Defining Tables.

The Table report has the following three sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Attributes—The second section displays the values of the attributes Oracle Name, SAS Name, SAS Label, Process Type, Allow Snapshot?, Blinding Flag.

  • Child Objects—The third section displays tables with information about each of the following Table components:

    Note:

    These tables display all possible information for each component. Some of the columns may not be applicable to a particular type of Table or to a particular component.

    • Columns. For each Column, the report displays the Name, Position, Oracle Name, SAS Name, SAS Label, Data Type, Length, Precision, SAS Format, Default Value, Mandatory?, and Variable Name.

    • Constraints. For each Constraint, the report displays the Name, Type, Column Name (s), Join Table, and Value(s) allowed.

To generate a Table report, navigate to the Properties screen of a Table. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Table Instance Report

The Table Instance report includes all the definitional information that pertains to the instance, including information about the underlying Table definition. See Table Report.

The Table Instance report contains the same information that is available in the Table instance's Properties screen and its subtabs. Similar to the Table report, the Table Instance report has three sections—Header, Attributes and Child Objects. See Table Report for details.

To generate a Table Instance report, navigate to the Properties screen of a Table Instance. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Workflow Report

The Workflow report contains information about the current status of a single Workflow. This is the same information that is available in the Workflow's Properties screen and its subtabs. For information on a Workflow's version history, see Object Version History Report.

For more information on Workflows, see Defining Workflows.

The Workflow report has the following two sections:

  • Header—See Header Information for Object Definitions for details on the Header section.

  • Child Objects—The third section displays tables with information about each of the following Workflow components:

    Note:

    These tables display all possible information for each component. Some of the table columns may not be applicable to a particular type of Workflow or to a particular component.

    • Executable Instances and Workflow Structures. For each Executable Instance and Workflow Structure, the report displays the Name, Type, Description, Checked out by, and Status.

    • Parameters. For each Parameter, the report displays the Prompt, Default Value, Yes or No settings for Visible?, and Yes or No settings for Required?.

    • Transitions. For each Transition, the report displays From Object Name, From Object Type, Condition, To Object, and To Object Type.

    • Mapping Details. The report displays information about the mapping between executable instances contained in the Workflow and Table instances.

The Workflow report includes information on each executable object instance included in the Workflow. These may include Data Marts, Programs, Load Sets and Report Sets. The information displayed is the same as in the report for each object type. See Data Mart Report, Program Report, Load Set Report, and Report Set Report.

To generate a Workflow report, navigate to the Properties screen of a Workflow. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports

Workflow Instance Report

The Workflow Instance report includes all the definitional information that pertains to the instance, including information about the underlying Workflow definition. The Workflow instance report contains the same information that is available in the Workflow instance's Properties screen and its subtabs.

Similar to the Workflow report, the Workflow Instance report has two sections—Header and Child Objects. See Workflow Report for details.

The Workflow Instance report contains information on each executable object instance included in the Workflow. The object instances may include Data Marts, Programs, Load Sets and Report Sets. The information displayed is the same as in the report for each object type. See Data Mart Instance Report, Program Instance Report, Load Set Instance Report, and Report Set Instance Report.

To generate a Workflow Instance report, navigate to the Properties screen of a WorkflowInstance. Select Definition Report from the list of reports available while following instructions in Running and Saving System Reports.

Parent topic: Object Metadata Reports