StudentCoreFields (ver7.9.0)
Database extension table associated with the Students table, which has been migrated from PowerSchool custom fields. These fields store general information.
Note: Columns in this table were previously custom fields.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
504_information | 7.10.0 | Varchar2(4000) | Information for students with disabilities. |
ACT_Composite | 7.9.0 | Varchar2(4000) | Student ACT test composite score. |
ACT_Date | 7.9.0 | Varchar2(4000) | Student ACT test date. |
ACT_English | 7.9.0 | Varchar2(4000) | Student ACT English test score. |
ACT_Math | 7.9.0 | Varchar2(4000) | Student ACT Math test score. |
ACT_Reading | 7.9.0 | Varchar2(4000) | Student ACT Reading test score. |
ACT_Science | 7.9.0 | Varchar2(4000) | Student ACT Science test score. |
AFDC | 7.9.0 | Varchar2(4000) | Student Aid to Families with Dependent Children. |
AFDCAppNum | 7.9.0 | Varchar2(4000) | Student Aid to Families with Dependent Children application number. |
Allergies | 7.9.0 | Varchar2(4000) | Student allergies information. |
Area | 7.9.0 | Varchar2(4000) | Student residence area. |
ATE_Skill_Cert | 7.9.0 | Varchar2(4000) | Student custom field. |
Autosend_AttendanceDetail | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Autosend_BalanceAlert | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Autosend_GradeDetail | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Autosend_HowOften | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Autosend_SchoolAnnouncements | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Autosend_Summary | 7.10.0 | Varchar2(4000) | No longer used by the application. See GuardianStudent table for superseding field. This field may still be referenced on reports and/or custom pages. |
Awards | 7.10.0 | Varchar2(4000) | Awards for a student. |
Career_Goal | 7.10.0 | Varchar2(4000) | Student stated career goal. |
CIP_Code | 7.10.0 | Varchar2(4000) | The classification of instructional program code. |
Competencies | 7.10.0 | Varchar2(4000) | Student competencies. |
Crt_7thMath | 7.10.0 | Varchar2(4000) | 7th grade math criterion referenced test. |
Crt_7thScience | 7.10.0 | Varchar2(4000) | 7th grade science criterion referenced test. |
Crt_8thScience | 7.10.0 | Varchar2(4000) | 8th grade science criterion referenced test. |
Crt_AppleMath2 | 7.10.0 | Varchar2(4000) | Database extension field associated to the Students table. |
Crt_ApplMath1 | 7.10.0 | Varchar2(4000) | Database extension field associated to the Students table. |
Crt_Biology | 7.10.0 | Varchar2(4000) | Biology criterion referenced test score. |
Crt_Chemistry | 7.10.0 | Varchar2(4000) | Chemistry criterion referenced test score. |
Crt_EarthSys | 7.10.0 | Varchar2(4000) | Earth sciences criterion referenced test score. |
Crt_ElemAlg | 7.10.0 | Varchar2(4000) | Elementary Algebra criterion referenced test score. |
Crt_ElemMath | 7.10.0 | Varchar2(4000) | Elementary math criterion referenced test score. |
Crt_ElemRead | 7.10.0 | Varchar2(4000) | Elementary reading criterion referenced test score. |
Crt_HumanBiol | 7.10.0 | Varchar2(4000) | Human Biology criterion referenced test score. |
Crt_InterAlg | 7.10.0 | Varchar2(4000) | Intermediate algebra criterion referenced test score. |
Crt_Physics | 7.10.0 | Varchar2(4000) | Physics criterion referenced test score. |
Crt_PreAlg | 7.10.0 | Varchar2(4000) | Pre-Algebra criterion referenced test score. |
Crt_SecMath | 7.10.0 | Varchar2(4000) | Secondary math criterion referenced test score. |
Crt_SecScience | 7.10.0 | Varchar2(4000) | Secondary science criterion referenced test score. |
DateOfEntryIntoUSA | 7.9.0 | Varchar2(4000) | Student date of entry into the USA. |
Dentist_Name | 7.9.0 | Varchar2(4000) | Student dentist's name. |
Dentist_Phone | 7.9.0 | Varchar2(4000) | Student dentist's phone. |
Ec_Athletics | 7.10.0 | Varchar2(4000) | Early childhood athletics. |
Ec_Clubs | 7.10.0 | Varchar2(4000) | Early childhood clubs. |
Ec_Community | 7.10.0 | Varchar2(4000) | Early childhood community. |
Ec_Leadership | 7.10.0 | Varchar2(4000) | Early childhood leadership. |
Emerg_1_PType | 7.9.0 | Varchar2(4000) | [From Codeset for Originalcontactmap emergency1] Student first emergency phone type. |
Emerg_1_Rel | 7.9.0 | Varchar2(4000) | [FromCodeset for Originalcontactmap emergency1] Student first emergency contact relationship. |
Emerg_2_PType | 7.9.0 | Varchar2(4000) | [From Codeset for Originalcontactmap emergency2] Student second emergency phone type. |
Emerg_2_Rel | 7.9.0 | Varchar2(4000) | [From Codeset for Originalcontactmap emergency2] Student second emergency contact relationship. |
Emerg_3_Phone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Codetype Relationship from Originalcontactmap Emerg_3_Rel] Student third emergency phone number. |
Emerg_3_PType | 7.9.0 | Varchar2(4000) | [From Codeset for Originalcontactmap emergency3] Student third emergency phone type. |
Emerg_3_Rel | 7.9.0 | Varchar2(4000) | [From Codeset for Originalcontactmap emergency3] Student third emergency contact relationship. |
Emerg_Contact_3 | 7.9.0 | Varchar2(4000) | [From Person for Originalcontactmap emergency3] Student third emergency contact. |
EquipStudent | 7.9.0 | Varchar2(4000) | Student custom field. |
ESL_Placement | 7.9.0 | Varchar2(4000) | English as a Second Language placement. |
Family_Rep | 7.9.0 | Varchar2(4000) | Student custom field. |
Father_Employer | 7.9.0 | Varchar2(4000) | [From Person for Codetype Relationship Father ] Student father's employer. |
Father_Home_Phone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Codetype Relationship Father] Student father's home phone number. |
FatherDayPhone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Codetype Relationship Father] Student father's daytime phone number. |
Graduation_Year | 7.9.0 | Varchar2(4000) | Student graduation year. |
Guardian | 7.9.0 | Varchar2(4000) | Student guardian. |
Guardian_FN | 7.9.0 | Varchar2(4000) | [From Person for Originalcontactmap guardian ] Student guardian's first name. |
Guardian_LN | 7.9.0 | Varchar2(4000) | [From Person for Originalcontactmap guardian] Student guardian's last name. |
Guardian_MN | 7.9.0 | Varchar2(4000) | [From Person for Originalcontactmap guardian] Student guardian's middle name. |
GuardianDayPhone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Originalcontactmap guardian ] Student guardian's daytime phone number. |
GuardianRelCode | 7.9.0 | Varchar2(4000) | Student relationship code. |
Guardianship | 7.9.0 | Varchar2(4000) | Student custom field. |
HLN | 7.9.0 | Varchar2(4000) | Student custom field. |
Homeless_Code | 7.9.0 | Varchar2(4000) | Student homeless code value. |
ILDP | 7.9.0 | Varchar2(4000) | Student custom field. |
Immunizaton_DPT | 7.9.0 | Varchar2(4000) | Student DPT immunization status. |
Immunizaton_MMR | 7.9.0 | Varchar2(4000) | Student MMR immunization status. |
Immunizaton_Polio | 7.9.0 | Varchar2(4000) | Student Polio immunization status. |
IPT_Oral_CurdDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test last date administered. |
IPT_Oral_CurrentScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test score. |
IPT_Oral_OrigDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original date taken. |
IPT_Oral_OrigScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original score. |
IPT_Reading_CurDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test date for reading. |
IPT_Reading_CurrentScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test last date administered for reading. |
IPT_Reading_OrigDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original date taken for reading. |
IPT_Reading_OrigScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original score for reading. |
IPT_Writing_CurDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test date for writing. |
IPT_Writing_CurrentScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test last date administered for writing. |
IPT_Writing_OrigDate | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original date taken for writing. |
IPT_Writing_OrigScore | 7.10.0 | Varchar2(4000) | IDEA Proficiency test original score for writing. |
Language_Form | 7.10.0 | Varchar2(4000) | Database extension field associated to the Students table. |
LEP_Exit_Date | 7.9.0 | Varchar2(4000) | Student Limited English Proficiency exit date. |
LEP_Status | 7.9.0 | Varchar2(4000) | Student Limited English Proficiency status. |
LPAC_Date | 7.9.0 | Varchar2(4000) | Student Language Proficiency Assessment Committee date. |
LunchApplicNo | 7.10.0 | Varchar2(4000) | Lunch application number. |
Medical_Considerations | 7.9.0 | Varchar2(4000) | Student medical considerations. |
MESA | 7.9.0 | Varchar2(4000) | Student Mathematics Engineering Science Achievement. |
Monitor_Date | 7.9.0 | Varchar2(4000) | Student custom field. |
Mother_Employer | 7.9.0 | Varchar2(4000) | [From Person for Codetype Relationship Mother] Student mother's employer. |
Mother_Home_Phone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Codetype Relationship Mother] Student mother's home phone number. |
MotherDayPhone | 7.9.0 | Varchar2(4000) | [From Phonenumber for Codetype Relationship Mother] Student mother's daytime phone number. |
PartTimeStudent | 7.9.0 | Varchar2(4000) | Student part time status. |
PHLOTE | 7.9.0 | Varchar2(4000) | Student Primary Home Language Other Than English. |
PhotoLastUpdated | 11.0.0 | Varchar2(20) | Date student photo was last updated. String formatted using ISO-8601, "yyyy-mm-ddThh:mm:ssZ". |
Post_Secondary_Objectives | 7.10.0 | Varchar2(4000) | Students stated post secondary objectives. |
PrevStudentID | 7.9.0 | Varchar2(4000) | Student previous student ID number. |
Primary_Pathway | 7.10.0 | Varchar2(4000) | Pathway to primary objective. |
PrimaryLanguage | 7.9.0 | Varchar2(4000) | Student primary language. |
PSCore_Legal_Middle_Name | 10.0.1 | Varchar2(100) | Student's legal middle name. Currently this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
PSCore_Legal_Gender | 10.0.1 | Varchar2(10) | Student's legal gender. Currently this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
PSCore_Legal_Suffix | 10.0.1 | Varchar2(10) | Student's legal suffix. Currently this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
PSCore_Legal_Last_Name | 10.0.1 | Varchar2(100) | Student's legal last name. Currently this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
PSCore_Legal_First_Name | 10.0.1 | Varchar2(100) | Student's legal first name. Currently this field only used by State Reporting. However, it may also be used on any PowerSchool custom page. |
SAT | 7.9.0 | Varchar2(4000) | Student SAT test score. |
Secondary_Pathway | 7.10.0 | Varchar2(4000) | Pathway to secondary objective. |
SecondaryLanguage | 7.9.0 | Varchar2(4000) | Student secondary language. |
SEOP_Notes | 7.10.0 | Varchar2(4000) | Student Education and Occupation Plan notes. |
SingleParentHshldFlag | 7.9.0 | Varchar2(4000) | Student in single parent household flag. |
SPEDLEP | 7.10.0 | Varchar2(4000) | Database extension field associated to the Students table. |
Test_Comments | 7.10.0 | Varchar2(4000) | Test comments. |
Tracker | 7.9.0 | Varchar2(4000) | Student custom field. |