COG200 LATEST EXAM TEST QUESTIONS AND ANSWERS
FIRM A+
✔✔Chapter 1 On the Query Template "Record & Contact Filters for Query" Extensions
how are they used - ✔✔Extensions can be specified here to filter certain records or
contacts out of the results returned by this template. Examples include RW BREAK THE
GLASS, a record select extension that filters out any patients whose records the report
runner does not have access to view, and RW SENSITIVE CONTACT, a contact select
extension which filters out any contacts the report runner does not have access to view.
✔✔Chapter 1 Before you add a parameter to a template, you must - ✔✔find out the INI
and item of the data point that you want the parameter to search for.
✔✔Chapter 1 Parameters in a template: How can you determine what master files the
template knows how to work with? - ✔✔You can determine this master file by looking at
the Query Template form.
✔✔Chapter 1 Parameters in a template: what Parameters can you search from. -
✔✔You can include parameters that search any item from the base search master file in
your Reporting Workbench query
✔✔Chapter 1 Parameters in a template: How can you includes Parameters not in the
base mater file? - ✔✔You will need to network out to those additional master files
✔✔Chapter 1 The Query Template > Parameters form contains a list of which
parameters? - ✔✔It contains a list of parameters that the query can search for
✔✔Chapter 1 The Query Template > Parameters:How can you tell which parameters
are searching the base search master file and which are networking out to additional
master files - ✔✔by looking at the Basic tab for each criterion.
✔✔Chapter 1 The Query Template > Parameters:On the Basic tab of the right hand
side, the Item field tells you the item number this parameter is searching. Since no
master file is specified, which master file is used? - ✔✔this is an item in the base search
master file.
✔✔Chapter 1 What are the three types of parameters that you will see on the Query
Template > Parameters form? - ✔✔*Simple Parameters evaluate an item in the search
master file.
*Networked Parameters evaluate an item in a different master file that can be
networked to from the search master file.
*Property parameters evaluate the results of a formula programmed in M code.
,✔✔Chapter 1 Query Parameter Wizard shows... - ✔✔The wizard shows all items from
the base search master file. Choose a networked item in the base search master file to
define a path to a new master file.
The networked items appear in blue text, have the Networked icon next to them, and
display the INI they
network to in parentheses.
✔✔Chapter 1 Modify the Default Settings of a Parameter: Multiple values - ✔✔Check
this box if the report user will be able to supply this parameter with multiple
operator/value combinations to find during the search
✔✔Chapter 1 Modify the Default Settings of a Parameter: Overtime criterion - ✔✔Check
this box if the item is an overtime item. This will cause an icon to appear to alert the
report writer that the criterion will be affected by the date/time range
✔✔Chapter 1 Modify the Default Settings of a Parameter: Related group - ✔✔Free text
value used to tie related parameters together. Any two parameters with the same
Related Group string are considered part of the same related group and
will be evaluated together at search time, meaning two things:
1. All criteria in the group must be met on the same contact
2. If criteria are part of a Chronicles related group, all criteria must be met on the same
line of the group
✔✔Chapter 1 Modify the Default Settings of a Parameter: If two criteria were not part of
a related group how are they evaluated? - ✔✔they would be evaluated separately
✔✔Chapter 1 Query Template: Search master file = EPT searches which records? -
✔✔patient records
✔✔Chapter 1 Query Template: Search on - Records how many times will a patient
appear? - ✔✔In the results of any report built from this template, a single patient will
only appear once.
✔✔Chapter 1 Query Template:: Set Search on to Contacts, how many times will
patients appear? - ✔✔modify the template to return one result for each patient contact
that meets the report's criteria
✔✔Chapter 1 Property Parameter: how does it work? - ✔✔Unlike simple and networked
parameters, property parameters compare a value to the results of a formula, instead of
comparing a value to a Chronicles item
✔✔Chapter 1 Property Parameter: what are the parts and how many? - ✔✔Property
parameters can consist of two parts: A Base property parameter which specifies the
,formula to be used, and ﴾optionally﴿ one or more Mnemonic parameters, which allow the
end user to specify variables to be used by the formula.
✔✔Chapter 1 review: What's the difference between a static and a dynamic report? -
✔✔The results of static reports are completely calculated and saved when run, and are
simply loaded when viewed. Dynamic reports only calculate which records or contacts
fit the report's criteria when run, and recalculate the contents of all columns each time
the report is viewed. Static reports take longer to run, dynamic reports take longer to
view.
✔✔Chapter 1 review: True or False. When creating a networked parameter, you can
only go through one networked link. For example, you could not link from EPT to ORD
to DEP. - ✔✔False. You can link up to four times for each parameter link.
✔✔Chapter 1 review: True or False. You can create a related group on the Criteria tab
that contains two single response items. - ✔✔True. The items that are part of a related
group on the Criteria tab do not have to have a response type of related group.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What controls the way the Report Settings window appears to end
users is controlled? - ✔✔Template the report was made from.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What does Query Template > Parameters form control? - ✔✔What
the search knows how to do
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What does User Interface > Parameters form control? - ✔✔hich
options will be available to the end user in the
Report Settings window, and what parameters will be used by reports made from the
template at run time.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - T or F, If we want a default value to be included in the search the
parameter must appear on the User Interface > Parameters form. - ✔✔T
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters- T or F, You can use the settings on the User Interface >
Parameters form to control how an end user will see
parameters on the Criteria tab. - ✔✔T
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Operator List- What operators are
, available on a contact based template? - ✔✔In a Contact‐based template, only the
following operator options are available:
Basic operator list
Don't show operator field
Equals and not equals operator
String operators
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- User can choose logic within
criteria, How does this work? - ✔✔If this is selected, the user will be able to choose
whether all of the values in a criterion must be found in order for the criterion to be
satisfied (AND logic), or only one (OR logic). If it's not selected, OR logic will be used.
This field should be cleared for single response parameters.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Visible - How does this work? -
✔✔When selected, the user can see and work with this parameter.
The parameter can also be marked as Default, however. If the parameter is marked as
default, it will still be evaluated
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Enabled - - ✔✔When selected, the
parameter can be edited by the user
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Restricted - - ✔✔If a parameter is
marked as Restricted, then the only people who can edit the parameter are users with
the security point Edit Restricted Parameters assigned to their RW Security Class.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- What do you use to control the appearance of the
Criteria Tab? - ✔✔Use the User Interface form to control the appearance of the Criteria
tab and what options the end user has in Report Settings.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- Basic Information-Search hyperlink - - ✔✔Choose a
name for the link that appears on the Report Settings Criteria tab. This should be a word
or short phrase that answers the question "what does each row in the results of this
report represent".
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- Basic Information- Description for hyperlink - ✔✔When
you click on the search hyperlink in the Criteria tab, this will display in a pop‐up window.
Use this field to provide detailed information about this report template
FIRM A+
✔✔Chapter 1 On the Query Template "Record & Contact Filters for Query" Extensions
how are they used - ✔✔Extensions can be specified here to filter certain records or
contacts out of the results returned by this template. Examples include RW BREAK THE
GLASS, a record select extension that filters out any patients whose records the report
runner does not have access to view, and RW SENSITIVE CONTACT, a contact select
extension which filters out any contacts the report runner does not have access to view.
✔✔Chapter 1 Before you add a parameter to a template, you must - ✔✔find out the INI
and item of the data point that you want the parameter to search for.
✔✔Chapter 1 Parameters in a template: How can you determine what master files the
template knows how to work with? - ✔✔You can determine this master file by looking at
the Query Template form.
✔✔Chapter 1 Parameters in a template: what Parameters can you search from. -
✔✔You can include parameters that search any item from the base search master file in
your Reporting Workbench query
✔✔Chapter 1 Parameters in a template: How can you includes Parameters not in the
base mater file? - ✔✔You will need to network out to those additional master files
✔✔Chapter 1 The Query Template > Parameters form contains a list of which
parameters? - ✔✔It contains a list of parameters that the query can search for
✔✔Chapter 1 The Query Template > Parameters:How can you tell which parameters
are searching the base search master file and which are networking out to additional
master files - ✔✔by looking at the Basic tab for each criterion.
✔✔Chapter 1 The Query Template > Parameters:On the Basic tab of the right hand
side, the Item field tells you the item number this parameter is searching. Since no
master file is specified, which master file is used? - ✔✔this is an item in the base search
master file.
✔✔Chapter 1 What are the three types of parameters that you will see on the Query
Template > Parameters form? - ✔✔*Simple Parameters evaluate an item in the search
master file.
*Networked Parameters evaluate an item in a different master file that can be
networked to from the search master file.
*Property parameters evaluate the results of a formula programmed in M code.
,✔✔Chapter 1 Query Parameter Wizard shows... - ✔✔The wizard shows all items from
the base search master file. Choose a networked item in the base search master file to
define a path to a new master file.
The networked items appear in blue text, have the Networked icon next to them, and
display the INI they
network to in parentheses.
✔✔Chapter 1 Modify the Default Settings of a Parameter: Multiple values - ✔✔Check
this box if the report user will be able to supply this parameter with multiple
operator/value combinations to find during the search
✔✔Chapter 1 Modify the Default Settings of a Parameter: Overtime criterion - ✔✔Check
this box if the item is an overtime item. This will cause an icon to appear to alert the
report writer that the criterion will be affected by the date/time range
✔✔Chapter 1 Modify the Default Settings of a Parameter: Related group - ✔✔Free text
value used to tie related parameters together. Any two parameters with the same
Related Group string are considered part of the same related group and
will be evaluated together at search time, meaning two things:
1. All criteria in the group must be met on the same contact
2. If criteria are part of a Chronicles related group, all criteria must be met on the same
line of the group
✔✔Chapter 1 Modify the Default Settings of a Parameter: If two criteria were not part of
a related group how are they evaluated? - ✔✔they would be evaluated separately
✔✔Chapter 1 Query Template: Search master file = EPT searches which records? -
✔✔patient records
✔✔Chapter 1 Query Template: Search on - Records how many times will a patient
appear? - ✔✔In the results of any report built from this template, a single patient will
only appear once.
✔✔Chapter 1 Query Template:: Set Search on to Contacts, how many times will
patients appear? - ✔✔modify the template to return one result for each patient contact
that meets the report's criteria
✔✔Chapter 1 Property Parameter: how does it work? - ✔✔Unlike simple and networked
parameters, property parameters compare a value to the results of a formula, instead of
comparing a value to a Chronicles item
✔✔Chapter 1 Property Parameter: what are the parts and how many? - ✔✔Property
parameters can consist of two parts: A Base property parameter which specifies the
,formula to be used, and ﴾optionally﴿ one or more Mnemonic parameters, which allow the
end user to specify variables to be used by the formula.
✔✔Chapter 1 review: What's the difference between a static and a dynamic report? -
✔✔The results of static reports are completely calculated and saved when run, and are
simply loaded when viewed. Dynamic reports only calculate which records or contacts
fit the report's criteria when run, and recalculate the contents of all columns each time
the report is viewed. Static reports take longer to run, dynamic reports take longer to
view.
✔✔Chapter 1 review: True or False. When creating a networked parameter, you can
only go through one networked link. For example, you could not link from EPT to ORD
to DEP. - ✔✔False. You can link up to four times for each parameter link.
✔✔Chapter 1 review: True or False. You can create a related group on the Criteria tab
that contains two single response items. - ✔✔True. The items that are part of a related
group on the Criteria tab do not have to have a response type of related group.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What controls the way the Report Settings window appears to end
users is controlled? - ✔✔Template the report was made from.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What does Query Template > Parameters form control? - ✔✔What
the search knows how to do
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - What does User Interface > Parameters form control? - ✔✔hich
options will be available to the end user in the
Report Settings window, and what parameters will be used by reports made from the
template at run time.
✔✔Chapter 2 -Changing the Way the End User Sees the Report
Settings Window - T or F, If we want a default value to be included in the search the
parameter must appear on the User Interface > Parameters form. - ✔✔T
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters- T or F, You can use the settings on the User Interface >
Parameters form to control how an end user will see
parameters on the Criteria tab. - ✔✔T
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Operator List- What operators are
, available on a contact based template? - ✔✔In a Contact‐based template, only the
following operator options are available:
Basic operator list
Don't show operator field
Equals and not equals operator
String operators
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- User can choose logic within
criteria, How does this work? - ✔✔If this is selected, the user will be able to choose
whether all of the values in a criterion must be found in order for the criterion to be
satisfied (AND logic), or only one (OR logic). If it's not selected, OR logic will be used.
This field should be cleared for single response parameters.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Visible - How does this work? -
✔✔When selected, the user can see and work with this parameter.
The parameter can also be marked as Default, however. If the parameter is marked as
default, it will still be evaluated
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Enabled - - ✔✔When selected, the
parameter can be edited by the user
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Changing the
Appearance of Parameters-Field Tab Settings- Restricted - - ✔✔If a parameter is
marked as Restricted, then the only people who can edit the parameter are users with
the security point Edit Restricted Parameters assigned to their RW Security Class.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- What do you use to control the appearance of the
Criteria Tab? - ✔✔Use the User Interface form to control the appearance of the Criteria
tab and what options the end user has in Report Settings.
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- Basic Information-Search hyperlink - - ✔✔Choose a
name for the link that appears on the Report Settings Criteria tab. This should be a word
or short phrase that answers the question "what does each row in the results of this
report represent".
✔✔Chapter 2 -Changing the Way the End User Sees the Report-Controlling
functionality in Report Settings- Basic Information- Description for hyperlink - ✔✔When
you click on the search hyperlink in the Criteria tab, this will display in a pop‐up window.
Use this field to provide detailed information about this report template
