CALPADS Student Information (SINF) [.2144 - .2223]

Classic View: CA State Reporting > CALPADS Student Information

Search Terms: CALPADS Student Information

The CALPADS Student Information File is used to submit demographic, grade level, EL, immigrant status, and address data information on a student or to manage changes to this data. This record uses the Effective Date processing method, meaning, when there is previous data for the student, CALPADS establishes an end date that is one day prior to the new start date.

This extract should be submitted after a new student is assigned an SSID and any time student data should be updated in the CALPADS database. This record is required in the Fall 1 collection.

CALPADS Student Information

Best Practice for generating this extract is to maintain student data in the CALPADS database on an ongoing basis. Enter a Reporting Date and a Previous Submission Date to select students who have changes during this date range.

For example, running the report as Record Type SINF and entering 11/01/CCYY as the Reporting Date and 10/1/CCYY as the Previous Submission Date allows all students who have an Enrollment Start Date between 10/02/CCYY and 11/01/CCYY to report with their Enrollment Start Date as the Effective Start Date in the extract. This serves to enter demographic information on new students as well as updating Grade Level data for any students who may have been promoted mid-year.

Report Logic

All students actively enrolled on the Reporting Date are reported, unless the Previous Submission Date is also chosen (see next paragraph). Only one record reports, no matter how many enrollments a student may have, unless the Include All Identities checkbox is marked. In that case, all instances of a student's identity are included in the report when the student is actively enrolled between the Previous Submission Date and the Reporting Date.

When the Previous Submission Date is also entered, only students who have data changes between the Previous Submission Date and the Reporting Date are included in the report. 

The Effective Start Date is used to populate field 4, Effective Start Date. This date can be before the Reporting Date. When a date is entered in this field, it populates every record in the submission. When the Effective Start Date is before the Start Date of the enrollment that is active on the Report Date, the Enrollment Start Date reports.

When a value is not entered in the Effective Start Date, the Enrollment Start Date reports as the Effective Start Date.

The Effective End Date is used to populate field 5, Effective End Date, unless the student has exited since the reporting date. See the description of the Effective End Date in the Data Elements Table for the logic in that situation. This date does not usually need to be entered.

Students do not report when:

  • They are not enrolled on the Reporting Date.
  • Their enrollment record has a Service Type of N.
  • Their enrollment record is marked as No Show or as State Exclude.
  • The grade level of enrollment is marked as State Exclude.
  • The calendar of enrollment is marked as State Exclude.

All enrollment-related data reports from the enrollment that is active on the Reporting Date.

Address Logic Used in Student Enrollment File

The student's residential address reports. When there is only one address for the student, this is the residential address. When the address is marked as mailing and there is another active address that is not marked as mailing, the address not marked as mailing reports.

Operational Key

  • SSID (Field 9)

CAASPP Address Decision Table and Logic

 When the CAASPP Address checkbox is marked, only the primary household's mailing address reports when the student has both a primary and secondary household that both have mailing addresses. This applies to the following fields:

  • Residential Address Line 2
  • Residential City
  • Residential State
  • Residential Zip

When the Primary Address is NOT active at the time of generating this report (the address has an end date prior to the reporting date entered on the report editor, or the end date is prior to the effective date in the date range entered on the report editor), the Secondary Household Primary Address reports.

In addition:

  • When the student has multiple addresses and none are marked as mailing, the newest address reports.
  • When the student has multiple addresses marked as mailing in one household, the most recent address reports.
  • When the student has multiple addresses marked as mailing in multiple households, the most recent address from the household not marked as Secondary reports.
  • When the student has multiple addresses marked as mailing in multiple households and neither is marked as secondary,  the most recent address of all addresses in the households reports.

The following table defines what address reports when a student is in two households both with mailing addresses.

Address ScenarioPrimary Household Mailing AddressSecondary Household Mailing AddressNo Mailing AddressMultiple Mailing AddressesPO Box
One Primary HouseholdReportsDoes not reportReports the newest address.Reports the newest mailing address.When CAASPP is not marked, the PO Box reports.
One Primary Household, One Secondary HouseholdReportsDoes not reportReports the newest address for the primary household.Reports the newest mailing address for the primary household.When CAASPP is not marked, the PO Box reports for the primary household.
One Secondary household, One Primary Household with end date within the date rangeDoes not reportReportsReports the newest address for the secondary household.Reports the newest mailing address for the secondary household.When CAASPP is not marked and the PO Box exists on the secondary household without an end date, the PO Box reports.
One Secondary Household, One Primary Household with an end date BEFORE the date rangeDoes not reportReportsReports the newest address for the secondary household.Reports the newest mailing address for the secondary household.When CAASPP is not marked and the PO Box exists on the secondary household without an end date, the PO Box reports.
One Secondary Household, One Primary Household with an end date AFTER the date rangeReportsDoes not reportReports the new address for the primary household.Reports the newest mailing address for the primary household.When CAASPP is not marked, the PO Box reports.
One Household with two addresses, one marked as PrimaryReportsDoes not reportN/AN/AWhen CAASPP is not marked, the PO Box reports.
Two Households with multiple addresses marked as mailingReports the address with the newest start date that does not have an end date and is marked as mailing.Does not reportN/AReports the address with the newest start date that does not have an end date and is marked as mailing.When CAASPP is not marked, the PO Box reports.

Non-Binary Gender Reporting

Schools can assign students a gender of M: Male, F: Female, X: Non-binary. This is done on the Identities tool and/or the Demographics tool. 

CALPADS Extracts use the Legal Gender field included in the Protected Identity Information to report student and staff identity information.

To record a gender of X: Non-binary, on the Identities tool:

  1. Assign the Gender of X: Non-Binary in the standard identify fields.
  2. Assign the Protected Identity Information Legal Gender of M: Male, F: Female, or X: Non-binary.
  3. Save the record when finished.

Screenshot of the Gender and Legal Gender fields for California. Gender and Legal Gender Assignment

Report Editor

Field

Description

Reporting Date

Indicates the date of the report. This field displays the current date and includes all students enrolled on this date unless a previous submission date is entered.

Previous Submission Date

Date the file was previously submitted. When entered, only students who have a data change since this date report, based on the record type.

Include All Identities
Allows every instance of a student's Identity records to be included in the report. Multiple identities report as separate records for the student between the Previous Submitted Date and the entered Reporting Date.

When marked, the student's Enrollment Start Date is used as the Effective Start Date.

This checkbox is automatically marked. If only one instance of the student's identity records (the most current record) should be included in the extract, remove the checkbox.

Effective Start Date

A date entered in this field populates the Effective Start Date field on the extract. This field is normally left blank for ongoing submissions, which allows the appropriate start date (depending on the record type) to populate the extract field.


This date CANNOT be earlier than the date entered in the Previous Submission Date field. If there is no date entered in the  Previous Submission Date field, this date CANNOT be earlier than the start date of the school year.


A date entered in this field is reported, unless the student's Enrollment Start Date is later than the Effective Start Date, in which case the Enrollment Start Date reports.

  • For SINF, the most recent enrollment start date that is after the Previous Submission Date reports.
  • For SIAD, the most recent enrollment start date or address start data that is after the Previous Submission Date reports. When there is more than one of these start dates, the most recent date reports, but not when it's after the Reporting Date.

This field does not display when the Include All Identities checkbox is marked.

Effective End Date

A date entered in this field populates the Effective End Date field in the extract. This field is normally left blank, which allows the appropriate End Date (depending on the Record Type) to populate the extract field when necessary.


This field does not display when the Include All Identities checkbox is marked.

Transaction Type

Indicates the type of transaction that occurs - Add/Update or Delete.

Format

Determines how the report generates. Select State Format (Caret Delimited) when submitting records to the state. Other formats available for testing and review purposes are CSV and HTML.

Ad hoc Filter

Select which students to include in the extract by choosing a filter that was created in the Filter Designer.

Calendar Selection

Select the calendar of enrollment from which to pull student data. Calendars can be chosen by the active year, by the school name or by the year.

Report Generation Options

Choose the Generate Extract to display the results of the chosen items immediately. Choose the Submit to Batch option to generate the report at a specified time. This option is helpful when generating large amounts of data.

Generate the Extract

  1. Enter the Reporting Date in mmddyy format, or use the calendar icon to select a date.
  2. Enter the Previous Submission Date in mmddyy format, or use the calendar icon to select a date.
  3. Verify the Include All Identities checkbox is marked to report all instances of a student's identity. If only one record should be included, remove the checkbox.
  4. When the Include All Identities checkbox is NOT marked, enter the Effective Start Date in mmddyy format, or use the calendar icon to select a date only when all records should have the same Effective Start Date.
  5. When the Include All Identities checkbox is NOT marked, enter the Effective End Date in mmddyy format, or use the calendar icon to select a date only when all records should have the same Effective End Date. Ordinarily, a date should not be entered in this field.
  6. Select the Transaction Type from the dropdown list - Add/Update or Delete.
  7. Select the Format of the file.
  8. Use the Ad hoc Filter to select students already included in a filter. This is not required. When not chosen, all students who have the appropriate enrollment start or end status during the entered date range are included.
  9. Select the Calendars to include in the file.
  10. Click the Generate Extract button. Or generate the extract at a specified time using the Submit to Batch button. The file appears in a new window in the selected format.

Student Information File Layout

X indicates a required field.

Elements

Description

Location

Record Type Code
(X)

Type of data record being submitted as chosen on the Extract Editor. SINF is the default.

  • Reports as SINF.txt for the State Format
  • Reports as SINF.csv for the CSV Format

Alphanumeric, 4 characters

Not dynamically stored

Transaction Type Code

Action the state should take with this record as chosen on the Extract Editor. Add/Update is the default.

  • D = Delete
  • R = Replace
  • Blank or no transaction type = Add/Update

Alphanumeric, 1 character

Not dynamically stored

Local Record ID

 N/A

N/A

Effective Start Date
(X)

When an Effective Start Date is entered in the editor, that date reports.

  • UNLESS the Enrollment Start Date from the enrollment active on the Reporting Date is later. Then the enrollment start date reports.

When the Effective Start Date is not entered, the reported date is based on the Record Type code.

  • SINF: the most recent Enrollment Start Date that is after the Previous Submission Date. 
  • SIAD: Reports the most recent Enrollment Start Date or Address Start Date that is after the Previous Submission Date. When there is more than one of these Start Dates, report the most recent (but not when it's after the Reporting Date).

Date field, 8 characters (CCYYMMDD)

Student Information > General > Enrollments > Start Date 


Enrollment.startDate


Student Information > Program Participation > English Learners (EL) > Identified Date or Program Exit Date.


lep.identifiedDate lep.programExitDate

Effective End Date

The month, day and year on which the data within the record stops being effective/current.

The Effective End Date selected in the editor is reported unless the student has an enrollment end date and the end status is not blank, 440 or E490 in the enrollment record that was active on the report date. In that case, the earlier of the two dates is reported.

When no date is chosen, this field is blank unless the student has an enrollment end date/status as described above.


Date field, 8 characters (CCYYMMDD)

Student Information > General > Enrollments > End Date


Enrollment.endDate

Reporting LEA
(X)

A unique identifier for the educational service institution responsible for obtaining and maintaining a student’s Statewide Student Identifier by way of an enrollment record in CALPADS.


When the reporting calendar is from a School with Type = 15: Independently Reporting Charter, the State School Number reports (not the State District Number).


This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number.


Numeric, 7 digits

System Administration > Resources > District Information > State District Number


District.number


System Administration > Resources > School > School Number


School.number


System Administration > Resources > School > Type


School.type

School of Attendance

A unique identifier for the school that delivers a majority of educational instruction and services and is where the student attends. A District-level school entity should use the State District Number for the State School Number.


When the CDS Number is populated on the School editor, that value reports.


Numeric, 7 digits

System Administration > Resources > School > State School Number


School.Number


System Administration > Resources > School > CDS Number

Academic Year ID
(X)

A unique identifier assigned to a specific Academic Year. An Academic Year is the period during which school is in regular session and provides a required number of days of instruction.


Date field, 9 characters (CCYY-CCYY)

System Administration > Calendar > School Years > Start Year/End Year


Calendar.schoolYear

SSID
(X)

The unique identifier for the student assigned to or by the first California district in which the student is enrolled in accordance with CDE established standards. This number follows the student from school to school throughout his/her K-12 career.


Alphanumeric, 10 characters

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

Local Student ID
(X)

A unique identifier assigned to the student by a local educational agency. This may not necessarily be the same as the identifier assigned to the student at the school level.


Alphanumeric, up to 15 characters

Census > People > Demographics > Person Identifiers > Student Number


Person.studentNumber

Legal First Name
(X)

Reports the student's Legal first name of the student when that field is populated on the Identities record.


When the Legal First Name field is not populated, information reports from the First Name field on the Demographics record.


This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 30 characters

Census > People > Demographics > Person Identifiers > First Name


Identity.firstName


Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName

Legal Middle Name

Reports Legal Middle name of the student when the Legal Middle Name field is populated on the Identities record.


When the Legal Middle Name field is not populated, information reports from the Middle Name field on the Demographics record.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 30 characters

Census > People > Demographics > Person Identifiers > Middle Name


Identity.middleName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName

Legal Last Name
(X)

Reports the Legal Last Name of the student.


When the Legal Last Name field is populated, information reports from that field.


When the Legal Last Name field is not populated, information reports from the Last Name field on the Demographics record.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 50 characters

Census > People > Demographics > Person Identifiers > Last Name


Identity.lastName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName

Suffix

Legal abbreviation following person’s name containing information specific to that person (i.e., Sr, Jr etc.).


Alphanumeric, 3 characters

Census > People > Demographics > Person Identifiers > Suffix


Identity.suffix

Alias First Name

Alternative first name given to the student reported from a previous identity.


When the Legal First Name field is populated on the earlier identity, information reports from that field.


When the Alias First Name, Alias Middle Name and Alias Last Name is the same as the Legal First Name, Legal Middle Name, and Legal Last Name, this field reports blank.


This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 30 characters

Census > People > Demographics > Person Identifiers > First Name


Identity.firstName


Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName

Alias Middle Name

Alternative middle name given to the student reported from a previous identity.


When the Legal middle Name field is populated on the earlier identity, information reports from that field.


When the Alias First Name, Alias Middle Name and Alias Last Name is the same as the Legal First Name, Legal Middle Name, and Legal Last Name, this field reports blank.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 30 characters

Census > People > Demographics > Person Identifiers > Middle Name


Identity.middleName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName

Alias Last Name

Alternative last name given to the student reported from a previous identity.


When the Legal Last Name field is populated on the earlier identity, information reports from that field.


When the Alias First Name, Alias Middle Name and Alias Last Name is the same as the Legal First Name, Legal Middle Name, and Legal Last Name, this field reports blank.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 50 characters

Census > People > Demographics > Person Identifiers > Last Name


Identity.lastName


Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName

Birth Date
(X)

The month, day and year on which a person was born based on the Gregorian Calendar.


Date field, 8 characters (CCYYMMDD)

Census > People > Demographics > Person Identifiers > Birth Date


Identity.birthDate

Gender
(X)

Student’s designated gender.


When the Legal Gender field is populated, information reports from that field.


See the Non-Binary Gender Reporting section for additional information.


Alphanumeric, 1 character (M or F)

Census > People > Demographics > Person Identifiers > Gender


Identity.gender


Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender


Identity.legalGender

Birth City

Formal name of the city or town in which a person was born.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


Alphanumeric, 30 characters

Census > People > Demographics > Person Information > Birth City


Identity.birthCity

Birth State

The state/province where an individual was born.


XX = country code (US, MX, etc.)
YYY = state or province (CA, OR, etc.)


Alphanumeric, 6 characters (XX-YY or XX-YYY)

Census > People > Demographics > Person Information > Birth State


Identity.birthState

Birth Country
(X)

A coded value representing the country where an individual was born. 


Reports the default value on the attribute when the student does not have a value entered or reports "US" when the student does not have a value entered AND there is no default value on the attribute.


Alphanumeric, 2 characters (XX-YY or XX-YYY)

Census > People > Demographics > Person Information > Birth Country


Identity.birthCountry

Hispanic Ethnicity

An indication of whether a student identifies as having a Hispanic ethnicity

  • Reports a value of Y when Is the individual Hispanic/Latino? is set to Yes. 
  • Reports a value of N when Is the individual Hispanic/Latino? is set to No.
  • Reports a blank value when Is the individual Hispanic/Latino? is not populated (null) OR the Race/Ethnicity Determination is 05 (Intentionally Blank).

Alphanumeric, 1 character (Y/N/Blank )

Census > Demographics > Person Information > Is the individual Hispanic/Latino?


Identity.hispanicEthnicity

Missing Ethnicity Indicator

An indication of whether or not the student’s Ethnicity has intentionally been left blank.

  • Reports a value of Y when Is the Individual Hispanic/Latino is blank (null) or the Race/Ethnicity Determination is 05 (Intentionally Blank).
  • Otherwise, reports a value of N.

Alphanumeric, 1 character
Y/N

Census > Demographics > Person Information > Race/Ethnicity Determination


Identity.raceEthnicityDetermination

Race Code 1

A coded value representing a person’s Race Category. The first race selected for the student.


Numeric, 3 digits or blank

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Race Code 2

A coded value representing a person’s Race Category.The second race selected for the student.


Numeric, 3 digits or blank

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Race Code 3

A coded value representing a person’s Race Category. The third race selected for the student.


Numeric, 3 digits or blank

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Race Code 4

A coded value representing a person’s Race Category. The fourth race selected for the student.


Numeric, 3 digits or blank

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Race Code 5

A coded value representing a person’s Race Category. The fifth race selected for the student.


Numeric, 3 digits or blank

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Race Missing Indicator

An indication of whether or not the student’s Ethnicity has intentionally been left blank.

Y reports when no race check boxes are marked. Otherwise, N reports.


Alphanumeric, 1 character
Y/N

Census > Demographics > Person Information > Race checkbox


Identity.caRace

Residential Address Line 1
(X)

The address where an individual either receives mail or resides. See the Address Logic section for more information. 


An Address Number is not required.


Alphanumeric, 60 characters

Census > Address > Address Information > Number, Prefix, Street, Tag, Direction, Apt


Address.Number
Address.Prefix
Address.Street
Address.Tag
Address.Direction
Address.Apt

Residential Address Line 2

Reports address overflow reported in Residential Address Line 1 field.


See the Report Logic section for more information.


Alphanumeric, 60 characters

Census > Address > Address Information > Number, Prefix, Street, Tag, Direction, Apt


Address.Number
Address.Prefix
Address.Street
Address.Tag
Address.Direction
Address.Apt

Residential City
(X)

The formal name of the city or town where mail is sent or received.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes

See the Report Logic section for more information.


Alphanumeric, 30 characters

Census > Address > Address Information > City


Address.City

Residential State
(X)

A coded value representing the abbreviation for a State/Province in an address.


See the Report Logic section for more information.


Alphanumeric, 4 characters (US-XX)

Census > Address > Address Information > State


Address.State

Residential Zip
(X)

The ZIP code used for the location where mail is sent or received, inclusive of the four-digit ZIP code extension.


See the Report Logic section for more information.


Numeric, 10 digits (XXXXX or XXXXX-XXXX)

Census > Address > Address Information > Zip


Address.Zip

Initial US School Enrollment Date

The date of the student’s first enrollment in a kindergarten through 12th grade public or private school in the US, including its territories.This field is required when the student's Birth Country is not US or PR or when the student's English Proficiency is EL.


Date field, 8 characters (CCYYMMDD)

Census > People > Demographics > Person Information > Date Entered US School


Identity.dateEnteredUSSchool

Enrolled less than three years

An indication of whether or not a student has been enrolled in a US school for less than three cumulative years.


This is calculated using the Start Date in the Early Learning editor. When the Early Learning Start Date is blank, this is calculated using the Date Entered US School. When multiple Early Learning records exists this is calculated using the earliest start date among the existing records. 

  • This reports as Y when the First US Enroll Date is less than three years before the Reporting Date.
  • This reports Y when the EL Enrolled Less Than 3 Years field is marked even when First US Enroll Date is more than three years before the Reporting Date of the extract.
  • Otherwise, it reports as N.
  • Students with no First US Enroll Date entered report blank.
    This field is required when the student's Birth Country is not US or PR.
  • This reports as Y when the Schooling in US check box is marked regardless of the dates listed in Kindergarten Enrollment or the Early Learning Start Date. 

Alphanumeric, 1 character (Y or N)

Census > People > Demographics > EL enrolled less than 3 years



Identity.schoolingUS


Student Information > Program Participation > Early Learning > Start Date

Guardian Highest Education
(X)

Coded value representing the highest educational level of the parent/guardian.


When the field is not populated on the student's Demographics record, then the selection made on the guardian's demographics tabs is used. When neither education level is selected, this field reports blank.


When the field is populated for one guardian, but not the other, and the field is blank on the student's Demographics record, the value reported for the one guardian reports.


This field reports blank when the field is blank for all guardians and the student.


When a guardian is marked as such as a non-household relationship, that person's Parent Ed value factors into the calculation to determine the highest ED level.


Numeric, 2 digits

Census > People > Demographics > Person Information > Education Level (for parent)


Identity.educationlevel

Guardian 1 First Name

First name of the first parent/guardian contact listed for the student.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


When a guardian's first name is longer than 30 characters, the name up and including the 30th character prints. Any characters thereafter do not print.


Alphanumeric, 30 characters

Census > People > Relationships > Guardian


Identity.firstName

Guardian 1 Last Name

The last name of the first Parent/Guardian contact listed for a student.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


When a guardian's last name is longer than 50 characters, the name up and including the 50th character prints. Any characters thereafter do not print.


Alphanumeric, 50 characters

Census > People > Relationships > Guardian


Identity.lastName

Guardian 2 First Name

The first name of the second Parent/Guardian contact listed for a student.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


When a guardian's first name is longer than 30 characters, the name up and including the 30th character prints. Any characters thereafter do not print.


Alphanumeric, 30 characters

Census > People > Relationships > Guardian


Identity.firstName

Guardian 2 Last Name

The first name of the second Parent/Guardian contact listed for a student.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


When a guardian's last name is longer than 50 characters, the name up and including the 50th character prints. Any characters thereafter do not print.


Alphanumeric, 50 characters

Census > People > Relationships > Guardian


Identity.lastName

Student Preferred First NameReports the student's First Name form the Demographics field when the Legal First Name field is populated on the Identities record.

This only reports when both the Legal First Name and Legal Last Name fields are populated on the Identities record.

Alphanumeric, 50 characters

Census > People > Demographics > Person Identifiers > First Name


Identity.firstName


Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName

Student Preferred Last NameReports the student's Last Name form the Demographics field when the Legal LastName field is populated on the Identities record.

This only reports when both the Legal First Name and Legal Last Name fields are populated on the Identities record.

Alphanumeric, 50 characters

Census > People > Demographics > Person Identifiers > Last Name


Identity.lastName



Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName

Mailing Address 1Reports the student's active Number and Street information from the Household that is active on the entered Reporting Date (a household with a start date prior to the reporting date or a household with no start date is considered active).

If the household has multiple addresses marked as Mailing, the address marked as Secondary or PO Box reports.

If the primary household has a single address, logic looks for a secondary household and reports the address form that household.

Alphanumeric, 60 characters

Census > Households > Addresses > Household Location Editor > Address


Address.number
Address.prefix
Address.street
Address.tag
Address.direction
Address.apt


Mailing Address 2

Reports address overflow reported in Residential Address Line 1 field.


See the Report Logic section for more information.


Alphanumeric, 60 characters

Census > Households > Addresses > Household Location Editor > Address


Address.number
Address.prefix
Address.street
Address.tag
Address.direction
Address.apt

Mailing Address City

The formal name of the city or town where mail is sent or received.

This field may only include alphabetic letters, numbers, periods, hyphens and apostrophes.


See the Report Logic section for more information.


Alphanumeric, 30 characters

Census > Households > Addresses > Household Location Editor > Address


Address.city


Mailing Address State

A coded value representing the abbreviation for a State/Province in an address.


See the Report Logic section for more information.


Alphanumeric, 4 characters (US-XX)

Census > Households > Addresses > Household Location Editor > Address


Address.state


Mailing Address Zip

The ZIP code used for the location where mail is sent or received, inclusive of the four-digit ZIP code extension.


See the Report Logic section for more information.


Numeric, 10 digits (XXXXX or XXXXX-XXXX)

Census > Households > Addresses > Household Location Editor > Address


Address.zip