Staff Demographics (ISEE Extracts) (Idaho)

 PATH   : ID State Reporting > ISEE Extracts 

The Staff Demographics extract is used to report demographic data on a staff level for staff with an active district assignment during the selected date range. Data for many fields in the Staff Demographics Extract are not currently stored in Infinite Campus and will have to be merged into the extract from an HR system. 

Staff Type

Description

Active

Any staff person with an active District Employment and an active District Assignment with a Type that is not null. The District Employment and District Assignment must be active at some point during the extract date range. 

Exiting

Any staff person whose District Employment ends during the reporting period.

Previously Exited

When a Previous Submission Date is selected on the report editor, any staff who have an ended District Employment any time from the Previous Submission Date entered to the start of the date range report.

Inactive

Any Staff Person who has an Active District Employment for the entire Date Range but who does not have an Active District Assignment for the entire Date Range.

 
 Image 1:   Staff Demographics   (ISEE Extract Editor) 

Staff Demographics Extract Logic

  • All district-employed staff must have an active District Employment to report unless a Previous Submission Date is entered on the editor.
  • For teaching staff not employed by the district who do not have a District Employment record but do have a District Assignment with a Contract Type of AR, R, or NE and 'Teacher' marked, a record reports per staff member regardless of the number of active teaching assignments that meet reporting criteria.
  • Staff must have an active District Assignment (with a Type that is not null) unless they are Exiting, Previously Exited, or Inactive.
  • Staff must have a Staff State ID to report.
  • Staff report only one record unless they have multiple District Employment records eligible to report. In that situation, one record reports for each District Employment.

Report Editor Field Descriptions

Field

Description

Report Type

Select Staff Demographics. The following ISEE extract types are also available:

Start Date

The earliest date from which data is pulled for the report. (Not required if Previous Submission Date is entered)

End Date

The latest date from which data is pulled for the report. (Required)

Previous Submission Date

To report Staff who have exited over the summer, enter a date in the Previous Submission Date field. Any staff who have an ended District Employment any time from the Previous Submission Date entered to the start of the date range report.

Format

The format in which the report will generate. Options include CSV (State Format) and HTML.

Batch Queue

Users have the option of submitting a District Calendar report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Staff Demographics Extract Layout

Column

Description & Format

Campus Location

idStaffID

The staff member's unique Idaho Staff Identification Number.


Numeric, 9 digits

Census > People > Demographics > Person Identifiers > Staff State ID


Person.staffStateID

lastName

The staff member's last name. Reports the Legal Last Name if entered. 


Alphanumeric, 35 characters

Census > People > Demographics > Person Information > Last Name


Identity.lastName

firstName

The staff member's first name. Reports the Legal First Name if entered. 


Alphanumeric, 35 characters

Census > People > Demographics > Person Information > First Name


Identity.firstName

middleName

The staff member's middle name. Reports the Legal Middle Name if entered. 


Alphanumeric, 40 characters

Census > People > Demographics > Person Information > Middle Name


Identity.middleName

suffix

An appendage, if any, used to denote the staff member's generation in their family or title; e.g., Jr., Sr., III, PhD.


Alphanumeric, 8 characters

Census > Demographics > Person Information > Suffix


Identity.suffix

formerName

Any names that were used in the past by the employee. Reports the First, Middle, Last Name and Suffix from an earlier Identity, if applicable.


Alphanumeric, 50 characters

Census > People > Identities


Identity.firstName
Identity.middleName
Identity.lastName
Identity.suffix

birthDate

The month, day, and year on which the staff member was born.


Date Field, 10 characters, MM/DD/YYYY

Census > People > Identities


Identity.birthDate

gender

A person's gender. Reports M (male) or F (female). Reports the Legal Gender if entered. 


M or F, 1 character

Census > People > Demographics > Person Information > Gender


Identity.gender

hispanic

Indicates whether the staff member is Hispanic or Latino. Hispanic or Latino means a person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > Hispanic/Latino


Identity.hispanicEthnicity

asian

Indicates whether the staff member is Asian. A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippines.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > Asian


Identity.raceEthnicity

indian

Indicates whether the staff member is a person having origins in any of the original peoples of North and South America (including Central America), and who maintains a tribal affiliation or community attachment.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > American Indian or Alaska Native


Identity.raceEthnicity

black

Indicates whether the staff member is a person who has origins in any of the Black racial groups of Africa.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > Black or African American


Identity.raceEthnicity

islander

Indicates whether the staff member is Native Hawaiian or Other Pacific Islander meaning having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander


Identity.raceEthnicity

white

Indicates whether the staff member is White or Causasian meaning having origins in any of the original peoples of Europe, the Middle East, or North Africa.


Y or N, 1 character

Census > People > Demographics > Person Information > Race/Ethnicity > White


Identity.raceEthnicity

language

If this staff member is proficient in a language other than English, the code for that language. If the staff member is proficient in more than one other language, the most proficient language reports.


Alphanumeric, 3 characters

Census > District Employment > Proficient Language


Employment.proficientLanguage

isCertified

Indicates whether the staff member has certified assignments or is on a contract. Reports Y if staff has an active District Assignment with Type: 02. 


Y or N, 1 character

Census > People > District Assignment > Type


EmploymentAssignment.type

isParaPro

Indicates whether the staff member is a paraprofessional working with students. Reports as Y if the staff person has a District Assignment active during the extract reporting window with a Type of 04. Otherwise reports as N.


Y or N, 1 character

Census > People > District Assignment > Type


EmploymentAssignment.type

certificationYear

The date teachers or administrators first received certification, regardless of the state issuing the certification. Teaching Start Date reports for Type 02 staff.


Date Field, 10 characters MM/DD/YYYY

Census > District Employment > Teaching Start Year


Employment.teachingStartYear

 certificationState 

Currently reports as blank.

Does not display

highestDegree

The highest degree claimed by the employee for funding purposes. Reported for Type 02 Staff preferentially from the Education Credential checked as State Reported. Will report from District Employment with Education=OS if no Education Credential.

See the Credential Code List following this table.


Alphanumeric, 2 characters

Census > People > Credentials > Credential Type > Education Level, State Reported


EmploymentCredential.degreeType

degreeYear

The year in which the highest degree being claimed was earned. Reported for Type 02 Staff preferentially from the Education Credential checked as State Reported. Will report Teaching Start Year from District Employment with Education=OS if no Education Credential.


Date Field, 10 characters, MM/DD/YYYY

Census > People > Credentials > Credential Type > Education > Date Credential Obtained


EmploymentCredential.date
OR
Employment.teachingStartYear

claimDegreeInst

The name of the institution that granted the highest degree the employee has claimed for funding purposes. Reporting for Type 02 Staff from Education Credential checked as State Reported.
See the Institution Code List following this table.


Alphanumeric, 3 characters

Census > People > Credentials > Credential Type > Education > Degree Institution


EmploymentCredential.campusCode

claimDegreeState

The two character postal code where the Institution of claimed highest degree is based. Reporting for Type 02 Staff from Education Credential checked as State Reported.


Numeric, 2 digits

Census > People > Credentials > Credential Type > Education > Degree State


EmploymentCredential.eduState

claimedMajor

The Major of the highest degree claimed for funding purposes. Reporting for Type 02 Staff from Education Credential checked as State Reported.


Alphanumeric, 6 characters, NN.NNNN

Census > People > Credentials > Credential Type > Education > Major CIP Code


EmploymentCredential.majorCipCode

claimedMinor

The Minor (if any) of the highest degree claimed for funding purposes. Reporting for Type 02 Staff from Education Credential checked as State Reported.


Alphanumeric, 6 characters, NN.NNNN

Census > People > Credentials > Credential Type > Education > Minor CIP Code


EmploymentCredential.minorCipCode

 addlCredits 

College transcript credit earned beyond the highest degree claimed.
This field reports blank.

Does not display.

 addlDegree1 

The first additional degree earned by this employee other than the one claimed for funding. Need not be earned prior to the claimed degree.
This field reports blank.

Does not display.

 degree1Year 

Year that the first additional degree was earned.
This field reports blank.

Does not display.

 degree1Institution 

The name of the institution that granted the first additional degree.
This field reports blank.

Does not display.

 degree1State 

The two character postal code where the Institution of the first additional degree is based.
This field reports blank.

Does not display.

 degree1Major 

The major area of study for the first additional degree.
This field reports blank.

Does not display.

 degree1Minor 

The minor area of study for the first additional degree.
This field reports blank.

Does not display.

 addlDegree2 

The second additional degree earned by this employee other than the one claimed for funding. Need not be earned prior to the claimed degree.
This field reports blank.

Does not display.

 degree2Year 

Year that the second additional degree was earned.
This field reports blank.

Does not display.

 degree2Institution 

The name of the institution that granted the second additional degree.
This field reports blank.

Does not display.

 degree2State 

The two character postal code where the Institution of the second additional degree is based.
This field reports blank.

Does not display.

 degree2Major 

The major area of study for the second additional degree.
This field reports blank.

Does not display.

 degree2Minor 

The minor area of study for the second additional degree.
This field reports blank.

Does not display.

 addlDegree3 

The third additional degree earned by this employee other than the one claimed for funding. Need not be earned prior to the claimed degree.
This field reports blank.

Does not display.

 degree3Year 

Year that the third additional degree was earned.
This field reports blank.

Does not display.

 degree3Institution 

The name of the institution that granted the third additional degree.
This field reports blank.

Does not display.

 degree3State 

The two character postal code where the Institution of the third additional degree is based.
This field reports blank.

Does not display.

 degree3Major 

The major area of study for the third additional degree.
This field reports blank.

Does not display.

 degree3Minor 

The minor area of study for the third additional degree.
This field reports blank.

Does not display.

 addlDegree4 

The fourth additional degree earned by this employee other than the one claimed for funding. Need not be earned prior to the claimed degree.
This field reports blank.

Does not display.

 degree4Year 

Year that the fourth additional degree was earned.
This field reports blank.

Does not display.

 degree4Institution 

The name of the institution that granted the fourth additional degree.
This field reports blank.

Does not display.

 degree4State 

The two character postal code where the Institution of the fourth additional degree is based.
This field reports blank.

Does not display.

 degree4Major 

The major area of study for the fourth additional degree.
This field reports blank.

Does not display.

 degree4Minor 

the minor area of study for the fourth additional degree.
This field reports blank.

Does not display.

 minCreditsDate 

For non-certified paraprofessional instructional assistants, the date they met the NCLB minimum college credits threshold.
This field reports blank.

Does not display.

 minCreditsIHE 

For non-certified paraprofessional instructional assistants, the institution granting the credits.
This field reports blank.

Does not display.

 minCreditsIHEState 

For non-certified paraprofessional instructional assistants, the state where the institution that granted the credit is based.
This field reports blank.

Does not display.

paraHSDiplomaType

For non-certified paraprofessional instructional assistants, indicates whether they received a regular high school diploma or a GED (or equivalent). For Type: 04 staff, the following codes report:

  • D ( 7: High School )
  • G ( 8: GED or Equivalent)
  • X (All others or blank)

Alphanumeric, 1 character

Census > District Employment > Education


Employment.educationLevel

 paraExamDate 

For non-certified paraprofessional instructional assistants, the date they passed the ETS Paraprofessional Exam.
This field reports blank.

Does not display.

 paraExamScore 

For non-certified paraprofessional instructional assistants, the score from the ETS paraprofessional Exam.
This field reports blank.

Does not display.

 paraPraxis 

For non-certified paraprofessional instructional assistants, indicates whether they took the Praxis.
This field reports blank.

Does not display.

 paraExamOS 

For non-certified paraprofessional instructional assistants, indicates whether the ETS paraprofessional exam was taken in another state.
This field reports blank.

Does not display.

schoolId

This is the SDE assigned school number where the employee has their primary responsibility or where they receive their mail.

Reports based on the District Assignment active on the extract End Date. If multiple District Assignments are active, reports the assignment with the largest FTE. If no FTE values are entered, reports the assignment with the earliest start date.


Numeric, 4 digits

System Administration > Resources > School > State School Number; Census > People > District Assignment


School.number

 transcriptYear 

The year of the most recent transcript for the employee.
This field reports blank.

Does not display.

 idahoK12Experience 

Years of prior teaching experience in an Idaho public PK-12 school.
This field reports blank.

Does not display.

 k12PublicExperience 

Years of prior teaching experience in any public PK-12 school in any state (including Idaho).
This field reports blank.

Does not display.

 k12PrivateExperience 

Years of prior teaching experience in any non-public PK-12 school in any state - private or parochial.
This field reports blank.

Does not display.

 idahoHEExperience 

Years of prior teaching experience in any non-public PK-12 school in any state - private or parochial.
This field reports blank.

Does not display.

 HEExperience 

Years of prior teaching experience in any institution of Higher Education in any state (including Idaho).
This field reports blank.

Does not display.

hireDate

The date the employee was first hired by the school district


Date Field, 10 characters, MM/DD/YYYY

Census > People > District Employment > Employment Information > Start Date


Employment.startDate

yearsInDistrict

The number of years the employee has been employed by the school district. Calculated from District Employment Start Date to End Date of Date Range or End Date of District Employment, whichever is shorter.


Numeric, 4 digits, NN.N

Census > People > District Employment > Employment Information > Start Date


Employment.startDate

employmentStatus

The employee's employment status. The following values report:

  • A--The staff person's District Employment record is active on the last day of the Date Range.
  • I--The staff person's District Employment record is active on the last day of the Date Range AND there are no active District Assignments on the last day of the Date Range.
  • T--The staff person's District Employment record was active at the start of the Date Range and is not active at the end of the Date Range.

Alphanumeric, 1 character

Census > People > District Employment, District Assignment


Calculated, not dynamically stored

 contractType1 

Reports the first Contract Type entered for the staff of record.


Alphanumeric, 2 characters

Census > People > District Employment > Contract Type


EmploymentAssignment. contractType

 baseSalary1 

For Certified staff, the base salary on the contract rounded to the nearest dollar.
This field reports blank.

Does not display.

 contractDays1 

For certified staff, the number of days based on a five day work week contracted in contract 1.
This field reports blank.

Does not display.

 contractHours1 

For certified staff, the hours contracted in contract 1.
This field reports blank.

Does not display.

 contractFTE1 

The full-time equivalent for this contract.
This field reports blank.

Does not display.

c1fundSource1This field reports blank.

Does not display.

c1percentSource1This field reports blank.

Does not display.

c1fundSource2This field reports blank.

Does not display.

c1percentSource2This field reports blank.

Does not display.

c1fundSource3This field reports blank.

Does not display.

c1percentSource3This field reports blank.

Does not display.

c1fundSource4This field reports blank.

Does not display.

c1percentSource4This field reports blank.

Does not display.

 contractType2 

Reports the second Contract Type entered for the staff of record.


Alphanumeric, 2 characters

Census > People > District Employment > Contract Type


EmploymentAssignment.contractType

 baseSalary2 

The base salary on contract 2, if any, rounded to the nearest dollar.
This field reports blank.

Does not display.

 contractDays2 

The number of days listed on contract 2, if any, based on a five day work week.
This field reports blank.

Does not display.

 contractHours2 

The total hours contracted in contract 2, if any.
This field reports blank.

Does not display.

 contractFTE2 

The full time equivalent for this contract.
This field reports blank.

Does not display.

c2fundSource1This field reports blank.

Does not display.

c2percentSource1This field reports blank.

Does not display.

c2fundSource2This field reports blank.

Does not display.

c2percentSource2This field reports blank.

Does not display.

c2fundSource3This field reports blank.

Does not display.

c2percentSource3This field reports blank.

Does not display.

c2fundSource4This field reports blank.

Does not display.

c2percentSource4This field reports blank.

Does not display.

 contractType3 

Reports the third Contract Type entered for the staff of record.


Alphanumeric, 2 characters

Census > People > District Employment > Contract Type


EmploymentAssignment.contractType

 baseSalary3 

The base salary on contract 3, if any, rounded to the nearest dollar.
This field reports blank.

Does not display.

 contractDays3 

The base salary on contract 3, if any, rounded to the nearest dollar.
This field reports blank.

Does not display.

 contractHours3 

The total hours contracted in contract 3, if any.
This field reports blank.

Does not display.

 contractFTE3 

The full time equivalent for contract 3, if any.
This field reports blank.

Does not display.

c3fundSource1This field reports blank.

Does not display.

c3percentSource1This field reports blank.

Does not display.

c3fundSource2This field reports blank.

Does not display.

c3percentSource2This field reports blank.

Does not display.

c3fundSource3This field reports blank.

Does not display.

c3percentSource3This field reports blank.

Does not display.

c3fundSource4This field reports blank.

Does not display.

c3percentSource4This field reports blank.

Does not display.

 extraPay1 

The code for the special or supplemental duties performed which are not in the base pay.
This field reports blank.

Does not display.

 extraPay2 

The code for the special or supplemental duties performed which are not in the base pay.
This field reports blank.

Does not display.

 extraPayAmount2 

The amount of extra pay received rounded to the nearest dollar.
This field reports blank.

Does not display.

 extraPay3 

The code for the special or supplemental duties performed which are not in the base pay.
This field reports blank.

Does not display.

 extraPayAmount3 

The amount of extra pay received rounded to the nearest dollar.
This field reports blank.

Does not display.

 extraPay4 

The amount of extra pay received rounded to the nearest dollar.
This field reports blank.

Does not display.

 extraPayAmount4 

The code for the special or supplemental duties performed which are not in the base pay.
This field reports blank.

Does not display.

ncfundSource1This field reports blank.

Does not display.

ncpercentSource1This field reports blank.

Does not display.

ncfundSource2This field reports blank.

Does not display.

ncpercentSource2This field reports blank.

Does not display.

ncfundSource3This field reports blank.

Does not display.

ncpercentSource3This field reports blank.

Does not display.

ncfundSource4This field reports blank.

Does not display.

ncpercentSource4This field reports blank.

Does not display.

terminationDate

The month, day, and year that the employee became or will become inactive or terminated.

Reports District Employment End Date if the date falls within the extract Date Range.

If a Previous Submission Date is entered and the District Employment End Date falls between the Last Submission Date and the Start Date of the date range, reports the End Date. 

To report the Teacher of Record as on leave, staff must:

  • Have an active District Employment where the Exit Date is Null and an Exit Reason of 11, 12, 13, or 14.
  • Be assigned as a Primary Teacher on an active section with at least one student rostered during the extract date range. The active District Assignment marked as Teacher must be selected on the Staff History tab. There must be another Teacher present on the Staff History tab with their active District Assignment selected with a Role of L: Long Term Substitute and a Start Date.

If the above is true, reports the first instructional calendar day prior to the Start Date of the Role L Staff History record in the Primary Teacher's record.

Otherwise reports as blank.


Date Field, 10 characters, MM/DD/YYYY

Census > District Employment > End Date


Employment.endDate

terminationReason

The reason an employee reported last year is not reported this year.
See the Staff Exit Reason Code List following this table.

Reports District Employment Staff Exit Reason.


Alphanumeric, 2 characters

Census > District Employment > Staff Exit Reason


Employment.exitReason

 notes 

Any comments or explanatory notes for the data in this record.
This field reports blank.


Alphanumeric, 250 characters

Does not display.

Credential Code List

Code

Name

Value reported

HS

High School Diploma

HS

GED

GED or Equivalent

G

A

Associates

A

AA

Associate of Arts (A.A.)

A

AS

Associate of Science (A.S.)

A

AAS

Associate of Applied Science (A.A.S.)

A

B

Bachelors

B

BA

Bachelor of Arts (B.A.)

BA

BS

Bachelor of Science (B.S.)

BS

BFA

Bachelor of Fine Arts (B.F.A.)

B

BBA

Bachelor of Business Administration (B.B.A.)

B

BED

Bachelor of Education (B.Ed)

B

M

Masters

M

MA

Master of Arts (M.A.)

MA

MS

Master of Science (M.S.)

MS

MED

Master of Education (M. Ed.)

M

MBA

Master of Business Administration (MBA)

M

EDD

Educational Doctorate (Ed.D)

ES

EDS

Educational Specialist (Ed.S)

ES

PHD

Doctor of Philosophy (Ph.D)

DR

MD

Doctor of Medicine (MD)

DR

PSD

Doctor of Psychology (Psy.D)

DR

Institution Code List

Code

Name

045

Albion or Southern College of Idaho

010

Boise State University

060BYU-Idaho
055BYU - Utah
020College of Idaho
085College of Southern Idaho
023College of St. Gertrude
082Eastern Idaho Technical College
000General Category - Out-of-State
065Gooding College
030Idaho State University
075ISU/UI At University Place - Idaho Falls
035Lewis-Clark State College
080Magic Valley Christian College
040North Idaho College
050Northwest Nazarene College
090Other Idaho College or University
070 University of Idaho

Staff Exit Reason Code List

Code

Name

01

To work for another educational institution in ID

02

To work for another educational institution outside ID

03

Leaving the education profession

04

Returning to school

05

Spouse transferred

06

Retirement

07

Death

08

Reduction in force

09

Personal reasons

10

Involuntary termination

11

Leave of absence

12

Parental/Family obligation

13

Service in foreign country

14

Military

15

Contractor no longer paid on district payroll

16

Early retirement incentive prog (IC 33-1004G only)

17

Certificated to non-certificated

18

Non-certificated to Certificated

Save

Save

Save