S_TX_USR_RESP_C (ver 16.10.0)
This table is an child of the Users table, and holds information related to Staff Responsibility Records for the PEIMS Fall Submission.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.10.0 | Number(10,0) | The primary key for this record. |
| SchoolID | 16.10.0 | Varchar2(9) | The campus ID associated with this record. |
| SectionID | 16.10.0 | Number(11,0) | The internal section ID for a section. This will be 0 if the record is not associated to a section. |
| UsersDCID | 16.10.0 | Number(10,0) | The foreign key that connects this record to the Users table. |
| YearID | 16.10.0 | Number(11,0) | The year associated to this record. |
| E0017_Grade_Level_Code | 20.7.2.0 | Varchar2(2) | The grade level of the students in the class. Reported only for teaching and paraprofessional staff that provide services to Special Education students. |
| E0170_Number_Students | 16.10.0 | Number(11,0) | The number of students in the class on snapshot date. |
| E0721_Role_ID | 16.10.0 | Varchar2(3) | The role ID for the staff for this record. |
| E0724_Service_ID | 16.10.0 | Varchar2(8) | The Service ID for this record. |
| E0747_Population_Served | 16.10.0 | Varchar2(2) | The population served for this record. |
| E0764_Weeks_of_Month | 16.10.0 | Varchar2(50) | Discontinued field. Weeks of month this section was taught. |
| E1055_Class_Type | 16.10.0 | Varchar2(2) | The Class Type for this record. |
| E1056_Class_ID_Number | 16.10.0 | Varchar2(14) | The unique section ID for this record. |
| E1057_Monthly_Minutes | 16.10.0 | Number(11,0) | The monthly minutes for this record. |
| E1604_Days_Taught_Week_1 | 18.6.0 | Number(11,0) | The number of days the PE class meets during the first week of October. |
| E1605_Days_Taught_Week_2 | 18.6.0 | Number(11,0) | The number of days the PE class meets during the second week of October. |
| E1606_Days_Taught_Week_3 | 18.6.0 | Number(11,0) | The number of days the PE class meets during the third week of October. |
| E1607_Days_Taught_Week_4 | 18.6.0 | Number(11,0) | The number of days the PE class meets during the fourth week of October. |
| E1608_Minutes_Taught_Week_1 | 18.6.0 | Number(11,0) | The number of minutes the PE class meets during the first week of October. |
| E1609_Minutes_Taught_Week_2 | 18.6.0 | Number(11,0) | The number of minutes the PE class meets during the second week of October. |
| E1610_Minutes_Taught_Week_3 | 18.6.0 | Number(11,0) | The number of minutes the PE class meets during the third week of October. |
| E1611_Minutes_Taught_Week_4 | 18.6.0 | Number(11,0) | The number of minutes the PE class meets during the fourth week of October. |
| E1673_ADSY_Teacher_Ind | 21.3.2.0 | Number(1,0) | Indicates that the Staff Responsibility Record if the for the ADSY program reported for the PEIMS Extended Year Submission. |
| Lock_Record | 22.12.1 | Number(1,0) | Indicates the record is locked and will not be refreshed by the Staff Responsibility process. |