TREx Import (Texas)

Last Modified on 04/10/2024 12:55 pm CDT

Tool Search: TREx Import

The TREx Import tool allows districts to import TREx-specific data for a student. Imported data is saved within Campus for each student along with an import history report accessible on a student's TREx Extract tab. 

  • All transcript records, from any year, are reported.
  • Transcript records report from transcripts regardless of any course link.
  • Transcript records report from transcripts regardless of an enrollment existing in that same calendar year.

Screenshot of the TREx Import Tool.TREx Import Tool


Users must have full Read, Write, Add, and Delete rights to properly use the TREx Import tool. For more information about Tool Rights and how they function, see the Tool Rights article.

Import a TREx File

Importing TREx data is as simple as locating the XML file on a local hard drive or network and selecting the Upload button. 

  1. Ensure TREx data has been saved in a file following the appropriate file format described in the Understanding the File Format section.
  2. Click the Choose File button. You will be directed to locate the file on your local hard drive, network or storage device. 
  3. Once you have located the file, select the file and click OK. The file name will appear to the right of the Choose File button on the editor.

    Screenshot showing selected xml file.

  4. Select the Upload button. A summary of data contained within the import file appears in a separate window.

    Screenshot of the summary of data contained within the import file.

Viewing a Student's TREx Import History

You can view a student's TREx import history via the TREx Upload History section of the TREx Extract tab.

Screenshot of an example TREx Import History.TREx Import History

Understanding the Import File Format

Imported files must follow a specific file format. All files downloaded from the TREx system will automatically be in the correct file format.

The following tables describe what data is imported from the file and where within Campus this information is stored. 

Data ElementLogicLocation
StudentUniqueIDImport Validation Logic:
Importing value must exactly match existing database value.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Identifiers > Student Unique State ID
FirstNameImport Validation Logic:
Importing value must exactly match existing database value.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > First Name
MiddleNameImport Validation Logic:
None

Import/Overwrite Logic:
Data is imported and will overwrite existing database value.		Census > People > Demographics > Person Information > Middle Name
LastNameImport Validation Logic:
Importing value must exactly match existing database value.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > Last Name
SuffixImport Validation Logic:
None

Import/Overwrite Logic:
Data is imported and will overwrite existing database value (as long as importing value exists in the local element dictionary).		Census > People > Demographics > Person Information > Suffix
LocalID

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Identifiers > Local Student Number
StudentIDImport Validation Logic:
Importing value must exactly match existing database value.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Identifiers > Student Unique State ID
AddressImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Address
CityImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Address > City
StateProvinceImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Address > State
PostalCodeImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > Zip
PriorIDImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.


During import, if the StudentID field is populated, then import the StudentID field into Previous State ID. If the StudentID field is empty/NULL, then import the PriorID into the Previous State ID field. Again, do not overwrite.

Census > People > Demographics > Previous State ID

Parent

Data ElementLogicLocation
FirstNameImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > Households > Parent/Guardian > First Name
MiddleNameImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > Households > Parent/Guardian > Middle Name
LastNameImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > Households > Parent/Guardian > Last Name
SuffixImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > Households > Parent/Guardian > Suffix

Student Demographic

Data ElementLogicDescription
Gender

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > Gender
Race

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > State Race Ethnicity
Ethnicity

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Race/Ethnicity
BirthDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > Birth Date
Language

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Census > People > Demographics > Home Primary Language
Migrant

Import Validation Logic:
None

Import/Overwrite Logic:

Data is overwritten if Migrant is unmarked and import file indicates it is marked.

Data is not overwritten if Migrant is marked.

Student Information > General > Enrollments > State Reporting Fields > Migrant
Homeless

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Enrollments > State Reporting Fields > Homeless Nighttime Residence
AsyleeRefugeeCode

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Census > People > Demographics > Person Information > Asylee Refugee
Foster Care

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Enrollments > State Reporting Fields > Foster Care Indicator Code
Military Connected

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Enrollments > State Reporting Fields > Military Connected Student Code
Dyslexia

Import Validation Logic:
None

Import/Overwrite Logic:

Data is overwritten if Dyslexia is unmarked and import file indicates it is marked.

Data is not overwritten if Dyslexia is marked.

Student Information > General > Enrollments > State Reporting Fields > Dyslexia Indicator Code
DyslexiaRiskCode

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Program Participation > State Programs > Dyslexia Risk

School

Data ElementLogicLocation
SchoolID

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > State School Number


School & District Settings > District > District Information > State District Number



DistrictID

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > District > District Information > State District Number
DistrictName

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > District > District Information > District  Detail > Name
SchoolName

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail > Name
PhoneNumber

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten

School & District Settings > Schools > School Information > School Detail  > Phone Number
Fax

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail > Fax
AddressImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail > Address
CityImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail  > City
StateProvinceImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail  > State
CountryImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail > Country
PostalCodeImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School Detail > Zip

Enrollment

Logic looks at the student's enrollment history to see if Entry Date, Exit Date and Grade Level match an enrollment or enrollment history record within the database. 

  • If all three match, the matching record will be updated with any missing data. Existing values are not overwritten.
    • If there are both enrollment records and enrollment history records matching all three elements, data is imported into the enrollment record.
    • If there are multiple enrollment records where all three elements match, logic will update enrollment records based on Service Type primacy (Primary, secondary, etc).
  • If no enrollment record matches all three elements, a new enrollment history record is created.
    • Service Type is defaulted to Primary.
    • Calendar Name is populated with the TREx School Name
Data ElementLogicLocation
GradeLevel

Import Validation Logic:
None

Import/Overwrite Logic:

Existing Record: No data is imported.

New Record: Grade value is imported.

Student Information > General > Enrollments Tab > General Enrollment Information > Grade
EntryDate

Import Validation Logic:
None

Import/Overwrite Logic:

Existing Record: No data is imported.

New Record: Entry Date is imported into the Start Date field.

Student Information > General > Enrollments Tab > General Enrollment Information > Start Date
ExitDate

Import Validation Logic:
None

Import/Overwrite Logic:

Existing Record: No data is imported.

New Record: Exit Date is imported into the End Date field.

Student Information > General > Enrollments Tab > General Enrollment Information > End Date
Withdraw Date

Import Validation Logic:
None

Import/Overwrite Logic:

Existing Record: "Withdraw Date YYYY-MM-DD" is entered in the End Comments field.


New Record: "Withdraw Date YYYY-MM-DD" is entered in the End Comments field.

Student Information > General > Enrollments Tab > General Enrollment Information > Withdrawal Date
Withdraw Reason

Import Validation Logic:
None

Import/Overwrite Logic:

Existing Record: "Withdraw Reason XX" is entered in the End Status field.


New Record:  "Withdraw Reason XX" is entered in the End Status field.

Student Information > General > Enrollments Tab > General Enrollment Information > End Status

Special Programs

Data ElementLogicLocation
CTEImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Career Tech > Career Tech Program


Course > Grading Task > Pass/Fail Credit Indicator


EconomicDisadvantageImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Enrollments > State Reporting > Code 99

FRAM > Eligibility


AtRiskImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Enrollment > State Reporting Fields > At Risk
Title1

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

School & District Settings > Schools > School Information > School History > Title 1
SpecialEd

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Special Ed > Documents > Plan Outline TXIEP / Education Plan
IEP

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Special Ed > Documents > Plan Outline TXIEP / Education Plan
Bilingual

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Program Participation > English Learners (EL) > EL Services > Service Type
ESL

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Program Participation > English Learners (EL) > EL Services > Service Type
GiftedTalented

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Flags > Student Flag Editor > Flag
LEPImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Program Participation > English Learners (EL) > EL

Assessment

In order for an assessment to be imported, the following values must exist in the Assessment Type record:

  • TestName or AdditionalTestName
  • TestDate
  • TestScore or TestCode

Also, the TestName or SubTestName must already exist within the Campus database as a Test Name.

The following logic is used to determine if the assessment record is a parent or child test:

  • If TestName or AdditionalTestName and TestCode match an existing parent test, then a record is added as a child record to the parent test.
    • If TestDate and TestScore match the existing parent test record, data is not imported (as it would be duplicate information).
  • If TestDate and TestScore do not match an existing parent test, a new parent test is created.
Data ElementLogicLocation
TestName

Import Validation Logic:
The value must match a State Code within Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment/Assessment Subtest > Test Detail > State Code (tied to the test)
AdditionalTestName

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment/Assessment Subtest > Test Detail > Test Name
TestLevel

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Setup > assessment > Test Detail > Test Grade Level


Student Information > General > Enrollment > Grade Level


TestDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Score Detail > Date
ExitRequirementMetDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > TAKS Exam > Test Score Detail > Result
TestScore

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Score Detail > Scale Score
TestCode

Import Validation Logic:
The value must match a Score Code within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Score Detail > Score Code
 PerformanceLevel Import Validation Logic:
N/A

Import/Overwrite Logic:
N/A		N/A
AssessmentSubTest
Note: If both the following elements exist along with either a TestName or AdditionalTestName, then create a parent test with the TestName/AdditionalTestName as the name, and a child test with the SubTestName as the name (and SubTestScore as the score).
AssessmentSubTest/
 SubTestName		Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Score Detail > Subtest Name
AssessmentSubTest/
SubTestScore		Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Assessment > Test Score Detail > Subtest > Scale Score

Attendance

Data ElementLogic Location
DaysAttended

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
DaysAbsent

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
PriorDaysAbsentImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
PriorDaysPresentImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
PriorRSDaysPresentImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
PriorRADaysPresentImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated

Immunization

In order for data to import, all three data elements must contain data. If all three elements have data and the ImmuizationDate is unique for a Vaccine type, data is imported.

Data ElementLogicLocation
ImmunizationCode

Import Validation Logic:
Value is used to validate a unique immunization record.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

System Administration > Health > Vaccines > Vaccine Detail > Code

Student Information > Health > Immunizations


ImmunizationDate

Import Validation Logic:
If all three elements have data and the ImmuizationDate is unique for a Vaccine type, data is imported.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Health > Immunizations
ImmunizationDose

Import Validation Logic:
Value is used to validate a unique immunization record.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Health > Immunizations

Discipline Action

Data ElementLogicLocation
DisciplineActionDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Behavior > Resolution Details > Resolution End Date
DisciplineActionNum

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calculated
DisciplineActionCode

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Behavior > Behavior Management/Referral > Add a Resolution > Resolution Details > Resolution Type
DisciplineActionReason

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Behavior > Behavior Management/Referral > Add Event/Participant > Event Details > Event Type

Academic Status

Data ElementLogicLocation
PublicServicesEndorsementCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > Public Services
FHSPDistingIndicatorCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation tab > State Reporting Graduation Fields > Graduation Endorsements > FHSP Distinguished
BusinessEndorsementCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > Business & Industry
STEMEndorsementCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > STEM
Multi-StudiesEndorsementCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > Multi Disciplinary
ArtsEndorsementCode

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > Arts & Humanities
FHSPCollegeCareerInstruction
Indicator

Import Validation Logic:
The value must match a Graduation Endorsement within the Campus database.

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Graduation Tab > State Reporting Graduation Fields > Graduation Endorsements > FHSP College Career
FHSPParticipationCode

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Graduation tab > Graduation Type
Performance Acknowledgment Certification Licensures

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
Performance Acknowledgment Bilingualism Biliteracy

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
Performance Acknowledgment 
College Readiness Assessments

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
Performance Acknowledgment Dual Credit

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
Performance Acknowledgment AP IB Exams

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
Distinguished Achievements 
(Advanced Measure)

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advance Measures > DAP Advanced Measures
Associate Degree

Import Validation Logic:
None

Import/Overwrite Logic:

Import and Overwrite if 1

Else do not Import

Student Information > General > Graduation > Associate Degree Earned
CertificateDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Graduation > State Reporting Graduation Fields > Coursework Completion Date
GraduationDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Graduation > General Graduation Information > Graduation Date

OR

Student Information > General > Graduation > State Reporting Graduation Fields > Projected Graduation Date

IGCGradReview

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation > State Reporting Graduation Fields > Ind Grad Committee
OnRamps

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Course/Section > Course > Onramps Dual Credit
ApIbTypeMetDate

Import Validation Logic:
If data is imported and the Academic Planning record is created, the date imports from the MetDate.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures > Performance Acknowledgement AP IB Exams
BilingBilitTypeMetDateImport Validation Logic:
If data is imported and the Academic Planning record is created, the date imports from the MetDate.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures > Performance Acknowledgement Bilingualism Biliteracy
CertLicTypeMetDateImport Validation Logic:
If data is imported and the Academic Planning record is created, the date imports from the MetDate.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures > Performance Acknowledgement Certification Licensures
CollegeAssessTypeMetDateImport Validation Logic:
If data is imported and the Academic Planning record is created, the date imports from the MetDate.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment College Readiness Assessments
DualCreditTypeMetDateImport Validation Logic:
If data is imported and the Academic Planning record is created, the date imports from the MetDate.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures > Performance Acknowledgment
SpeechMetDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measures
TexasGrant

Import Validation Logic:
AAR Only

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Graduation > State Reporting Graduation Fields > Texas Grant
CPRMetDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measure
POIIMetDate

Import Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Academic Planning > Advanced Measure
Section504

Import Validation Logic:

SR Only

Uses the date of the import for the record's start date.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > Program Participation > Section 504
StarofTexas

Import Validation Logic:

SR Only

If the Star of Texas checkbox on enrollment is not checked, does overwrite.

If the Star of Texas checkbox on enrollment is checked, does NOT overwrite.


Import/Overwrite Logic:

Data is imported.

Existing data may be overwritten.

Student Information > General > Enrollment > State Reporting Fields
IBCReimbursementImport Validation Logic:
N/A

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation > Graduation Certification and Licensure
IBCEarnedImport Validation Logic:
N/A

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

N/A
IBCCodeImport Validation Logic:
N/A

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Graduation > Graduation Certification and Licensure
PostSecondaryCertificationLicensure
Result		Import Validation Logic:
N/A

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student information > General > Graduation > Graduation Endorsement/Certification Information > Status
FinancialAidApplicationImport Validation Logic:
N/A

Import/Overwrite Logic:

Data is not imported.

Existing data may be overwritten.

Student Information > General > Graduation > State Reporting Graduation Fields > Financial Aid Application
FinancialAidApplicationMetDate

Import Validation Logic:
N/A

Import/Overwrite Logic:

Data is not imported.

Existing data may be overwritten.

Student Information > General > Graduation > Financial Aid Met Date

Current Coursework

Courses report using the following criteria:

  • The most recent six/nine weeks grade reports OR
  • If the student has a CG (CourseGrade) or F (FinalGradeAverage) grading task that occurs after any six/nine weeks grades, that grade reports.

If a transcript record exists for the current school year, a record does NOT report for that course under the Current Coursework Type.

For each unique section that is reporting (regardless of the number of periods that the section covers), one record reports for each applicable grading task.

If data exists for any of the following fields, and all imported values match an existing record, the record will not be imported (as it is duplicate data):

  • CourseID
  • SubjectArea
  • SchoolYear
  • CourseCredit
  • GradeLevel

If data in any of the elements above do not match an existing record, the record and data is imported.

Data ElementLogicLocation
Course
Course/CourseTitleImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript >  Name
Course/CourseIDImport Validation Logic:
Imported State Code must match an existing State Code within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > State Code
Course/AbbreviationImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Abbreviated Course Name
Course/SemesterImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence
Course/ClassPeriodImport Validation Logic:

Reports the sequence value for the course.

If the section is scheduled into more than one period, the latest period sequence reports.


Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Calendar > Calendar > Period > Sequence
Course/SubjectAreaImport Validation Logic:
Imported Credit Name must match an existing Credit Name within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Transcript Credit > Credit Name
Course/CourseGradeImport Validation Logic:
The actual or raw grade earned by the student for an academic reporting period; e.g., six-week or nine-week grading period. This grade does not reflect any type of weighting for course type.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Grading and Standards > Grading Tasks > Grading Task Detail > 'Code' and 'State Reported'

OR

Student Information > General > Transcript > Transcript Course Editor > Current Score

OR

Course/Section > Course Information > Grading Task with a value of CG or F


Course/WithdrawGrade N/AN/A
Course/GradeAverageImport Validation Logic:

Identifies the final course grade that the student received for a multi-part course; e.g., a year long course with credit and grades awarded for each of the two semesters.


This field reports blank if the student has not completed the course or all terms of the course.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Transcript Course Editor > Percent

OR

Course/Section > Grading Task > Percent


Course/CourseCreditImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported in both locations.

Existing data is not overwritten.

Student Information > General > Transcript > Transcript Record > Transcript Credit > Earned AND Attempted
Course/PassFailCreditImport Validation Logic:
Indicates the outcome for a course taken by a particular student.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > transcript record > Transcript Credit > TX Pass/Fail Credit

OR

Course/Section > Course Information > TX Pass/Fail Credit on grading task with a code of CG or F AND the Pass/Fail box is checked

Course/ExplanationImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Special Explanation
Course/CourseTeacherImport Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Course > Section > Staff History > Primary Teacher > Last Name
Course/CreditCampus Import Validation Logic:
N/A

Import/Overwrite Logic:
N/A		N/A
Course/SemesterSeqImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence
Course/FinalGradeAverageImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence, Current Score
SchoolYear

Import Validation Logic:

When an enrollment exists, Campus uses  the school year tied to the enrollment calendar for reporting.


For records where an enrollment does not exist for that calendar, report the Start Year and End Year from transcript as entered.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

System Administration > Calendar > Academic Year
GradeLevel

Import Validation Logic:

For records where an enrollment does not exist for that calendar year, the Grade field from the transcript reports.


For records where an enrollment does exist, the report references the mapped state grade levels.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Enrollments Tab > General Enrollment Information > Grade

System Administration > Resources > Grade Level Definitions > Code


SessionType

Import Validation Logic:
None

Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence

Academic Session

If a transcript record exists for the current school year, that record reports under the Academic Session Type.

If the Academic Session Course record has either a FinalGradeAverage or CourseGrade value, then the record is imported into the student's transcript record, using the following logic:

  • If both FinalGradeAverage and CourseGrade are populated, data is imported as follows:
    • If SemesterSeq = 0 or A, FinalGradeAverage is imported and CourseGrade is ignored.
    • If SemesterSeq does not equal 0 or A, CourseGrade is imported and FinalGradeAverage is ignored.
  • If neither FinalGradeAverage or CourseGrade exist in the import file, data is not imported.

If data exists for any of the following fields, and all imported values match an existing record, the record will not be imported (as it is duplicate data):

  • CourseID
  • SubjectArea
  • SchoolYear
  • CourseCredit
  • GradeLevel
Data ElementLogicLocation
SchoolYearImport Validation Logic:

For records where an enrollment does exist, the school year tied to the enrollment calendar reports.


For records where an enrollment does not exist for that calendar, the Start Year and End Year from the transcript report.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

System Administration > Calendar > Academic Year


Student Information > General > Transcript > Start Year AND End Year


GradeLevelImport Validation Logic:

For records where an enrollment does not exist for that calendar year, the Grade field from the transcript reports.


For records where an enrollment does exist, the report references the mapped state grade levels.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Enrollments Tab > General Enrollment Information > Grade / System Administration > Resources > Grade Level Definitions > Code


OR


Student Information > General > Transcript > Transcript Detail > Grade


CourseTitleImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.


Student Information > General > Transcript >  Name
CourseIDImport Validation Logic:
Imported State Code must match an existing State Code within the Campus database.

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > State Code
AbbreviationImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Abbreviated Course Name
SemesterImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence
ClassPeriodImport Validation Logic:

Reports the sequence value for the course.


If the section is scheduled into more than one period, the latest period sequence reports.


Import/Overwrite Logic:

Data is not imported.

Existing data is not overwritten.

System Administration > Calendar > Calendar > Period > Sequence
SubjectAreaImport Validation Logic:

Imported Credit Name must match an existing Credit Name within the Campus database.


If multiple codes match the import value, the code from the parent group that contains AAR is imported. If no parent group contains AAR, the top record is imported.


Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Transcript Credit > Credit Name
CourseGradeImport Validation Logic:
None

Import/Overwrite Logic:
Data is imported.

Existing data is not overwritten.

Grading and Standards > Grading Tasks > Grading Task Detail > 'Code' and 'State Reported'


Student Information > General > Transcript > Transcript Course Editor > Current Score


WithdrawGradeImport Validation Logic:
N/A
Import/Overwrite Logic:
N/A		N/A
GradeAverageImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Transcript Course Editor > Percent
CourseCreditImport Validation Logic:
If PassFailCredit does not equal 01 or 08, then a value of 0.0 is imported, regardless of the value in the import file.

Import/Overwrite Logic:

Data is imported in both locations.

Existing data is not overwritten.

Student Information > General > Transcript > Transcript Record > Transcript Credit > Earned AND Attempted
PassFailCreditImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > transcript record > Transcript Credit > TX Pass/Fail Credit
ExplanationImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Special Explanation
CourseTeacherImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Course > Section > Staff History > Primary Teacher > Last Name
CreditCampusImport Validation Logic:
N/A
Import/Overwrite Logic:
N/A		N/A
SemesterSeqImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence
FinalGradeAverageImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Student Information > General > Transcript > Course Record > Course Sequence, Current Score
GPAImport Validation Logic:
None

Import/Overwrite Logic:

Data is imported.

Existing data is not overwritten.

Calculated
Student Information > General > Credit Summary > Transcript Credit Summary > Cum GPA

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com