Difference between revisions of "Common Column Headers"

From EDgearWiki
Jump to navigationJump to search
 
(54 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
:'''Student/Teacher/Substitute Teacher Name'''--Student's/employee's full name
+
:'''Age''' - Age of the student/employee
:'''Last Name'''--Last name of the student/employee
+
:'''Apt/Rm #''' - The student's/employee's apartment/room number
:'''First Name'''--First name of the student/employee
+
:'''Advisor''' - Name of the advisor to which the student has been assigned
:'''Middle Name'''--Middle name of the student/employee
+
:'''Average''' - Average of the assignment grades in the gradebook (formerly "Final" in the gradebook)
:'''Suffix'''--The generation indicator for males such as Jr., II, III.
+
:'''Birth date/DOB''' - Date of birth of the student/employee
:'''Address'''--The student's/employee's street address
+
:'''City''' - City in which the person resides
:'''Age'''--age of the student/empolyee
+
:'''Class Code''' - Section number of courses/subjects
:'''Apt/Rm #'''--The student's/employee's apartment/room number
+
:'''CP - Class Period
:'''Advisor'''--name of the advisor to which the student has been assigned
+
:'''Counselor''' - Name of the counselor to which the student has been assigned
:'''Birth date/DOB'''--Date of birth of the student/employee
+
:'''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
:'''City'''--city in which the person resides
+
:'''Student ID''' - Student's identification number
:'''Counselor'''--name of the counselor to which the student has been assigned
+
:'''Except''' - Special Education exceptionality
:'''Course Name/Course Code'''--Name(s)/Codes(s) of the course(s) in which the student is enrolled
+
:'''Exit Code''' - Code that describes the reason a student exited your school
:'''District (Dist)'''--district in which the student is enrolled
+
:'''G1, G2, etc.''' - Grading Periods
:'''Email Address'''--email address of the student/employee
+
:'''District (Dist)''' - District in which the student is enrolled
:'''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
+
:'''Email Address''' - Email address of the student/employee
:'''Entry Date'''--date student enrolled in school/district
+
:'''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
:'''Ethnic'''--primary ethnicity of the student/employee
+
:'''Entry Date, EDate''' - Date student enrolled in school/district
:'''Gender'''--gender of the student/employee
+
:'''Ethnic, Eth''' - Primary ethnicity of the student/employee
:'''Grade'''--grade level of the student
+
:'''Exit Date''' - Date student dropped from your school
:'''Homeroom'''--student's homeroom teacher
+
:'''First Name/FName''' - First name of the student/employee
:'''Leave Code'''--code describing where a student is transferring to
+
:'''504''' - 504 Students
:'''Leave Date'''--date the student transfers to another school/district; this can also be a program completer indicator
+
:'''Gender, Gen''' - Gender of the student/employee
:'''Period'''--class period(s) of the course(s) in which the student is enrolled
+
:'''Grade, Grd''' - Grade level of the student and/or course
:'''Phone Number'''--The student's/employee's phone number
+
:'''Homeroom''' - Student's homeroom
:'''School/Site'''--site code of the school in which the student/employee is enrolled/works
+
:'''Last Name/LName''' - Last name of the student/employee
:'''School Name'''--name of the school in which the student is enrolled
+
:'''Homeroom''' - Student's homeroom teacher
:''' Section'''--section number of courses/subjects
+
:'''Leave Code''' - Code describing where a student is transferring
:'''Sidno'''--local ID of the student/Teacher/Substitute Teacher
+
:'''Leave Date''' - Date the student transfers to another school/district; this can also be a program completer indicator
:'''Sped'''--Special Education students
+
:'''Lunch Code''' - Indicator of student's lunch status
:'''SSN'''--Student's social security number
+
:'''Middle Name/MName''' - Middle name of the student/employee
:'''Staff ID/SID'''--Identification number of the staff
+
:'''Period''' - Class period(s) of the course(s) in which the student is enrolled
:'''State'''--State in which the student/employee resides
+
:'''PTD'''  - Period to date, period is determined by the to and from dates in the set up box
:'''Subject'''--another name for course or transcript group
+
:'''Phone Number''' - The student's/employee's phone number
:'''Teacher'''--name of the teacher of the course in which the student is enrolled
+
:'''Room''' - Room number of teacher/student
:'''Team'''--team to which the student has been assigned if the school is using the team scheduling method
+
:'''SA SID''' - State assigned secure student identification number
:'''Total'''--sum of counts in each cell on each row of information
+
:'''School/Site''' - Site code of the school in which the student/employee is enrolled/works
:'''Zip'''--Postal zip code associated with the student's/employee's address
+
:'''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

Latest revision as of 13: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