This job creates an extract containing all the relevant information that Health Care Providers require to include in hard copy of reports on International Students health care cover and payments to the Institution's health care provider.

It extracts a range of data (pertaining to a student) from the Callista database tables and includes the data in the extract.
The extract, depending on parameters, contains details of applicants who have paid their OSHC in full. It contains either new records or renewals. If a student has already paid, and is renewing their policy with an updated premium, the extract records the extra charge.
The extract uses the HEALTH_CARE_COVER_REPORT_DTL tables, which has columns matching the fields required by the Health Care provider. The table also stores the Job Request Number, Creation Date Logical Delete Date and Submitted Date for each record.

S_LOG_ENTRY data will be created with S_LOG_TYPE = OSHC_COVER.
Note in all entries to the log, the Person ID and Provider Code will be recorded in addition to the validation message number.

This Job is accessed via the main menu.

The Overseas Health Care Cover Extract block contains:

Parameters Tab

• Health Care Provider Code
• Person ID
• Fee Type
• Fee Type Calendar
• Cover Start Date From
• Cover Start Date To
• Sort By

Rules/Notes:

• All fields are mandatory except the 'Cover Start Date To' field.
• If only the 'Cover Start Date From' value is defined, then only records with that date, where a fee has been generated, will be included.
  If the 'Cover Start Date From' and 'Cover Start Date To' value defined, all records on or between those dates, where a fee has been generated, will be included.

The following messages may be generated in the log during the running of this job.

• The Person has overlapping Admission Application Letter Health Care records. The student will not be extracted.
• A previous extract for the Person and provider code is not yet set to submitted. The student will not be extracted.
• The fee is not greater than the total previously reported. The student will not be extracted.
• The total fee assessment for the health cover fee type is not equal to the total Health Cover Amount recorded in Admission Application Letter Health Care records. The student will not be extracted.
• Student Has Been Extracted.
• The student is to be reported as RENEWAL policy type but does not have a policy number recorded in the system. The student will not be extracted.
• The student’s policy end date is not later than the date already reported. The student will not be extracted.
• The student’s calculated policy duration is not greater than the amount already reported. The student will not be extracted.
• The Health Cover type has changed since the previous extract. Policy Start and End Dates have been re-derived.