Difference between revisions of "Common Column Headers"

From EDgearWiki
Jump to navigationJump to search
 
(21 intermediate revisions by the same user not shown)
Line 1: Line 1:
===Definitions of Common Column Headers===
+
'''These are the most commonly used "Column Headers" displayed in reports.'''
  
 +
:'''NOTE: Use the back arrow ← to return to the previous set of instructions.'''
  
::'''NOTE: Use the back arrow to return to the previous set of instructions.'''
 
  
 
+
:'''Address Line 1 and 2''' - The student's/employee's street address
:'''Address'''--The student's/employee's street address
+
:'''Age''' - Age of the student/employee
:'''Age'''--age of the student/empolyee
+
:'''Apt/Rm #''' - The student's/employee's apartment/room number
:'''Apt/Rm #'''--The student's/employee's apartment/room number
+
:'''Advisor''' - Name of the advisor to which the student has been assigned
:'''Advisor'''--name of the advisor to which the student has been assigned
+
:'''Average''' - Average of the assignment grades in the gradebook (formerly "Final" in the gradebook)
:'''Average''' - average of the assignment grades in the gradebook
+
:'''Birth date/DOB''' - Date of birth of the student/employee
:'''Birth date/DOB'''--Date of birth of the student/employee
+
:'''City''' - City in which the person resides
:'''City'''--city in which the person resides
+
:'''Class Code''' - Section number of courses/subjects
:'''Class Code'''--section number of courses/subjects
+
:'''CP - Class Period
:'''Counselor'''--name of the counselor to which the student has been assigned
+
:'''Counselor''' - Name of the counselor to which the student has been assigned
:'''Course Name/Course Code'''--Name(s)/Codes(s) of the course(s) in which the student is enrolled or as listed in the Master Schedule or Course Catalog
+
:'''Course Name/Course Code''' - Name(s)/Codes(s) of the course(s) in which the student is enrolled or as listed in the Master Schedule or Course Catalog
:'''Except'''--Special Education exceptionality
+
:'''Student ID''' - Student's identification number
:'''Exit Code'''--code that describes the reason a student exited your school
+
:'''Except''' - Special Education exceptionality
 +
:'''Exit Code''' - Code that describes the reason a student exited your school
 
:'''G1, G2, etc.''' - Grading Periods
 
:'''G1, G2, etc.''' - Grading Periods
:'''District (Dist)'''--district in which the student is enrolled
+
:'''District (Dist)''' - District in which the student is enrolled
:'''Email Address'''--email address of the student/employee
+
:'''Email Address''' - Email address of the student/employee
:'''Entry Code'''--code that describes the student's previous enrollment except for code E1 which is original enrollment; E1 is limited to pre-kindergarten and kindergarten students enrolling on the first day of school
+
:'''Entry Code''' - Code that describes the student's previous enrollment except for code E1 which is original enrollment; E1 is limited to pre-kindergarten and kindergarten students enrolling on the first day of school
:'''Entry Date, EDate'''--date student enrolled in school/district
+
:'''Entry Date, EDate''' - Date student enrolled in school/district
:'''Ethnic'''--primary ethnicity of the student/employee
+
:'''Ethnic, Eth''' - Primary ethnicity of the student/employee
:'''Exit Date'''--date student dropped from your school
+
:'''Exit Date''' - Date student dropped from your school
:'''First Name/FName'''--First name of the student/employee
+
:'''First Name/FName''' - First name of the student/employee
:'''Final''' in the gradebook is now '''Average''' - the average of the assignment grades
+
:'''504''' - 504 Students
:'''504'''--504 Students students
+
:'''Gender, Gen''' - Gender of the student/employee
:'''Gender, Gen'''--gender of the student/employee
+
:'''Grade, Grd''' - Grade level of the student and/or course
:'''Grade, Grd'''--grade level of the student and/or course
+
:'''Homeroom''' - Student's homeroom
:'''Last Name/LName'''--Last name of the student/employee
+
:'''Last Name/LName''' - Last name of the student/employee
:'''Homeroom'''--student's homeroom teacher
+
:'''Homeroom''' - Student's homeroom teacher
:'''Leave Code'''--code describing where a student is transferring to
+
:'''Leave Code''' - Code describing where a student is transferring
:'''Leave Date'''--date the student transfers to another school/district; this can also be a program completer indicator
+
:'''Leave Date''' - Date the student transfers to another school/district; this can also be a program completer indicator
:'''Lunch Code'''-- indicator of student's lunch status
+
:'''Lunch Code''' - Indicator of student's lunch status
:'''Middle Name/MName'''--Middle name of the student/employee
+
:'''Middle Name/MName''' - Middle name of the student/employee
:'''Period'''--class period(s) of the course(s) in which the student is enrolled
+
:'''Period''' - Class period(s) of the course(s) in which the student is enrolled
:'''PTD''' --period to date, period is determined by the to and from dates in the set up box
+
:'''PTD''' - Period to date, period is determined by the to and from dates in the set up box
:'''Phone Number'''--The student's/employee's phone number
+
:'''Phone Number''' - The student's/employee's phone number
:'''Room'''--room number of teacher/student
+
:'''Room''' - Room number of teacher/student
:'''SA SID'''--state assigned secure student identification number
+
:'''SA SID''' - State assigned secure student identification number
:'''School/Site'''--site code of the school in which the student/employee is enrolled/works
+
:'''School/Site''' - Site code of the school in which the student/employee is enrolled/works
:'''School Name'''--name of the school in which the student is enrolled
+
:'''School Name''' - Name of the school in which the student is enrolled
:''' Section'''--section number of courses/subjects as generated from the Master Schedule Editor
+
:''' Section''' - Section number of courses/subjects as generated from the Master Schedule Editor
:'''Sel''' -- Select
+
:'''Sel''' - Select
:'''Sem, S1, S2, etc.''' --semester, Ex: 1st semester, 2nd semester
+
:'''Sem, S1, S2, etc.''' - Semester, Ex: 1st semester, 2nd semester
:'''Sidno, ID'''--local ID of the student/Teacher/Substitute Teacher
+
:'''SASID, StateID''' - State Assigned Student Identification Number
:'''SIS Sch'''--school assignment for SIS submission purposes
+
:'''Sidno, ID''' - Local ID of the student/Teacher/Substitute Teacher
:'''Sped'''--Special Education students
+
:'''SIS Sch''' - School assignment for SIS submission purposes
:'''SSN'''--Student/Teacher/Employee's social security number
+
:'''Sped''' - Special Education students
:'''Staff ID/SID/ID'''--Identification number of the staff
+
**'''Health Button''' - If the SPED button is in Red, there is now a SE Code under the PE Code.
:'''State'''--State in which the student/employee resides
+
:'''SSN''' - Student/Teacher/Employee's social security number
:'''Student/Staff/Employee/Teacher/Substitute Teacher Name'''--Student's/employee's full name
+
:'''Staff ID/SID/ID''' - Identification number of the staff
:'''Subject'''--another name for course or transcript group
+
:'''State''' - State in which the student/employee resides
:'''Suffix'''--The generation indicator for males such as Jr., II, III.
+
:'''Student/Staff/Employee/Teacher/Substitute Teacher Name''' - Student's/employee's full name
:'''Teacher'''--name of the teacher of the course in which the student is enrolled
+
:'''Student Email''' - Student's email address
:'''Team'''--team to which the student has been assigned if the school is using the team scheduling method
+
:'''Subject''' - Another name for course or transcript group
:'''Total'''--sum of counts in each cell on each row of information
+
:'''Suffix''' - The generation indicator for males such as Jr., II, III.
:'''YTD''' --year to date, time span is determined by the first day of school and the last day of school as set up in the sponsor site
+
:'''Teacher''' - Name of the teacher of the course in which the student is enrolled
:'''Zip'''--Postal zip code associated with the student's/employee's address
+
:'''Team''' - Team to which the student has been assigned if the school is using the team scheduling method
 +
:'''Total''' - Sum of counts in each cell on each row of information or sum of counts in each cell in each column of information
 +
:'''YTD''' - Year to date, time span is determined by the first day of school and the last day of school as set up in the sponsor site
 +
:'''Zip''' - Postal zip code associated with the student's/employee's address

Latest revision as of 14:18, 16 February 2021

These are the most commonly used "Column Headers" displayed in reports.

NOTE: Use the back arrow ← to return to the previous set of instructions.


Address Line 1 and 2 - The student's/employee's street address
Age - Age of the student/employee
Apt/Rm # - The student's/employee's apartment/room number
Advisor - Name of the advisor to which the student has been assigned
Average - Average of the assignment grades in the gradebook (formerly "Final" in the gradebook)
Birth date/DOB - Date of birth of the student/employee
City - City in which the person resides
Class Code - Section number of courses/subjects
CP - Class Period
Counselor - Name of the counselor to which the student has been assigned
Course Name/Course Code - Name(s)/Codes(s) of the course(s) in which the student is enrolled or as listed in the Master Schedule or Course Catalog
Student ID - Student's identification number
Except - Special Education exceptionality
Exit Code - Code that describes the reason a student exited your school
G1, G2, etc. - Grading Periods
District (Dist) - District in which the student is enrolled
Email Address - Email address of the student/employee
Entry Code - Code that describes the student's previous enrollment except for code E1 which is original enrollment; E1 is limited to pre-kindergarten and kindergarten students enrolling on the first day of school
Entry Date, EDate - Date student enrolled in school/district
Ethnic, Eth - Primary ethnicity of the student/employee
Exit Date - Date student dropped from your school
First Name/FName - First name of the student/employee
504 - 504 Students
Gender, Gen - Gender of the student/employee
Grade, Grd - Grade level of the student and/or course
Homeroom - Student's homeroom
Last Name/LName - Last name of the student/employee
Homeroom - Student's homeroom teacher
Leave Code - Code describing where a student is transferring
Leave Date - Date the student transfers to another school/district; this can also be a program completer indicator
Lunch Code - Indicator of student's lunch status
Middle Name/MName - Middle name of the student/employee
Period - Class period(s) of the course(s) in which the student is enrolled
PTD - Period to date, period is determined by the to and from dates in the set up box
Phone Number - The student's/employee's phone number
Room - Room number of teacher/student
SA SID - State assigned secure student identification number
School/Site - Site code of the school in which the student/employee is enrolled/works
School Name - Name of the school in which the student is enrolled
Section - Section number of courses/subjects as generated from the Master Schedule Editor
Sel - Select
Sem, S1, S2, etc. - Semester, Ex: 1st semester, 2nd semester
SASID, StateID - State Assigned Student Identification Number
Sidno, ID - Local ID of the student/Teacher/Substitute Teacher
SIS Sch - School assignment for SIS submission purposes
Sped - Special Education students
    • Health Button - If the SPED button is in Red, there is now a SE Code under the PE Code.
SSN - Student/Teacher/Employee's social security number
Staff ID/SID/ID - Identification number of the staff
State - State in which the student/employee resides
Student/Staff/Employee/Teacher/Substitute Teacher Name - Student's/employee's full name
Student Email - Student's email address
Subject - Another name for course or transcript group
Suffix - The generation indicator for males such as Jr., II, III.
Teacher - Name of the teacher of the course in which the student is enrolled
Team - Team to which the student has been assigned if the school is using the team scheduling method
Total - Sum of counts in each cell on each row of information or sum of counts in each cell in each column of information
YTD - Year to date, time span is determined by the first day of school and the last day of school as set up in the sponsor site
Zip - Postal zip code associated with the student's/employee's address
Retrieved from EDgear Wiki