Generate Cost Containment Certification Spreadsheet

Contents ShowHide

The Generate Cost Containment Certification Spreadsheet screen is used to generate the Cost Containment Certification Spreadsheet (Output).

For detailed information about the system output generated, see Cost Containment Certification Spreadsheet (Output).

The Generate Cost Containment Certification Spreadsheet screen is available in the following applications:

Vendor

Generate Cost Containment Certification Spreadsheet screen

Screen Access

Display the Generate Reports screen > Double-click Cost Containment Certification Spreadsheet.

Interface Initialization

Upon initial display of the screen, the following occurs:

The title bar text is set to "Generate Cost Containment Certification Spreadsheet".

The Date Range group box is visible, enabled, and presented as follows:.

The From calendar control is visible, enabled, and blank.
The To calendar control in visible, enabled, and blank.

The OK button is visible and enabled as the default.

The Cancel button is visible and enabled as the default.

Screen Elements

Unless otherwise stated below, all controls on the Generate Cost Containment Certification Spreadsheet screen are visible and enabled when:

The screen is active.

If one or more special conditions exist that affect a control on the Generate Cost Containment Certification Spreadsheet screen, the condition(s) are documented for that specific control below.

Date Range group box

Complete the information in the Date Range group box.

This group box includes calendar controls that allow you to specify the date range for which to generate the system output. The title text of the group box is set to "Date Range". Complete the information in the following calendar controls to specify the date range the system output will cover:

From calendar control

Select or enter the starting date of the date range in this calendar control.

To calendar control

Select or enter the ending date of the date range in this calendar control.

The From date entered must be equal to or less than the To date entered. If not, a standard error message (E0047) displays when the screen is processed.

OK button

Click the OK button to generate the system output.

It is the default button for the screen.

The control is disabled when:

The system is generating the spreadsheet.

It does not have a mnemonic. Its keyboard shortcut is the Enter key.

The system output is generated and the Generate Reports screen displays when the button is clicked. Some reports can take a bit of time to generate. For these reports, a progress bar displays when the button is clicked.

Cancel button

Click the Cancel button to close the screen without generating the system output.

The control is disabled when:

The system is generating the spreadsheet.

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Generate Reports screen displays when the button is clicked.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

A process to check for required controls as identified in the Data Map below is performed.
A process to check for valid entries as identified individually for each applicable control in Screen Elements above is performed.
A process to check for edits and cross edits as identified for each applicable control in Screen Elements above is performed.
If any checks or processes fail, a standard error message displays.

If no data can be validated and saved on the screen:

No cross edits are performed.
All values are considered legitimate.
No data is written to the database.

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Control Label	Required
From	X
To	X

Software Version: 2.40.00