| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Count | Table | Field Name | Field Type | What is it? | Example of Export | Notes | |||||||||||||||||||
2 | 1 | TEACHERS | Homeroom | Text Field | Shows the Teachers Home Room | Room 23 | ||||||||||||||||||||
3 | 2 | TEACHERS | LoginID | Display Field | Displays the PowerSchool Login ID from Users Table | jsmith | ||||||||||||||||||||
4 | 3 | TEACHERS | Sched_Lunch | Toggle Field | Displays if the teacher should be assigned a lunch period on each valid lunch day | 0 or 1 | LPS does not use this Field | |||||||||||||||||||
5 | 4 | TEACHERS | TeacherLoginID | Display Field | Displays the PowerSchool Login ID from Teachers Table | jsmith@longmeadow.k12.ma.us | ||||||||||||||||||||
6 | 5 | TEACHERS | Zip | Text Field | Show the Teachers Zip Code | 01106 | ||||||||||||||||||||
7 | 6 | TEACHERS | TeacherNumber | Number | From the Teachers Table, the number assigned to the record | 0000 | This is an internal Primary Key | |||||||||||||||||||
8 | 7 | TEACHERS | WM_Status | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
9 | 8 | TEACHERS | ID | Number | Sequential number generated by PowerSchool at time of creating staff account | 000000 | This is an internal Primary Key for the Staff Table | |||||||||||||||||||
10 | 9 | TEACHERS | StaffStatus | Display Field | Displays staff Type | 00 | The values are exported as numbers 00 - 04 | |||||||||||||||||||
11 | 10 | TEACHERS | NameAsImported | Matching Tool | Tool used when importing staff to ensure no duplication | N/A | LPS doesn't import Staff information | |||||||||||||||||||
12 | 11 | TEACHERS | WM_CreateDate | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
13 | 12 | TEACHERS | AdminLDAPEnabled | Toggle Field | Displays if the staff account has access to PowerSchool Admin or not | 0 or 1 | ||||||||||||||||||||
14 | 13 | TEACHERS | TeacherLoginPW | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
15 | 14 | TEACHERS | Sched_TotalCourses | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
16 | 15 | TEACHERS | WM_CreateTime | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
17 | 16 | TEACHERS | SSN | Text Field | Displays the Staff Member's Social Security Number | 000-00-0000 | LPS has not collected SSN's since the use of MUNIS at the Town Level. That is now the repository for a majority of staff information | |||||||||||||||||||
18 | 17 | TEACHERS | IPAddrRestrict | Text Field | Field that allows an admin to limit the IPs that a user can log in from | N/A | LPS does not use this Field, we use SSO as a MFA | |||||||||||||||||||
19 | 18 | TEACHERS | State | Text Field | Displays the Staff Member's State | MA | ||||||||||||||||||||
20 | 19 | TEACHERS | Home_Phone | Text Field | Displays the Phone Number associated with the staff member | This field is used for Robo Calls during Emergencies and inclimate weather alerts | ||||||||||||||||||||
21 | 20 | TEACHERS | Sched_UseBuilding | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
22 | 21 | TEACHERS | Classpua | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
23 | 22 | TEACHERS | Sched_Team | Text Field | Scheduling field used to show what "Team" or Pod a teacher is a part of during scheduling. This helps keep student pods together | Blue Team | LPS does not use this Field | |||||||||||||||||||
24 | 23 | TEACHERS | NoOfCurClasses | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
25 | 24 | TEACHERS | Sched_MaxPreps | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
26 | 25 | TEACHERS | WM_Address | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
27 | 26 | TEACHERS | Email_Addr | Text Field | Displays a staff members Email Address | jsmith@longmeadow.k12.ma.us | This field is used for Robo Calls during Emergencies and inclimate weather alerts | |||||||||||||||||||
28 | 27 | TEACHERS | PrefixCodesetID | Number | Displays the foreign key for the prefix table codset | 0000000000000 | Exported value is a number that corresponds to the Prefix table. "Mr" would turn into a number | |||||||||||||||||||
29 | 28 | TEACHERS | WM_StatusDate | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
30 | 29 | TEACHERS | Sched_Scheduled | Toggle Field | Checkbox to toggle if a Teacher should show up in the PowerScheduler in order to be scheduled | 0 or 1 | ||||||||||||||||||||
31 | 30 | TEACHERS | Sched_IsTeacherFree | Toggle Field | Checkbox to toggle if a teacher can be scheduled at any time | 0 or 1 | ||||||||||||||||||||
32 | 31 | TEACHERS | Ethnicity | Toggle Field | Checkbox to deliniate what the Ethnicity of a Staff member is | C | This is used at the state level to assign MEPIDs | |||||||||||||||||||
33 | 32 | TEACHERS | TeacherLoginIP | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
34 | 33 | TEACHERS | Access | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
35 | 34 | TEACHERS | DefaultStudScrn | Display Field | What page does the user want opened by default when working with a student record | CLOB | Value exported is trimmed into acronyms | |||||||||||||||||||
36 | 35 | TEACHERS | StaffPers_guid | Number | ID for the staff member on the Users Table | kjkfg90i9nkgjfkjg99 | Value exported is a string of text that is the primary key generated from the Users table | |||||||||||||||||||
37 | 36 | TEACHERS | AllowLoginStart | Text Field | Allows an admin to set a valid "Start Time" where a Staff member wouldn't be able to log in before | 8:00am | LPS does not use this Field | |||||||||||||||||||
38 | 37 | TEACHERS | PTAccess | Toggle Field | Checkbox to deliniate if a staff member has access to PowerTeacherPro or not | 0 or 1 | ||||||||||||||||||||
39 | 38 | TEACHERS | Sched_PrimarySchoolCode | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
40 | 39 | TEACHERS | Sched_Substitute | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
41 | 40 | TEACHERS | Sched_HouseCode | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
42 | 41 | TEACHERS | Sched_Homeroom | Text Field | The homeroom that the staff member is assigned to | Room 23 | ||||||||||||||||||||
43 | 42 | TEACHERS | Sched_Classroom | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
44 | 43 | TEACHERS | PowerGradePW | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
45 | 44 | TEACHERS | Sched_MaxPers | Text Field | Allows an admin to set the number of max periods a teacher is allowed to be scheduled | 5 | ||||||||||||||||||||
46 | 45 | TEACHERS | WM_TA_Flag | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
47 | 46 | TEACHERS | PeriodsAvail | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
48 | 47 | TEACHERS | HomePage | Display Field | Displays the page that the user has as the default page when logging into PowerSchool | Home Page | ||||||||||||||||||||
49 | 48 | TEACHERS | Balance4 | Display Field | Not Tracked in LPS PowerSchool | N/A | LPS does not use this Field | |||||||||||||||||||
50 | 49 | TEACHERS | Balance3 | Display Field | Not Tracked in LPS PowerSchool | N/A | LPS does not use this Field | |||||||||||||||||||
51 | 50 | TEACHERS | Password | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
52 | 51 | TEACHERS | Balance2 | Display Field | Not Tracked in LPS PowerSchool | N/A | LPS does not use this Field | |||||||||||||||||||
53 | 52 | TEACHERS | Balance1 | Display Field | Staff members Lunch Balance | 0.000 | ||||||||||||||||||||
54 | 53 | TEACHERS | Sched_ActivityStatusCode | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
55 | 54 | TEACHERS | supportContact | Toggle Field | Shows if the staff member can contact PowerSchool Support | 0 or 1 | ||||||||||||||||||||
56 | 55 | TEACHERS | HomeSchoolId | Number | Displays the School Code for the school where the user spends a majority of their time | 01590505 | ||||||||||||||||||||
57 | 56 | TEACHERS | GradebookType | Toggle Field | Displays what type of gradebook teacher is using | 0 or 1 | ||||||||||||||||||||
58 | 57 | TEACHERS | NumLogins | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
59 | 58 | TEACHERS | PreferredName | Text Field | A commonly used name for the staff member | N/A unless specified by Staff | ||||||||||||||||||||
60 | 59 | TEACHERS | Group | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
61 | 60 | TEACHERS | AllowLoginEnd | Text Field | Allows an admin to set a valid "End Time" where a Staff member wouldn't be able to log in after | N/A | LPS does not use this Field | |||||||||||||||||||
62 | 61 | TEACHERS | Sched_TeacherMoreOneSchool | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
63 | 62 | TEACHERS | WM_Alias | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
64 | 63 | TEACHERS | SchoolID | Number | Number associated to the school the staff member is located | 01590505 | ||||||||||||||||||||
65 | 64 | TEACHERS | TeacherLDAPEnabled | Toggle Field | Checkbox to deliniate if a staff member has access SSO or not | 0 or 1 | ||||||||||||||||||||
66 | 65 | TEACHERS | CanChangeSchool | Display Field | Lists the school numbers seperated by semi-colon that a user is able to access | 01590505;888888888 | ||||||||||||||||||||
67 | 66 | TEACHERS | Sched_MaximumDuty | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
68 | 67 | TEACHERS | Sched_MaximumConsecutive | Number | Displays the number of consecutive periods a teacher is allowed to be scheduled | 3 | This is used during school scheduling between years | |||||||||||||||||||
69 | 68 | TEACHERS | LastFirst | Display Field | Displays the indexed fields "Last name", "First Name" | Smith, John | ||||||||||||||||||||
70 | 69 | TEACHERS | FedEthnicity | Toggle Field | Allows an admin to toggle if the staff member identifies as Hispanic/Latino | 0 or 1 | ||||||||||||||||||||
71 | 70 | TEACHERS | City | Text Field | Displays the staff members City of residence | |||||||||||||||||||||
72 | 71 | TEACHERS | Notes | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
73 | 72 | TEACHERS | WM_TA_Date | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
74 | 73 | TEACHERS | PSAccess | Toggle Field | From the Users table, shows if a staff member can access PowerSchool Admin | 0 or 1 | ||||||||||||||||||||
75 | 74 | TEACHERS | Photo | Display Field | Shows if the staff member has a photo or not | 0 or 1 | ||||||||||||||||||||
76 | 75 | TEACHERS | Lunch_ID | Number | Number associated to a staff member from the Lunch Table | 2345 | ||||||||||||||||||||
77 | 76 | TEACHERS | Maximum_Load | Number | Allows an admin to set a max number of students scheduled for a teacher | 21 | ||||||||||||||||||||
78 | 77 | TEACHERS | Sched_Gender | Display Field | Shows the gender value associated to a staff member | M | ||||||||||||||||||||
79 | 78 | TEACHERS | WM_Tier | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
80 | 79 | TEACHERS | Sched_MaximumCourses | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
81 | 80 | TEACHERS | Street | Text Field | Displays the Staff member's street address | |||||||||||||||||||||
82 | 81 | TEACHERS | WM_Exclude | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
83 | 82 | TEACHERS | Middle_Name | Text Field | Displays the staff member's middle name | |||||||||||||||||||||
84 | 83 | TEACHERS | Users_DCID | Number | Displays the Primary key number for the staff member from the Users table | 000000 | ||||||||||||||||||||
85 | 84 | TEACHERS | LastMeal | Display Field | Shows the last date a member purchased a meal | \00/00/0000 | LPS | |||||||||||||||||||
86 | 85 | TEACHERS | Last_Name | Text Field | Displays a staff members Last Name | Smith | ||||||||||||||||||||
87 | 86 | TEACHERS | SIF_StatePrid | Toggle Field | Checkbox to deliniate if a staff member's data is sent to State Reporting or not | 0 or 1 | ||||||||||||||||||||
88 | 87 | TEACHERS | FedRaceDecline | Toggle Field | Shows if a staff member declined to answer Fed Race | N/A | Data is collected as a requirement for MA state reporting | |||||||||||||||||||
89 | 88 | TEACHERS | WM_Password | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS has not used this for quite some time. All staff is expected to use Our SSO method to access PowerSchool which requires access to the users work email | |||||||||||||||||||
90 | 89 | TEACHERS | dcid | Number | Primary Key associated to the Staff member through all tables | 000000 | ||||||||||||||||||||
91 | 90 | TEACHERS | Title | Text Field | What the staff member is teaching or employed to do | Principal, Custodian, etc | ||||||||||||||||||||
92 | 91 | TEACHERS | Sched_MaximumFree | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
93 | 92 | TEACHERS | Status | Toggle Field | Displays if a staff member is set to active or not | 0 or 1 | ||||||||||||||||||||
94 | 93 | TEACHERS | First_Name | Text field | Displays a staff members Efirst Name | John | ||||||||||||||||||||
95 | 94 | TEACHERS | Sched_Department | Dropdown Menu | displays what department a staff member belongs to | Music | ||||||||||||||||||||
96 | 95 | TEACHERS | Log | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
97 | 96 | TEACHERS | Sched_BuildingCode | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
98 | 97 | TEACHERS | School_Phone | Text Field | Displays the Staff members Classroom number | Ext 0000 | ||||||||||||||||||||
99 | 98 | TEACHERS | Sched_UseHouse | Legacy Field | Legacy Field (No Longer Used) | N/A | LPS does not use this Field | |||||||||||||||||||
100 |