| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
| StateOrganizationId |
DISTRICT ID |
TEXAS_DISTRICT_INFORMATION |
DISTRICT_ID |
Texas_District_Information.district_id where district_id is used in District Information |
1,2,3,4,5,6 |
|
|
TX‐TotalNumSchoolBoardRequests |
Total Number of School Board Requests |
TEXAS_DISTRICT_INFORMATION |
REQUESTS_NUMBER |
Texas_District_Information.requests_number where requests_number is used in District Information |
3 |
|
|
TX‐TotalCostSchoolBoardRequests |
Total Cost of School Board Requests |
TEXAS_DISTRICT_INFORMATION |
REQUESTS_COST |
Texas_District_Information.requests_cost where requests_cost is used in District Information |
3 |
|
| TX-ArmedServicesVocAptBatteryIndicator |
ASVAB |
TEXAS_DISTRICT_INFORMATION |
ASVAB |
Texas_District_Information.asvab where Armed Services Voc Apt Battery Indiator is used in District Information |
1 |
|
| TX-ProgramOfStudy |
Progam Of Study |
TEXAS_DISTRICT_INFORMATION |
PROGRAMS_OF_STUDY |
Texas_District_Information.programs_of_study where Programs of Study is used in District Information |
1 |
|
| TX-GiftedTalentedProgramCode |
Gifted Program |
TEXAS_DISTRICT_INFORMATION |
GT_PROGRAMS |
Texas_District_Information.gt_programs where Gifted and Talented Program Code is used in District Information |
1 |
| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
StateOrganizationId |
Campus ID |
SCHOOLS |
CUSTOM_100000001 + CUSTOM_327 |
Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information |
1,2,3,4,5,6 |
|
|
StateOrganizationId |
District ID |
SCHOOLS |
CUSTOM_100000001 |
Schools.custom_100000001(District ID) where custom_100000001 is used in School Information |
1,2,3,4,5,6 |
|
|
ClassPeriodReference |
Class Periods |
SCHOOL_PERIODS |
SHORT_NAME |
If School_Periods.period_id is NULL use ‘00’ otherwise use School_Periods.short_name where short_name is used in School Periods |
3 |
|
| TX-CampusEnrollmentType |
Campus Enrollment Type |
SCHOOLS |
CUSTOM_300000003 |
Schools.custom_300000003 where custom_300000003 is used in School Information |
1 |
|
|
TX-NSLPTypeCode |
NSLP Code |
SCHOOLS |
CUSTOM_400009436 |
Schools.custom_400009436 where custom_400009436 is used in School Information |
1 |
|
| TX-PKFullDayWaiver |
PK Full Day Waiver |
SCHOOLS |
CUSTOM_300000004 |
Schools.custom_300000004 where custom_300000004 is used in School Information |
3 |
|
| TX-ExpandedLearningOpportunityIndicator |
School ELO |
If record exist for custom_field_log_entries.school_id for field id 300000001(Expanded Learning Opportunities) then use 1 otherwise use 0. |
If record exist for custom_field_log_entries.school_id for field id 300000001(Expanded Learning Opportunities) then use 1 otherwise use 0. |
3,4 |
||
| TX-SchoolELOS |
School ELOS |
If record exist for custom_field_log_entries.school_id for field id 300000001(Expanded Learning Opportunities) use appropriate column information from logging field |
If record exist for custom_field_log_entries.school_id for field id 300000001(Expanded Learning Opportunities) use appropriate column information from logging field |
3,4 |
| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
ID |
Period ID |
SCHOOL_PERIODS |
CP_ + SHORT_NAME |
CP concatenated with school_periods.short_name where the short_name is used in the master schedule |
1,2,3,4 |
|
|
ClassPeriodName |
Class Period |
SCHOOL_PERIODS |
SHORT_NAME |
School_periods.short_name where the short_name is used in the master schedule |
3 |
| Element Name |
Alias Name |
Table |
Field/Logic |
End User Logic |
Field ID |
Sub |
|---|---|---|---|---|---|---|
|
ID |
Service ID |
STUDENT_REPORT_CARD_GRADES and MASTER_COURSES |
CUSTOM_14 and CUSTOM_FIELD_12 |
Student_Report_Card_Grades.custom_14 where custom_14 is used for PEIMS Course Number in Course History and/or Master_Courses.custom_field_12 where custom_field_12 is used for PEIMS Course Number in course catalog |
1,2,3,4 |
|
|
StateOrganizationId |
Campus ID |
SCHOOLS |
CUSTOM_100000001 + CUSTOM_327 |
Schools.custom_100000001(District ID) concatenated with Schools.custom_327(Campus ID) where custom_100000001 & custom_327 are used in School Information |
1,2,3,4 |