Direct CertificationLearning Support : Minnesota Department of Education

Direct Certification

Direct Certification Data File Format


PDF Document Word Document

Electronic Certification Data File Format

Fixed Field

FIELD

FIELD NAME

TYPE

WIDTH

VALUE

1

SUB_CDE

Character

1

F for FALL

2

SCH_YER

Character

2

SCHOOL YEAR (FISCAL)

3

STU_NUM

Character

13

STUDENT NUMBER

4

DST_NUM

Numeric

4

DISTRICT NUMBER

5

DST_TYE

Numeric

2

DISTRICT TYPE

6

SCH_NUM

Numeric

3

SCHOOL NUMBER

7

SS_NUM_A

Character

9

SOCIAL SECURITY NUMBER

8

GRD_LVL

Character

2

GRADE LEVEL

9

SEX_GEN_A

Character

1

SEX/GENDER

10

BTH_DAT_A

Numeric

8

BIRTH DATE (YYYYMMDD)

11

STU_NAM

Character

40

STUDENT NAME

12

LOCUSE_DAT

Character

10

LOCAL USE DATA

13

METHOD

Character

2

MATCHING METHOD

14

SS_NUM_B

Character

9

DHS SOCIAL SECURITY NUMBER

15

BTH_DAT_B

Numeric

8

DHS BIRTH DATE (YYYYMMDD)

16

CASE_NBR

Numeric

8

DHS CASE NUMBER

17

COUNTY

Character

2

COUNTY

18

VLAST

Character

25

DHS LAST NAME

19

VFIRST

Character

12

DHS FIRST NAME

20

VMIDDLE

Character

1

DHS MIDDLE INITIAL

21

SEX_GEN_B

Character

1

DHS SEX/GENDER

22

STREET_ONE

Character

22

APPLICANT STREET ADDRESS

23

CITY

Character

15

APPLICANT CITY

24

STATE

Character

2

Applicant STATE (blank if not MN)

25

ZIP

Character

9

Applicant ZIP+4 (blank if not MN)

26

APPL_NAME

Character

25

APPLICANT NAME

TOTAL 236