You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Support Center > SIS Integration > Data Import: Contact File Specification from SIS to SIRAS
Data Import: Contact File Specification from SIS to SIRAS
print icon
Use this article as the optional inbound contact-file reference.
A file-based SIS integration can include contact data alongside demographics when the district wants SIS contact information to update SIRAS. For filenames, delivery, Training testing, Production approval, and automation, use File-Based SIS Integration: Implementation Guide.

Contact Field Specification

HeaderDataNotes
SSID10 digitsRequired KEY1.
LOCAL_IDStringStudent identifier used by the SIS.
STUDENT_FIRST_NAMEStringKEY2 for students without a usable SSID.
STUDENT_LAST_NAMEStringKEY2.
STUDENT_BIRTHDATEDD/MM/YYYY or YYYYMMDDKEY2.
CONTACT_FIRST_NAMEStringRequired when a combined name is not used.
CONTACT_LAST_NAMEStringRequired when a combined name is not used.
CONTACT_NAMEStringAlternate combined name when first/last cannot be separated.
CONTACT_TYPEStringGuardian, Emergency, Physician, or custom SIS descriptor.
RELATIONSHIPStringMother, Father, Grandparent, or other relationship text.
ADDRESSStringStreet address; required for a complete addressed contact.
CITYStringRequired for a complete addressed contact.
STATEStringDefaults to CA when omitted.
ZIPStringRequired for a complete addressed contact.
EMAILStringRecommended for electronic communication.
HOME_PHONEStringHome phone.
WORK_PHONEStringWork phone.
MOBILE_PHONEStringMobile phone.
PRIMARY_PHONEStringAlternative single phone field.
PRIMARY_PHONE_TYPEStringType for PRIMARY_PHONE.
MAILING_ADDRESSY, N, or blankOptional; marks contacts used for mailing/labels.
CURRENT_RESIDENCEY, N, or blankOptional; only one contact should represent the current residence.
PRIMARYY, N, or blankOptional alternative to INDEX=0.
INDEXNumberOptional ordering: 0 primary, 1 secondary, 2 tertiary.

How SIRAS Builds Contact Records

  1. Primary process: import and process all valid contact rows supplied by the SIS.
  2. Fallback process: when no valid addressed contact is found, SIRAS may construct a contact using the guardian name and residence address from the student-level demographic data.

Each file row should represent one parent, guardian, emergency contact, physician, or other communication contact for one student.

Primary, Mailing and Residence Priority

  • When no priority columns are supplied, SIRAS treats the first contact as Primary, the second as Secondary, and so on.
  • INDEX=0 identifies the Primary contact; 1 identifies Secondary; 2 identifies Tertiary.
  • PRIMARY=Y is an alternative to INDEX=0.
  • Any contact with MAILING_ADDRESS=Y may be used for mailing and labels.
  • Only one contact should have CURRENT_RESIDENCE=Y.
  • When CURRENT_RESIDENCE is omitted, the Primary contact is assumed to be the current residence.
Many SIS products do not have reliable equivalents for every priority indicator. In those cases, an intentionally ordered source file may be more accurate than populating unsupported flags.

Student Matching and Fallback Logic

  • KEY1: SSID.
  • KEY2: student first name, last name, and birthdate for younger students without an SSID.
  • Local ID can provide additional context.
  • A contact row is not processed safely when the student cannot be matched unambiguously.

When no valid addressed contact rows are found, the configured integration may use guardian and residence fields from the demographic file to create a fallback contact.

Search before creating or correcting a student manually.
A failed contact match may be caused by a transferred, inactive, duplicate, renamed, or near-matching record.

Attachments

Picture1.png
scroll to top icon