| Top of STA | Index | Table of Contents | Feedback | ![]() |
STAJ0190 - Create Tax File Number Look Up and Revision
| Purpose | To create a TFN LookUp (TL) and TFN REvision (TR) files for submission to the Government. | |
| SubSystem | Statistics | |
| Normally Run By | Statistics Specialist | |
| Anticipated Frequency | As required | |
| Structure | Block | Create Tax File Number Look Up and Revision |
| Tab | Parameters | |
This new function enables the creation of the TFN LookUp (TL) and TFN Revision (TR) files for submission to the government. Institutions receive an email from HEIMS, advising when records that have been submitted via either file have failed verification with the ATO. Records failing verification can be viewed online via the Higher Education Provider Client Assistance Tool (HEPCAT). Student records are identified for submission years and periods by the following government snapshot processes:
For further information about Statistics processes, see the 'Understanding HE Statistics' (STAINTR3) Help page. This job is accessed via the main menu and can only be run in Scheduled mode. |
The Create OS-HELP File block contains: Tab
|
Rules/Notes: Parameters provide options to select a TL or TR file, the type of government submissions to be included and the submission year and number. Validation errors generated by the job are recorded within an exception report. A previous exception report can be produced by selecting it in the Previous Log Creation Date field. The Start Date/End Date fields are populated for the Submission selected. |
To Create an Tax File Number Lookup or Revision File: Select the File Type, Submission Year, System Submission Type and Submission number, then run the job. Filenames:
|
Rules/Notes: The job counts previous submissions to determine the submission number for the file name (for TL or TR files) and then adds 1 to determine the submission number for the file name.
|
TFN LookUp (TL) and TFN Revision (TR) File Structure
| Element | Element No | Position | Width | Callista Source |
| Student identification code | 313 | 1-10 | 10 | PERSON.PERSON_ID |
| Tax file number | 416 | 11-21 | 11 | The unencrypted Tax File Number is sourced from: |
| Date of birth | 314 | 22-29 | 8 | PERSON.BIRTH_DT |
| Filler 26 spaces | NA | 30-55 | 26 | Not Applicable |
| Student surname | 402 | 56-85 | 30 | PERSON.SURNAME |
| Student given name - first | 403 | 86-100 | 15 | stap_get_prsn_names |
| Student given name - others | 404 | 101-130 | 30 | stap_get_prsn_names |
| Filler 130 spaces | NA | 131-260 | 130 | Not Applicable |
| Address of permanent home residence – part 1 | 410 | 261-298 | 38 | PERSON_ADDR_GOVT_PERM_V |
| Address of permanent home residence – part 2 | 411 | 299-336 | 38 | PERSON_ADDR_GOVT_PERM_V |
| Residential address – suburb/town | 469 | 337-363 | 27 | PERSON_ADDR_GOVT_PERM_V |
| Residential address – state | 470 | 364-366 | 3 | PERSON_ADDR_GOVT_PERM_V |
| Address of permanent home residence – postcode | 413 | 367-370 | 4 | PERSON_ADDR_GOVT_PERM_V |
| Residential address – country name | 471 | 371-390 | 20 | PERSON_ADDR_GOVT_PERM_V |
| Filler 19 spaces | NA | 391-409 | 19 | Not Applicable |
Last Modified on 03-Aug-2018 2:03 PM
History Information
| Release Version | Project | Change to Document |
| 19.1.0.3, 20.0.0.3 & 21.0.0.0 | 2340 Compliance 2018 | New Help page |