TCSI File Overview and Logic Requirements
The TCSI integration will sync the following TCSI records:
- Course
- Course included when set as VSL or Fee Help Eligible
- Campus (Location)
- Location included once linked to a Course Offer > Unit of Study
- Student (Learner)
- Learner included once linked to a reportable Course Enrolment
- CHESSN is auto populated if applicable
- Course Admission (Course Enrolment)
- Course Enrolment included if
- Course Enrolment is VSL eligible or any HE enrolment
- Links to at least one reportable Unit of Study
- Course Enrolment included if
- Unit Enrolment (Unit of Study Enrolment)
- Unit of Study Enrolment included when
- Linked Course Enrolment is VSL eligible or any HE enrolment
- The Unit Of Study Enrolment has a Completion status other than empty or 9
- Unit of Study Enrolment included when
- Course Of Study – HEP only
- All Course Of Study records are included
- Courses on Campus – HEP only
- This must be completed via the TCSI Data Entry tool
- Exit Award – HEP only
- See Exit Award
Learn how the TCSI Integration Works
TCSI Elements and Wisenet Mapping
This mapping lists the Elements reported to TCSI for VSL and HE and where to find them in Wisenet. It also indicates what file the element is included in.
The official Element Specification is available on the TCSI Support website.
Element Number | Element Name | TCSI File | Wisenet Field | Wisenet Section | VSL | HE | PIR | Notes |
---|---|---|---|---|---|---|---|---|
E313 | Student Identification Code | Student | Ref Export | Learner > Personal | Y | Y | Y | |
E314 | Date of Birth | Student | DOB | Learner > Personal | Y | Y | Y | |
E402 | Student family name | Student | Last Name | Learner > Personal | Y | Y | Y | |
E403 | Student given name first | Student | First Name | Learner > Personal | Y | Y | Y | |
E404 | Student given name others | Student | Middle Name | Learner > Personal | Y | Y | Y | |
E410 | Residential Address Street | Student | Permanent Address 1 | Learner > Personal | Y | Y | Y | |
E469 | Residential address suburb | Student | Permanent Address Suburb/Town | Learner > Personal | Y | Y | Y | |
E470 | Residential address state | Student | Permanent Address State | Learner > Personal | Y | Y | Y | |
E658 | Residential Address country code | Student | Permanent Address Country | Learner > Personal | Y | Y | Y | |
E320 | Residential Address Postcode | Student | Permanent Address Postcode | Learner > Personal | Y | Y | Y | |
E416 | Tax File Number | Student | TFN | Learner > Personal | Y | Y | N | |
E488 | CHESSN | Student | CHESSN | Learner > Personal | Y | Y | N | |
E584 | Unique Student Identifier | Student | USI | Learner > Personal | Y | Y | Y | |
E315 | Gender Code | Student | Gender | Learner > Personal | Y | Y | Y | |
E316 | Aboriginal and Torres Strait Islander Code | Student | Indigenous Status | Learner > Demographics | Y | Y | Y | |
E346 | Country of Birth Code | Student | Country of Birth | Learner > Demographics | Y | Y | Y | |
E347 | Year of Arrival in Australia | Student | Year Arrived In Australia | Learner > Demographics | Y | Y | Y | |
E348 | Language Spoken at Home | Student | Language | Learner > Demographics | Y | Y | Y | |
E572 | Year Left School | Student | Year Left School | Learner > Demographics | Y | Y | Y | |
E612 | Level left school | Student | Highest School Level | Learner > Demographics | Y | Y | Y | |
E573 | Highest Attainment code parent 1 | Student | Parent Education Level 1 | Learner > Demographics | N | Y | Y | |
E574 | Highest Attainment code parent 2 | Student | Parent Education Level 2 | Learner > Demographics | N | Y | Y | |
E319 | Term address postcode | Student | Street Address Postcode | Learner > Personal | Y | Y | Y | |
E661 | Term Address Country Code | Student | Street Address Country | Learner > Personal | Y | Y | Y | |
E358 | Citizen resident code | Student | Citizen Resident Section | Learner > Demographics | Y | Y | Y | |
E609 | Citizenship Effective From date | Student | Citizen Resident Section | Learner > Demographics | Y | N | Y | Enter Enrolment Date for Citizens by Birth |
E615 | Disability code | Student | Disability Section | Learner > Demographics | Y | Y | N | |
E609 | Disability Effective From date | Student | Disability Section | Learner > Demographics | Y | Y | Y | |
E610 | Disability Effective To date | Student | Disability Section | Learner > Demographics | Y | Y | Y | |
E313 | Student Identification Code | Course Admission | Ref Export | Learner > Personal | Y | Y | Y | |
E307 | Course Code | Course Admission | Course Code | Course | Y | Y | Y | |
E534 | Course of Study Commencement Date | Course Admission | Start date | Learner > Course Enrolment | Y | Y | Y | |
E330 | Type of Attendance Code | Course Admission | Attendance Type | Learner > Course Enrolment | Y | Y | Y | |
E632 | ATAR | Course Admission | ATAR | Learner > Demographics | N | Y | Y | |
E605 | Selection Rank | Course Admission | Selection Rank | Learner > Demographics | N | Y | Y | |
E620 | Highest Attainment Code | Course Admission | Highest attainment set in Prior Education section | Learner > Demographics | Y | Y | Y | |
E575 | Study Reason Code | Course Admission | Study Reason | Learner > Course Enrolment | Y | N | N | |
E576 | Labour force status code | Course Admission | Labour Force Status | Learner > Demographics | Y | N | N | |
E599 | Course Outcome Code | Course Admission | Course Outcome | Learner > Course Enrolment | Y | Y | Y | |
E592 | Course Outcome Date | Course Admission | ActualEndDate where QualIssuedFlag = True | Learner > Course Enrolment | Y | Y | Y | |
E327 | Basis for Admission code | Course Admission | Admission Basis | Learner > Demographics | Y | Y | Y | |
E560 | Credit Used Value | Course Admission | Auto calculated based on sum of EFTSL for all units of study granted Credit / RPL | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E561 | Credit Basis Code | Course Admission | Credit / RPL Status | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E566 | Credit Provider code | Course Admission | Where was Credit / RPL Offered? | Learner > Course Enrolment > UoS Enrolment | N | Y | Y | |
E463 | Specialisation Code | Course Admission | Specialisation Field of Education | Learner > Course Enrolment | N | Y | Y | |
E593 | HDR end user engagement code | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E609 | HDR end user engagement effective from date | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E610 | HDR end user engagement Effective To Date | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E487 | Scholarship type | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E609 | Scholarship effective from date | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E610 | Scholarship Effective To Date | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E623 | RTP stipend amount | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E415 | Reporting Year | Course Admission | N/A | N | Y | N | Not supporting for v1 | |
E591 | HDR thesis submission date | Course Admission | N/A | N | Y | Y | Not supporting for v1 | |
E594 | HDR primary field of research code | Course Admission | N/A | N | Y | Y | Not supporting for v1 | |
E595 | HDR secondary field of research code | Course Admission | N/A | N | Y | Y | Not supporting for v1 | |
E313 | Student Identification Code | Unit Enrolment | Ref Export | Learner > Personal | Y | Y | Y | |
E307 | Course Code | Unit Enrolment | Course Code | Course | Y | Y | Y | |
E534 | Course of Study Commencement date | Unit Enrolment | Start Date | Learner > Course Enrolment | Y | Y | Y | |
E625 | Delivery Location Code | Unit Enrolment | Delivery Location Code | Course Offer > UoS | Y | N | N | |
E354 | Unit of Study Code | Unit Enrolment | Unit of Study Code | Course Offer > UoS | Y | Y | Y | |
E464 | Discipline Code | Unit Enrolment | Field of Education | Course Offer > UoS | Y | Y | Y | |
E337 | Work Experience In Industry Code | Unit Enrolment | Work Experience Indicator | Course Offer > UoS | N | Y | Y | |
E551 | Summer and Winter School Code | Unit Enrolment | Summer/Winter School | Course Offer > UoS | N | Y | N | |
E622 | Unit of Study Year Long Indicator | Unit Enrolment | Year Long Indicator | Course Offer > UoS | Y | Y | Y | |
E489 | Unit of Study Census Date | Unit Enrolment | Census Date | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E600 | Unit of Study Commencement Date | Unit Enrolment | Commencement Date | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E355 | Unit of Study Status code | Unit Enrolment | Completion Status | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E601 | Unit of Study Outcome Date | Unit Enrolment | Outcome Date | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E660 | Delivery Location country code | Unit Enrolment | Country | Course Offer > UoS | N | Y | Y | |
E477 | Delivery Location Postcode | Unit Enrolment | Location Country and Postcode | Course Offer > UoS | N | Y | Y | |
E619 | Course assurance indicator | Unit Enrolment | Course Assurance Indicator | Learner > Course Enrolment > UoS Enrolment | Y | N | N | |
E577 | Recognition of prior learning code | Unit Enrolment | RPL Indicator | Learner > Course Enrolment > UoS Enrolment | Y | N | N | |
E329 | Mode of Attendance Code | Unit Enrolment | Attendance Mode | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E490 | Student Status Code | Unit Enrolment | Enrolment Status | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E392 | Maximum Student Contribution Code | Unit Enrolment | Max. Student Contribution: | Learner > Course Enrolment > UoS Enrolment | N | Y | N | |
E446 | Remission Reason Code | Unit Enrolment | Remission Reason | Learner > Course Enrolment > UoS Enrolment | Y | Y | N | |
E339 | EFTSL | Unit Enrolment | EFTSL | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E384 | Amount Charged | Unit Enrolment | Unit of study fee | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E381 | Amount Paid Upfront | Unit Enrolment | Student upfront payment | Learner > Course Enrolment > UoS Enrolment | Y | Y | Y | |
E529 | Loan Fee | Unit Enrolment | Loan Fee $ | Learner > Course Enrolment > UoS Enrolment | Y | Y | N | |
E558 | HELP Loan Amount | Unit Enrolment | Loan Amount | Learner > Course Enrolment > UoS Enrolment | Y | Y | N | |
E525 | Campus suburb | Campuses | AddressLine3 | Location | N | Y | Y | |
E644 | Campus country code | Campuses | CountryCode | Location | N | Y | Y | |
E559 | Campus postcode | Campuses | Postcode | Location | N | Y | Y | |
E625 | Delivery Location code | Campuses | Code | Location | Y | N | N | |
E627 | Delivery Location Street Address | Campuses | Unit Details, Street Number and Street Name | Location | Y | N | N | |
E678 | Delivery Location Suburb | Campuses | AddressLine3 | Location | Y | N | N | |
E630 | Delivery Location State | Campuses | State | Location | Y | N | N | |
E660 | Delivery Location Country Code | Campuses | CountryCode | Location | Y | N | N | |
E477 | Delivery Location Postcode | Campuses | Postcode | Location | Y | N | N | |
E609 | Campus Effective From Date | Campuses | Effective From Date | Location | Y | Y | Y | |
E610 | Campus Effective To Date | Campuses | Effective To Date | Location | Y | Y | Y | |
E597 | CRICOS Code | Campuses | N/A | N | Y | Y | Not supporting for v1 | |
E569 | Campus operation type | Campuses | N/A | N | Y | Y | Not supporting for v1 | |
E570 | Principal mode of offshore delivery code | Campuses | N/A | N | Y | Y | Not supporting for v1 | |
E571 | Offshore delivery code | Campuses | N/A | N | Y | Y | Not supporting for v1 | |
E533 | Course of Study Code | Course of Study | Course of Study Code | Course | N | Y | Y | |
E394 | Course of Study Name | Course of Study | Course of Study Description | Course | N | Y | Y | |
E310 | Course of Study Type | Course of Study | Course Type | Settings > Dropdowns | N | Y | Y | |
E350 | Course of Study Load | Course of Study | Total Course EFTS | Settings > Dropdowns | N | Y | Y | |
E455 | Combined Course of Study Indicator | Course of Study | Combined Course of Study Indicator | Settings > Dropdowns | N | Y | Y | |
E533 | Course of Study Code | Course | Course of Study Code | Course | N | Y | Y | |
E307 | Course Code | Course | Course Code | Course | Y | Y | Y | |
E308 | Course Name | Course | Course Description | Course | Y | Y | Y | |
E350 | Course of Study Load | Course | Total Course EFTSL | Course | Y | Y | N | |
E596 | Standard Course Duration | Course | Standard Course Duration | Course | Y | Y | Y | |
E609 | Course Effective From Date | Course | Effective From Date | Course | Y | Y | Y | |
E610 | Course Effective To Date | Course | Effective To Date | Course | Y | Y | Y | |
E461 | Field of Education Code | Course | Field of Education | Course | N | Y | Y | |
E462 | Field of Education Supplementary Code | Course | Field of Education Supplementary | Course | N | Y | Y | |
E609 | Field of Education Effective From Date | Course | Effective From Date | Course | N | Y | Y | |
E312 | Special Course Type Code | Course | Special Course Type | Course | N | Y | N | |
E609 | Special Interest Course Effective From Date | Course | Effective From Date | Course | N | Y | N | |
E610 | Special Interest Course Effective To Date | Course | Effective To Date | Course | N | Y | N |