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