Census-Staff Filter Fields for Ad hoc Reporting

Last Modified on 07/31/2024 11:19 am CDT

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 Evaluations	Person > 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 Scheduling Board.
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 Field	Mapping 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
transactionRef	The 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.
paymentTimestamp	The day and time on which the payment occurred.
amount	The total amount charged. This amount includes any convenience fee plus the total amount of the payment for the fees or food service deposit.
convenienceFee	A per-transaction, flat fee charge that the district can choose to charge the payer.
transactionFee	The fee the payment vendor charges the district to complete the transaction.
comments	The comment entered when the transaction was voided.
settlementDate	The date the transaction was settled.
processDate	The date when the transaction was initiated.
depositDate	The date funds for the transaction were deposited into the client’s account.
customerRef	The 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.
fundID	The ID of the fund to which the payment is deposited.
returnReason	The 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