Students, 1 (ver3.6.1)
This table maintains Student demographics and other School related information such as Lunch ID, Grade Level and scheduling data.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alert_Discipline | 3.6.1 | CLOB | One of many various alerts in PowerSchool. This field stores the text tied to the alert. |
Alert_DisciplineExpires | 3.6.1 | Date | One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert. |
Alert_Guardian | 3.6.1 | CLOB | One of many various alerts in PowerSchool. This field stores the text tied to the alert. |
Alert_GuardianExpires | 3.6.1 | Date | One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert. |
Alert_Medical | 3.6.1 | CLOB | One of many various alerts in PowerSchool. This field stores the text tied to the alert. |
Alert_MedicalExpires | 3.6.1 | Date | One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert. |
Alert_Other | 3.6.1 | CLOB | One of many various alerts in PowerSchool. This field stores the text tied to the alert. |
Alert_OtherExpires | 3.6.1 | Date | One of many various alerts in PowerSchool. This field stores the expiration date tied to the alert. |
AllowWebAccess | 3.6.1 | Number(10,0) | Indicates whether to allow the parent user ID to log in to the parent/student page: 1=Yes 0=No |
Applic_Response_Recvd_Date | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Applic_Submitted_Date | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Balance1 | 3.6.1 | Float | Lunch balance. |
Balance2 | 3.6.1 | Float | Beginning lunch balance for the year copied from balance 1 in the end-of-year process. |
Balance3 | 3.6.1 | Float | Fees balance. |
Balance4 | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. Beginning fee balance for the year copied from balance3 in the end-of-year process. |
Building | 4.0.0 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. This field is necessary to capture the building value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearBuilding during the End-of-Year process. The field stores the text value of building (i.e.Building1). |
Bus_Route | 3.6.1 | Varchar(20) | The district name for the students' bus route. |
Bus_Stop | 3.6.1 | Varchar(20) | The stop number at which the student gets on and off the bus. |
CampusID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
City | 3.6.1 | Varchar(50) | City element of the students address. |
ClassOf | 3.6.1 | Number(10,0) | Stores the calculated graduation class year. |
CumulativeGPA | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Cumulative_Pct | 3.6.1 | Float | The cumulative percent GPA for the student as of the last time GPA calculations ran. |
Custom | 3.6.1 | CLOB | This field holds all the students' custom fields and their values in key-pair format separated by semicolons. |
CustomRank_ GPA | 3.6.1 | Float | The rank for the student as of the last time GPA calculations ran based on their custom calculations. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DistrictEntryDate | 3.6.1 | Date | A static field with no coding used simply to hold information entered by the district. |
DistrictEntryGradeLevel | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
DistrictOfResidence | 3.6.1 | Varchar(20) | The school district in which the student physically lives. |
DOB | 3.6.1 | Date | Date of birth. |
Doctor_Name | 3.6.1 | Varchar(305) | Name of the doctor for the student. |
Doctor_Phone | 3.6.1 | Varchar(30) | Phone number for the doctor. |
Emerg_Contact_1 | 3.6.1 | Varchar(305) | Name to contact in case of an emergency. |
Emerg_Contact_2 | 3.6.1 | Varchar(305) | Name to contact in case of an emergency. |
Emerg_Phone_1 | 3.6.1 | Varchar(30) | Phone number for the first emergency contact. |
Emerg_Phone_2 | 3.6.1 | Varchar(30) | Phone number for the second emergency contact. |
Enroll_Status | 3.6.1 | Number(10,0) | The enrollment status of the student.
|
Enrollment_SchoolID | 3.6.1 | Number(10,0) | This field holds the school ID value when creating reenrollment records. |
Enrollment_Transfer_Date_Pend | 3.6.1 | Date | Date of the pending transfer of the student from the school. If 00/00/00 then immediate transfer. |
Enrollment_Transfer_Info | 3.6.1 | BLOB | BLOB containing one or more comments regarding this transfer. |
EnrollmentCode | 3.6.1 | Number(10,0) | This can be used for any special code that needs to be attached to an enrollment. Currently, it is only used in AZ: 0=None 1=CECA 2=CECB 3=Open Enrollment |
EnrollmentID | 3.6.1 | Number(10,0) | Value which becomes the Reenrollments.ID value when the Reenrollments record is created except in the case that Reenrollments records are created for summer school. Required. Defaults to 0. |
EnrollmentType | 3.6.1 | Varchar(2) | This is used to specify what type of enrollment the student has at this school. Currently, it is only used in AZ: M=Main A=Ancillary |
EntryCode | 3.6.1 | Varchar(10) | The code representing how or why the student entered school. These codes are stored in Gen Table [6] cat=entrycodes. These are set in school setup. |
EntryDate | 3.6.1 | Date | The date the student enrolled in school for the current enrollment. Indexed. |
Ethnicity | 3.6.1 | Varchar(20) | Heritage background of a student. The codes assigned here are stored in the Gen Table [6] Cat=Ethnicity. These are set in school setup. |
Exclude_FR_ Rank | 3.6.1 | Number(10,0) | True/False. Exclude from class rank. Used to keep particular students from counting in the class rank. This is often used for special education students. |
ExitCode | 3.6.1 | Varchar(10) | The code representing how or why the student exited the school. These codes are stored in Gen Table [6] cat=exitcodes. These are set in school setup. |
ExitComment | 3.6.1 | CLOB | Any comments for the student exiting this school. |
ExitDate | 3.6.1 | Date | The date the student exited for the current/last enrollment. This is the day after a student-attended class. For example, if the last day the student is in school is a Wednesday, Thursday is the exit day. Indexed. |
Family_Ident | 3.6.1 | Varchar(30) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Father | 3.6.1 | Varchar(305) | Name of students father. |
Father_StudentCont_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
FedEthnicity | 6.0.0.1 | Number(10,0) | Numerical answer to the question "Is the student Hispanic or Latino?" Valid values :
|
FedRaceDecline | 6.0.0.1 | Number(10,0) | Valid values:
|
Fee_Exemption_Status | 3.7.0 | Number(10,0) | Determines what fees this student is exempt from. Valid values:
|
First_Name | 3.6.1 | Varchar(100) | Students' first name. |
FTEID | 4.0.0 | Number(10,0) | The internal number for the FTE with which this record is associated. Indexed. |
FullTimeEquiv_Obsolete | 4.0.0 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. FTEID is now used. Originally, Full-time equivalency to determine if this is a full-time or part-time student. The largest number for this will usually be 1 and fractions are expressed as decimals such as .5 or .25. Note: The column name was renamed from FullTimeEquiv to FullTimeEquiv_Obsolete in ver4.0.0. |
Gender | 3.6.1 | Varchar(2) | M=Male F=Female. Indexed. |
Geocode | 6.0.0 | Varchar(50) | Latitude/longitude coordinates for the student's primary address. |
GPEntryYear | 6.2.0 | Number(4) | The year the current entry entered the Grad Planner. |
Grade_Level | 3.6.1 | Number(10,0) | The grade the student is in. Since this is an integer: 0=Kindergarten 1, -2=Preschool. Indexed. |
GradReqSet | 3.6.1 | Varchar(3) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
GradReqSetID) | 3.6.1 | Number(10,0) | The graduation requirements this student follows. Links to the ID on the GradReq Table [37]. |
Graduated_Rank | 3.6.1 | Number(10,0) | Class rank upon the time of graduation. |
Graduated_SchoolID | 3.6.1 | Number(10,0) | Stores the school number the student graduated from so the user can search for him or her in the Graduated Students school. |
Graduated_SchoolName | 3.6.1 | Varchar(60) | Stores the name of the school the student graduated from so the user can search for him or her in the Graduated Students school. |
Guardian_StudentCont_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
GuardianEmail | 3.6.1 | CLOB | Parent/guardian email address. |
GuardianFax | 3.6.1 | Varchar(30) | Parent/guardian fax number. |
Home_Phone | 3.6.1 | Varchar(30) | Home phone number for the student. Indexed. |
Home_Room | 3.6.1 | Varchar(60) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
House | 4.0.0 | Varchar(10) | This field is necessary to capture the house value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearHouse during the End-of-Year process. The field stores the text value of house (i.e. Hawthorne). |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IsMigrated | 12.0.0 | Number(1,0) | Flag indicating if the Student information has been migrated to Contact Management (Person and related tables). Required. Valid values:
|
Last_Name | 3.6.1 | Varchar(100) | Students last name. |
LastFirst | 3.6.1 | Varchar(305) | Last, First, Mi. Indexed. |
LastMeal | 3.6.1 | Varchar(20) | Stores the date of last lunch purchase. |
LDAPEnabled | 4.3.0/5.0. 7 | Number(10,0) | Used for LDAP support. |
Locker_Combination | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Locker_Number | 3.6.1 | Varchar(15) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Log | 3.6.1 | CLOB | Place to write notes about transferring students. |
Lunch_ID | 3.6.1 | Float | The students PowerLunch number. Indexed. |
LunchStatus | 3.6.1 | Varchar(3) | Represents the portion of lunch a student must pay for: Blank=No status P=Full pay R=Reduced F=Free E=Exempt T=Temporary FDC=Free-DC. |
Mailing_City | 3.6.1 | Varchar(50) | City part of the mailing address. |
Mailing_Geocode | 6.0.0 | Varchar(50) | Latitude/longitude coordinates for the student's mailing address. |
Mailing_State | 3.6.1 | Varchar(2) | State part of the mailing address. |
Mailing_Street | 3.6.1 | Varchar(60) | Street address of the mailing address. |
Mailing_Zip | 3.6.1 | Varchar(10) | The zip code in the students mailing address. |
MembershipShare | 3.6.1 | Float | The amount of a student's membership this school claims. If a student attends more than one school each one will only be able to claim a certain portion of the membership. The largest number for this will usually be 1 and fractions expressed as decimals. Like .5 or .25. |
Middle_Name | 3.6.1 | Varchar(30) | Student's middle name. |
Mother | 3.6.1 | Varchar(305) | Name of student's mother. |
Mother_StudentCont_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
Next_School | 3.6.1 | Number(10,0) | The school the student will be attending the next school year. It is likely this will be the same school. The information is stored as the internal ID on the schools table for that school. |
Person_ID | 5.0.0 | Number(10,0) | The related person in the Relationship table. Indexed. |
Phone_ID | 3.6.1 | Number(10,0) | The number for the student on PowerLink. Indexed. |
PhotoFlag | 3.6.1 | Number(10,0) | Set to 1 if a photo exists for this student. |
PL_Language | 3.6.1 | Varchar(12) | PowerLink language, which is either Spanish or English. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus.If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
Sched_LoadLock | 5.0.0 | Number(10,0) | This field will lock individual students' schedules from Load. |
Sched_LockStudentSchedule | 3.6.1 | Number(10,0) | True/False: True (selected)=Do not allow the schedule to be changed by PowerScheduler. False (deselected)=Schedule this student when the scheduling engine is run. |
Sched_NextYearBuilding | 3.6.1 | Varchar(10) | The building this student will be in next year for schools with multi-building needs. |
Sched_NextYearBus | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_NextYearGrade | 3.6.1 | Number(10,0) | The grade the student is going to be in next year. If the student is being retained, this should be the same as the current grade level. |
Sched_NextYearHomeRoom | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Sched_NextYearHouse | 3.6.1 | Varchar(10) | The house this student will belong to next year. This is used for scheduling purposes. A house is most often used for school within a school type of scheduling. |
Sched_NextYearTeam | 3.6.1 | Varchar(10) | The team this student will belong to next year. |
Sched_Priority | 3.6.1 | Number(10,0) | Indicates when you want this student to be scheduled in relation to the other students. The lower the number, the sooner he or she is scheduled. |
Sched_Scheduled | 3.6.1 | Number(10,0) | A flag indicating if this student has had a schedule built for them. True means they do have a schedule and another will not be made unless the engine is told to reschedule regardless of this flag. False, the engine will build a schedule for this student next time. |
Sched_YearOfGraduation | 3.6.1 | Number(10,0) | Year of graduation. This changes if the student fails or skips a grade. |
SchoolEntryDate | 3.6.1 | Date | A static field with no coding used to hold information entered by the district. |
SchoolEntryGradeLevel | 3.6.1 | Number(10,0) | Grade level of the student for entering into this school. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SDataRN | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Simple_GPA | 3.6.1 | Float | The simple GPA for the student as of the last time GPA calculations ran. |
Simple_PCT | 3.6.1 | Float | The simple percent GPA for the student as of the last time GPA calculations ran. |
SSN | 3.6.1 | Varchar(12) | Students Social Security number. Indexed. |
State | 3.6.1 | Varchar(2) | State element of address. |
State_EnrollFlag | 3.6.1 | Number(10,0) | True/False. Used for state reporting to indicate he or she is enrolled at the state level. |
State_ExcludeFromReporting | 3.6.1 | Number(10,0) | True/False. Used for state reports to exclude certain students from reports. Most often, these will be special education students who are reported differently. |
State_StudentNumber | 3.6.1 | Varchar(32) | The state-assigned student number for the student. In most cases, this number should stay the same from school to school. |
Street | 3.6.1 | Varchar(60) | Student's street address. |
Student_AllowWebAccess | 3.6.1 | Number(10,0) | Allow student user webID to log in to parent/student page: 1=Yes 0=No |
Student_Number | 3.6.1 | Float | Student Number assigned by the school. Indexed. |
Student_Web_ID | 3.6.1 | Varchar(20) | The student user ID for logging in to PowerSchool Parent. Indexed. |
Student_Web_Password | 3.6.1 | Varchar(20) | The password for Student_Web_ID. |
StudentPers_ guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
StudentPict_ guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
StudentSchlEnrl_guid | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
SummerSchoolID | 5.0.7 | Number(10,0) | School Identifier for this Student's Summer School, if applicable. |
SummerSchoolNote | 5.0.7 | Varchar(80) | Notes specific to this Student's Summer School. |
TeacherGroupID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Team | 4.0.0 | Varchar(10) | This field is necessary to capture the team value assigned in PowerScheduler to a student. This will need to be moved from Students:Sched_NextYearTeam during the End-of-Year process. Sched_NextYearTeam captures the record ID from the Gen table (Cat = TeacherGroups). Current_Team cannot capture the ID since this record is part of PowerScheduler and may be changed when scheduling for a future year. An acceptable compromise is to capture the value instead (i.e. Blue) and store this. |
Track | 3.6.1 | Varchar(20) | A-H or blank. This represents the times of year a student goes to school. This is most common with year-round schools. |
TransferComment | 3.6.1 | CLOB | A text field for the school administrator to write a note about the reason a student is being transferred. |
TuitionPayer | 3.6.1 | Number(10,0) | This is an integer code used to represent the tuition status of a student. For AZ: 1=State-funded 2=Privately paid or no tuition |
Web_ID | 3.6.1 | Varchar(20) | The parent user ID for logging in to PowerSchool Parent. Indexed. |
Web_Password | 3.6.1 | Varchar(20) | The parent password for logging in to PowerSchool Parent. |
Withdrawal_Reason_Code | 4.0.0 | Varchar(3) | Reason code provided when a student withdraws from school. |
WM_Address | 3.6.1 | Varchar(70) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_CreateDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_CreateTime | 3.6.1 | Time | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Password | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Status | 3.6.1 | Varchar(10) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_StatusDate | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_TA_Date | 3.6.1 | Date | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_TA_Flag | 3.6.1 | Varchar(3) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
WM_Tier | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Zip | 3.6.1 | Varchar(10) | Students zip code. |