PMO Reports: PPM Schema

ccppmop1571
The PPM Schema report displays the columns of tables and views in the 
Clarity 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 PPM
 
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through 
Clarity PPM
 
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through 
Clarity 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.