| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|---|---|---|---|---|---|---|
|
SAR_ID |
SAR ID |
STUDENTS |
SAR_ + CUSTOM_400009369 |
SAR concatenated with Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information |
3,4 |
|
|
StudentUniqueStateId |
Texas Unique Student ID |
STUDENTS |
CUSTOM_400009369 |
Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information |
3,4 |
| Element Name | Alias Name | Table | Field/Logic | End User Logic | Field ID | Sub |
|---|---|---|---|---|---|---|
|
ID |
Service ID |
MASTER_COURSES, STUDENT_REPORT_CARD_GRADES |
CUSTOM_FIELD_12 |
If Submission 3, use Master_Courses.custom_field_12. If Submission 4 use Student_Report_Card_Grades.custom_14. If Student_Report_Card_Grades.custom_14 is blank then use Master_Courses.custom_field_12 otherwise use Student_Report_Card_Grades.custom_14 |
3,4 |
|
|
StateOrganizationId |
Campus ID |
If submission = 3, if non_secondary.SCHOOL_NUMBER is NOT NULL, use non_secondary.SCHOOL_NUMBER, otherwise use schools.CUSTOM_10000001 + schools.CUSTOM_327. If submission = 4, if non_secondary.SCHOOL_NUMBER is NOT NULL, use non_secondary.SCHOOL_NUMBER, otherwise use student_report_card_grades.CUSTOM_5 + CUSTOM_6. |
"If submission = 3, if Non_Secondary(Student_Enrollment).school_number is NOT NULL, use Non_Secondary(Student_Enrollment).school_number, otherwise use Schools.custom_10000001 (District ID) + Schools.custom_327 (Campus ID). If submission = 4, if Non_Secondary(Student_Enrollment).school_number is NOT NULL, use Non_Secondary(Student_Enrollment).school_number, otherwise use Student_Report_Card_Grades.custom_5 + Student_Report_Card_Grades.custom_6." |
3,4 |
||
|
StudentAcademicRecordReference |
Texas Unique Student ID |
STUDENTS |
CUSTOM_400009369 |
Students.custom_400009369 (Texas Unique Student ID) where custom_400009369 is used in Student Information |
3,4 |
|
|
TX-GradeLevel |
Grade Level |
SCHOOL_GRADELEVELS |
SHORT_NAME |
School_Gradelevels.short_name where short_name is used in School Setup > Grade Levels |
3,4 |
|
|
TX-PassFailCreditIndicator |
Pass Fail Credit Indicator |
STUDENT_REPORT_CARD_GRADES |
CUSTOM_13 |
Student_Report_Card_Grades.custom_13 where custom_13 is used in Grades |
3,4 |
|
|
TX-DualCreditIndicator |
Dual Credit Indicator |
STUDENT_REPORT_CARD_GRADES, MASTER_COURSES, SCHEDULE |
CUSTOM_9, CUSTOM_FIELD_7, CUSTOM_5 |
If Submission = 3 use Schedule.custom_5. If Submission = 4 use Student_Report_Card_Grades.custom_9. Combine Schedule.custom_5 or Student_Report_Card_Grades.custom_9 with Master_Courses.custom_field_7. |
3,4 |
|
|
TX-ATCIndicator |
ATC Indicator |
STUDENT_REPORT_CARD_GRADES |
CUSTOM_10 |
If Submission = 3 use Schedule.custom_7. If Submission = 4 use Student_Report_Card_Grades.custom_10. Combine Schedule.custom_7 or Student_Report_Card_Grades.custom_10 with Master_Courses.custom_field_8 and with Course_Periods.custom_3. |
3,4 |
|
|
TX-CollegeCreditHours |
College Credit Hours |
STUDENT_REPORT_CARD_GRADES |
CUSTOM_12 |
If Submission = 3 use Schedule.custom_9. If Submission = 4 use Student_Report_Card_Grades.custom_12. Combine Schedule.custom_9 or Student_Report_Card_Grades.custom_12 with Master_Courses.custom_field_21 and with Course_Periods.custom_5. |
3,4 |
|
|
TX-CampusIdOfEnrollment |
Campus ID of Enrollment |
If submission = 3, if non_secondary.SCHOOL_NUMBER is NOT NULL, use non_secondary.SCHOOL_NUMBER, otherwise use schools.CUSTOM_10000001 + schools.CUSTOM_327. If submission = 4, if non_secondary.SCHOOL_NUMBER is NOT NULL, use non_secondary.SCHOOL_NUMBER, otherwise use student_report_card_grades.CUSTOM_5 + CUSTOM_6. |
"If submission = 3, if Non_Secondary(Student_Enrollment).school_number is NOT NULL, use Non_Secondary(Student_Enrollment).school_number, otherwise use Schools.custom_10000001 (District ID) + Schools.custom_327 (Campus ID). If submission = 4, if Non_Secondary(Student_Enrollment).school_number is NOT NULL, use Non_Secondary(Student_Enrollment).school_number, otherwise use Student_Report_Card_Grades.custom_5 + Student_Report_Card_Grades.custom_6." |
3,4 |
||
|
TX-CourseSequence |
TX-CourseSequence |
If course_period.course_period_id is equal to blank and course_sequence (master_courses.CUSTOM_FIELD_13) is not equal to blank and partial_credit (master_courses.CUSTOM_FIELD_16 not equal to 1 or Y) not equal to Y, then use course_sequence (master_courses.CUSTOM_FIELD_13). |
If Course_Period.course_period_id is equal to blank and course_sequence (Master_Courses.custom_field_13) is not equal to blank and partial_credit (Master_Courses.custom_field_16 not equal to 1 or Y) not equal to Y, then use course_sequence (Master_Courses.custom_field_13). Set (Schedule or Course_Periods).priority = 0 for School_Years table, 1 for School_Semesters table & 2 for School_Quarters table.Set (Schedule or Course_Periods).priority = 0 for School_Years table, 1 for School_Semesters table & 2 for School_Quarters table. If Schedule.priority = 0, then output A. If Course_Periods.priority equals Schedule.priority and Course_Periods.priority not equal to blank and Schedule.priority not equal to blank, If Master_Courses.course_sequence is not blank, then use Master_Courses.course_sequence, otherwise output 0. If Course_Periods.priority is not equal to Schedule priority, then use 1, 2, 3 or 4 based on Scheduling.sibling_count and Scheduling.course_sequence. |
3,4 |
||
|
UniqueSectionCode |
Class ID Number |
If course_period.course_period_id is blank, then output CH + non_campus + marking period short_name + courses.short_name or student_report_card_grades.COURSE_NUM. Else output course_period.course_period_id + marking period.short_name. |
"If Course_Period.course_period_id is blank, then output 'CH' concatenated with CoursePeriod.custom_4 concatenated with marking period (School or Course) short_name concatenated with Courses.short_name(Submission 3) or Student_Report_Card_Gardes.course.num (Submission 4) Else output Course_Period.course_period_id + marking period (School or Course) short_name." |
3,4 |
||
|
TX-OnRampsDualEnrollmentIndicator' |
Onramps Dual Enrollment |
STUDENTS |
If Student_Report_Card_Grades.onramps or Master_Courses.onramps is <> ' ' use Student_rReport_Card_Grades.onramps or Master_Courses.onramps Else use Students.custom_300000072 |
"If Student_Report_Card_Grades.onramps or Master_Courses.onramps is <> ' ' use Student_rReport_Card_Grades.onramps or Master_Courses.onramps Else use Students.custom_300000072 used on the Graduation tab in Student Information." |
3,4 |