Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt

The following is the file layout for your district. See the State Direct Certification document for details on performing the DC process. 

Plug-In Name: Maryland

Match Style: State Match 

File Type: CSV

Number of Heading Lines: 0

Export Available: No

Advanced Setup Available: No

 

File Format: Fixed Length

...

Note:

...

 Not all fields are defined; only ones we are importing.

Field

...





Start Position

Length

...


Import.Birthdate

MCDateMask

Trim

Mid

(sLineOfText

14

21

"MMDDYYYY"

Import.FirstName

...


Trim

Mid

(sLineOfText

24

20

...


Import.LastName

...


Trim

Mid

(sLineOfText

44

20

...


Import.Middle

...


Trim

Mid

(sLineOfText

64

1

...


Import.Address1

Trim

Trim

Mid

(sLineOfText

65

5

& " " & Trim(Trim (Mid (sLineOfText, 70, 20)

Import.Address2

...


Trim

Mid

(sLineOfText

90

20

...


Import.City

...


Trim

Mid

(sLineOfText

110

15

...


Import.State

...


Trim

Mid

(sLineOfText

125

2

...


Import.Zip

...


Trim

Mid

(sLineOfText

127

5

...


Import.StudentSSN

...


Trim

Mid

(sLineOfText

132

9

...