Enrollment Reporting Knowledge Base

Electronic Data Interchange (EDI) File Mapping

Contents

    Return to File Formats & Field Values

    Note: Download EDI File Mapping for Data Elements for details on mapping A3 data elements to Excel/text file fields.

    The tables below outline how EDI file fields map to Excel/text file fields.

    Header Record

    Excel/Text FieldEDI Field(s)
    Record TypeN/A
    School CodeENT03, ENT04, ENT05
    Branch CodeENT03, ENT04, ENT05
    Academic TermENT08, ENT09
    Compulsory Term FlagENR11
    Certification DateENR12, ENR13
    FillerN/A

    Detail Records

    Excel/Text FieldEDI Field(s)
    Record TypeN/A
    Student SSNENT03, ENT04
    First NameIN201, IN202
    Middle InitialIN201, IN202
    Last NameIN201, IN202
    Name SuffixIN201, IN202
    Previous SSNENT06, ENT07
    Previous Last NameIN201, IN202
    Enrollment Status (campus-level)ENR01
    Status Start DateDTP01, DTP02, DTP03
    Street Line 1N301
    Street Line 2N302
    CityN401
    StateN402
    CountryN404
    Anticipated Graduation DateENR03, ENR04
    Birth DateDMG01, DMG02
    Term Begin DateDTP01, DTP02, DTP03
    Term End DateDTP01, DTP02, DTP03
    FillerN/A
    Directory Block IndicatorENR10
    NCES CIP Code for Major 1FOS01, FOS02, FOS03
    NCES CIP Code for Major 2FOS01, FOS02, FOS03
    Major Course of Study 1FOS04
    Major Course of Study 2FOS04
    ClassSES10
    First Time Full TimeENR19
    Degree SeekingENR09
    High School CodeENT01, ENT02, ENT03, ENT04 (Loop 4)
    GenderDMG03
    Race/EthnicityDMG05
    College Student IDENT01, ENT02, ENT03, ENT04 (Loop 3)
    State Student IDENT05, ENT06, ENT07 (Loop 3)
    EmailPER01, PER03, PER04
    Good StudentENR20
    Middle NameIN201, IN202
    FillerN/A
    Veteran’s Status IndicatorNTE02
    Commit IDNTE02
    Pell Grant RecipientSUM10
    Remedial FlagSUM02
    Citizenship FlagDMG06
    Student Phone TypePER05
    Preferred Phone FlagPER09
    Student Phone Country CodePER06
    Student Phone NumberPER08
    Move To OPEIDENT04
    Program IndicatorSUM03
    Program 1 CIP CodeFOS03
    Program 1 CIP YearFOS04
    Program 1 Credential LevelSES10
    Program 1 Published Program 1 LengthFOS06
    Program 1 Published Program Length MeasurementFOS05
    Program 1 Weeks Title IV Academic YearFOS07
    Program 1 Begin DateENR04
    Program 1 Special Program IndicatorNTE02
    Program 1 Enrollment StatusENR01
    Program 1 Enrollment Status Effective DateENR13
    Program 2 CIP CodeFOS03
    Program 2 CIP YearFOS04
    Program 2 Credential LevelSES10
    Program 2 Published Program LengthFOS06
    Program 2 Published Program Length MeasurementFOS05
    Program 2 Weeks Title IV Academic YearFOS07
    Program 2 Begin DateENR04
    Program 2 Special Program IndicatorNTE02
    Program 2 Enrollment StatusENR01
    Program 2 Enrollment Status Effective DateENR13
    Program 3 CIP CodeFOS03
    Program 3 CIP YearFOS04
    Program 3 Credential LevelSES10
    Program 3 Published Program LengthFOS06
    Program 3 Published Program Length MeasurementFOS05
    Program 3 Weeks Title IV Academic YearFOS07
    Program 3 Begin DateENR04
    Program 3 Special Program IndicatorNTE02
    Program 3 Enrollment StatusENR01
    Program 3 Enrollment Status Effective DateENR13
    Program 4 CIP CodeFOS03
    Program 4 CIP YearFOS04
    Program 4 Credential LevelSES10
    Program 4 Published Program LengthFOS06
    Program 4 Published Program Length MeasurementFOS05
    Program 4 Weeks Title IV Academic YearFOS07
    Program 4 Begin DateENR04
    Program 4 Special Program IndicatorNTE02
    Program 4 Enrollment StatusENR01
    Program 4 Enrollment Status Effective DateENR13
    Program 5 CIP CodeFOS03
    Program 5 CIP YearFOS04
    Program 5 Credential LevelSES10
    Program 5 Published Program LengthFOS06
    Program 5 Published Program Length MeasurementFOS05
    Program 5 Weeks Title IV Academic YearFOS07
    Program 5 Begin DateENR04
    Program 5 Special Program IndicatorNTE02
    Program 5 Enrollment StatusENR01
    Program 5 Enrollment Status Effective DateENR13
    Program 6 CIP CodeFOS03
    Program 6 CIP YearFOS04
    Program 6 Credential LevelSES10
    Program 6 Published Program LengthFOS06
    Program 6 Published Program Length MeasurementFOS05
    Program 6 Weeks Title IV Academic YearFOS07
    Program 6 Begin DateENR04
    Program 6 Special Program IndicatorNTE02
    Program 6 Enrollment StatusENR01
    Program 6 Enrollment Status Effective DateENR13

    Trailer Record

    No Excel/text file trailer record fields are required for EDI implementation.

    Return to File Formats & Field Values

    Related Articles