Top of STA | Index | Table of Contents | Feedback |
STAJ0160 - Create OS-HELP File
Purpose | To create the OS-HELP file (and if required, the OS-HELP Revisions file) for submission to the Government. | |
SubSystem | Statistics | |
Normally Run By | Statistics Specialist | |
Anticipated Frequency | As required | |
Structure | Block | Create OS-HELP File |
Tab | Parameters |
This job creates a snapshot records (GOVT_EXTRNL_STUDY_LOAN_SNPSHT table) and produces an OS-HELP (OS) file or OS-HELP REVISION (RO) file. depending io the Submission Type parameter selected. These files are saved in the KEEP directory specified in the S_JOB_CONTROL table and are reported to the Government . Typical processing sequence for STAJ0160 OS-HELP submission type: Typical processing sequence for STAJ0160 REVISION submission type: A student's OS-HELP is recorded in ENRF3900 with a Student Status of 240, 241 or 242. Each record in the OS-HELP snapshot, the OS and the RO file represents a single OS-HELP, Asian Studies OS-HELP or OS-HELP Language Supplement loan. Hence some students may have multiple OS-HELP records (with statuses of 241 and 242). 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
|
Rules/Notes: Submission Type may be OS-HELP or REVISION. |
To Create an OS-HELP or OS-HELP REVISION File: Select the Submission Year, System Submission Type and Submission number, then run the job. Filenames:
Note: The Submission Number used in the file name is the Submission Number defined in STAF1350 – Government Snapshot Control. |
Rules/Notes: 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. In that form there must not be a Completion Date recorded for this record.
|
OS-HELP (OS) and OS-HELP Revision (RO) File Structure
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 50 spaces | N/A | 75-123 | 50 | Alphanumeric |
OS-HELP Language Code | 582 | 124-127 | 4 | Numeric |
OS-HELP Language Study Commencement Date | 583 | 128-135 | 8 | Numeric |
Multiple records may be reported for a student course course attempt in an OS-HELP study period, if the student has student statuses of 241 and 242.
For the OS-HELP Language Code element (582):
If Student Status is 242, the OS-HELP Language code will be the govt code corresponding to the language recorded for the student Course Attempt in ENRF3900; otherwise the value is 9999.
For the OS-HELP Language - Study Commencement Date (583):
If Student Status is 242, the OS‑HELP Language study commencement date is that recorded for the Student Course Attempt in ENRF3900 (with the date format YYYYMMDD); otherwise the value is 00000000.
For the OS-HELP Primary Country of study (553):
If Student Status is 242, the primary country of study is 0000; otherwise it is the govt country code corresponding to the country code recorded for the student Course Attempt in ENRF3900.
For the OS-HELP Secondary Country of study (554):
If Student Status is 242 the secondary country of study is 0000; otherwise, if the secondary study code is blank for the Student Course Attempt in ENRF3900 then the secondary country of study is 0001, otherwise it is the govt country code corresponding to the country code recorded for the Student Course Attempt in ENRF3900
Last Modified on 27-Feb-2018 4:04 PM
History Information
Release Version | Project | Change to Document |
15.1.0.3, 16.0.0.3 & 16.1.0.2 | 1999 - Compliance 2014 | Added new fields to the file structure and information about how the system handle multiple OS-HELP records. |
12.1.1.0 | 1708 - Compliance 2011 - Calipso 31933 | Updated file naming convention. |
11.1 | 1505 - Compliance | Increased the number of filler spaces at the end of the file |
10.1 | 1340 Compliance 2007 Pt 2 | Removed redundant parts of file structure |