PMO Reports: PPM Schema

The PPM Schema report displays the columns of tables and views in the schema. The report includes the column data types, nulls constraints and comments. The report is grouped by the database table or view. The following image displays the PPM Schema report with table column details.
ccppmop144
The PPM Schema report displays the columns of tables and views in the
Clarity Project and Portfolio Management (PPM)
schema. The report includes the column data types, nulls constraints and comments. The report is grouped by the database table or view. The following image displays the PPM Schema report with table column details.
Image displaying the PPM Schema report with table column details
Report Prerequisites
There are no prerequisites for this report.
Report Properties
The following values list the report properties:
Name:
PPM Schema
Resource ID:
CSK_ADM_PPMSchema
Description:
Administration (PMO Accelerator)
Folder:
CA PPM/Reports/Administration/PPM Schema
Path:
/ca_ppm/reports/administration/CSK_ADM_PPMSchema
Data Source:
CA PPM Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
PPM Table
ppmTable
Multiple-select
Query
PPM Table
ppmTable
No
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Parameter Lookup Values
There are no parameter lookup values for this report.
Parameter Explanations
The PPM Table parameter allows you to determine which tables or views display on the report.
Report Fields and Calculations
The report is grouped by the database table or view and it displays the columns available to each table or view. The columns on the report include: column, definition, nulls, and comments. The Nulls report column displays "Yes" when the NOT NULL integrity constraint is specified for the database column; otherwise it displays "No".
Report Security
There is no security inside the report.