Course Credit Duplicates

Report Location: Student>Student Data Validation>Course Completion Validation

Summary: This report displays summer PEIMS students based on the year selected who have a service ID that has received credit for the same course sequence part in either the same year or different years in either summer or extended year reporting.

Usage: Use this report to review possible master schedule coding issues or transcript issues that need to be modified. Also can be used to help with identifying CTE courses that aren’t being used for auto calculation due to master schedule coding issues (both parts are in semester 1).

Special Note(s):

• Service IDs that begin with ‘PES’ (PE Substitution) are excluded from this report since they can repeat same part passing over multiple years.
• Service IDs that are marked Course Sequence D0, D0 in the same year (with no other years marked 0 or D0 for the same service ID) are excluded due to TWEDS documentation – EX2:
  • https://tealprod.tea.state.tx.us/TWEDS/98/0/0/0/DataComponents/ComplexType/List/11135
• Service IDs that are marked Course Sequence 0, 0 in the same year are not excluded in order to potentially correct dual credit courses that need the dual credit course sequence code instead (D0, D0).
• Use sort arrows on the Service ID column to easily pick out courses with issues.

Data Source(s):

• Summer PEIMS
  • Interchange Student
    • 40100 Student Basic Information
      • StudentExtension Complex Type
  • Interchange Student Enrollment
    • 40110 Enrollment
      • StudentSchoolAssociationExtension Complex Type
  • Interchange Student Transcript
    • 43415 CourseTranscriptExtension Complex Type
• Extended Year PEIMS
  • Interchange Student Transcript
    • 43415 CourseTranscriptExtension Complex Type

Definitions:

• Students displayed if:
  • Count of Unique Service ID (E0724) course sequence parts > 1 AND
  • Pass/Fail Credit Indicator Codes (E0949) = 01 or 08 AND
  • Course Sequence Codes (E0948) are one or a combination of the following:
    • 0, D0
    • 1, D1
    • 2, D2
    • 3, D3
    • 4, D4
    • 5, D5
    • 6, D6
    • 7, D7
    • 8, D8
    • 9, D9
• SPED – E0794 matches to the Year in the row
  • 0 = Not SPED
  • 1 = SPED
• Year indicates the year the Service ID exists (current and/or prior years depending on Trigger Year(s) selected)
• Service ID indicates the course that is being counted multiple times for the same course sequence part
• Course Sequence displays so that you can review which parts are being duplicated
  • Note: All course sequence codes are displayed for the particular year, not just the one that is duplicated

Features:

• Filter on:
  • Multi select Course Sequence (Default All)
    • Filter lists all course sequence codes existing in the summer and extended year course completion records
    • Only displays rows where the selected course sequence(s) is the trigger
  • Single select Course Types (Default All Courses) – Uses Service ID E0724 to determine type of course
    • All Courses
    • CTE Courses
    • Non-CTE Courses
  • Multi select Trigger Year(s) (Default Most Recent PEIMS Summer Trigger Year)
    • Years may appear that are not in the trigger year if the duplication was across years
    • Choose more Trigger Year(s) to verify transcript coding for students. This will not take into account any historical changes that have already been modified in the SIS, but could potentially identify issues that still need to be addressed in the SIS for AARs.
  • Multi select Campus (Default All)
  • Multi select Grade (Default All)
  • Single select Year (Defaults to most recent Summer PEIMS year)
    • Used to pull base file of summer students