Rule Applies To | |||||||||
---|---|---|---|---|---|---|---|---|---|
Rule Type |
Rule # | Rule Text / Business Meaning |
Error Level |
TSDS | PEIMS Sub |
ESC | LEA | Campus | Charter |
Business Context | 43415-0005 |
A particular TX-UNIQUE-STUDENT-ID reporting a Course Transcript must match a TX-UNIQUE-STUDENT-ID for a student.
For course transcript data reported, there must be corresponding student data reported.
|
F | 4 | Y | Y | Y | ||
Business Context | 43415-0006 |
Except for Texas Tech University K-12 (152504), for a particular TX-UNIQUE-STUDENT-ID reporting a Course Transcript, there must be Attendance and/or Flexible Attendance, or this student must be reported with discipline or restraint event data where NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is "1", or this student must be reported with VIRTUAL-STUDENT-NOT-IN-MEMBERSHIP of "1".
Except for Texas Tech University K-12, a student reported with a course transcript must be reported with at least some attendance or flexible attendance data, or must be reported as enrolled, not in membership in one or more of the following ways:
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0007 |
For a Course Transcript, there must be Attendance and/or Flexible Attendance reported with a matching TX-UNIQUE-STUDENT-ID and CAMPUS-ID-OF-ENROLLMENT, or this student must be reported with discipline or restraint event data where NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is "1", or this student must be reported with VIRTUAL-STUDENT-NOT-IN-MEMBERSHIP of "1".
A student reported with a course transcript must be reported with attendance or flexible attendance with a matching StudentUniqueStateId and TX-CampusIdOfEnrollment, or must be reported as enrolled, not in membership in one or more of the following ways:
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0008 |
For each Course Transcript, there must be a corresponding Course Section where CAMPUS-ID-OF-ENROLLMENT matches CAMPUS-ID, and SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE are the same.
For each course transcript reported, the TX-CampusIdOfEnrollment, CourseCode, UniqueSectionCode, and TX-CourseSequence must match a reported course section.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0009 |
There should not be more than eight Course Transcripts for a particular TX-UNIQUE-STUDENT-ID.
A student should not have more than 8 course transcripts reported in submission 4.
|
S | 4 | Y | Y | Y | ||
Field Validation | 43415-000A |
The combination of the following fields must be unique for each Course Transcript: COURSE-IDENTIFICATION-SYSTEM, SERVICE-ID, CAMPUS-ID, StudentAcademicRecordReference, COURSE-SEQUENCE-CODE, and CLASS-ID-NUMBER.
The combination of the following fields must be unique for each Course Transcript: CourseReference, EducationOrganizationReference, StudentAcademicRecordReference, TX-CourseSequence, and UniqueSectionCode.
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000B |
For a Course Transcript, the following must be provided: COURSE-IDENTIFICATION-SYSTEM, SERVICE-ID, CAMPUS-ID, StudentAcademicRecordReference, GRADE-LEVEL-CODE, PASS/FAIL-CREDIT-INDICATOR-CODE, DUAL-CREDIT-INDICATOR-CODE, ATC-INDICATOR-CODE, CAMPUS-ID-OF-ENROLLMENT, COURSE-SEQUENCE-CODE, and CLASS-ID-NUMBER.
For a Course Transcript, the following must be provided: IdentificationSystem, Id, StateOrganizationId (EducationOrganizationReference), StudentAcademicRecordReference, TX-GradeLevel, TX-PassFailCreditIndicator, TX-DualCreditIndicator, TX-ATCIndicator, TX-CampusIdOfEnrollment, TX-CourseSequence, and UniqueSectionCode.
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000D |
The combination of the following fields must be unique for each Course Section: CLASS-ID-NUMBER, CAMPUS-ID, and COURSE-SEQUENCE-CODE.
The combination of the following fields must be unique for each Course Section: UniqueSectionCode, StateOrganizationId (SchoolReference), and TX-CourseSequence.
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000E |
For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID (SchoolReference), CLASS-PERIOD, CAMPUS-ID (ClassPeriodReference), SCHOOL-YEAR, POPULATION-SERVED-CODE, COURSE-SEQUENCE-CODE, and NON-CAMPUS-BASED-INSTRUCTION-CODE.
For a Course Section, the following must be provided: UniqueSectionCode, CourseOfferingReference, StateOrganizationId (SchoolReference), ClassPeriodName, StateOrganizationId (ClassPeriodReference), TX-SchoolYear, TX-PopulationServed, TX-CourseSequence, and TX-NonCampusBasedInstruction.
|
F | 3 | Y | Y | Y | ||
Field Validation | 43415-000F |
For a Course Section, the following must be provided: CLASS-ID-NUMBER, CourseOfferingReference, CAMPUS-ID, SCHOOL-YEAR and COURSE-SEQUENCE-CODE.
For a Course Section, the following must be provided: UniqueSectionCode, CourseOfferingReference, StateOrganizationId (SchoolReference), TX-SchoolYear and TX-CourseSequence.
|
F | 4 | Y | Y | Y | ||
Field Validation | 43415-000H |
TX-UNIQUE-STUDENT-ID must be unique for each student Enrollment (Student School Association).
StudentUniqueStateId must be unique for each student Enrollment (Student School Association).
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000K |
For a Student School Association, the following must be provided: TX-UNIQUE-STUDENT-ID, CAMPUS-ID, GRADE-LEVEL-CODE, and STUDENT-ATTRIBUTION-CODE.
For a Student School Association, the following must be provided: StudentUniqueStateId, StateOrganizationId (SchoolReference), TX-GradeLevel, and TX-Attribution.
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000M |
TX-UNIQUE-STUDENT-ID must be unique for each Student Academic Record.
StudentUniqueStateId must be unique for each Student Academic Record.
|
F | 3, 4 | Y | Y | Y | ||
Field Validation | 43415-000N |
For a Student Academic Record, the following must be provided: TX-UNIQUE-STUDENT-ID.
For a Student Academic Record, the following must be provided: StudentUniqueStateId.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0010 |
For a particular CAMPUS-ID-OF-ENROLLMENT, TX-UNIQUE-STUDENT-ID, SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE on a Course Transcript, only one corresponding student section association may have a COURSE-COMPLETION-INDICATOR of "1".
A student can only complete a particular course section one time.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0011 |
For a particular CAMPUS-ID-OF-ENROLLMENT, TX-UNIQUE-STUDENT-ID, SERVICE-ID, CLASS-ID-NUMBER, and COURSE-SEQUENCE-CODE, there may be only one Course Transcript.
A student can only pass, fail, or not complete a particular course section one time.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0019 |
Except for Texas Tech University K-12 (152504), SERVICE-ID must not begin with "SA", "SE", "SR", "SS", "01", or "8".
Except for Texas Tech University K-12, a course transcript must not be reported for CourseCodes that indicate: educational aides (starts with "SA"), special education and related services (starts with "SE"), teachers with additional responsibilities (starts with "SR"), faculty with non-teaching responsibilities (starts with "SS"), pre-first grade courses (starts with "01"), or local-credit courses (start with "8").
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0020 |
SERVICE-ID must be a high school course (Eligible for State HS Credit = "Y") and must not begin with "8".
For submission 4, a student course transcript must be reported with a high school CourseCode that is also not a local-credit course (starts with "8").
|
F | 4 | Y | Y | Y | ||
Business Context | 43415-0023 |
CAMPUS-ID-OF-ENROLLMENT must match an entry registered with the TEA as an active instructional campus in the reporting LEA ending in "001"-"698".
For a course transcript, the student's SchoolReference must be registered with the TEA as an active instructional campus in the reporting LEA and must end in "001"-"698".
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0024 |
DUAL-CREDIT-INDICATOR-CODE must be "1", or SERVICE-ID must be a high school Career and Technical Education course (CTE Course = "H" in code table C022), or SERVICE-ID must be "CP110100" or "CP111200". Only dual-credit courses, high school CTE courses, and college preparatory courses CP110100 and CP111200 are reported in submission 4.
|
F | 4 | Y | Y | Y | ||
Business Context | 43415-0025 |
PASS/FAIL-CREDIT-INDICATOR-CODE must not be "13" or "14".
For submission 4, the TX-PassFailIndicator codes for a non-high school course passed and a non-high school course failed are not valid. Only high school courses can be reported in submission 4.
|
F | 4 | Y | Y | Y | ||
Business Context | 43415-0026 |
For the campus reported in CAMPUS-ID-OF-ENROLLMENT, except for TxVSN waiver campuses "015835011", "031912203", "031916009", "046802011", "057905554", "101846008", "101911040", "129902005", "170902220", "177901104", "186902040", "186902698", "220920108", "246906006", or "246913100", the grade range registered with the TEA must include at least one of grades "03"-"12".
For a course transcript, the grade range for the TX-CampusIdOfEnrollment must include at least one of the grades "03"-"12", unless the TX-CampusIdOfEnrollment is a TxVSN waiver campus.
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0027 |
For the campus reported in CAMPUS-ID-OF-ENROLLMENT, the grade range registered with the TEA must include at least one of grades "06"-"12".
For a course transcript reported in submission 4, the grade range for the TX-CampusIdOfEnrollment must include at least one of the grades "06"-"12".
|
F | 4 | Y | Y | Y | ||
Business Context | 43415-0028 |
If SERVICE-ID is a high school course, then COURSE-SEQUENCE-CODE must not be "A".
The TX-CourseSequence "A" is only reported for non-high school courses.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0033 |
If SERVICE-ID is an Advanced Placement course (begins with an "A"), then DUAL-CREDIT-INDICATOR-CODE should be "0" or blank (not reported).
If a student is reported with a course that is an advanced placement course, then the course generally should not be reported as dual credit.
|
S | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0034 |
If ATC-INDICATOR-CODE is "1", then DUAL-CREDIT-INDICATOR-CODE must be "0".
A course that is taught for advanced technical credit cannot also be taught for dual high school/college credit for the same student.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0035 |
If DUAL-CREDIT-INDICATOR-CODE is "1", then ATC-INDICATOR-CODE must be "0".
A course that is taught for dual high school/college credit cannot also be taught for advanced technical credit for the same student.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0036 |
If PASS/FAIL-CREDIT-INDICATOR-CODE is "01", DUAL-CREDIT-INDICATOR-CODE is "1", and COURSE-SEQUENCE-CODE is "D0", "D2", "D5", or "D9", then COLLEGE-CREDIT-HOURS must be greater than 0.
If a student has passed a course that has been designated as a dual credit course, and is a one semester course or the last part of a multi-part course, then the student must be reported with TX-CollegeCreditHours greater than zero (0).
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0037 |
If DUAL-CREDIT-INDICATOR-CODE is "0" or blank/not reported, then COLLEGE-CREDIT-HOURS must be 0 or blank/not reported.
If a student is reported with a course that is not reported as dual-credit, then it is not possible for a student to have earned TX-CollegeCreditHours.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0043 |
If PASS/FAIL-CREDIT-INDICATOR-CODE is "13" or "14", then SERVICE-ID must not be a high school course.
If the TX-PassFailIndicator indicates a non-high school course passed (13), or a non-high school course failed (14), then the CourseCode must be a non-high school course.
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0047 |
For each campus registered with TEA as an active instructional campus reporting Attendance or Flexible Attendance (if applicable), there should be at least one Course Transcript.
At least one Course Transcript should be reported for each active instructional campus that reports Attendance or Flexible Attendance (if applicable).
|
S | 3 | Y | Y | Y | ||
Business Context | 43415-0050 |
If SERVICE-ID is not a high school course, then DUAL-CREDIT-INDICATOR-CODE must be "0" or blank/not reported, and COLLEGE-CREDIT-HOURS must be 0 or blank/not reported.
Only high school courses are eligible for dual credit and college credit hours.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0051 |
For a Course Transcript, if DUAL-CREDIT-INDICATOR-CODE is "1", then SERVICE-ID must be a high school course (Eligible For State HS Credit = "Y" in code table C022).
Only high school courses are eligible for dual credit.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0052 |
For a Course Transcript, if DUAL-CREDIT-INDICATOR-CODE is "1", then there should be Attendance and/or Flexible Attendance for that student where GRADE-LEVEL-CODE is "09"-"12", or this student should be reported with discipline or restraint event data where NON-MEMBERSHIP-DISCIPLINE-RESTRAINT-INDICATOR-CODE is "1", or this student should be reported with VIRTUAL-STUDENT-NOT-IN-MEMBERSHIP of "1".
A student reported with a dual credit course transcript should be reported with attendance or flexible attendance where the TX-GradeLevel is "09"-"12", or should be reported as enrolled, not in membership in one or more of the following ways:
|
S | 3 | Y | Y | Y | ||
Business Context | 43415-0055 |
If NON-CAMPUS-BASED-INSTRUCTION-CODE is "08", then STUDENT-END-DATE must equal STUDENT-BEGIN-DATE on the corresponding student section association.
For students reported with course transcripts that indicate a course section for "credit by exam", the last date that a student is assigned to the course must be equal to the date the student was assigned to the course.
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0056 |
If DUAL-CREDIT-INDICATOR-CODE is "1" and COLLEGE-CREDIT-HOURS is greater than 0, then PASS/FAIL-CREDIT-INDICATOR-CODE should be "01".
If a student has been reported as completing a dual credit course with college credit hours greater than zero (0), then the course should be reported as passed.
|
S | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0057 |
If PASS/FAIL-CREDIT-INDICATOR-CODE is "01", and COLLEGE-CREDIT-HOURS is greater than 0, then DUAL-CREDIT-INDICATOR-CODE must be "1", and COURSE-COMPLETION-INDICATOR must be "1" on the corresponding student section association.
If a student has passed and received high school credit for a course, and college credit hours are also received, then it must be a dual credit course, and the course must have been completed.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0058 |
If DUAL-CREDIT-INDICATOR-CODE is "1", then SERVICE-ID should not begin with "A".
Advanced Placement courses should not be reported as dual credit unless the course has been approved as an AP® course by the College Board through the AP® Course Audit. This means the college instructor must have submitted his/her course syllabus and have received approval in advance.
|
S | 4 | Y | Y | Y | ||
Business Context | 43415-0064 |
Except for Texas Tech University K-12 (152504) and TxVSN waiver campuses "015835011", "031912203", "031916009", "046802011", "057905554", "101846008", "101911040", "129902005", "170902220", "177901104", "186902040", "186902698", "220920108", "246906006", or "246913100", for a course transcript, GRADE-LEVEL-CODE must be "03"-"12".
Except for Texas Tech University K-12 and TxVSN waiver campuses, only students enrolled in grades "03"-"12" can be reported with a course transcript.
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0065 |
If PASS/FAIL-CREDIT-INDICATOR-CODE is "01"-"12", then SERVICE-ID must be a high school course.
If the TX-PassFailIndicator indicates high school results of passed/failed/incomplete/credit received/credit not received (01-12), then the CourseCode must a high school course.
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0068 |
If NON-CAMPUS-BASED-INSTRUCTION-CODE is "11", then there must be at least some Flexible Attendance data with a matching TX-UNIQUE-STUDENT-ID and FLEXIBLE-ATTENDANCE-PROGRAM-TYPE-CODE of "6".
For a student reported with a course transcript for a section that indicates TX-NonCampusBasedInstruction of "Optional Flexible School Day Online Dropout Recovery Program" (11), there must also be Flexible Attendance reported with TX-FlexibleAttendanceProgram of "OFSDP Online Dropout Recovery Program" (6).
|
F | 3 | Y | Y | Y | ||
Business Context | 43415-0071 |
If SERVICE-ID is "A3580110", then there must be another Course Transcript reported with a matching TX-UNIQUE-STUDENT-ID and PASS/FAIL-CREDIT-INDICATOR-CODE where SERVICE-ID is "A3580120".
Both CourseCodes "AP Computer Science A - Math" (A3580110) and "AP Computer Science A - LOTE" (A3580120) must be reported together for a student and with the same TX-PassFailCreditIndicator.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0072 |
If SERVICE-ID is "A3580120", then there must be another Course Transcript reported with a matching TX-UNIQUE-STUDENT-ID and PASS/FAIL-CREDIT-INDICATOR-CODE where SERVICE-ID is "A3580110".
Both CourseCodes "AP Computer Science A - Math" (A3580110) and "AP Computer Science A - LOTE" (A3580120) must be reported together for a student and with the same TX-PassFailCreditIndicator.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0073 |
If SERVICE-ID is "I3580310", then there must be another Course Transcript reported with a matching TX-UNIQUE-STUDENT-ID and PASS/FAIL-CREDIT-INDICATOR-CODE where SERVICE-ID is "I3580320".
Both CourseCodes "IB Computer Science Higher Level - Math" (I3580310) and "IB Computer Science Higher Level - LOTE" (I3580320) must be reported together for a student and with the same TX-PassFailCreditIndicator.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0074 |
If SERVICE-ID is "I3580320", then there must be another Course Transcript reported with a matching TX-UNIQUE-STUDENT-ID and PASS/FAIL-CREDIT-INDICATOR-CODE where SERVICE-ID is "I3580310".
Both CourseCodes "IB Computer Science Higher Level - Math" (I3580310) and "IB Computer Science Higher Level - LOTE" (I3580320) must be reported together for a student and with the same TX-PassFailCreditIndicator.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0075 |
For a Course Transcript, if DUAL-CREDIT-INDICATOR-CODE is "1", then COURSE-SEQUENCE-CODE must be one of the following: "D0", "D1", "D2", "D3", "D4", "D5", "D6", "D7", "D8", or "D9".
Dual credit courses must use a TX-CourseSequence intended for dual credit courses.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0076 |
For a Course Transcript, if DUAL-CREDIT-INDICATOR-CODE is "0", then COURSE-SEQUENCE-CODE must not be any of the following: "D0", "D1", "D2", "D3", "D4", "D5", "D6", "D7", "D8", or "D9".
Only dual credit courses may use a TX-CourseSequence intended for dual credit courses.
|
F | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0077 |
If DUAL-CREDIT-INDICATOR-CODE is "1", and COURSE-SEQUENCE-CODE is "D1", "D3", "D4", "D6", "D7", or "D8", then COLLEGE-CREDIT-HOURS should be 0.
If a student has taken a course that has been designated as a dual credit course, but that course is not a one semester course or the last part of a multi-part course, then the course transcript should be reported with TX-CollegeCreditHours of zero (0). College credit hours are generally not awarded for multi-semester courses until the last part of that course is completed and passed.
|
S | 3, 4 | Y | Y | Y | ||
Business Context | 43415-0078 |
For a course transcript for Texas Tech University K-12 (152504), SERVICE-ID must not begin with "SA", "SE", "SR", or "SS".
For Texas Tech University K-12, a course transcript must not be reported for CourseCodes that indicate: educational aides (starts with "SA"), special education and related services (starts with "SE"), teachers with additional responsibilities (starts with "SR"), faculty with non-teaching responsibilities (starts with "SS").
|
F | 3 | Y | Y | Y |