STAJ0160 - Create OS-HELP File

Purpose

To create the OS-HELP file (and if required, the OS-HELP Revisions file) for submission to DIISRTE.

SubSystem

Statistics

Normally Run By Statistics Specialist
Anticipated Frequency As required
Structure Block Create OS-HELP File
Tab Parameters

 

This job enables the creation of the OS-HELP file ('OS' file type) that is reported to DIISRTE and validated through HEPCAT software. It creates a snapshot of the data that is to be included in the extract file so that a record of the reported data is maintained.

It also creates the extract file and saves it to the KEEP directory specified in S_JOB_CONTROL.

This job can also be run with a System Submission Type of REVISION which allows it to process Revision details and produce the OS-HELP REVISION (RO) file.

For insights into Statistics, see the 'Understanding HE Statistics' (STAINTR3) Help page.

This job is accessed via the main menu.

 

The Create OS-HELP File block contains:

Tab

Parameters

  • Submission Year
  • System Submission Type
  • Submission Number
  • Start Date
  • End Date

Rules/Notes:

All parameters are mandatory.

To Create a Unit of Study Completions File:

Select the Submission Year, System Submission Type and Submission number, then run the job.

Filenames:

  • The file name of the OS-HELP file is: HHHHXXYYYY.PNNNNN
    where:
    • HHHH = Higher Education Provider Code - (Institution Code)
    • XX = File Type abbreviation code - (File Type code is not case sensitive), i.e. OS
    • YYYY = Reporting Year - (must be >=2011)
    • P = Reporting Period - (1 or 2)
    • NNNNN = Submission Number - (00001 – 99999)

    For example, 1234OS2011.100001

  • The file name of the OS-HELP REVISION file is: HHHHXXYYYY.PNNNNN
    where:
    • HHHH = Higher Education Provider Code - (Institution Code)
    • XX = File Type abbreviation code - (File Type code is not case sensitive), i.e. RO
    • YYYY = Reporting Year - (always 0000)
    • P = Reporting Period - (always 0)
    • NNNNN = Submission Number - (00001 – 99999)

For example, 1234RO0000.000001

Note: The Submission Number used in the file name is the Submission Number defined in STAF1350 – Government Snapshot Control.

Rules/Notes:

Output is in the format as specified by DIISRTE.

Submission Year, Type and Number combination must exist as a Government Submission Control record with a System Submission Type of OS-HELP or REVISION in STAF1350. There must not be a Completion Date recorded for this record.

 

Element Element No Position Width Type
Student Identification Number 313 2-11 10 Alphanumeric
Course Code 307 12-21 10 Alphanumeric
CHESSN 488 22-31 10 Numeric
OS-HELP Payment Amount 528 32-39 8 Numeric
OS-HELP Study Period Commencement Date 521 40-47 8 Alphanumeric
Loan Fee 529 48-55 8 Numeric
OS-HELP Debt Incurral Date 527 56-63 8 Alphanumeric
Student Status 490 64-66 3 Numeric
OS-HELP Country of Study Code - Primary 553 67-70 4 Alphanumeric
OS-HELP Country of Study Code - Secondary 554 71-74 4 Alphanumeric
Filler N/A 75-114 50 Alphanumeric

 


Last Modified on 16-May-2012 2:00 PM

History Information

Release Version Project Change to Document
12.1.1.0 1708 - Compliance 2011 - Calipso 31933 Updated DIISRTE file naming convention.
11.1 1505 - DIISRTE Complience Increased the number of filler spaces at the end of the file
10.1 1340 DIISRTE 2007 Pt 2

Removed redundant parts of file structure