Student Contact Address Record (FG) (Ohio Extracts)

The Student Contact Address Record (FG) reports the addresses of student's contacts from Census.


Image 1: Ohio Student Contact Address Record (FG)

Report Logic

  • Reports data from the primary household of students enrolled in the selected calendar(s).
    • To be included in the extract, enrollments must have a Service Type of P or N.
    • A record reports for each unique combination of an enrollment record and a household address within the extract date range.
  • Relationship contacts must be mapped to a State Definition and have an Emergency Priority entered to report. (System Administration > Data Defining Tools > Code Defining)
  • If more than one address displays, reports the address with the most recent Start Date.

Generating the Extract

  1. Select Student Contact Address Record (FG) as the Extract Type.
  2. Select the Reporting Period to indicate when the report is being submitted.
  3. Enter a Date Range in mmddyyyy format or by clicking the calendar icons and selecting dates.
  4. Select the Format in which the report should generate. Options are State Format (Fixed width), HTML, and CSV. Use HTML or CSV or XML formats for data review and verification and State Format for submission to the State.
  5. Indicate which Calendar(s) should appear in the report. Student enrollments in the selected calendar(s) report.
  6. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time (after Campus.1921), requests can only be submitted to the Batch Queue.

Users have the option of submitting a 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.


Image 2: Student Contact Address Record (FG) - State Format


Image 3: Student Contact Address Record (FG) - HTML Format


Image 4: Student Contact Address Record (FG) - CSV Format

Extract Layout

Element Name

Description & Format

Campus Location

Filler

N/A

N/A

Sort Type

Reports as FG for this extract.

N/A

Filler

N/A

N/A

Fiscal Year

The end year of the reporting school year.


Date field, 4 digits, YYYY

System Administration > Calendar > School Year > End Year


Calendar.endYear

Reporting Period

The Reporting Period selected in the extract editor.


Alphanumeric, 1 character

OH State Reporting > OH Extracts > Student Standing (FG) > Reporting Period


Not dynamically stored

LEA IRN

The state-assigned information retrieval number (IRN) of the district.


Numeric, 6 characters

System Administration > Resources > District Information > State District Number


District.number

EMIS Student ID Number

The locally determined EMIS student ID, zero padded if necessary.


Alphanumeric, 9 characters

Census > People > Demographics > Person Identifiers > Local Student Number


Person.studentNumber

Contact Sequence Order NumberThe sequence number of this contact which determines the order in which this contact is contacted.

Numeric, 2 digits
Census > People > Relationships > Emergency Priority

RelatedPair.seq
Address TypeThe code representing the type of the address. If mailing is selected in the household relationship or on the primary address of the primary household, reports as 0123. Otherwise reports as 0765.

Numeric, 4 digits
Census > People > Relationships > Mailing; Census > Households > Addresses > Mailing

RelatedPair.mailing

HouseholdLocation.mailing

Address Line 1The first line of the contact's address.

Alphanumeric, 60 characters
Census > Addresses > Address Info > Number, Prefix, Street, Tag, Direction, Apt

Address.prefix, .street, .tag, .dir, .apt
Address Line 2The second line of the contact's address. Currently reports as blank.

Alphanumeric, 60 characters
N/A
CityThe city of the contact's address.

Alphanumeric, 30 characters
Census > Addresses > Address Info > City

Address.city
County CodeThe code for the county of the contact's address.

Alphanumeric, 2 characters
Census > Addresses > Address Info > County

Address.county
State Province CodeThe state of the contact's address.

Alphanumeric, 2 characters
Census > Addresses > Address Info > State

Address.state
Postal CodeThe zip code of the contact's address. Reports the dash if the full

Alphanumeric, 11 characters
Census > Addresses > Address Info > Zip

Address.zip
Country CodeThe country of the contact's address.

Alphanumeric, 2 characters
Census > Addresses > Address Info > State

Address.state

Effective Start Date

Reports the Start Date of the address.


Date field, 8 characters, YYYYMMDD

Census > Households > Address > Start Date

HosueholdLocation.startDate