|
Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
COURSE-OFFERING-ID |
Course Offering ID |
SCHOOLS, STUDENT_REPORT_CARD_GARDES, MASTER_COURSES |
StateOrganizationId + ID |
Schools.custom_327 concatenated with Student_Report_Card_Grades.custom_14 or Master_Courses.custom_field_12 where custom_327 is used in School Information, custom_14 is used in Grades and custom_field_12 is used in Course Catalog |
3,4,6 |
|
|
StateOrganizationId |
Campus ID |
SCHOOLS |
CUSTOM_327 |
Schools.custom_327(Campus ID) where custom_327 is used in School Information |
3,4,6 |
|
|
ID |
Service ID |
STUDENT_REPORT_CARD_GARDES, MASTER_COURSES |
CUSTOM_14, CUSTOM_FIELD_12 |
Student_Report_Card_Grades.custom_14 or Master_Courses.custom_field_12 where custom_14 is used in Grades and custom_field_12 is used in Course Catalog |
3,4,6 |
|
Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
UniqueSectionCode |
Class ID Number |
COURSE_PERIODS, STUDENT_REPORT_CARD_GRADES |
CH_ + NON_CAMPUS + SCMP_SHORT_NAME or CPMP_SHORT_NAME + SHORT_NAME |
CH' concatentated with Student_Report_Card_Grades.custom_field_6 concatenaed with Marking Period Short Name concatenated with Student_Report_Card_Grades.short_name or Courses.short_name |
3,4,6 |
|
|
CourseOfferingReference |
Service ID |
STUDENT_REPORT_CARD_GARDES, MASTER_COURSES |
CUSTOM_14, CUSTOM_FIELD_12 |
Student_Report_Card_Grades.custom_14 or Master_Courses.custom_field_12 where custom_14 is used in Grades and custom_field_12 is used in Course Catalog |
3,4,6 |
|
|
StateOrganizationId |
Campus ID |
SCHOOLS |
CUSTOM_327 |
Schools.custom_327(Campus ID) where custom_327 is used in School Information |
3,4,6 |
|
|
ClassPeriodName |
Class Period |
SCHOOL_PERIODS, STUDENT_REPORT_CARD_GRADES |
PERIOD_SHORT_NAME |
Use 'CH' when from Student_Report_Card_Grades. Use '00' if School_Periods.period_id is null otherwise use School_periods.period_id when from School_Periods. |
3,6 |
|
|
TX‐SchoolYear |
School Year |
SYEAR |
2 digit this school year concatenated with - concatenated with 2 digit next school year |
3,4,6 |
||
|
TX‐PopulationServed |
Population Served |
COURSE_PERIODS, MASTER_COURSES |
CUSTOM_6, CUSTOM_FIELD_1 |
Course_Periods.custom_6 or Master_Courses.custom_field_1 where custom_6 is used in Course Periods and custom_field_1 is used in Course Catalog |
3,6 |
|
|
TX‐CourseSequence |
Course Sequence |
LOGIC |
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 Schedule.priority = 0, then output A. If Course_Period.priority equals Schedule.priority and Course_Period.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_Period.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,6 |
||
|
TX‐NonCampusBasedInstruction |
Non Campus Based Instruction |
MASTER_COURSES, COURSE_PERIODS |
NON_CAMPUS |
Master_Courses.custom_field_6 or Course_Periods.custom_4 where custom_field_6 is used in Course Catalog and custom_4 is used in Course Periods |
3,6 |
|
|
TX-PKCurricula |
PK Curricula |
MASTER_COURSES, COURSES, STUDENT_REPORT_CARD_GRADES |
PK_CURRICULA |
Master_Courses.pk_curricula or Courses.pk_curricula or Student_Report_Card_Grades.pk_curricula where Master_Courses.pk_curricula is used in Course Catalog, Courses.pk_curricula is used in Courses and Student_Report_Card_Grades.pk_curricula is used in Grades |
6 |
|
|
TX-HighQualityPrekProgramIndicator |
High Quality PK Program |
COURSE_PERIODS, STUDENT_REPORT_CARD_GRADES, SCHOOLS, COURSES, MASTER_COURSES, COURSES_PERIODS |
HQ_PK_INDICATOR |
Schools.custom_400009434 or Master_Courses.hq_pk_indicator or Courses.hq_pk_indicator or Course_Periods.hq_pk_indicator or Student_Report_Card_Grades.hq_pk_indicator where custom_400009434 is used in School Information, Master_Courses.hq_pk_indicator is used in Course Catalog, Courses.hq_pk_indicator is used in Courses, Course_Periods.hq_pk_indicator is used in Course Periods and Student_Report_Card_Grades.hq_pk_indicator is used in Grades |
6 |
|
|
TX-StudentInstruction |
Student Instruction |
COURSE_PERIODS, STUDENT_REPORT_CARD_GRADES, COURSES, MASTER_COURSES, COURSES_PERIODS |
STUDENT_INSTRUCTION |
Master_Courses.student_instruction or Courses.student_instruction or Course_Periods.student_instruction or Student_Report_Card_Grades.student_instruction whereMaster_Courses.student_instruction is used in Course Catralog, Courses.student_instruction is used in Courses, Course_Periods.student_instruction is used in Course Periods and Student_Report_Card_Grades.student_instruction is used in Grades |
6 |
|
|
TX-PKSchoolType |
PK School Type |
COURSE_PERIODS, STUDENT_REPORT_CARD_GRADES, SCHOOLS, COURSES |
PK_SCHOOL_TYPE |
Schools.custom_400009435 or Courses.pk_school_type or Course_Periods.pk_school_type or NULL if from Student_Report_Card_Grades where custom_400009435 is used in School Information, Courses.pk_school_type is used in Courses, Course_Periods.pk_school_type is used in Course Periods |
6 |
|
| TX-ProgramEvaluationType |
PK Program Evaluation |
MASTER_COURSES, COURSES, COURSE_PERIODS |
PK_PROGRAM_EVALUATION |
Master_Courses.pk_program_evaluation or Courses.pk_program_evaluation or Course_Periods.pk_program_evaluation where pk_program_evaluation is used in Course Catalog, Courses or Course Periods. |
6 |