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.
The TL and TR files are populated with student data from the existing government snapshot tables and includes the student’s unencrypted Tax File Number.

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:

  • Create Government Submission Snapshot (STAJ0110)
  • Create OS-HELP File (STAJ0160)
  • Create SA-HELP File (STAJ0180)
  • Create Government Revision Submission Snapshot (STAJ1610)
  • Create VET Student Loans Submission Snapshot (STAJ8050)
  • VET Student Loans Revision Submission Snapshot (STAJ8055)

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

Parameters

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

    OR

  • Previous Log Creation Date

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:

  • The file name of the Tax File Number Lookup file is: HHHHTLYYYY.PNNNNN
    where:
    • HHHH = Government Institution Code
    • TL= TFN Lookup File Type abbreviation code
    • YYYY = Reporting Year - (always 0000)
    • P = Reporting Period - (1 or 2)
    • NNNNN = Submission Number - (00001 – 99999)

    e.g. 1234TL0000.100001

  • The file name of theTax File Number Revision file is: HHHHTRYYYY.PNNNNN
    where:
    • HHHH = Higher Education Provider Code - (Institution Code)
    • TR = TFN Revision File Type abbreviation code
    • YYYY = Reporting Year - (always 0000)
    • P = Reporting Period - (always 0)
    • NNNNN = Submission Number - (00001 – 99999)

For example, 1234TR0000.000001

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:

  • The Student Status (ENRF3110) for HECS-HELP, FEE-HELP and VET Student Loan records.
  • SA-HELP Application (ENRF3240) for SA-HELP records
  • Student Course External Study Loan (ENRF3900) for OS-HELP records.
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