Student Fields Explained.xlsx

	A	B	C	D	E	F	G
1	Count	Table	Field Name	Field Type	What is it?	Example of Export	Notes
2	1	STUDENTS	Alert_Discipline	Icon/Text Field	Displays an Icon and text to teachers when populated	n/a	LPS doesn't use this field
3	2	STUDENTS	Alert_DisciplineExpires	Date	A date field that controls Alert Discipline and if it is "Active" or not	0/0/00
4	3	STUDENTS	Alert_Guardian	Icon/Text Field	Displays a Guardian Icon to teachers when populated	Parent1 is not allowed to pick up student
5	4	STUDENTS	Alert_GuardianExpires	Date	A date field that controls Alert Guardian and if it is "Active" or not	0/0/00
6	5	STUDENTS	Alert_Medical	Icon/Text Field	Displays a Medical Icon to teachers when populated	Student is allergic to Milk
7	6	STUDENTS	Alert_MedicalExpires	Date	A date field that controls Alert Medical and if it is "Active" or not	0/0/00
8	7	STUDENTS	Alert_Other	Icon/Text Field	Displays a Caution Icon and text to the teacher when Populated	Student is a FEL student	LPS uses this to help teachers Identify EL students who have exited EL Program
9	8	STUDENTS	Alert_OtherExpires	Date	A date field that controls Alert Other and if it is "Active" or not	0/0/00
10	9	STUDENTS	LDAPEnabled	Toggle field	A Yes/No Field on if a SSO is enabled	0 or 1	Displays as a 0 or 1 when exported
11	10	STUDENTS	Student_AllowWebAccess	Toggle field	A Yes/No Field for if a student is allowed to access PS Online	0 or 1	Displays as a 0 or 1 when exported
12	11	STUDENTS	AllowWebAccess	Toggle field	A Yes/No Field for if a Contact is allowed to access PS Online	0 or 1	Displays as a 0 or 1 when exported
13	12	STUDENTS	Student_Web_ID	Text Field	Text Field that is used as the Student's Username in connected application	Follows naming convention	"Tbarrows" Caveat = this is unique to each user. Similar to the student email, just without the @longmeadow….
14	13	STUDENTS	Student_Web_Password	Encrypted Password Field	Text Field used to store the students password and share between connected applications	****	LPS updated to the lastest version of PS on 10/15/2024. This newest version encryted this field and made it unable to be exported. We at LPS had students reset their passwords out of an abundance of caution. It is also only available to be seen by a select few at each building
15	14	STUDENTS	Web_ID	Reference Field	Displays the Students "Student_Number"	#####
16	15	STUDENTS	Web_Password	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
17	16	STUDENTS	WM_Address	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
18	17	STUDENTS	WM_CreateDate	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
19	18	STUDENTS	WM_CreateTime	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
20	19	STUDENTS	WM_Password	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
21	20	STUDENTS	WM_Status	Toggle Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
22	21	STUDENTS	WM_StatusDate	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
23	22	STUDENTS	WM_TA_Date	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
24	23	STUDENTS	WM_TA_Flag	Toggle Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
25	24	STUDENTS	WM_Tier	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
26	25	STUDENTS	Applic_Response_Recvd_Date	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
27	26	STUDENTS	Applic_Submitted_Date	Date	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
28	27	STUDENTS	ClassOf	Number	Stores the calculated Graduation Class Year	2024
29	28	STUDENTS	DistrictEntryDate	Date	Legacy Field (no longer in use)	0/0/00	It is not Common for LPS to fill these fields out
30	29	STUDENTS	DistrictEntryGradeLevel	Date	Legacy Field (no longer in use)	0/0/00	It is not Common for LPS to fill these fields out
31	30	STUDENTS	Enrollment_SchoolID	Text Field	Displays the School Code that the student enrolled with in the beginning of the year	159505	Based on Codes set up by DESE, no words are sent, just numbers that correlate to values on DESE's side
32	31	STUDENTS	Enrollment_Transfer_Date_Pend	Date	When the student is expected to start/leave	0/0/00	This is not a common field as we typically transfer the day the student leaves, rather than setting a transfer for a future date
33	32	STUDENTS	Enrollment_Transfer_Info	Text Field	User entered text that displays where a student was enrolling From	"Student is enrolling into LHS from Springfield High School"	Only really relavant to New Students. Previously enrolled students receive a standard "Promote to next school"
34	33	STUDENTS	EnrollmentCode	Text Field	Status of Student's Enrollment	01	Based on Codes set up by DESE, no words are sent, just numbers that correlate to values on DESE's side
35	34	STUDENTS	EnrollmentID	Number	Number that is assigned to a student's application/initial enrollment	111111	This number links a student to the Enrollment Express forms / Applications
36	35	STUDENTS	EnrollmentType	Text Field	Arizona State Field Only	N/A	LPS has never used this field
37	36	STUDENTS	EntryCode	Number	Explains how/Why a student is enrolling	04	Based on Codes set up by DESE, no words are sent, just numbers that correlate to values on DESE's side
38	37	STUDENTS	EntryDate	Date	When the student enrolled in the current year	8/27/2024
39	38	STUDENTS	ExitCode	Number	Explains how/Why a student is transferring	02	Based on Codes set up by DESE, no words are sent, just numbers that correlate to values on DESE's side
40	39	STUDENTS	ExitComment	Text Field	User entered text that displays where a student is tranferring to in the current year	"Student Is transferring to Greenfield Public Schools"
41	40	STUDENTS	ExitDate	Date	When the student transferred in the current year	6/30/2025
42	41	STUDENTS	GPEntryYear	Number	The year the student entered the Grad Planner	N/A	Grad Planner is not used by LPS
43	42	STUDENTS	GradReqSet	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
44	43	STUDENTS	GradReqSetID	Text Field	Links the student to the Grad Req Table	N/A	LPS hasn't used this field, and it currently holds no data
45	44	STUDENTS	Graduated_Rank	Text Field	Class Rank upon graduating	N/A	LPS doesn't use this field or Rank their students
46	45	STUDENTS	Graduated_SchoolID	Display Field	Displays the School Number for the School that the student Graduated From	159505
47	46	STUDENTS	Graduated_SchoolName	Display Field	Displays the School Name for the School that the student Graduated From	Longmeadow High School
48	47	STUDENTS	SchoolEntryDate	Date	When the student enrolled in the current school in the current year	8/27/2024
49	48	STUDENTS	SchoolEntryGradeLevel	Number	Grade level that the student enrolled into when first entering the school	11
50	49	STUDENTS	SchoolID	Number	ID associated with the school student attends	0159505
51	50	STUDENTS	Sched_LoadLock	Toggle Field	Field with either a yes/no on if a students load (scheduling requests) is locked	0	Exported as a 0 or a 1
52	51	STUDENTS	Sched_LockStudentSchedule	Toggle Field	Field with either a yes/no on if a student's schedule is locked	1	Exported as a 0 or a 1
53	52	STUDENTS	Sched_NextYearBuilding	Text Field	Scheduled building for next year	N/A	LPS doesn't use this field
54	53	STUDENTS	Sched_NextYearBus	Text Field	Legacy Field (no longer in use)	N/A	LPS hasn't used this field, and it currently holds no data
55	54	STUDENTS	Sched_NextYearGrade	Number	The grade level the student is scheduled to enter next year	12
56	55	STUDENTS	Sched_NextYearHomeRoom	Text Field	Text field that lists the next year's homeroom	N/A	LPS hasn't used this field, and it currently holds no data
57	56	STUDENTS	Sched_NextYearHouse	Text Field	Scheduled House for next year	N/A	LPS doesn't use this field
58	57	STUDENTS	Sched_NextYearTeam	Text Field	Scheduled Team for next year	N/A	LPS doesn't use this field
59	58	STUDENTS	Sched_Priority	Number	This field is used when loading students into the Class Scheduler at the High School. Seniors receive more priority when scheduling than first years	20
60	59	STUDENTS	Sched_Scheduled	Toggle field	Identifies if a student is allowed to be scheduled using PowerScheduler	0	Exported as a 0 or a 1
61	60	STUDENTS	Sched_YearOfGraduation	Number	Year that the student is scheduled to graduate	2025
62	61	STUDENTS	SummerSchoolID	Number	ID of the summer school student is attending	N/A	LPS does not use this field
63	62	STUDENTS	SummerSchoolNote	Text Field	Note as to why the student is enrolling in summer school	N/A	LPS does not use this field
64	63	STUDENTS	TransferComment	Text Field	User entered text that displays where a student is tranferring to in the current year	"Student is getting their GED and Unenrolled"	This is similar to the Exit Comment
65	64	STUDENTS	Exclude_fr_rank	Toggle Field	Deliniates if a student should be included in class rank or not	N/A	LPS does not use this field
66	65	STUDENTS	State_EnrollFlag	Toggle Field	Used for State Reporting, identifies if a student is enrolled at the State Level	0
67	66	STUDENTS	State_ExcludeFromReporting	Toggle Field	Used for State Reporting, Identifies if a Student's information is being sent to the state for Reporting	0
68	67	STUDENTS	FTEID	Number	Field used in PowerSchool in tandem with Attendance and Enrollment. It is a field that is used to calculate attendance values at the state	1
69	68	STUDENTS	FullTimeEquiv_obsolete	Number	Legacy Field (no longer in use)	N/A	LPS does not use this field
70	69	STUDENTS	Home_Room	Text Field	Identifies what HomeRoom the student is apart of, used for Report card as well	Barr/3	Each school uses the field differently, typically though it is the name of the teacher with the room number
71	70	STUDENTS	DistrictOfResidence	Dropdown Field	Used for State Reporting to identify the district that the student resides in	0159
72	71	STUDENTS	Enroll_Status	Hidden Field	A field in the background that designates if a student record is set to "Active" (or Enrolled) or not	01
73	72	STUDENTS	LastFirst	Indexed Field	This is used on exports to identify the combined values of the students last name and first name	Smith, John	This is not stored in the SIS, but is based on the two other fields (Last name, and First Name)
74	73	STUDENTS	Last_Name	Text Field	Text value reflecting the Student's Last Name	Smith
75	74	STUDENTS	First_Name	Text Field	Text value reflecting the Student's First Name	John
76	75	STUDENTS	Middle_Name	Text Field	Text value reflecting the Student's Middle Name	Jack
77	76	STUDENTS	Gender	Dropdown Field	Value reflecting the student's designated Gender	M
78	77	STUDENTS	DOB	Date	Value reflecting the student's Date of birth	01/01/2001
79	78	STUDENTS	HomePhone	Text Field	Value reflecting the student's Home Phone (taken from time of enrollment)	413-413-4131
80	79	STUDENTS	Ethnicity	Toggle Field	Value representing if the student is identified as Hispanic/Latino or not	0	Value is exported as a 0 or 1
81	80	STUDENTS	FedEthnicity	CheckBox Field	Value reflecting the student's overall Race	C	Values are indexed and only the first letter is exported
82	81	STUDENTS	FedRaceDecline	Toggle Field	Values reflecting if Race was collected or declined	0	MA reporting requires that we collect race. In the event that we have a family that wishes to not identify, we work out an exception with the State of Massachussetts for Reporting
83	82	STUDENTS	Grade_Level	Calculated Field	Value is based on Enrollment and reflects the grade that the student is currently enrolled in for the school	11
84	83	STUDENTS	Student_Number	Primary Key	Value that marks and identifies each student individually. This is the field used to ensure no duplicated students	0000
85	84	STUDENTS	State_StudentNumber	State Primary Key	Value that marks and identifies each student individually based on the MA State database. This is the field used to ensure no duplicated students across MA Schools	000000000	This number is only available at the State level, you would need access to their data tables to use this number and identify students in their reports. DESE data tabels were NOT Compromised at all
86	85	STUDENTS	ID	Number	Number that is generated everytime a record is added to the system	N/A	Values for ID vary and is automatically generated, but this field is not used to any degree in LPS PowerSchool for reports or internal processes
87	86	STUDENTS	DCID	Number	Internal Number generated in PowerSchool to connect the student table to other tables (Stored Grades, Attendance, etc)	0000	DCID is not an ID field that LPS uses for any integrations. The auto-generated field is used internally in PowerSchool amongst the data tables
88	87	STUDENTS	Locker_Combination	Text Field	Displays the students Locker Combination	00-00-00	Used by the main office to assist students when they forget their combination
89	88	STUDENTS	Next_School	Dropdown Field	This field is used to show what the student's next year grade level is going to be	12	This is a field used for Scheduling and when the year rolls to the next. It is how students are moved from one grade to the next in PowerSchool
90	89	STUDENTS	Locker_Number	Number	Displays the student's Locker Number	000	Used by the main office to assist students when they forget where their locker is
91	90	STUDENTS	Street	Text Field	Field that identifies a students Street Address	535 Bliss Road
92	91	STUDENTS	City	Text Field	Field that identifies a students City Address	Longmeadow
93	92	STUDENTS	Geocode	Generated Field	Field that Identifies the Lat and Lng of a students address	Lat: 00.00000, Lng: 00.0000	This is used when identifying where a student should be enrolled at the Elm and MS level
94	93	STUDENTS	State	Text Field	Field that identifies a students State	MA
95	94	STUDENTS	Zip	Text Field	Field that identifies a students ZipCode	01106
96	95	STUDENTS	Mailing_Street	Text Field	Field that identifies a students Mailing Street Address	535 Bliss Road	These fields are used to identify where paper information is sent home. 99% are a duplicate of the Students Resident Address
97	96	STUDENTS	Mailing_City	Text Field	Field that identifies a students Mailing City Address	Longmeadow	These fields are used to identify where paper information is sent home. 99% are a duplicate of the Students Resident Address
98	97	STUDENTS	Mailing_Geocode	Generated Field	Field that Identifies the Lat and Lng of a students Mailing address	Lat: 00.00000, Lng: 00.0000	These fields are used to identify where paper information is sent home. 99% are a duplicate of the Students Resident Address
99	98	STUDENTS	Mailing_State	Text Field	Field that identifies a students Mailing State	MA	These fields are used to identify where paper information is sent home. 99% are a duplicate of the Students Resident Address
100	99	STUDENTS	Mailing_Zip	Text Field	Field that identifies a students Mailing ZipCode	01106	These fields are used to identify where paper information is sent home. 99% are a duplicate of the Students Resident Address