Documentation for Administrators

Staff Association Extension

Updated on

Expand or collapse content Staff Responsibility
Element Name Alias Name Table Field/Logic End User Logic Field ID Sub
StateOrganizationId
 District ID
 SCHOOLS
 CUSTOM_100000001
 Schools.custom_100000001(District ID) where custom_100000001 is used in School Information
1
StaffUniqueStateId
 Texas Unique Staff ID
 USERS
 CUSTOM_300000002
 Users.custom_300000002 (Texas Unique Staff ID) where custom_300000002 is used in User Information
1
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_327
 Schools.custom_327(Campus ID) where custom_327 is used in School Information
1
TX-StaffRole
 Role ID
 USERS
 CUSTOM_400000008 / If there is a value set, use that value. If no value set, use default. If value is not set, and no default is set, grab value set on parent user.
 Users.custom_400000008 (Role ID) where custom_400000008 is used on the General tab in User Information
1
TX-ServiceId
 Service ID
 COURSES
 CUSTOM_10 / If value is not set, grab value from master courses table/course catalog (master_courses.MC_CUSTOM_FIELD_12)
 Courses.custom_10 where custom_10 is used in Courses.  If Courses.custom)19 is blank, get from Master_Courses.custom_field_12.
1
TX-UniqueSectionCode
 Class ID Number
 COURSE_PERIODS
 COURSE_PERIOD_ID
 Course_Periods.course_period_id where course_period_id is used in Course Periods
1
Element Name Alais Name Table Field/Logic End User Logic Field ID Sub
TX-PopulationServed
 Population Served
 COURSE_PERIODS
 CUSTOM_6 / If value is not set grab value from master courses/course catalog
(master_courses.MC_CUSTOM_FIELD_1)
 Course_Periods.custom_6 where custom_6 is used in Course Periods.  If Course_periods.custom_6 is blank get from Master_Courses.custom_field_1.
1
TX-NumberOfStudentsInClass
 Number Student in Class
LOGIC / Count of number of students in class for the submission period.
 Number of students scheduled where effective date falls within the range of Schedule.start_date and Schedule.end_date
1
TX-SharedServiceArrangementStaffIndicator
 ESC SSA Staff Indicator
OUTPUT BLANK
 Output Blank
1
TX-ClassTypeCode
 Class Type
 COURSE_PERIODS
 CUSTOM_2 / If value is not set grab value from master courses/course catalog
(master_courses.MC_CUSTOM_FIELD_20)
 Course_Periods.custom_2 where custom_2 is used in Course Periods.  If Course_Periods.custom_2 is blank get from Master_Courses.custom_field_20.
1
TX-MonthlyMinutes
 Monthly Minutes
LOGIC / Use minutes based on bell schedule, If Class Mins Monthly is NOT blank (course_periods.custom_13) then use it instead of bell schedule minutes.
 Use minutes based on bell schedule, If Class Mins Monthly is NOT blank (Course_Periods.custom_13) then use it instead of bell schedule minutes.
1
TX-NumberDaysTaughtWeek1
 Number of Days Week 1
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week1 <> Blanks
use Course_periods.num_days_week1
Else
use Number of Days Week 1 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week1 <> Blanks
use Course_periods.num_days_week1
Else
use Number of Days Week 1 from Bell Schedule
Else
use Blanks "

1
TX-NumberDaysTaughtWeek2
 Number of Days Week 2
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week2 <> Blanks
use Course_periods.num_days_week2
Else
use Number of Days Week 2 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week2 <> Blanks
use Course_periods.num_days_week2
Else
use Number of Days Week 2 from Bell Schedule
Else
use Blanks "
1
TX-NumberDaysTaughtWeek3
 Number of Days Week 3
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week3 <> Blanks
use Course_periods.num_days_week3
Else
use Number of Days Week 3 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week3 <> Blanks
use Course_periods.num_days_week3
Else
use Number of Days Week 3 from Bell Schedule
Else
use Blanks "
1
TX-NumberDaysTaughtWeek4
 Number of Days Week 4
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week4 <> Blanks
use Course_periods.num_days_week4
Else
use Number of Days Week 4 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_days_week4 <> Blanks
use Course_periods.num_days_week4
Else
use Number of Days Week 4 from Bell Schedule
Else
use Blanks "
1
TX-NumberMinutesTaughtWeek1
 Number of Minutes Week 1
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week1 <> Blanks
use Course_periods.num_minutes_week1
Else
use Number of Minutes Week 1 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week1 <> Blanks
use Course_periods.num_minutes_week1
Else
use Number of Minutes Week 1 from Bell Schedule
Else
use Blanks "
1
TX-NumberMinutesTaughtWeek2
 Number of Minutes Week 2
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week2 <> Blanks
use Course_periods.num_minutes_week2
Else
use Number of Minutes Week 2 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week2 <> Blanks
use Course_periods.num_minutes_week2
Else
use Number of Minutes Week 2 from Bell Schedule
Else
use Blanks "
1
TX-NumberMinutesTaughtWeek3
 Number of Minutes Week 3
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week3 <> Blanks
use Course_periods.num_minutes_week3
Else
use Number of Minutes Week 3 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week3 <> Blanks
use Course_periods.num_minutes_week3
Else
use Number of Minutes Week 3 from Bell Schedule
Else
use Blanks "
1
TX-NumberMinutesTaughtWeek4
 Number of Minutes Week 4
 COURSE_PERIODS
 If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week4 <> Blanks
use Course_periods.num_minutes_week4
Else
use Number of Minutes Week 4 from Bell Schedule
Else
Use Blanks
 "If IS_MAIN (Main Teacher Record) and Service ID equals 02530002, 02530003, 02850000, 03823000, PES00052, PES00053, PES00054, PES00055, 82200***, 82930***, 83200*** or 84200***
If Course_periods.num_minutes_week4 <> Blanks
use Course_periods.num_minutes_week4
Else
use Number of Minutes Week 4 from Bell Schedule
Else
use Blanks "
1
Expand or collapse content Staff Responsibility Extension (Services Tab)
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
StaffUniqueStateId
 Texas Unique Staff ID
 USERS
 CUSTOM_300000002
 Users.custom_300000002 (Texas Unique Staff ID) where custom_300000002 is used in User Information
1
StateOrganizationId
 Campus ID
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD1
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-StaffRole
 Role ID
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD2 / If there is a value set, use that value. If no value set, use default. If value is not set, and no default is set, grab value set on parent user.
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-ServiceId
 Service ID
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD3
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-UniqueSectionCode
 Class ID Number
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD4
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-PopulationServed
 Population Served
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD5
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-NumberOfStudentsInClass
 Number Student in Class
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD6
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-SharedServiceArrangementStaffIndicator
 ESC SSA Staff Indicator
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD7
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-ClassTypeCode
 Class Type
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD8 / If value is set, use that value, else use defaults.
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
TX-MonthlyMinutes
 Monthly Minutes
 CUSTOM_FIELD_LOG_ENTRIES
 LOG_FIELD9
 Custom_Field_Log_Entries for FIeld ID 300000001 used on the Services tab in User Information
 300000001
 1
Expand or collapse content Teacher Section Association
Element Name Alais Name Table Field/Logic End User Logic Field ID Sub
StaffUniqueStateId
 Texas Unique Staff ID
 USERS
 CUSTOM_300000002
 Users.custom_300000002 (Texas Unique Staff ID) where custom_300000002 is used in User Information
6
StateOrganizationId
 Campus ID
 SCHOOLS
 CUSTOM_327
 Schools.custom_327(Campus ID) where custom_327 is used in School Information
6
UniqueSectionCode
 Class ID Number
 COURSE_PERIODS, SCHOOL_YEARS, SCHOOL_SEMESTERS, SCHOOL_QUARTERS
 COURSE_PERIODS.COURSE_PERIOD_ID + SHORT_NAME
 Course_Periods.course_period_id concatenated with short_name from (School_Years or School_Semesters or School_Quarters)
6
BeginDate
 Assignment Begin Date
 SCHOOL_YEARS, SCHOOL_SEMESTERS, SCHOOL_QUARTERS
 START_DATE
 Course_Periods.co_teacher##_custom2 (Co-Teachers) or School_Years.start_date or School_Semesters.start_date or School_Quearters.start_date
6
EndDate
 Assignment End Date
 SCHOOL_YEARS, SCHOOL_SEMESTERS, SCHOOL_QUARTERS
 END_DATE
 Course_Periods.co_teacher##_custom3 (Co-Teachers) or School_Years.start_date or School_Semesters.start_date or School_Quearters.start_date
6
TX-CourseSequence
 Course Sequence
LOGIC / If marking period priority = 0, then output A. If course_period priority equals schedule priority and course_catalog.course_sequence is not blank, then use course_catalog.course_sequence. If course_period priority equals schedule priority and course_catalog.course_sequence is blank, then use 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.
 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_Period.priority equals Sschedule.priority and Master_Courses.custom_field_13 is not blank, then use Master_Courses.custom_field_13. If Course_Period.priority equals Schedule.priority and Master_Courses.custom_field_13 is blank, then use 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.
6
TX-StaffRole
 Role ID
 USERS
 CUSTOM_400000008
 Users.custom_400000008 (Role ID) where custom_400000008 is used on the General tab in User Information
6
Previous Article Student Enrollment Extension
Next Article Student Attendance Extension
Print Article

Texas State Reporting

Texas Reports 26
State Reporting Fields: TSDS Extracts 12