STAF8050 - Maintain VET FEE-HELP Snapshot - VET only

Purpose To maintain data produced by the VET FEE-HELP Submission Snapshot (STAJ8050) and the VET FEE-HELP Revisions Submission Snapshot (STAJ8055).
SubSystem Statistics
Sector VET
Normally Run By Statistics specialist
Anticipated Frequency As required
Structure Blocks Submission
Submission Details

 

This form is used to maintain data produced by the VET FEE-HELP Submission Snapshot (STAJ8050) and the VET FEE-HELP Revisions Submissions Snapshot (STAJ8055). It allows administrators to:

  • query, view or change the Reporting Status of submission snapshot records, or
  • create a CSV output of the data.

As well as showing all the data produced by snapshots, the form also shows a summary of the data, including:

  • The number of students in the submission or revision.
  • Unreported records that were not included in a prior VET Enrolment (VEN) and/or VET Load Liability (VLL) File.

The user is able to select from the Submission Types and Submission Snapshots that currently exist in the snapshot tables.

The following Reporting Statuses can be set for any person level, course level or unit level record in any submission that has not been set as completed:

  • INCLUDE – The record will be included in the file creation process.
  • EXCLUDE – The record will not be included in the file creation process. Records marked as EXCLUDE will also be excluded from future snapshot processing within the context snapshot submission period.
  • RE-PROCESS – The record requires the snapshot process to be run over it again before the file creation process can create the files.

The main tables involved in STAF8050 are:

For more information, see STAJ8050.

This form is accessed through the main menu.

For more information about the VET FEE-HELP Reporting process see, Understanding VET Statistics.

 

The Submission block contains:

  • Submission Year (LOV)
  • Type (LOV)
  • Number (LOV)
  • Start Date
  • End Date
  • Description

Button:

  • Download Records

The Submission Details block contains:

Person Tab:

  • Person ID
  • Reporting Status (LOV)
  • Reporting Year
  • Given Name
  • Surname
  • Birth Date
  • Sex
  • Title
  • Other Names
  • Aborig Torres Code
  • Govt Aborig Torres Code
  • Citizenship Code
  • Govt Citizenship Code
  • Govt Home Location
  • Govt Term Location
  • Birth Country Code
  • Govt Birth Country Code
  • Year Arrival
  • Home Language Code
  • Govt Home Language Code
  • Govt Disability
  • Commencing Location
  • Commencing Geographic Location
  • Highest Attainment
  • Postal Address Line 1
  • Postal Address Line 2
  • Postal Address Suburb
  • Postal Address State
  • Postal Address Postcode
  • Postal Address Country
  • Residential Address Line 1
  • Residential Address Line 2
  • Residential Address Suburb
  • Residential Address State
  • Residential Address Postcode
  • Residential Address Country
  • CHESSN
  • USI

Course Tab:

  • Person ID
  • Reported Course Code
  • Reporting Status (LOV)
  • Reporting Year
  • Course Code
  • Version Number
  • Attendance Type
  • Govt Attendance Type
  • Commencement Date
  • Basis for Admission Type
  • Govt Basis for Admission
  • Prior Studies Exemption
  • Exemption Institution Code
  • Govt Exemption Institution
  • Govt Credit Used
  • Govt Credit Basis
  • VTE Field of Education
  • VTE Level Detail
  • Govt VTE Provider Type
  • Variation Reason Code
  • Study Reason ID
  • Labour Force Status ID
  • CHESSN

Unit Tab:

  • Person ID
  • Reported Course Code
  • Reported Unit Code
  • Reporting Status (LOV)
  • Unit Census Date
  • Course Code
  • Crv Version Number
  • Unit Code
  • Unit Version Number
  • Tr Org Unit Code
  • Tr Org Unit Start Date
  • Govt Org Unit Code
  • Cal Type
  • CL Seq Number
  • Unit of Study Cmpltn Status
  • Discipline Group Code
  • Govt Discipline Group Code
  • Attendance Mode
  • Govt Attendance Mode
  • Total EFTSL
  • Student Status
  • Govt Student Status
  • Variation Reason Code
  • New Record Ind
  • Authorising Officer Person ID
  • Campus Location
  • Total Amount Charged
  • Amount Paid Upfront
  • Loan Fee
  • Unit of Study Help Debt
  • CHESSN
  • RPL indicator

Rules/Notes:

The following two lamps may be displayed in the Submission block when a query has been performed:

  • Previously unreported students [number].
  • Number of included students [number].

The Type field is used to perform a query for a particular Submission Type. Examples are:

  • VS-RPT - (VET Reporting Snapshot)
  • VC-CMP-CRS - (VET Course Completions Snapshot)
  • VS-CMP-UNT - (VET Unit Completions Snapshot)
  • VS-REV - (VET Revision Snapshot)

For the following System Submission Types:

  • VS-RPT - Has records in all three snapshot tables: GOVT_SNAPSHOT_PE, GOVT_SNAPSHOT_SCA and GOVT_SNAPSHOT_SUA.
  • VS-REV
    • Variation Reason Code (GSSUA table) of 2, 5
      has records in all three snapshot tables: GOVT_SNAPSHOT_PE, GOVT_SNAPSHOT_SCA and GOVT_SNAPSHOT_SUA.
    • Variation reason code (GSSUA table) of 1,4 or new record indicator of ‘Y’ (GSSUA table)
      has records in the GOVT_SNAPSHOT_SUA table only.
  • VS-CPM-CRS - has records in GOVT_SNAPSHOT_SCA only.
  • VS-CPM-UNT - has records in GOVT_SNAPSHOT_SUA only.

The Number field is used to perform a query for a particular Submission number.

Enter the Calendar Year and Submission Number for each submission in a year.

The Download Records button enables the user to download the records to a CSV file and transfer it to the client. Details from all fields in the snapshot tables are included. For instructions see INQF12EO.

The download file will be in the format
 ‘STAF8050_’ || submission_type || ‘_’ || submission_year||submission_number||user||session.csv

Submission Details block:

It is possible to perform a query on any field in the Submission Details block.

The Reporting Status field displays the Reporting Status of the snapshot record. The status can be INCLUDE, EXCLUDE or RE-PROCESS. This field is updateable only for records that are not completed, i.e. if the submission has a Completion Date, the Reporting Status of a record cannot be updated.

Validations:

  • Records with a Reporting Status of EXCLUDE can only be set to RE-PROCESS.
  • Records with a Reporting Status of RE-PROCESS can only be updated to EXCLUDE.
  • The System Reporting Status must be open.

For validations, scenarios and information regarding Reporting Statuses, see Record Reporting Statuses.

If all the Govt. Snapshot SUA (GSSUA) data of a person for a course is updated to EXCLUDE, the GSSCA and Govt. Snapshot Person (GSP) data for this person will update to EXCLUDE. And if the GSP record that is parent to the GSSCA has no child record that will be reported, then the GSP of the person is also updated to EXCLUDE.

The csv file structure is listed in the table below.

Column No.

Title

Column

1

Submission Year

GOVT_SNAPSHOT_PE.SUBMISSION_YR

2

Submission Number

GOVT_SNAPSHOT_PE.SUBMISSION_NUMBER

3

Submission Type

GOVT_SNAPSHOT_PE.S_SUBMISSION_TYPE

4

Person ID

GOVT_SNAPSHOT_PE.PERSON_ID

GOVT_SNAPSHOT_PE

5

PE Reporting Status

GOVT_SNAPSHOT_PE.S_REPORTING_STATUS

6

Reporting Year

GOVT_SNAPSHOT_PE.REPORTING_YR

7

Birth Date

GOVT_SNAPSHOT_PE.BIRTH_DT

8

Sex

GOVT_SNAPSHOT_PE.SEX

9

Title

GOVT_SNAPSHOT_PE.TITLE

10

Surname

GOVT_SNAPSHOT_PE.SURNAME

11

Given Name

GOVT_SNAPSHOT_PE.GIVEN_NAME

12

Other Names

GOVT_SNAPSHOT_PE.OTHER_NAMES

13

Aborig Torres Code

GOVT_SNAPSHOT_PE.ABORIG_TORRES_CD

14

Govt Aborig Torres Code

GOVT_SNAPSHOT_PE.GOVT_ABORIG_TORRES_CD

15

Citizenship Code

GOVT_SNAPSHOT_PE.CITIZENSHIP_CD

16

Govt Citizenship Code

GOVT_SNAPSHOT_PE.GOVT_CITIZENSHIP_CD

17

Govt Home Location

GOVT_SNAPSHOT_PE.GOVT_HOME_LOCATION

18

Govt Term Location

GOVT_SNAPSHOT_PE.GOVT_TERM_LOCATION

19

Birth Country Code

GOVT_SNAPSHOT_PE.BIRTH_COUNTRY_CD

20

Govt Birth Country Code

GOVT_SNAPSHOT_PE.GOVT_BIRTH_COUNTRY_CD

21

Year Arrival

GOVT_SNAPSHOT_PE.YR_ARRIVAL

22

Home Language Code

GOVT_SNAPSHOT_PE.HOME_LANGUAGE_CD

23

Govt Home Language Code

GOVT_SNAPSHOT_PE.GOVT_HOME_LANGUAGE_CD

24

Govt Disability

GOVT_SNAPSHOT_PE.GOVT_DISABILITY

25

Commencing Location

GOVT_SNAPSHOT_PE.COMMENCING_LOCATION

26

Commencing Geographic Location

GOVT_SNAPSHOT_PE.COMMENCING_GEOGRAPHIC_LOCATION

27

Highest Attainment

GOVT_SNAPSHOT_PE.HIGHEST_ATTAINMENT

28

Postal Address Line 1

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_LINE_1

29

Postal Address Line 2

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_LINE_2

30

Postal Address Suburb

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_SUBURB

31

Postal Address State

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_STATE

32

Postal Address Postcode

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_POSTCODE

33

Postal Address Country

GOVT_SNAPSHOT_PE.POSTAL_ADDRESS_COUNTRY

34

Residential Address Line 1

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_LINE_1

35

Residential Address Line 2

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_LINE_2

36

Residential Address Suburb

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_SUBURB

37

Residential Address State

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_STATE

38

Residential Address Postcode

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_POSTCODE

39

Residential Address Country

GOVT_SNAPSHOT_PE.RESIDENTIAL_ADDRESS_COUNTRY

40

CHESSN

GOVT_SNAPSHOT_PE.CHESSN

41

USI

GOVT_SNAPSHOT_PE.PERSON_USI

GOVT_SNAPSHOT_SCA

42

SCA Reporting Status

GOVT_SNAPSHOT_SCA.S_REPORTING_STATUS

43

Course Code

GOVT_SNAPSHOT_SCA.COURSE_CD

44

Crv Version Number

GOVT_SNAPSHOT_SCA.CRV VERSION NUMBER

45

Reporting Year

GOVT_SNAPSHOT_SCA.REPORTING_YR

46

Reported Course Code

GOVT_SNAPSHOT_SCA.REPORTED_COURSE_CD

47

Attendance Type

GOVT_SNAPSHOT_SCA.ATTENDANCE_TYPE

48

Govt Attendance Type

GOVT_SNAPSHOT_SCA.GOVT_ATTENDANCE_TYPE

49

Commencement Date

GOVT_SNAPSHOT_SCA.COMMENCEMENT_DT

50

Basis For Admission Type

GOVT_SNAPSHOT_SCA.BASIS_FOR_ADMISSION_TYPE

51

Govt Basis For Admission

GOVT_SNAPSHOT_SCA.GOVT_BASIS_FOR_ADMISSION

52

Prior Studies Exemption

GOVT_SNAPSHOT_SCA.PRIOR_STUDIES_EXEMPTION

53

Exemption Institution Code

GOVT_SNAPSHOT_SCA.EXEMPTION_INSTITUTION_CD

54

Govt Exemption Institution

GOVT_SNAPSHOT_SCA.GOVT_EXEMPTION_INSTITUTION

55

Govt Credit Used

GOVT_SNAPSHOT_SCA.GOVT_CREDIT_USED

56

Govt Credit Basis

GOVT_SNAPSHOT_SCA.GOVT_CREDIT_BASIS

57

VTE Field Of Education

GOVT_SNAPSHOT_SCA.VTE_FIELD_OF_EDUCATION

58

VTE Level Detail

GOVT_SNAPSHOT_SCA.VTE_LEVEL_DETAIL

59

Govt VTE Provider Type

GOVT_SNAPSHOT_SCA.GOVT_VTE_PROVIDER_TYPE

60

Variation Reason Code

GOVT_SNAPSHOT_SCA.VARIATION_REASON_CD

61

Study Reason Id

GOVT_SNAPSHOT_SCA.STUDY_REASON_ID

62

Labour ForceStatus ID

GOVT_SNAPSHOT_SCA.LABOUR_FORCE_STATUS_ID

63

CHESSN

GOVT_SNAPSHOT_SCA.CHESSN

GOVT_SNAPSHOT_SUA

64

SUA Reporting Status

GOVT_SNAPSHOT_SUA.S_REPORTING_STATUS

65

Course Code

GOVT_SNAPSHOT_SUA.COURSE_CD

66

Crv Version Number

GOVT_SNAPSHOT_SUA.CRV_VERSION_NUMBER

67

Unit Code

GOVT_SNAPSHOT_SUA.UNIT_CD

68

Uv Version Number

GOVT_SNAPSHOT_SUA.UV_VERSION_NUMBER

69

Unit Census Date

GOVT_SNAPSHOT_SUA.UNIT_CENSUS_DT

70

Tr Org Unit Code

GOVT_SNAPSHOT_SUA.TR_ORG_UNIT_CD

71

Tr Org Unit Start Date

GOVT_SNAPSHOT_SUA.TR_ORG_UNIT_START_DT

72

Govt Org Unit Code

GOVT_SNAPSHOT_SUA.GOVT_ORG_UNIT_CD

73

Cal Type

GOVT_SNAPSHOT_SUA.CAL_TYPE

74

Ci Sequence Number

GOVT_SNAPSHOT_SUA.CI_SEQUENCE_NUMBER

75

Reported Course Code

GOVT_SNAPSHOT_SUA.REPORTED_COURSE_CD

76

Reported Unit Code

GOVT_SNAPSHOT_SUA.REPORTED_UNIT_CD

77

Unit Of Study Cmpltn Status

GOVT_SNAPSHOT_SUA.UNIT_OF_STUDY_CMPLTN_STATUS

78

Discipline Group Code

GOVT_SNAPSHOT_SUA.DISCIPLINE_GROUP_CD

79

Govt Discipline Group Code

GOVT_SNAPSHOT_SUA.GOVT_DISCIPLINE_GROUP_CD

80

Attendance Mode

GOVT_SNAPSHOT_SUA.ATTENDANCE_MODE

81

Govt Attendance Mode

GOVT_SNAPSHOT_SUA.GOVT_ATTENDANCE_MODE

82

Total EFTSL

GOVT_SNAPSHOT_SUA.TOTAL_EFTSL

83

Student Status

GOVT_SNAPSHOT_SUA.STUDENT_STATUS

84

Govt Student Status

GOVT_SNAPSHOT_SUA.GOVT_STUDENT_STATUS

85

Variation Reason Code

GOVT_SNAPSHOT_SUA.VARIATION_REASON_CD

86

New Record Ind

GOVT_SNAPSHOT_SUA.NEW_RECORD_IND

87

Authorising Officer Person ID

GOVT_SNAPSHOT_SUA.AUTHORISING_OFFICER_PERSON_ID

88

Campus Location

GOVT_SNAPSHOT_SUA.CAMPUS_LOCATION

89

Total Amount Charged

GOVT_SNAPSHOT_SUA.TOTAL_AMOUNT_CHARGED

90

Amount Paid Upfront

GOVT_SNAPSHOT_SUA.AMOUNT_PAID_UPFRONT

91

Loan Fee

GOVT_SNAPSHOT_SUA.LOAN_FEE

92

Unit Of Study Help Debt

GOVT_SNAPSHOT_SUA.UNIT_OF_STUDY_HELP_DEBT

93

CHESSN

GOVT_SNAPSHOT_SUA.CHESSN

94

RPL

GOVT_SNAPSHOT_SUA.PRIOR_LEARNING_RECOGNITION_CD

Last Modified on 15-Sep-2014 8:47 AM

History Information

Release Version: Project: Change to Document:
18.0.0.2 & 18.1.0.0 2089 - Compliance Added USI
17.0.0.2 1953 - VET RPL Added RPL indicator
13.1 1323 - Online Help consolidation Converted to standard style. Added VET label
12.0.0.3 1646 - Skills Vic FEE-HELP Reporting

New Help page