Staff

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool Navigation

Staff Demographics

staffUniqueId

E1524

TX-UNIQUE-STAFF-ID

u.SIF_StatePrid

Y

State-assigned number for staff
Must be the actual UID - no backup source

Staff > Information > StatePrId

personalTitlePrefix

trim(substr(u.Title, 1, 30))

N

firstName

E0703

FIRST-NAME

ucf.PSCORE_LEGAL_FIRST_NAME
u.First_Name

Y

Staff > Information > Legal First or First

middleName

E0704

MIDDLE-NAME

ucf.PSCORE_LEGAL_MIDDLE_NAME
u.Middle_Name

N

Staff > Information > Legal Middle or Middle

LastSurname

E0705

LAST-NAME

ucf.PSCORE_LEGAL_LAST_NAME
u.Last_Name

Y

Staff > Information > Legal Last or Last

sexType

E1325
E0004

SEX
SEX-CODE

ucf.gender

TX

Mar 2022: TEA values changed from '01', '02' to 'M', 'F'

birthDate

E0006

DATE-OF-BIRTH

ucf.dob

TX

format date

hishispanicLatinoEthnicity

E1064
E1375

HISPANIC-LATINO-CODE
HISPANIC-LATINO-ETHNICITY

u.FedEthnicity

Y

draft shows E1375; when 1 then 'true', otherwise 'false'
Note: True and False outputs have been used for TSDS collections; output for PEIMS has been 1 and 0, but I think the booleans will be true or false for Ed-Fi.

highestCompletedLevelOfEducationDescriptor

E1460

E0730

HIGHEST-LEVEL-OF-EDUCATION-COMPLETED
HIGHEST-DEGREE-LEVEL-CODE

These are both the same field in PS:
HIGHEST-LEVEL-OF-EDUCATION-COMPLETED E1460
HIGHEST-DEGREE-LEVEL-CODE E0730
Source for both:  S_TX_USERS_X.E0730_Highest_Degree

TX

Default = 1 (Bachelor's)
Reason for two TEA fields:  E1460 used for TSDS Collections with output of the text description using one TSDS code table; E0730 used for PEIMS Collections with output of the numeric code using a different PEIMS Code Table.  LevelOfEducation descriptors, C015 in final spec.

Staff > Information > Highest Degree Level (E0730)

highlyQualifiedTeacher

xt.highlyQualifiedTeacher

N

'true' if 1, 'false' if 0, don't publish if null

electronicMail

[Array]

N

only one in PowerSchool

electronicMailType

'04' Work

Y

electonicMailAddress

u.Email_Addr

Y

identificationCodes

[Array]

N

Not collect by TEA, no TEA descriptors, use core Ed-Fi

staffIdentificationSystemDescriptor

E1088

STAFF-IDENTIFICATION-SYSTEM

'District, 'State'

Y

identificationCode

E0505

STAFF-ID

STAFF-ID E0505 is the Social Security Number
USERS.SSN

Y

All users must be reported with SSN; do not use a secondary source

Staff > Information > SSN

races

[Array]

TX

E1343 RACIAL-CATEGORY is currently used in the TSDS collections; in the PEIMS collections, the separate race elements are used.  

Staff > Information > Race

raceDescriptor

E1059
etc.

TEACHERRACE.RaceCd, left-zero-pad to 2 chars

Y

Initial draft included E1343 but later specs do not.

E1059

AMERICAN-INDIAN-ALASKA-NATIVE-CODE

E1060

ASIAN-CODE

E1061

BLACK-AFRICAN-AMERICAN-CODE

E1062

NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE

E1063

WHITE-CODE

telephones

N

not required but published in Base - users.school_phone

telephoneNumberTypeDescriptor

'06' Work

N-R

telephoneNumber

substr(trim(u.school_phone), 1, 24)

N-R

TX extensions

generationCodeDescriptor

E0706
E1303

GENERATION-CODE
GENERATION-CODE-SUFFIX

S_TX_USERS_X.E0706_Generation_Code
single-char code, don't left-zero-pad to 2 chars

TX

Report only if populated; do not use core legal suffix
Changed to descriptor Oct 1 spec

Staff > Information > Generation Code

pkTeacherRequirementDescriptor

E1581

PK-TEACHER-REQUIREMENT

S_TX_USR_X.E1581_PK_Teacher_Req

TX

Currently only reported in the TSDS ECDS PK Collection (required)
No default is applied if missing, which triggers a loader error for correction
Current code table:
01 - Certification offered through a training center accredited by Association Montesorri Internationale or through the Montessori Accreditation Council for Teacher Education
02 - At least eight years’ experience of teaching in a nationally accredited child care program
03 - Be employed as a prekindergarten teacher in a school district that has ensured specific prekindergarten professional development has been met.
04 - A graduate or undergraduate degree in early childhood education or early childhood special education
05 - A Child Development Associate (CDA) credential
06- -Documented completion of the Texas School Ready Training Program (TSR Comprehensive)

Staff > Information > PK Teacher Requirement (E1581)

totalYearsProfExperience

E0130

TOTAL-YEARS-PROF-EXPERIENCE

TOTAL-YEARS-PROF-EXPERIENCE E0130
S_TX_USERS_X.E0130_Total_Years_Exp

TX

Default = 1
Used for PEIMS collections.  Moved to extension Oct 21 spec

Staff > Information > Total Years Experience (E0130)

totalYearfPriorTeachingExperience

E1377

YEARS-OF-PRIOR-TEACHING-EXPERIENCE

YEARS-OF-PRIOR-TEACHING-EXPERIENCE E1377
S_TX_USERS_X.E1377_Yrs_Prior_Teach_Exp

TX

Default = 1
Field added in PSSR-256839; used for the TSDS Winter Class Roster Collection where only teachers are reported. Moved to extension Oct 21 spec

Staff > Information > Years of Prior Teaching Experience (E1377)

creditableYearOfService

E1721

CREDITABLE-YEAR-OF-SERVICE-INDICATOR-CODE

S_TX_USR_X.E1721_Credit_Year_Svc_Ind

TX

New for 21-22 - will be reported only for the TSDS Winter Class Roster collection
See new field in PSSR-256839 (21.8.2 release)
added in Jul 1 doc

Staff > Information > Creditable Year Of Service Indicator Code (E1721)

yearsExperienceInDistrict

E0161

YEARS-EXPERIENCE-IN-DISTRICT

S_TX_USR_X.E0161_Years_Exp_in_District

TX

Default = 1
Current domain of values:  1-99
Also note that this value is auto-incremented by 1 by TX Year End Process Automation if the preference is enabled in District

Staff > Information > Years Experience in District (E0161)

staffId

E0505

STAFF-ID

USERS.ssn

TX 

All users must be reported with SSN; do not use a secondary source

Staff > Information > SSN

teacherIncentiveAllotmentDesignations

[Array]

made array Mar 2022

     teacherIncentiveAllotmentDesignationDescriptor

E1722

TEACHER-INCENTIVE-ALLOTMENT-DESIGNATION-CODE

S_TX_USR_X.E1722_Tch_Inc_Allot

TX

csv, up to 3 values, e.g. '01,02,03'; added Oct 22, new this year, see PSSR-256839

additionalDaysProgramTeacher

E1673

ADDITIONAL-DAYS-PROGRAM-TEACHER-INDICATOR-CODE

S_TX_USR_RESP_C.E1673_ADSY_Teacher_Ind

TX

added Mar 2022
Currently reported only in PEIMS Extended Year Submission 4

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > ADSY Program Teacher Indicator (E1673)

staffDoNotReportTSDS

E3069

S_USR_X.State_ExcludeFromReporting

TX

added Mar 2022, not collected by TEA, flag in Landing Zone

labeled as 'Exclude from PEIMS/TSDS'

typeSets

[Array]

TX

     staffTypeDescriptor

E1073

STAFF-TYPE-CODE

S_TX_USR_X.E1073_Staff_Type_Code

TX

Default = 1
CodeValues:
1 - School District Or Charter School Employee
3 - Contracted Professional Staff
4 - Teacher Employed At In-District Charter Partner Campus

Staff > Information > Staff Type Code (E1073)

     beginDate

E3010

use start and end of school year

TX

TEA: May be in prior year
Collected twice during the year and may change during year.
If it changes, previous certified value would still be in TEA repository.
Suggest adding 2nd Staff_Type_Code field if needed, publish for 2nd half of year if populated

     endDate

E3020

day after last day of school year

TX

TEA: First day of non-applicability

paraprofessionalCertificationSets

TX

     paraprofessionalCertification

E1670

PARAPROFESSIONAL-CERTIFICATION-INDICATOR-CODE

S_TX_USR_X.E1670_Paraprof_Cert_Ind

TX

Currently reported only in the PEIMS Fall Submission.
Reported as 1 or 0; default is 0
This indicator is only reported for paraprofessional staff that provide services to Special Education students. Educational Aides (ROLE-ID 033) serving special education students (POPULATION-SERVED-CODE 06).

Staff > Information > Paraprofessional Certification Indicator (E1670)

     beginDate

E3010

use start and end of school year

TX

TEA: May be in prior year
Currently not reported and no date-based tracking is in place.

     endDate

E3020

day after last day of school year

TX

TEA: First day of non-applicability

additional fields for display only

sch.school_name

district view only

u.teachernumber

u.lastfirst

Staff Associations

staffEducationOrganizationEmploymentAssociations

 Primary PowerSchool Source Data

Tables: USERS (u), SCHOOLSTAFF (ss)
S_TX_USR_FIN_C (fin)
S_TX_USR_X
S_USR_X

Publish only if config parameter PublishHRStaffAndAssociations = 1

• Otherwise not published from SIS; 0 indicates Ed-Fi enabled HR system in use

Selection Criteria

One record published for each S_TX_USR_FIN_C where:

• Record_Type = '050'

• Yearid is the selected year

• Percent_Day_Employed or Number_Days_Employed is not null

• Staff member is not excluded from Ed-Fi (S_USR_X.ExcludeFromEdFi = 1)

Or publish dummy record if no active record in S_TX_USR_FIN_C and:

• PublishDefaultStaffEmployment = 1

• And staff meets other Staffs selection criteria

• Selected record in S_TX_USR_RESP_C

• Or taught published section during school year

• Not otherwise excluded

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool Navigation

educationOrganizationId

E0212

DISTRICT-ID

district Id

Y

table is district-level data, no school id

staffUniqueId

E1524

TX-UNIQUE-STAFF-ID

u.SIF_StatePrid

Y

State-assigned number for staff
Must be the actual UID - no backup source

employmentStatusDescriptor

LZ

derived from fin.percent_day_employed

Y

Landing zone only, TX descrptors deleted  - use Ed-Fi core descriptors
if percent_day_employed = 100 then full time else part-time
Dummy record: full time (TX or Ed-Fi core equivalent)

hireDate

E3032

schoolyear start

Y

changed to TX-required Mar 2022; TEA: may be a date in a prior school year

endDate

E3020

n/a

TX

Added Mar 2022 - not currently reported.
Publish  day after end of school year if staff is no longer active, otherwise blank

TX extensions

percentDayEmployed

E0760

PERCENT-DAY-EMPLOYED

S_TX_USR_FIN_C.Percent_Day_Employed

TX

Currently reported for PEIMS Fall Submission only
Dummy record: 100

Staff > Information > TX State Report Information for Staff > Staff Data (Payroll and Employment) > % Day Employed (where Record Type = Employment (050) and Year is the current school year.

numberDaysEmployed

E0160

NUMBER-DAYS-EMPLOYED

S_TX_USR_FIN_C.Number_Days_Employed

TX

same as above
Dummy record: 180

Staff > Information > TX State Report Information for Staff > Staff Data (Payroll and Employment) > # Days Employed (where Record Type = Employment (050) and Year is the current school year.

auxiliaryRoleIdSets

[Array]

TX

     auxiliaryRoleIdDescriptor

E1594

AUXILIARY-ROLE-ID

S_TX_USR_X.E1594_Auxiliary_Role_ID

TX

same as above
Also note that there is an obsolete field with the same column name in the S_TX_USR_FIN_C table: E1594_Auxiliary_Role_ID.  This is no longer used due to usability issues when customers update records via import.

Staff > Information > Auxiliary Role ID (E1594)

     beginDate

E3010

use start and end of school year

TX

TEA: May be in prior school year.
Currently not reported and no date-based tracking is in place.
Default to first day of school or possibly to PEIMS Fall Snapshot Date?

     endDate

E3020

day after last day of school year

TX

TEA: First day of non-applicability

staffEducationOrganizationAssignmentAssociations

 Primary PowerSchool Source Data

Tables:  USERS (u), S_TX_USR_RESP_C

Used by TEA for Staff Responsibilities.

Selection Criteria

One record published for each record in S_TX_USR_RESP_C where:

• yearid is selected school year

• E0721_Role_ID is not null

• E0724_Service_ID is valid StaffSevice descriptor

• valid descriptors begin with 'SA', 'SE', 'SR', or 'SS'

• Instructional staff not generally included

• Staff is not excluded from Ed-Fi (S_USR_X.ExcludeFromEdFi = 1)

• School is not excluded from state reporting

• Published even if PublishHRStaffAndAssociations = 0

• These records are entered only if record not available in HR system

The Staff Responsibilities table S_TX_USR_RESP_C must be updated before publishing to have the most recent data.

Staff > Information > TX State Report Information for Staff > Staff Responsibilities

For Fall, Staff Responsibility records as populated in the table will need to be reported.  We have a function that creates/refreshes the Staff Responsibility records for assignments based on Sections - this is invoked by the user via the "Staff Responsiblity Record Creation" report or when running the Staff Interchange and selecting the option to "Refresh Staff Responsibility Records".   We should consider automating this routine so that it runs at least nightly during the Fall reporting cycle.

For non-instructional staff, some districts enter or import records; other districts source these records from the HR/Finance system.

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool Navigation

staffUniqueId

E1524

TX-UNIQUE-STAFF-ID

u.SIF_StatePrid

Y

State-assigned number for staff
Must be the actual UID - no backup source

staffClassificationDescriptor

E0721

ROLE-ID

S_TX_USR_RESP_C.E0721_Role_ID

TX

TX ROLE-ID - not related to the base Ed-Fi implementation.
Currently reported in Fall PEIMS Staff Responsibility Records (all Role ID's are reportable)
Value pulled as entered in the table where YearID = the current year.
For instructional staff, TEA will derive Role Id from StaffSectionAssociations ClassroomPosition.

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Role ID (E0721)

educationOrganizationId

E0266

CAMPUS-ID

S_TX_USR_RESP_C.SchoolID

TX

Note that many district level staff are reported under the SchoolID's of specific "admin" placeholder schools, which are not reportable schools & are used only for Staff Responsibility, Finance & Payroll records.  These admin schools are flagged as Exclude from State Reporting, and bear these 3 digit school numbers:  701, 750, 760, 761, 998 and 999.   They are never included in the Org School Extension - TEA automatically recognizes these numbers and allows them to be reported without any dependency on the SchoolExtension records.

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Campus ID (E0266) 

beginDate

E3010

start of school year

Y

Mar 2022 - collected by TEA; may be in prior year

endDate

E3020

end of school year

TX

Mar 2022 - collected by TEA
TEA: First day of non-applicability

positionTitle

u.title or Short Description from selected staffClassification

N

Not collected by TEA

TX extensions

TX

Required extension - staff service sets not published for teaching assignments where service id is not available or not in desciptors (e.g. most course codes) or is not available

staffServiceSets

[Array]

TX

Non-instructional services and ancillary instrucional services

     staffServiceDescriptor

E3072

SERVICE-ID

S_TX_USR_RESP_C.E0724_Service_ID

TX

TX Element Id changed from E0724 to E3072, 8/1/2022

     gradeLevelDescriptor

E0017

GRADE-LEVEL-CODE

S_TX_USR_RESP_C.E0017_Grade_Level_Code

TX

TEA reverted to gradeLevel descriptor for parallel year

Special Handling:
For StaffResponsibilitiesExtension, GRADE-LEVEL-CODE will only be reported for teaching and paraprofessional staff that provide services to Special Education students.  GRADE-LEVEL-CODE will only be reported for Teachers (ROLE-ID 087), Substitute Teachers (ROLE-ID 047), and Educational Aides (ROLE-ID 033) serving special education students (POPULATION-SERVED-CODE 06).

For Special Education (POPULATION-SERVED-CODE 06) Teachers (ROLE-ID 087), Substitute Teachers (ROLE-ID 047), and Educational Aides (ROLE-ID 033) who serve more than one grade level in the same class, report at least one StaffResponsibilitiesExtension per grade level range below:

• EE-PK - 1 record

• KG-12 - 1 record

Districts will be required to create separate sections for EE-PK students starting in the parallel year.

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Grade Level Code

     populationServedDescriptor

E0747

POPULATION-SERVED-CODE

S_TX_USR_RESP_C.E0747_Population_Served

CETX

Default is 01 Regular Students

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Population Served (E0747)

     numberOfStudentsInClass

E0170

NUMBER-STUDENTS-IN-CLASS

S_TX_USR_RESP_C.E0170_Number_Students 

TX

NUMBER-STUDENTS-IN-CLASS added in Sep 23 spec.  Normally reported only for staff sections.

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Students in Class (E0170)

     monthlyMinutes

E1057

MONTHLY-MINUTES

S_TX_USR_RESP_C.E1057_Monthly_Minutes

TX

MONTHLY-MINUTES (E1057) is the total number of minutes in a month devoted to a particular service. A month is generally considered to be the 4 weeks prior to the as-of date.

MONTHLY-MINUTES is reported for all instructional ROLE-IDs and is based upon 8400 minutes a month (7 hours per day x 5 days per week x 4 weeks per month).

MONTHLY-MINUTES is also reported for only one non-instructional ROLE-ID “008” Counselor and is based upon 9600 minutes a month (8 hours per day x 5 days per week x 4 weeks per month).

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Monthly Minutes (E1057)

     staffServiceBeginDate

E3060

TBD, for now default to start of school year

TX

name changed 4-22
Date non-instructional services began, may be in prior year. 
Needs to be before Fall snapshot date for inclusion in PEIMS.
New set with new begin date if monthly minutes etc. changes.

     staffServiceEndDate

E3061

end of school year

TX

Mar 2022 - collected by TEA
TEA: First day of non-applicability

additional fields for display only

sch.school_name

district view only

u.teachernumber

u.lastfirst

classification descriptor + ' ' + short description

staffSchoolAssociations

Primary PowerSchool Source Data

Tables: USERS (u), SCHOOLSTAFF (ss), S_TX_USR_X (uxt)

Used by TEA for Winter submission, not related to Base profile

Selection Criteria

One record published for each ss record where:

• School not excluded from reporting

• Staff not excluded from Ed-Fi

• S_TX_USR_X.E1722_Tch_Inc_Allot is not null

• S_TX_USR_X.E1721_Credit_Year_Svc_Ind = 1

• Staff not teaching any sections at any school

• TEA count: as of last Friday of February

• Publish for all schools associated with staff member (ss.schoolid)

 Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool Navigation

schoolId

ss.schoolid

Y

format schoolid

staffUniqueId

E1524

TX-UNIQUE-STAFF-ID

u.SIF_StatePrid

Y

State-assigned number for staff
Must be the actual UID - no backup source

programAssignmentDescriptor

E3045

Hard-coded, '01' TIA Teacher'

Y

only this one descriptor defined for 2022-23, all others removed

Staff Sections

staffSectionAssociations

Primary PowerSchool Source Data

Tables:  SCHOOLSTAFF (ss), SECTIONS (sec), SECTIONTEACHER (st), TERMS (t), USERS (u), S_IN_SSF_X (ssxt), COURSES (crs), CoursesCoreFields (ccf), SECTION_MEETING (sm), PERIOD (per), roledef (rd)
S_TX_SEC_ADD_STAFF_C,  S_USR_X (uxt)
S_TX_USR_RESP_C

Selection Criteria

Publish one record for each SectionTeacher record in current school year

• same exclusion rules as staff demographics

• course must exist in state downloads or published by district

• See selection criteria for CourseOfferings and sections

• SECTION_MEETING must be defined

• exclude if sec.Exclude_State_Rpt_YN = 1

• exclude if no students enrolled in section

• other exclusion rules same as for Staff Demographics and Sections

Special Handling:

1. exclude if section school or staff school association is excluded from state reporting:  this is true for normal sections, but not true for remote classes taught at non-reportable campuses.

2. Records for remote classes  must also be "fabricated" so that Teacher Section records are reported under the Home School ID's of the students enrolled in the class (same for MasterSchedule, StudentSection, and if appplicable, StudentTranscript)

Resource Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

PowerSchool Navigation

staffUniqueId

E1524

TX-UNIQUE-STAFF-ID

u.SIF_StatePrid

Y

State-assigned number for staff
Must be the actual UID - no backup source

sectionReference

Y

standard v2 section reference - Base Profile and INSite, except use v3 section identifier

localCourseCode

sec.course_number

Y

schoolId

Special Handling:

• "Normal" Classes:  State-assigned number based on SECTIONS.schoolId

• Remote Classes:   SchoolID reported as the Home School ID(s) of the student(s) in the classes.

Y

See Special Handling above

schoolYear

TERMS.yearid + 1991

Y

sectionIdentifier

E1056

CLASS-ID-NUMBER

Sections: S_TX_SEC_X.E1056_SectionIden_Calc
Manual Stored Grades: S_TX_SGR_X.E1056_SectionIden_Calc
Use calc fields in every case
For now, publish only the first 14 chars of the calculated section identifier.

Y

FYI, override fields are provided for user entry; calc fields take override values into account

• Sections: S_TX_SEC_X.E1056_SectionIden_Ovr

• Stored Grades:  S_TX_SGR_X.E1056_SectionIden_Ovr

The calc fields should always be used in publishing

Section Default: Section > TX State Information > Ed-Fi Section Identifier (E1056 - Calculated)
Section Override:  Section > TX State Information > Ed-Fi Section Identifier Override (E1056 - Override)
Historical Grades > State Reporting Overrides > Ed-Fi Section Identifier
Historical Grades > State Reporting Overrides > Ed-Fi Section Identifier Override

sessionName

Composite using TERMS.schoolid, TERMS.abbreviation, TERMS.dcid

Y

FORMAT:  t.schoolid '-' t.abbreviation '-' t.dcid

classroomPositionDescriptor

E1454

CLASSROOM-POSITION

[SectionTeacher]RoleID linked to [RoleDef]Name and [RoleDef]RoleModuleID

TX

Classroom Position values are output based on the staff member's assigned "Role" in the Section. 
PowerSchool Role                                                       TSDS Output
Lead Teacher                                                                Teacher Of Record
Co-Teacher                                                                    Assistant Teacher
Class Observer                                                              Support Teacher
Lead Teacher with override Role ID (E0721)             Substitute Teacher
of 047 in the section record
Teacher’s Aide                                                              PK Classroom Aide
Note: "PK Classroom Aide" will only be output for the ECDS PK Collection & the Winter Class Roster collection where the Service ID = 01010000; Grade PK is not reportable for the Fall Class Roster collection.

Role of "Job Share Teacher" is never reportable & is for local user only

School > Sections > Section # > Teacher - Section Lead
School > Sections > Section # > Teachers/Staff - Additional > Memo Icon > Role ID (E0721)  (used primarily for Substitute Teachers)
School > Sections > Section # > Teachers/Staff - Additional > Role > 

beginDate

E1065

ASSIGNMENT-BEGIN-DATE

st.start_date (or first term day)

TX

endDate

E1066

ASSIGNMENT-END-DATE

day after st.end_date (or last term day)

TX

First day after last day staff is assigned to section

percentageContribution

st.allocation/100.0

N

TX extensions

TX

Moved from StaffResponsibilities 3-22

     numberOfStudentsInClass

E0170

NUMBER-STUDENTS-IN-CLASS

S_TX_USR_RESP_C.E0170_Number_Students

Note element name was singluar rather than plural - TEA typo, corrected in Sep 23 spec

TX

NUMBER-STUDENTS-IN-CLASS is reported for instructional ROLE-IDs only.

If more than one classroom staff member is serving a group of students during the same class period, the person who is the “teacher of record” is reported with all the students for NUMBER-STUDENTS-IN-CLASS. The other staff members are reported with NUMBER-STUDENTS-IN-CLASS as 0.

Instructional Educational Aides and Certified Interpreters should report NUMBER-STUDENTS-IN-CLASS as 0.

TEA Fatal Edits
30090-0007:  If ROLE-ID is "002", "007", "015", "016", "017", "018", "021", "026", "032", "033", "036", "047", or "087", then the following must be provided: CLASS-ID-NUMBER, NUMBER-STUDENTS-IN-CLASS, CLASS-TYPE-CODE, and MONTHLY-MINUTES.
30090-0008:  If ROLE-ID is NOT "002", "007", "008", "015", "016", "017", "018", "021", "026", "032", "033", "036", "047", or "087", then the following must be blank: CLASS-ID-NUMBER, NUMBER-STUDENTS-IN-CLASS, CLASS-TYPE-CODE, and MONTHLY-MINUTES.

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Students in Class (E0170)

     monthlyMinutes

E1057

MONTHLY-MINUTES

S_TX_USR_RESP_C.E1057_Monthly_Minutes

TX

MONTHLY-MINUTES (E1057) is the total number of minutes in a month devoted to a particular service. A month is generally considered to be the 4 weeks prior to the as-of date.

MONTHLY-MINUTES is reported for all instructional ROLE-IDs and is based upon 8400 minutes a month (7 hours per day x 5 days per week x 4 weeks per month).

MONTHLY-MINUTES is also reported for only one non-instructional ROLE-ID “008” Counselor and is based upon 9600 minutes a month (8 hours per day x 5 days per week x 4 weeks per month).

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Monthly Minutes (E1057)

     numberDaysTaughtWeek1

E1604

NUMBER-DAYS-TAUGHT-WEEK-1

S_TX_USR_RESP_C.E1604_Days_Taught_Week_1

TX

Days & Minutes Taught Weeks 1-4 are reported only for specific PE Class Service ID's, and suppressed in all other records:   "02530002", "02530003", "02530004", "02530005", "02530006", "02530007", "02530008", "02850000", "03823000", "PES00052", "PES00053", "PES00054", "PES00055", "82210XXX", "82931XXX", "83210XXX", or "84200XXX"

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Days Taught per Week 1 (E1604)

     numberDaysTaughtWeek2

E1605

NUMBER-DAYS-TAUGHT-WEEK-2

S_TX_USR_RESP_C.E1605_Days_Taught_Week_2

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Days Taught per Week 2 (E1605)

     numberDaysTaughtWeek3

E1606

NUMBER-DAYS-TAUGHT-WEEK-3

S_TX_USR_RESP_C.E1606_Days_Taught_Week_3

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Days Taught per Week 3 (E1606)

     numberDaysTaughtWeek4

E1607

NUMBER-DAYS-TAUGHT-WEEK-4

S_TX_USR_RESP_C.E1607_Days_Taught_Week_4

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Days Taught per Week 4 (E1607)

     numberMinutesTaughtWeek1

E1608

NUMBER-MINUTES-TAUGHT-WEEK-1

S_TX_USR_RESP_C.E1608_Minutes_Taught_Week_1

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Minutes Taught per Week 1 (E1608)

     numberMinutesTaughtWeek2

E1609

NUMBER-MINUTES-TAUGHT-WEEK-2

S_TX_USR_RESP_C.E1609_Minutes_Taught_Week_2

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Minutes Taught per Week 2 (E1609)

     numberMinutesTaughtWeek3

E1610

NUMBER-MINUTES-TAUGHT-WEEK-3

S_TX_USR_RESP_C.E1610_Minutes_Taught_Week_3

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Minutes Taught per Week 3 (E1610)

     numberMinutesTaughtWeek4

E1611

NUMBER-MINUTES-TAUGHT-WEEK-4

S_TX_USR_RESP_C.E1611_Minutes_Taught_Week_4

TX

same as above

Staff > Information > TX State Report Information for Staff >
Staff Responsibilities > Number of Minutes Taught per Week 4 (E1611)

additional fields for display only

sch.school_name

district view only

u.teachernumber

u.lastfirst

crs.course_name

sec.section_number

terms descriptor from t.abbreviation

change to t.abbreviation?

ClassroomPositionSet

classroomPositionBeginDate

TX

E1065

ASSIGNMENT-BEGIN-DATE

st.start_date (or first term day)

classroomPositionDescriptor

TX

E1454

CLASSROOM-POSITION

[SectionTeacher]RoleID linked to [RoleDef]Name and [RoleDef]RoleModuleID

'01'
Teacher of Record

Classroom Position values are output based on the staff member's assigned "Role" in the Section. 
PowerSchool Role                                                       TSDS Output
Lead Teacher                                                                Teacher Of Record
Co-Teacher                                                                    Assistant Teacher
Class Observer                                                              Support Teacher
Lead Teacher with override Role ID (E0721)             Substitute Teacher
of 047 in the section record
Teacher’s Aide                                                              PK Classroom Aide
Note: "PK Classroom Aide" will only be output for the ECDS PK Collection & the Winter Class Roster collection where the Service ID = 01010000; Grade PK is not reportable for the Fall Class Roster collection.

Role of "Job Share Teacher" is never reportable & is for local user only