PRINT MEDICAL DEPENDENTS REPORT

Use this screen to print information about employees and their covered dependents.

You can print or view the Medical Dependents Report at any time.

If you have not been set up to print Social Security Numbers (SSNs), blanks print instead of the numbers. The ability to print SSNs is controlled by the Suppress SSN checkbox in the Maintain Users screen in Costpoint System Administration.

Sort

Use the selections in this group box to control the order in which information prints on the report.

Employee Name

Select this radio button to print information on the report in order by employee name.

Employee ID

Select this radio button to print information on the report in order by employee ID number.

Select

Use this group box to define the effective date and range of employees and benefit plans you want printed on the report.

Effective Date

Enter the effective date of this report in MM/DD/YYYY format. The system uses this date to determine which dependents to include on the report. It compares the Effective Date to the dependent's End Date in the Assign Dependents to Benefit Plans screen in Costpoint Employee. This field is required.

Employee

Use this group box to define the range of employees you want included in this report.

Range Option

Use the drop-down box to select a range option. Valid options are "All," "One," "Range," "From Beginning" and "To End."

From

If you selected "One" in the Range Option field, enter, or use Lookup to select, the ID number of the employee for whom you wish to print information on medical dependents. If you selected "Range" or "To End" in the Range Option field, enter, or use Lookup to select, the lowest ID number in the range of employees you want printed on the report.

To

If you selected "Range" or "From Beginning" in the Range Option field, enter, or use Lookup to select, the highest ID number in the range of employees you want printed on the report.

Benefit Plan

Use this group box to define the range of benefit plans you want printed on this report.

Range Option

Use the drop-down box to select a range option. Valid options are "All," "One," "Range," "From Beginning" and "To End."

From

If you selected "One" in the Range Option field, enter, or use Lookup to select, the code for the benefit plan for which you wish to print information on medical dependents. If you selected "Range" or "To End" in the Range Option field, enter, or use Lookup to select, the lowest code in the range of benefit plans you want printed on the report.

To

If you selected "Range" or "From Beginning" in the Range Option field, enter, or use Lookup to select, the highest code in the range of benefit plans you want printed on the report.

Report Sources

Column Heading

Screen

Table Name

Dependent

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Dependent Name

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Dependent SSN

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Relationship

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Sex

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Birth Date

Employee Dependents/Beneficiaries

HB_EMPL_DEP_BNFIC

Coverage Option

Assign Dependents to Benefit Plans

HB_EMPL_MED_DEP

Start Date

Assign Dependents to Benefit Plans

HB_EMPL_MED_DEP

End Date

Assign Dependents to Benefit Plans

HB_EMPL_MED_DEP

Employee ID  

Basic Employee Info 

EMPL

Employee Name

Basic Employee Info

EMPL

Benefit Plan Code

Employee Benefit Elections

HB_EMPL_PKG_ELEC

Benefit Plan Description

Employee Benefit Elections

HB_EMPL_PKG_ELEC