Census-Staff Filter Fields for Ad hoc Reporting

Tool Search: Filter Designer, Report Designer

The Ad hoc Reporting tools allow users to create custom queries and reports on various types of information stored within the Campus database. Reports may be used for data analysis and state reporting and queries may be exported out of Campus or used to create filters for standard reports. Custom filters and reports are built by adding elements from Ad hoc Reporting tools like the Filter Designer. The following is a list of available fields that can be included in Ad hoc reports that draw from census and staff data.

The name of an Ad hoc element is not necessarily the name listed in the user interface; therefore, the following tables briefly define and map Ad hoc elements to the appropriate interface locations/fields.

These fields appear in Ad hoc Reporting > Filter Designer, but many can be used in the Letter Designer. However, some areas/fields are not currently available in the Report Designer.


Census/Staff Filter Fields (Query Wizard)

The following fields are available in the Filter Designer. The filter field name and the actual interface field name may differ. Interface field names are capitalized within the definition when referenced.

Note that data returned for these queries is determined by how data is set up/entered in Census.

See the Query Wizard article for instructions on managing these filter.


Filter Data Type - Census/Staff

Person Demographics

Impact Aid Employment

Person > Demographics > Impact Aid Employment

Staff State ID History

Person > Demographics > Identity History > Staff State ID History

Staff Number History

Person > Demographics > Identity History > Staff Number History

Other ID History

Person > Demographics > Identity History > Other ID History

State ID History

Person > Demographics > Identity History > State ID History

Student Number History

Person > Demographics > Identity History > Student Number History

Identity History

Person > Demographics > Identity History

Federal Race

Person > Demographics > Federal Race

Filter Field

Mapping and Definition

personID

Census > People > Demographics
Internal database identifier.

stateID

Census > People > Demographics
Unique identifier issued to a student by the state department of education for state reporting purposes.

studentNumber

Census > People > Demographics
The unique numerical identifier assigned to a student enrolled in a school that can be formatted to district preferences and is used in state reporting.

staffNumber

Census > People > Demographics
District-assigned staff member number.

staffStateID

Census > People > Demographics
Staff ID used by state.

personGUID

Census > People > Demographics
Internal database identifier.

identityID

Internal database identifier.

effectiveDate

Census > People > Demographics
Date identity became active.

lastName

Census > People > Demographics
Last name of identity.

firstName

Census > People > Demographics
First name of identity.

middleName

Census > People > Demographics
Middle name of identity.

suffix

Census > People > Demographics
Indication of Jr., Sr., III, IV, etc.

alias

Census > People > Demographics
Nickname used instead of given name.

gender

Census > People > Demographics
Male or female.

birthdate

Census > People > Demographics
Birth date of person.

ssn

Census > People > Demographics
Social security number of individual.

raceEthnicity

Census > People > Identities
Race/ethnicity of person.

districtID

Internal database identifier.

personID

Internal database identifier.

identityID

Internal database identifier.

raceEthnicity

Census > People > Demographics
Individuals state race/ethnicity

hispanicEthnicity

Census > People > Demographics
Indicates individual's Hispanic ethnicity.

raceEthnicityFed

Census > People > Demographics
Individual's federal race/ethnicity designation

raceEthnicityDetermination

Census > People > Demographics
How the individual's race was determined.

hispanicLatino

Census > People > Demographics
Indicates if individual is Hispanic/Latino.

americanIndian

Census > People > Demographics
Indicates if individual is American Indian or Alaska Native.

asian

Census > People > Demographics
Indicates if individual is Asian.

blackOrAfricanAmerican

Census > People > Demographics
Indicates if individual is Black or African American.

pacificIslander

Census > People > Demographics
Indicates if individual is Native Hawaiian or Other Pacific Islander.

white

Census > People > Demographics
Indicates if individual is White.

multiracial

Census > People > Demographics
Indicates that person has more than one race selected.

identityID

Internal database identifier.

personID

Internal database identifier.

effectiveDate

Census > People > Identities
Date identity became active.

lastName

Census > People > Identities
Last name of identity.

firstName

Census > People > Identities
First name of identity.

middleName

Census > People > Identities
Middle name of identity.

suffix

Census > People > Identities
Indication of Jr., Sr., III, IV, etc.

alias

Census > People > Identities
Nickname used instead of given name.

gender

Census > People > Identities
Male or female.

birthdate

Census > People > Identities
Birth date of person.

ssn

Census > People > Identities
Social security number of individual.

raceEthnicity

Census > People > Identities
Race/ethnicity of person.

birthCountry

Census > People > Identities
Selection of country of birth, if not U.S.

dateEnteredUS

Census > People > Identities
Date person entered U.S.

birthVerification

Census > People > Identities
Birth Verification certificate type (e.g. birth certificate, immigration document, physician’s certificate). Not used in all states.

comments

Census > People > Identities
Additional information associated with identity of person.

districtID

Internal database identifier.

hispanicEthnicity

Census > People > Identities
If flagged, checkbox indicates person is considered to be of Hispanic/ Latino ethnicity. Not used in all states.

identityGUID

Internal database identifier.

lastNamePhonetic

Used in sound-alike searches.

firstNamePhonetic

Used in sound-alike searches.

dateEnteredState

Census > People > Identities
Date student originally entered state.

birthCertificate

Census > People > Identities
Type of document used to verify existence of person.

immigrant

Student Information > General > Enrollments
Indicates the student being of immigrant status.

dateEnteredUSSchool

Census > People > Identities
Date student entered a U.S. school for the first time.

raceEthnicityFed

Student Information > Demographics
Federal race/ethnicity code. May be different than the raceEthnicity selection.

raceEthinicityDetermination

Student Information > Demographics
Selection of how the individual was determined to be the selected race/ethnicity.

birthVerificationBIE

Census > People > Demographics
How the individual's birth was verified.

modifiedByID

Does not appear.
Lists the person who modified the information.

modifiedDate

Does not appear.
Date of last change.

refugee

Student Information > General > Enrollments > State Reporting Fields
If flagged, checkbox indicates individual is a refugee.

homePrimaryLanguage

Census > People > Demographics
The primary language spoken in the individual's home.

personID

Census > People > ID History
The reporting person's personID number.

startDate

Census > People > ID History
The start date of the person's identity containing the student number being reported.

studentNumber

Census > People > ID History
The student number reporting data.

modifiedByID

Census > People > ID History
The last person to modify the reporting person's identity information tied to the reporting student number.

endYear

Census > People > ID History
The year in which the reporting student number was ended.

active

Census > People > ID History
Indicates whether or not the reporting student number is active.

comments

Census > People > ID History
Any comments entered when the person's student number was ended.

personID

Census > People > ID History
The reporting person's personID number.

startDate

Census > People > ID History
The start date of the person's identity containing the stateID being reported.

stateID

Census > People > ID History
The stateID reporting data.

modifiedByID

Census > People > ID History
The last person to modify the reporting person's identity information tied to the reporting state ID.

endYear

Census > People > ID History
The year in which the reporting stateID was ended.

active

Census > People > ID History
Indicates whether or not the stateID number is active.

comments

Census > People > ID History
Any comments entered when the person's stateID was ended.

personID

Census > People > ID History
The reporting person's personID number.

startDate

Census > People > ID History
The start date of the person's identity containing the otherID being reported.

otherID

Census > People > ID History
The otherID reporting data.

modifiedByID

Census > People > ID History
The last person to modify the reporting person's identity information tied to the reporting otherID.

endYear

Census > People > ID History
The year in which the reporting otherID was ended.

active

Census > People > ID History
Indicates whether or not the otherID number is active.

comments

Census > People > ID History
Any comments entered when the person's otherID was ended.

personID

Census > People > ID History
The reporting person's personID number.

startDate

Census > People > ID History
The start date of the person's identity containing the staff number being reported.

staffNumber

Census > People > ID History
The staff number reporting data.

modifiedByID

Census > People > ID History
The last person to modify the reporting person's identity information tied to the reporting staff number.

endYear

Census > People > ID History
The year in which the reporting staff number was ended.

active

Census > People > ID History
Indicates whether or not the staff number is active.

comments

Census > People > ID History
Any comments entered when the person's staff number was ended.

personID

Census > People > ID History
The reporting person's personID number.

startDate

Census > People > ID History
The start date of the person's identity containing the staff state ID being reported.

staffStateID

Census > People > ID History
The staff state ID reporting data.

modifiedByID

Census > People > ID History
The last person to modify the reporting person's identity information tied to the reporting staff state ID.

endYear

Census > People > ID History
The year in which the reporting staff state ID was ended.

active

Census > People > ID History
Indicates whether or not the staff state ID is active.

comments

Census > People > ID History
Any comments entered when the person's staff state ID was ended.

personID

Internal database identifier

siteID

Internal database identifier

employeeType

Census > People > Demographics > Person Impact Aid Employment
Type of impact aid employment in which individual is participating.

Person Census

Student Assignment Override

Person > Census > Student Assignment Override

School Choice

Person > Census > School Choice

Mailing Address

Person > Census > Mailing Addresses

Contact Summary

Person > Census > Contact Summary

Employment Background

Person > Census > Employment Background

Person Contacts

Person > Census > Person Contacts

Filter Field

Mapping and Definition

personID

Internal database identifier.

homePhone

Census > People > Demographics
Home phone number for the associated person.

workPhone

Census > People > Demographics
Work phone number of the associated person.

cellPhone

Census > People > Demographics
Cell phone number of the associated person.

pager

Census > People > Demographics
Pager number of the associated person.

email

Census > People > Demographics
Email address of the associated person.

comments

Census > People > Demographics
User-entered comments on personal contact information.

homePhonePrivate

Census > People > Demographics
If flagged, checkbox indicates the home phone for this person should not be published.

workPhonePrivate

Census > People > Demographics
If flagged, checkbox indicates the work phone for this person should not be published.

cellPhonePrivate

Census > People > Demographics
If flagged, checkbox indicates the cell phone for this person should not be published.

pagerPrivate

Census > People > Demographics
If flagged, checkbox indicates the pager number for this person should not be published.

emailPrivate

Census > People > Demographics
If flagged, checkbox indicates the email address for this person should not be published.

homePhoneMessenger

Census > People > Demographics
Number indicating which types of messages a contact will receive on his/her home phone.

workPhoneMessenger

Census > People > Demographics
Number indicating which types of messages a contact will receive on his/her work phone.

cellPhoneMessenger

Census > People > Demographics
Number indicating which types of messages a contact will receive on his/her cell phone.

emailMessenger

Census > People > Demographics
Number indicating which types of messages a contact will receive in his/her email.

inboxMessenger

Census > People > Demographics
Number indicating which types of messages a contact will receive in his/her Campus Process Inbox.

communicationLanguage

Census > People > Demographics
Stores the preferred communication language for this person used in conjunction with Messenger.

modifiedByID

Does not appear.
Lists the person who modified the information.

modifiedDate

Does not appear.
Date of last change.

cellPhoneTxtMsg

Census > People > Demographics
Indicates that cell phone can receive test messages.

personID

Internal database identifier.

lastYearState

Census > People > Employment
Indicates the state where the staff person was last employed.

lastYearTitle

Census > People > Employment
Indicates the title the staff person had in the previous school year.

publicEducation

Census > People > Employment
Notes the hours of public education for the staff person.

privateEducation

Census > People > Employment
Notes the hours of private education for the staff person.

nonEducation

Census > People > Employment
Notes the hours of non-education for the staff person.

districtID

Internal database identifier.

personID

Internal database identifier.

relatedBy

System determination of contact/student relationship:

  • Household = The people are considered related because they share the same household.
  • Relationship = The people are considered related because they have a relationship other than a shared household.

contactID

Internal database identifier.

contactGUID

Internal database identifier.

private

Census > Household > Addresses
If flagged, checkbox indicates contact details are to remain unpublished in ad hoc queries and third-party mailing lists.

secondary

Census > Household > Addresses
If flagged, checkbox indicates person is a member a secondary household member or information is for a secondary address.

mailing

Census > Household > Addresses
If flagged, checkbox indicates guardian contact should receive mailings at the specified address.

guardian

Census > People > Relationships
If flagged, checkbox indicates contact has a guardian relationship with the selected person.

portal

Census > People > Relationships
If flagged, checkbox indicates contact may receive information for the selected person via the Portal.

messenger

Census > People > Relationships
If flagged, checkbox indicates contact receives messages for the selected person via Messenger .

householdID

Internal database identifier.

householdPhone

Census > Households
The phone number of the household.

householdName

Census > Households
The name of the household.

personGUID

Internal database identifier.

contactPersonID

Internal database identifier.

studentNumber

Student Information > General > Demographics
The unique numerical identifier assigned to a student enrolled in a school that can be formatted to district preferences and is used in state reporting.

staffNumber

Census > People > Demographics
Staff number used within school and district.

lastName

Census > People > Demographics
Last name of current identity.

firstName

Census > People > Demographics
First name of current identity.

middleName

Census > People > Demographics
Middle name of current identity.

suffix

Census > People > Demographics
Indication of Jr. Sr. III, IV, etc. of current identity.

gender

Census > People > Demographics
Male or female.

birthdate

Census > People > Demographics
Birth date of person.

relationship

Census > People > Relationships
Name of the relationship between the person and the contact.

seq

Census > People > Relationships
Sequence number given to a relationship.

grade

Student Information > General > Enrollments
Notes the grade level of the student.

calendarName

System Administration > Calendar > Calendar
User-entered name of the calendar associated with the student’s current enrollment.

homePhone

Census > People > Demographics
Home phone number for the associated person.

workPhone

Census > People > Demographics
Work phone number for the associated person.

cellPhone

Census > People > Demographics
Cell phone number for the associated person.

pager

Census > People > Demographics
Pager number for the associated person.

email

Census > People > Demographics
Email address for the associated person.

comments

Census > People > Demographics
User-entered information on contact information.

number

Census > People > Demographics
Street address house number (e.g. 123, 28345).

street

Census > Address
Street name of address (e.g. Main, 7th, Fourth).

tag

Census > Address
Postal tag for address (e.g. St., Ave., Blvd.).

prefix

Census > Address
Direction if prior to the street name (e.g. E, W, NE) as in NE 7th St.

dir

Census > Address
Direction if after the street name (e.g. E, W, NE) as in 7th St. NE.

apt

Census > Address
Apartment number (e.g. 201, 3a).

city

Census > Address
Postal city for the address.

state

Census > Address
Two digit state code for the address.

zip

Census > Address
Postal zip code (zip + 4 available).

county

Census > Address
County in which this address resides.

addressLine1

Combination of first line address elements (street number, name , tag, etc.)

addressLine2

Combination of second line address elements (e.g. city, state, zip).

residentDistrictID

Student Information > General > Enrollments
District ID of person’s resident district.

residentDistrictNumber

Student Information > General > Enrollments
State-defined district number for the person’s resident district.

residentDistrictType

Student Information > General > Enrollments
State-defined district type for the person’s resident district.

residentDistrictName

Student Information > General > Enrollments
State-defined name of the district person lives in as associated with his/her address.

addressID

Internal database identifier.

location_code

Census > Address
District-defined code to identify address location.

tract

Census > Address
Government-defined tract address is part of.

block

Census > Address
Government-defined block address is located on.

privatePhone

Census > Households
If flagged, checkbox indicates household phone number should not be part of third-party mailing lists.

privateAddress

Census > Households > Addresses
If flagged, checkbox indicates address should not be part of third-party mailing lists.

modifiedDate

Does not appear.
Date of last change.

districtID

Internal database identifier.

personID

Internal database identifier.

relatedBy

System determination of contact/student relationship:

  • Household = The people are considered related because they share the same household.
  • Relationship = The people are considered related because they have a relationship other than a shared household.

addressID

Internal database identifier.

householdID

Internal database identifier.

phone

Census > People > Demographics
Home phone number for the associated person.

householdName

Census > Households
The name of the household.

number

Census > Address
Street address house number.

street

Census > Address
Street name if address (i.e. Main, 7th, Fourth, etc).

tag

Census > Address
Postal tag for address (i.e. St, Ave, Blvd, etc).

prefix

Census > Address
Direction if prior to the street name, as in “NE” 7th St.

dir

Census > Address
Direction if after the street name, as in 7th S. “NE”.

apt

Census > Address
Apartment number (i.e. 201, 3a, etc)

city

Census > Address
Postal city of address.

state

Census > Address
Two digit state code for the address.

zip

Census > Address
Postal zip code (zip + 4 available).

county

Census > Address
County in which this address resides.

postOfficeBox

Census > Address
Flag to indicate that this address is a PO Box.

addressLine1

Combination of first line address elements (e.g. street number, name, tag)

addressLine2

Combination of second line address elements (e.g. city, state, zip).

guardianPersonID

Internal database identifier

guardianName

Census > Relationships
Full name of a person flagged as a guardian on student’s relationship tab.

guardianLastName

Census > Relationships
Last name of a person flagged as a guardian on student’s relationship tab.

guardianFirstName

Census > Relationships
First name of a person flagged as a guardian on student’s relationship tab.

guardianMiddlename

Census > Relationships
Middle name of a person flagged as a guardian on student’s relationship tab.

location_code

Census > Address
District-defined code to identify address location.

tract

Census > Address
Government defined tract this address is part of.

block

Census > Address
Government defined block this address resides on.

secondary

Census > Household > Addresses
Flag determines if the household this person is a member of is their secondary household.

addressDistrictID

Internal database identifier.

guardian

Census > Address > Households
Indicates guardian relationship is flagged.

modfiedDate

Does not appear.
Date of last change.

endYear

System Administration > Calendar > School Years
The last year of the school year in yyyy format.

label

System Administration > Calendar > School Years
The name of the school year.

startYear

System Administration > Calendar > School Years
The first year of the school year in yyyy format.

applicationID

Internal database identifier.

calendarID

Internal database identifier.

calendarName

System Administration > Calendar
The name of the calendar, generally reflective of the year and school it relates to (i.e. 07-08 Harrison High School).

schoolID

Internal database identifier.

name

System Administration > School Choice > Rules
Name of the rule to be applied to incoming school choice applications.

personID

Internal database identifier.

applicationYearID

Internal database identifier.

applicationDate

Census > People > School Choice
Date school choice application was received.

processedDate

Census > People > School Choice
Date school choice application was reviewed by school.

approvalStatus

Census > People > School Choice
Status of processed application (i.e. (APP)roved, (DEN)ied, (PEN)ding, (WAI)t-listed).

acceptedStatus

Census > People > School Choice
Status of student’s decision on whether or not to enroll when application has been approved by school (i.e. accepted, pending/ declined).

acceptedDate

Census > People > School Choice
Date student made decision on whether or not to enroll in school.

gradeLevel

Census > People > School Choice
The grade level student would be enrolled into if application is approved.

randomNumber

Random number assigned to application by system in the event a tiebreaker is necessary.

allowAccept

Census > People > School Choice
If flagged, checkbox indicates that after application is approved, student acceptance is allowed via Portal.

priority

Scheduling > Courses
The priority of the course as related to others courses in the scheduling process.

posted

Census > People > School Choice
Indication that school choice application has posted.

overrideID

Internal database identifier.

lockApprovalStatus

Census > People > School Choice
Indicates approval status is locked.

comments

Census > People > School Choice
User-entered comments on school choice application.

ruleID

Internal database identifier.

code

System Administration > School Choice > Rules
Code assigned to School Choice rule.

ruleName

System Administration > School Choice > Rules
The name of the rule.

weight

System Administration > School Choice > Rules
The weight assigned to applications in compliance with rule.

studentOverrideID

Internal database identifier.

personID

Internal database identifier.

calendarID

Internal database identifier.

overrideType

Census > People > Overrides
Type of override assigned to student.

startDate

Census > People > Overrides
First day override applies to student.

endDate

Census > People > Overrides
Last day override applies to student.

modifiedDate

Census > People > Overrides
Time stamp of modification to student override.

modifiedByID

Does not appear.
Lists the person who modified the information.

oldStartDate

Census > People > Overrides
Original start date when multiple overrides exist.

oldEndDate

Census > People > Overrides
Original end date when multiple overrides exist.

Person Staff

Section Schedule

Person > Staff > Section Information > Section Schedule

Roster Summary

Person > Staff > Teaching Assignment > Section Information > Roster Summary

Section Information

Person > Staff > Teaching Assignment > Section Information

Course Information

Person > Staff > Teaching Assignment > Course Information

Calendar Assignment Override

Person > Staff > Teaching Assignment > School Calendar > Calendar Assignment Override

School Calendar

Person > Staff > Teaching Assignment > School Calendar

Teaching Assignment

Person > Staff > Teaching Assignment

Credential

Person > Staff > Credential

 Staff Evaluation Detail 

 HR Person > HR > Work Assignments >  Completed Staff Evaluations > Staff Evaluation Detail 

Completed Staff EvaluationsPerson > Staff > Assignment > Completed Staff Evaluations

School

Person > Staff > Assignment > School

Assignment

Person > Staff > Assignment

District 

Person > Staff > District Employment > District

District Employment

Person > Staff > District Employment

Filter Field

Mapping and Definition

employmentID

Internal database identifier.

personID

Internal database identifier.

districtID

Internal database identifier.

distrctStateDate

Census > People > District Employment
Very first date staff member was employed within district. Dates are entered in mmddyy format.

districtEndDate

Census > People > District Employment
Very last date staff member was employed within district. Dates are entered in mmddyy format.

teachingStartYear

Census > People > District Employment
First year instructor began teaching within the district. Date fields are entered in mmddyy format.

teachingYearsModifier

Census > People > District Employment
Number of years to add or subtract from years since teachingStartYear field. Used to determine totalYearsTeaching.

totalYearsTeaching

Census > People > District Employment
Number of years since teachingStartYear field plus value from teachingYearsModifier field.

liscenseNumber

Census > People > District Employment
Records the license number of staff member.

ftePercent

Census > People > District Employment
Lists the full-time employment percentage of staff member (rounds to whole number).

seniority

Census > People > District Employment
Notes the seniority level of the staff member. Options are defined in System Administration > Custom > Attribute/Dictionary > Employment.

educationLevel

Census > People > District Employment
Lists the completed education degree of the staff person.

exitReason

Census > People > District Employment
Reason the employee is no longer employed at the district.

active

System indicator of active employment assignment of staff member in district. The employment assignment Start Date must be earlier than the current date and the End Date must either be in the future or null.

districtID

Internal database identifier.

ncesDistrictID

Internal database identifier.

number

System Administration > Resources > District Information
State-assigned district number.

name

System Administration > Resources > District Information
State-recognized district name.

type

System Administration > Resources > District Information
State-defined district type used for state reporting.

state

System Administration > Resources > District Information
State in which the district exists.

comments

System Administration > Resources > District Information
User-entered additional information.

address

System Administration > Resources > District Information
Mailing address of the district office.

city

System Administration > Resources > District Information
Mailing city of the district office.

zip

System Administration > Resources > District Information
Mailing zip code (zip+4 available) of the district office.

county

System Administration > Resources > District Information
Mailing county of the district office.

phone

System Administration > Resources > District Information
General information phone number for the district office.

fax

System Administration > Resources > District Information
General fax number for the district office.

email

System Administration > Resources > District Information
General information email for the district office.

districtGUID

Internal database identifier.

stateLinked

System indicator to determine whether district is linked with a state or regional installation of Campus.

url

System Administration > Resources > District Information
General URL for the district.

contactLastName

System Administration > Resources > District Information
Primary contact last name for the district.

contactFirstName

System Administration > Resources > District Information
Primary contact first name for the district.

inactive

System indicator to determine if the district is currently active.

legacyKey

Used during data conversion.

spedFax

System Administration > Resources > District Information
District Special Ed office fax number.

spedPhone

System Administration > Resources > District Information
District Special Ed office phone number.

spedContactFirstName

System Administration > Resources > District Information
District Special Ed contact first name.

spedContactLastName

System Administration > Resources > District Information
District Special Ed contact last name.

regionNumber

System Administration > Resources > District Information
The state-defined region that logically or physically groups districts together for reporting purposes.

legacyKey

Used during data conversion.

spedAddress

System Administration > Resources > District Information
District Special Ed mailing address.

spedCity

System Administration > Resources > District Information
District Special Ed mailing city.

spedState

System Administration > Resources > District Information
District Special Ed mailing state.

spedZip

System Administration > Resources > District Information
District Special Ed mailing zip code (zip+4 available).

spedCounty

System Administration > Resources > District Information
District Special Ed mailing county.

groupNumber

District number assigned by and only used in the federal installation to allow tracking of both the state-assigned district number and the federal assigned number.

federalTaxID

System Administration > Resources > District Information
Federal ID for Medicaid billing.

nationalProviderID

System Administration > Resources > District Information
National Provider ID for Medicaid billing.

mchpProviderID

System Administration > Resources > District Information
MHCP Provider ID for Medicaid billing.

districtCode

System Administration > Resources > District Information
District Code indicating district type (e.g. Public Schools, Correctional Facilities, Alternative). Not used in all states.

physicalAddress

System Administration > Resources > District Information
Physical address of district.

physicalCity

System Administration > Resources > District Information
Physical city of district.

physicalState

System Administration > Resources > District Information
Physical state of district.

physicalZip

System Administration > Resources > District Information
Physical zip code of district.

status

System Administration > Resources > District Information
Operational status of district. Not used in all states.

ISDNumber

System Administration > Resources > District Information
Independent school district number.

assignmentID

Internal database identifier.

personID

Internal database identifier.

schoolID

Internal database identifier.

schoolNumber

System Administration > Resources > School
NCES school number.

schoolName

System Administration > Resources > School
State-designated school name.

schoolType

System Administration > Resources > School
Type of school (e.g. middle, elementary, primary).

departmentID

Internal database identifier.

departmentName

Census > People > District Assignments
District or school-defined department name for use in organizing curriculum.

assignmentStartDate

Census > People > District Assignments
Very first date the staff member was employed at the specified school. Dates are entered in mmddyy format.

assignmentEndDate

Census > People > District Assignments
Very last date the staff member was employed at the specified school. Dates are entered in mmddyy format.

fteInAssignment

Census > People > District Assignments
Full-time employment percentage of staff member within specified school (rounds to whole number).

highlyQualified

Census > People > District Assignments
Denotes the staff person as being highly qualified for the assignment, based on district policy.

titleCode

System Administration > Custom > Attribute/Dictionary
Code associated with the title selected on Census > Person > District Assignments for staff member.

title

Census > People > District Assignments
Position name of the staff person.

type

Census > People > District Assignments
Type of employment assignment.

programCategory

Census > People > District Assignments
Indication of what type of program the staff member teachers, such as Special Education or Title 1. Not used in all states.

assignmentCode

Census > People > District Assignments
District-provided code associated with the employment at the school.

teacher

Census > People > District Assignments
If flagged, checkbox indicates staff member is a teacher.

specialEd

Census > People > District Assignments
If flagged, checkbox indicates person is a special education staff member.

behavior

Census > People > District Assignments
If flagged, checkbox indicates staff member oversees behavior events.

health

Census > People > District Assignments
If flagged, checkbox indicates staff member may record health events and records.

advisor

Census > People > District Assignments
If flagged, checkbox indicates staff member may advise PDPs, PLPs and/or IEPs.

supervisor

Census > People > District Assignments
If flagged, checkbox indicates staff member is a supervisor of other employees.

counselor

Census > People > District Assignments
If flagged, checkbox indicates staff member can act as a counselor.

foodservice

Census > People > District Assignments
If flagged, checkbox indicates staff member is a food service staff member and is uses food service and POS functionality.

excludeReferral

Census > People > District Assignments
If flagged, checkbox indicates staff member is excluded from behavior referral records.

active

System indicator of active employment assignment of staff member in district.

readingFirst

Census > People > District Assignment
Indicates the staff person is trained on Reading First theories.

subjectMatter

Census > People > District Assignment
Indicates the subject area in which the teacher exhibits Digits competency.

gradeLevel

Census > People > District Assignment
Selection of grade levels staff person is able to teach.

otherFundingPercent

Census > People > District Assignment
Notes the total percentage of salary the staff person is paid by other sources.

generalFundingPercent

Census > People > District Assignment
Notes the total percentage of salary the staff person is paid by general funding dollars.

federalFundingPercent

Census > People > District Assignment
Notes the total percentage of salary the staff person is paid by federal dollars, usually reserved for those that work with Title 1 students.

salary

Census > People > District Assignment
Staff person’s yearly income.

daysPerYear

Census > People > District Assignment
Entry indicates how many days per year the staff person works.

hoursPerDay

Census > People > District Assignments
Number of hours per day the staff member works. Not used in all states.

districtID

Internal database identifier.

spedAgeGroup

Census > People > District Assignments
Special education age group, only used by BIE.

schoolID

Internal database identifier.

districtID

Internal database identifier.

ncesSchoolID

System Administration > Resources School
NCES school number.

number

System Administration > Resources > School
NCES school number.

name

System Administration > Resources > School
Official name of school.

type

System Administration > Resources > School
Designated type of school (e.g. Elementary, Middle, High, etc.).

comments

System Administration > Resources > School
User-entered notes about the school.

address

System Administration > Resources > School
Mailing address of school building.

city

System Administration > Resources > School
Mailing city of school building.

state

System Administration > Resources > School
State of school building.

zip

System Administration > Resources > School
Zip code of school building.

phone

System Administration > Resources > School
Phone number of school building.

fax

System Administration > Resources > School
Fax number of school building.

email

System Administration > Resources > School
Email of school building.

url

System Administration > Resources > School
Checked if school allows students to be enrolled in two buildings at one time.

dualEnrollment

System Administration > Resources > School
Checked if school allows students to be enrolled in two buildings at one time.

title1

System Administration > Resources > School
Selected if school provides Title 1 services.

principalName

System Administration > Resources > School
Name of principal.

principalTitle

System Administration > Resources > School
Principal’s title.

principalEmail

System Administration > Resources > School
Email of principal.

schoolGUID

Internal database identifier.

catalogID

Internal database identifier.

satNumber

System Administration > Resources > School
School number for SAT purposes; varies by state (e.g. CEEB, CBBC).

standardCode

System Administration > Resources > School
Code related to SIF/DIS information.

agency

System Administration > Resources > School
Agency (Education Line Office) associated with school. Not used in all states.

restructureStartDate

System Administration > Resources > School > School
For BIE schools, the date on which restructuring to meet NCLB standards began.

restructureEndDate

System Administration > Resources > School > School
For BIE schools, the date on which restructuring to meet NCLB standards ended.

groupNumber

District number assigned by and only used in the federal installation to allow tracking of both the state-assigned district number and the federal assigned number.

aypGrouping

System Administration > Resources > School
AYP Grouping of school (e.g. K-8, 9-12, exclude). Not used in all states.

reportingSchoolID

Internal database identifier.

physicalAddress

System Administration > Resources > School
Physical address of school building.

physicalCity

System Administration > Resources > School
Physical city of school building.

physicalState

System Administration > Resources > School
Physical state of school building.

physicalZip

System Administration > Resources > School
Physical zip code of school building.

county

System Administration > Resources > School
County of school. Not used in all states.

status

System Administration > Resources > School
Operational Status of school. Not used in all states.

accreditation

System Administration > Resources > School
Accreditation Status of school. Not used in all states.

gradeType

System Administration > Resources > School
Grade Type associated with school. Not used in all states.

sector

System Administration > Resources > School
Sector of education school is related to (e.g. public, non-public). Not used in all states.

locale

System Administration > Resources > School
Locale Code indicating school size and location. Not used in all states.

locale2

System Administration > Resources > School
Locale Old Code indicating school size and location. Not used in all states.

blueRibbon

System Administration > Resources > School
If flagged, checkbox indicates school is considered a Blue Ribbon School. Not used in all states.

title1Distinguished

System Administration > Resources > School
If flagged, checkbox indicates school is considered a Title 1 Distinguished School. Not used in all states.

entityID

System Administration > Resources > School
Reporting entity for the school. Not used in all states.

aypStatus

System Administration > Resources > School
Indicator of school’s AYP School Status. Not used in all states.

size

System Administration > Resources > School
The school’s MHSA Designation. Not used in all states.

sessionType

Not applicable to interface
SIF element.

fRYSCServiceCenterCode

System Administration > Resources > School
FRYSC Service Center serving this school.

modifiedByID

Does not appear.
Lists the person who modified the information.

modifiedDate

Does not appear.
Date of last change.

 hrStaffEvaluationID The primary key to the HRStaffEvaluation table.
 assignmentID Foreign Key to the EmploymentAssignment table.
 startDate Start date of the evaluation.
 endDate End date of the evaluation.
 completionDate 

The date that the supervisor clicked the complete button to finish the evaluation.

 firstName 

Census > People > Demographics > Person Information > First Name

The employee's first name.

 middleName 

Census > People > Demographics > Person Information > Middle Name

The employee's middle name.

 lastName 

Census > People > Demographics > Person Information > Last Name

The employee's last name.

 staffNumber 

Census > People > District Employment > Employment Record> License Number

The unique code assigned to the employee and maintained by the district.

 evaluatorPersonID 

Foreign Key to the Person table to identify who is doing the evaluation.

 evaluatorFirstName 

Census > People > Demographics > Person Information > First Name

The evaluator's first name.

 evaluatorLastName 

Census > People > Demographics > Person Information > Last Name

The evaluator's last name.

 evaluatorStaffNumber 

Census > People > District Employment > Employment Record> License Number

The unique code assigned to the evaluator and maintained by the district.

 overallRatingScaleCode 

Human Resources > Administration > Staff Evaluations Setup > Rating Scales > Code

The unique code for the rating scale to which the overall rating scale code belongs.

 overallRatingScaleDescription 

Human Resources > Administration > Staff Evaluations Setup > Rating Scales > Description

The description of the rating scale to which the overall rating scale code belongs.

 overallRatingCode 

 Staff Evaluations > Supervisor

 The code for the Overall Rating given to the evaluation.

 overallRatingDescription 

 Staff Evaluations > Supervisor 

 The description for the Overall Rating given to the evaluation. 

 evaluatorOverallComments 

 Staff Evaluations > Supervisor 

The evaluator's overall comments about the evaluation.

 staffFinalComments 

 Staff Evaluations > Supervisor 

The staff member's final comments about the evaluation.

 evaluationCode 

  Staff Evaluations > Supervisor  

 The code for the Evaluation template.
 

 evaluationDescription 

  Staff Evaluations > Supervisor
 
 

 The description for the Evaluation template. 

 evaluationType 

   Staff Evaluations > Supervisor   

  Identifies the type of evaluation:   Annual, Interim, and Observation.

 evaluationWorkflow 

    Staff Evaluations > Supervisor    

Identifies the workflow used to create the evaluation: Staff Reflection and Acknowledgement (Full Process), Staff Acknowledgement (No Reflection), or No Staff Reflection or Acknowledgement.

 hrSEEvaluationPeriodID 

Foreign Key to the HRSEEvaluationPeriod table to identify the period to which the evaluation belongs.

 periodCode 

    Staff Evaluations > Supervisor    

The code for the Evaluation Period during which the staff evaluation process occurred.

 periodDescription 

Staff Evaluations > Supervisor

The description for the Evaluation Period during which the staff evaluation process occurred.

 hrStaffEvaluation
ComponentScoreID
 
Primary key to the HRStaffEvaluation table.
 hrStaffEvaluationID 

Foreign Key to the HRStaffEvaluation table to identify the evaluation this score is for.

 componentCode 

Staff Evaluations > Supervisor

The code for the Category on the evaluation.

 componentDescription 

Staff Evaluations > Supervisor

The description of the Category on the evaluation.
 level 

The level at which the employees are rated. Options include the following:

  • 0 - Category
  • 1 - Element
  • 2 - sub-element
 seq The order in which the Categories display.
 ratingScaleCode 

Staff Evaluations > Supervisor

The code for the specific scale used to measure an employee's performance.

 ratingScaleDescription 

Staff Evaluations > Supervisor

A detailed description of the rating scale.

 evaluatorRatingCode 

Staff Evaluations > Supervisor

The code for the rating entered by the evaluator.

 evaluatorRatingDescription 

Staff Evaluations > Supervisor 

The description of the rating entered by the evaluator. 

 evaluatorRatingDefinition 

Staff Evaluations > Supervisor 

The rating code definition that is included in the rating scale.

 evaluatorReflection 

Staff Evaluations > Supervisor 

The reflection entered by the evaluator.

 evaluatorEvidence 

Staff Evaluations > Supervisor

The evidence entered by the evaluator.

 staffRatingCode 

Staff Evaluations > Supervisor

The rating code entered by the employee.

 staffRatingDescription 

Staff Evaluations > Supervisor

The description of the rating code entered by the employee.
 staffRatingDefinition 

Staff Evaluations > Supervisor 

The rating code definition, selected by the employee, that is included in the rating scale.

 staffReflection 

Staff Evaluations > Supervisor 

The reflection entered by the employee.

 staffEvidence 

Staff Evaluations > Supervisor 

The evidence entered by the employee.

 categoryCode 

Staff Evaluations > Supervisor 

The Category code.

 categoryDescription 

Staff Evaluations > Supervisor 

The Category description.

credentialID

Internal database identifier.

personID

Internal database identifier.

area

Census > People > Credential
Indicates the area of study in which the teacher is experienced.

credentialType

Census > People > Credential
Indicates the type of credential.

creditHours

Census > People > Credential
Indicates the number of credit hours earned.

number

Census > People > Credential
Indicates the credential number.

date

Census > People > Credential
Indicates the date the credential was earned.

employmentCredentialType

Census > People > Credential
Type of credential staff person has.

subjectType

Census > People > Credential
Indicates the type of competency staff person has.

coreSubject

Census > People > Credential
Subject area staff person is designated to teach.

metHousse

Census > People > Credential
Indicates staff person has met the requirements of HOUSSE.

housseDate

Census > People > Credential
Date staff person completed the HOUSSE.

subjectCompetency

Census > People > Credential
Indicates the staff person has subject competency.

degreeType

Census > People > Credential
Indicates the staff person has full certification.

fullCertification

Census > People > Credential
Indicates the staff person has full certification.

lepCredential

Census > People > Credential
Indicates staff person has an LEP Credential

licenseNumber

Census > People > Credential
License Number of staff person.

licenseType

Census > People > Credential
Type of License staff person has.

endDate

Census > People > Credential
Date the credential will end or has ended.

campusCode

Census > People > Credential
Code indicating the institution where the staff member received education credentials.

institutionType

Census > People > Credential
Type of education institution.

districtID

Internal database identifier.

credentialGUID

Internal database identifier.

spedRelatedService

Census > People > Credential
Indicates the staff person serves in a special education related service.

eduState

Census > People > Credential
Indicates in what state the staff member received education credentials.

subjectArea

Census > People > Credentials
Subject area of the credential, based on core academic classes. Not used in all states.

paraprofessionalQualification

Census > People > Credentials
Qualifications specific to a paraprofessional. Not used in all states.

stateReported

Census > People > Credentials > Education
Indicates that the data in this record is reported as the primary education information in the Staff demographics and employment records. Not used in all states.

majorCipCode

Census > People > Credentials > Education
The major subject code for the degree reported in District Employment.

minorCipCode

Census > People > Credentials > Education
The minor subject of the degree reported in District Employment

stateCompetency

Census > People > Credentials > Education
The state-defined competency determination of the individual.

personID

Internal database identifier.

trialID

Internal database identifier.

calendarID

Internal database identifier.

courseID

Internal database identifier.

sectionID

Internal database identifier.

assignmentID

Internal database identifier

title

Census > People > District Assignment
The person's title associated with their district assignments.

stateTitle

Census > People > District Assignment > State Title
The state-defined title associated with the person's district assignments.

calendarID

Internal database identifier.

districtID

Internal database identifier.

schoolID

Internal database identifier.

endYear

System Administration > Calendar > Calendar
The 4-digit year marking the end of the school year (i.e. 2006 would be the end of the 05-06 school year).

name

System Administration > Calendar > Calendar
Name of calendar.

number

System Administration > Calendar > Calendar
Number associated with calendar.

startDate

System Administration > Calendar > Calendar
Lists the date when the calendar is first used. This is NOT the first day of instruction, but could be the first day staff is available.

endDate

System Administration > Calendar > Calendar
Lists the date when the calendar is last used. This is NOT the last day of instruction, but could be the last day staff are available.

comments

System Administration > Calendar > Calendar
Notes any comments associated with the calendar.

exclude

System Administration > Calendar > Calendar
When this checkbox is marked, the calendar is not used in state reporting extracts.

summerSchool

System Administration > Calendar > Calendar
When this checkbox is marked, the calendar is labeled as a summer school calendar.

studentDay

System Administration > Calendar > Calendar
Lists the total number of minutes students are scheduled into courses.

teacherDay

System Administration > Calendar > Calendar
Lists the total number of minutes teachers are available for instruction and prep time.

wholeDayAbsence

System Administration > Calendar > Calendar
Lists the total number of minutes that constitutes a full day of absence per a district or state decision. Used in calculating ADM and ADA.

halfDayAbsence

System Administration > Calendar > Calendar
Lists the total number of minutes that constitutes a half day of absence per a district or state decision. Used in calculating ADM and ADA.

calendarGUID

Internal database identifier.

alternativeCode

System Administration > Calendar > Calendar
If flagged, checkbox indicates a 4 Day School Week. Not used in all states.

title3

System Administration > Calendar > Calendar
Indicates district participates in the Title 3 program. Not used in all states.

title3consortium

System Administration > Calendar > Calendar
Indicates the school is part of a team of districts operating together to improve student learning using Title 3 funds. Not used in all states.

title1

System Administration > Resources > School
Displays the selection of the Title 1 funding options.

legacyKey

Used during data conversion.

schoolChoice

System Administration > Calendar > Calendar
If flagged, checkbox indicates calendar is labeled as using school choice functionality.

type

System Administration > Calendar > Calendar
Calendar type is usually (I)nstructional, but can also be (S)ummer School, (R)esidential, etc.

countDate

System Administration > Calendar > Calendar
Testing Count Date. Not used in all states.

assignmentRequired

System Administration > Calendar > Calendar
Defines if students enrolling in this calendar are required to follow school boundary assignment logic.

calendarOverrideID

Internal database identifier.

calendarID

Internal database identifier.

overridetype

System Administration > Calendar > Calendar > Overrides
Displays selection of type of override used in school placement.

courseID

Internal database identifier.

courseMasterID

Internal database identifier.

calendarID

Internal database identifier.

schoolID

Internal database identifier.

districtID

Internal database identifier.

endYear

System Administration > Calendar > Calendar
The 4-digit year marking the end of the school year (i.e. 2006 would be the end of the 05-06 school year).

courseNumber

Scheduling > Courses
Course number.

courseName

Scheduling > Courses
Course name.

stateCode

Scheduling > Courses
State code associated with this course.

description

Scheduling > Courses
User-entered course description.

descriptionNoHTML

Scheduling > Courses
User-entered course description devoid of HTML tags.

departmentID

Internal database identifier.

departmentName

Scheduling > Courses
District or school-defined department name for use in organizing curriculum.

type

Scheduling > Courses
Course type indicating that course is R: Required, E: Elective, or other.

programType

Scheduling > Courses
Stores the type of program the course is related to.

teachingMethod

Scheduling > Courses
Stores the teaching method of the course.

vocationsCode

Scheduling > Courses
Stores the vocational code of the course. Not used in all states.

distanceCode

Scheduling > Courses
Instructional setting of course.

specialEdCode

Scheduling > Courses
Stores the special education code for the course.

coursePart

Scheduling > Courses
Stores the course part for the course.

honorsCode

Scheduling > Courses
Difficulty level of course.

activityCode

Scheduling > Courses
The district-defined activity code of the course for tracking activity rosters and groups.

homeroom

Scheduling > Courses > Section
Indicates whether or not the course is designated as a homeroom for state reporting purposes.

transcript

Scheduling > Courses
Indicates whether or not the course should be posted to transcript.

requestable

Scheduling > Courses
Indicates whether or not the course is available for request via the portal.

required

Scheduling > Courses
Indicates whether or not the course is a required course.

attendance

Scheduling > Courses
Indicates attendance should be taken in the course.

unitAttendance

Scheduling > Courses
Indicates whether or not the course has unit attendance.

terms

Scheduling > Courses
Stores the number of terms the course meets.

schedules

Scheduling > Courses
Determines how many period schedules a section will take up in schools with multiple period schedules.

periods

Scheduling > Courses
The number of periods a section of the course lasts.

gpaWeight

Scheduling > Courses
The weight the course should contribute to a student’s cumulative GPA.

bonusPointsAvail

Scheduling > Courses
Indicates whether or not bonus points are available.

maxStudents

Scheduling > Courses
The maximum number of students who can be enrolled in the course.

priority

Scheduling > Courses
The priority of the course as related to others courses in the scheduling process.

sectionsToBuild

Scheduling > Courses
The number of sections that need to be built for the course in the schedule.

sections

Scheduling > Courses
Count of all sections existing for all active courses in selected calendar.

pseoType

Scheduling > Courses
Stores the PSEO number in the Community College CTDS field. Not used in all states.

pseoCredit

Scheduling > Courses
Stores the number of PSEO credits the course is worth. Not used in all states.

specialCode

Scheduling > Courses > Course
Stores the special education code for the course.

highSchoolCredit

Scheduling > Courses > Course
Checkbox indicating that course is grants high school credit. Not used in all states.

catalogID

Internal database identifier.

catalogName

Grading and Standards > Course Catalog
Course catalog name.

courseMasterNumber

Grading and Standards > Course Master
Course number for this course master entry.

courseMasterName

Scheduling > Course Catalog
Course name for this course master entry.

courseMasterStateCode

Scheduling > Course Catalog
Course state code for this course master entry.

altStateCode

Scheduling > Courses > Courses
Alternative state code associated with this course. Not available in all states.

abbreviation

Abbreviation of the course name. Appears when searching.

grade

Scheduling > Courses > Course
The grade related to the course.

sectionID

Internal database identifier.

trialID

Internal database identifier.

calendarID

Internal database identifier.

courseID

Internal database identifier.

sectionNumber

Scheduling > Courses > Section
Section number for instance of course.

teacherDisplay
teacher2Display
teacher3Display
teacher4Display

Scheduling > Courses > Section
Stores the teacher name displayed on student schedules, default to fullname, may be changed in section editor.

sectionStaff1Display
sectionStaff2Display
sectionStaff3Display

Scheduling > Courses > Section
Displays additional staff members who can view roster information for the course section (special education teachers, etc.).

maxStudents

Scheduling > Courses > Section
The maximum number of students who can be enrolled in the course.

classType

Scheduling > Courses > Section
Stores the type of class for the section. Not used in all states.

schedGroupID

Internal database identifier.

groupName

Scheduling > Course > Section
Name of the scheduling group or team assigned to the section, if applicable.

roomID

Internal database identifier.

roomName

Scheduling > Course > Section
Name associated with room.

roomPhone

Scheduling > Course > Section
Phone number to room.

roomCapacity

Scheduling > Course > Section
Number of people room can hold.

lunchID

Internal database identifier.

lunchName

Scheduling > Course > Section
The name of the lunch scheduled within the section, if lunches are set up in Scheduling > Lunches.

lunchCount

Scheduling > Courses > Section
If flagged, checkbox indicates the lunch count field should be added to the attendance tool for this course section.

milkCount

Scheduling > Courses > Section
If flagged, checkbox indicates the milk count field should be added to the attendance tool for this course section.

homeroomSection

Scheduling > Courses > Section
Indicates the section is the Homeroom for the student.

serviceDistrict

Scheduling > Courses > Section
Notes the name of the district where students receive special services.

serviceSchool

Scheduling > Courses > Section
Notes the name of the school building where students receive special services.

multipleTeacherCode

Scheduling > Courses > Section
Code indicating reason Multiple Teacher(s) are assigned to section. Not used in all states.

lockBuild

Indicates that the scheduling build may not be changed.

lockRoster

Indicates that the roster may not be changed. Rosters are locked within the Schedule Wizard.

giftedDelivery

Scheduling > Courses > Section
If flagged, checkbox indicates course is targeted at students receiving gifted services. Not used in all states.

giftedContentArea

Scheduling > Courses > Section
Identifies the state-defined gifted delivery area for this course. Not used in all states.

parapros

Scheduling > Courses > Section
Number of paraprofessionals attached to this section. Not used in all states.

skinnySeq

Scheduling > Courses > Section
Determines which course prints first on a student schedule when two or more occur courses are taken within the same period. The course with the lowest number will print first on student’s schedule.

teacherPersonID
teacher2PersonID
teacher3PersonID
teacher4PersonID

Internal database identifier.

teacherLastName
teacher2LastName
teacher3LastName
teacher4LastName

Scheduling > Courses > Section
Last name of the primary teacher assigned to section.

teacherFirstName
teacher2FirstName
teacher3FirstName
teacher4FirstName

Scheduling > Courses > Section
First name of the primary teacher assigned to section.

teacher2StaffStateID
teacher3StaffStateID
teacher4StaffStateID

Scheduling > Courses > Section
The Staff State ID number of the primary teacher assigned to section.

teacher2StaffNumber
teacher3StaffNumber
teacher4StaffNumber

Scheduling > Courses > Section
The staff number of the primary teacher assigned to section.

sectionStaff1StateID
sectionStaff2StateID
sectionStaff3StateID

Scheduling > Courses > Section
The Staff State ID number of the section staff assigned to section.

sectionStaff1Number
sectionStaff2Number
sectionStaff3Number

Scheduling > Courses > Section
The staff number of the section staff assigned to section.

sectionStaff1PersonID
sectionStaff2PersonID
sectionStaff3PersonID

Internal database identifier.

sectionStaff1LastName
sectionStaff2LastName
sectionStaff3LastName

Scheduling > Courses > Section
Last name of the section staff assigned to section.

sectionStaff1FirstName
sectionStaf21FirstName
sectionStaf31FirstName

Scheduling > Courses > Section
First name of the section staff assigned to section.

nonHqtReason

Scheduling > Courses > Section
Reason that the section is not taught by a Highly Qualified Teacher. Not available in all states.

nonHqtExplanation

Scheduling > Courses > Section
Explanation of why the section is not taught by a Highly Qualified Teacher. Not available in all states.

highlyQualified

Scheduling > Courses > Sections
Indicates if teacher of section is considered highly qualified.

sectionID

Internal database identifier.

trialID

Internal database identifier.

calendarID

Internal database identifier.

studentCount

Scheduling > Courses > Section > Roster
Count of requests for this course flagged as Required or Elective.

maleStudentCount

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by male students.

femaleStudentCount

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by female students.

specialEdStudents

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by special education students with a current IEP.

gradeKGstudents

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by kindergarten students.

grade01students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by first-grade students.

grade02students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by second-grade students.

grade03students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by third-grade students.

grade04students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by fourth-grade students.

grade05students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by fifth-grade students.

grade06students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by sixth-grade students.

grade07Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by seventh-grade students.

grade08Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by eighth-grade students.

grade09Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by ninth-grade students.

grade10Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by tenth-grade students.

grade11Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by eleventh-grade students.

grade12Students

Scheduling > Courses > Section > Roster
Count of non-alternate requests for this course made by twelfth-grade students.

drops

Scheduling > Courses > Section > Roster
Count of students who have dropped the section.

calendarID

Internal database identifier.

structureID

Internal database identifier.

trialID

Internal database identifier.

termStart

System Administration > Calendar > Terms
Very first day students begin taking classes in term.

termEnd

System Administration > Calendar > Terms
Very last day students take classes in term.

terms

System Administration > Calendar > Calendar > Terms
Number of terms the course section takes place.

scheduleStart

System Administration > Calendar > Calendar > Terms
Start date of term schedule.

scheduleEnd

System Administration > Calendar > Calendar > Terms
End date of term schedule.

schedules

System Administration > Calendar > Calendar > Terms
Number of period schedules a section will take up in schools with multiple period schedules.

periodStart

System Administration > Calendar > Period
The time of the first minute in military time the period meets.

periodEnd

System Administration > Calendar > Period
The time of the last minute in military time (24 hour clock) which this period meets.

periods

System Administration > Calendar > Period
Number of periods the course section runs.

Food Service

Eligibility

Person > Food Service > Eligibility

Filter Fields

Mapping and Definition

eligibilityID

Internal database identifier

eligibility

FRAM > Eligibility
Student's meal status eligibility.

personID

Internal database identifier

endYear

FRAM > Eligibility
Last school year to which eligibility applies.

type

FRAM > Eligibility
Certified type of eligibility

startDate

FRAM > Eligibility
Start date of the food service eligibility.

endDate

FRAM > Eligibility
End date of the food service eligibility.

applicationID

Internal database identifier

optOutMedicaid

FRAM > Eligibility
Indicates that parent does not want to be contacted by that specific agency.

optOutSCHIP

FRAM > Eligibility
Indicates that parent does not want to be contacted by that specific agency.

districtID

Internal database identifier

eligibilityGUID

Internal database identifier

freeMilk

FRAM > Eligibility
Student receives free milk assistance.

notParticipate

FRAM > Eligibility
Indicates that student does not participate in meal assistance.

StateCode

FRAM > Eligibility
State eligibility code attached to the eligibility.

Person Campus Usage

User Account/Summary

Person > Campus Usage > User Account/Summary

Filter Field

Mapping and Definition

userID

Internal database identifier.

personID

Internal database identifier.

districtID

Internal database identifier.

username

System Administration > User Security > User > User Account
Login name assigned to a user.

allModules

System Administration > User Security > User > User Account
If flagged, the All Tools checkbox indicates a user has rights to all tools/modules in Campus.

allCalendars

System Administration > User Security > User > User Account
If flagged, indicates whether or not user has rights to all historical calendars.

failCount

System Administration > User Security > User > User Account
Stores the number of failed login attempts the user has had since the last successful login.

forceChangePassword

System Administration > User Security > User > User Account
If flagged, indicates whether or not user must change his/her password at next login attempt.

disable

System Administration > User Security > User > User Account
If flagged, indicates whether or not the User’s account has been disabled, a result of either administrator action or excessive failed login attempts.

expiresDate

System Administration > User Security > User > User Account
Date the user’s account will become inactive.

homepage

System Administration > User Security > User > User Account
Lists the Portal URL for Portal users.

name

System Administration > User Security > User
Name of the user who last logged in (from SecurityAccess table).

serverName

System Administration > User Security > User
Network name of server user logged into.

remoteIP

Access Log
System Administration > User Security > User > Access Log
Stores the IP address from which login was attempted.

remoteName

Access Log
System Administration > User Security > User > Access Log
Stores the remote browser name from which login was attempted.

remoteBrowser

Access Log
Stores the info about the browser from which login was attempted.

timestamp

Access Log
System Administration > User Security > User > Access Log
Records the date and time of login attempts for user.

appServer

Access Log
System Administration > User Security > User > Access Log
Stores the appserver instance that processed the login attempt.

accountType

System Administration > User Security > User Account
Homepage interface assigned to the account (e.g. Campus application, Portal, other).

lastAccessedTimestamp

Access Log
System Administration > User Security > User > Access Log
Timestamp of the most recent login attempt.

loginsThisWeek

Access Log
System Administration > User Security > User > Access Log
Count of logins occurring within the last seven days.

loginsThisMonth

Access Log
System Administration > User Security > User > Access Log
Count of logins occurring within the last thirty days.

totalLoginCount

Access Log
System Administration > User Security > User > Access Log
Total logins stored in the SecurityAccess table.

LDAPDN

Does Not Appear
The Distinguished Name from the Active Directory. Results indicate the user’s location in the Active Directory organizational structures and the common name.

LDAPGUID

Does Not Appear
Populates when users have been updated to the LDAP account and linked to the Active Directory.

Person Custom Tab

Filter Field

Mapping and Definition

Custom Filter

System Administration > Custom > Custom Tab > Person Tabset > People
Custom Tab fields are locally customized fields created and used by a district for internal purposes. Custom Tabs aligned with the People Person Tabset populate in this area.

Person Online Payments

Online Payment Users
Filter FieldMapping and Definition
personID

Does Not Appear

Internal database identifier.

disableAccount

Census > Households > Payments > Disable OLP Account

When this checkbox is marked, the person does not see the Payments area on the portal.

Online Payment Transactions

System Administration > Finance > Payments > Reports > Payment Transaction Report

transactionRefThe unique ID number assigned to each transaction. This number is generated by the payment platform and appears on the transaction receipt. This number can also be looked up by running the Payment Transaction Report for the corresponding Payment Bank Account ID or for all transactions within a certain date range.
paymentTimestampThe day and time on which the payment occurred.
amountThe total amount charged. This amount includes any convenience fee plus the total amount of the payment for the fees or food service deposit.
convenienceFeeA per-transaction, flat fee charge that the district can choose to charge the payer.
transactionFeeThe fee the payment vendor charges the district to complete the transaction.
commentsThe comment entered when the transaction was voided.
settlementDateThe date the transaction was settled.
processDateThe date when the transaction was initiated.
depositDateThe date funds for the transaction were deposited into the client’s account.
customerRefThe customer ID, generated by the payment platform, to identify who paid for the transaction.
feeFundID

The account name that is tracked in Campus to which the fee payment is attributed.

fundIDThe ID of the fund to which the payment is deposited.
returnReasonThe reason why the transaction was returned.
returnDate

The date the transaction was returned.

ccStatus 

The status of the online payment.

P=Processed

E=Error, did not process

F=Failed, did not process

 

Save