Purpose

To display a set of overseas student health care cover records and allow them to be marked as:

• Submitted where they have been successfully submitted to the Institution's Health Care provider or
• Deleted where the submission was unsuccessful or incorrect.

Anticipated Frequency

As required

Structure

Blocks

Buttons

This form displays data extracted from the Callista database tables by ADMJ6000 - Overseas Health Cover Extract job.This job populates the the HEALTH_CARE_COVER_REPORT_DTL table which includes information that Health Care Providers require for reports for health care cover and payments for International Students.

In this form a user can:

• Logically delete a record – this marks the record as deleted by recording a LOGICAL_DELETE _DT value. The form hides any logically deleted records by default, but can optionally display them.
• Mark an individual record as submitted/not submitted - the user can enter a date, or remove a date in the Submitted Date on a record.
• Mark records as submitted in bulk – The user can mark all non-deleted, non-submitted records for a particular job run as submitted at a defined date. This will put the defined date into the submitted date field for each non-deleted, non-submitted record.

Accessing this form:

This form is accessed via the Callista menu.

Health Care Cover Reporting Block

• Include Deleted Health Care Records check box
• Person ID
• Submitted Date
• Request Job Run ID
• Provider Code
• Policy Type
• Health Care Type
• Surname
• Given Names
• OSHC Premium
• Start Date
• Visa Expiry Date
• Cover Length
• Health Care Number
• Sponsor Paid
• Logical Delete Date
• Selected Request Job Run ID
• Submission Date

Buttons

• Apply Submission Date

Notes/Details:

The 'Include Deleted Health Care Records' check box controls whether logically deleted records are returned as part of queries in this form.

To mark a record as submitted:

• Go to ADMF3950.
• Query for required student.
• In the required Health Care Cover record, insert a date in the Submitted Date field.
• Save.

Notes/Details:

• Go to ADMF3950.
• Query for required student.
• Select the Health Care Cover record to be deleted.
• Click on the Delete toolbar button (or Shift/F6).
• Confirm that you wish to delete the record.

Notes/Details:

Today's date is inserted for the Logical Delete Date field for that record.
If you confirm the deletion, the record will not redisplay unless the Include Deleted Health Care Records check box is selected when you query in this form.

To mark records as submitted in bulk:

• Go to ADMF3950.
• Select a Request Job Run ID .
• Record a date in Submission Date.
• Click on the Apply Submission Date button.

Notes/Details:

The Submitted Date will only be updated for records which don't have a Submitted Date and are not logically deleted: