Data Elements by Record Type

2004-2005 PEIMS Data Standards

Appendix B: Data Elements by Record Type

APPENDIX B

DATA ELEMENTS BY RECORD TYPE

The following pages in this section include a detailed list of the required data elements arranged by the four major data categories: organization, finance, students, and staff. Each list of data elements is a chart with the following columns:

COLUMN / EXPLANATION
GROUP / classifies each sub-category of data
TYPE OF STAFF
TYPE OF STUDENT / classifies staff
(used for staff category only)
classifies students
(used for student category only)
DATA ELEMENT NAME / lists the required data elements
DATA ELEMENT ID / lists the element reference numbers
CODE TABLE ID / lists the code table reference numbers for data elements that require a standard set of code values, such as 'M' or 'F' for sex
INPUT RECORD TYPE / lists the number of the input record type
COLUMN(S) / lists the record layout column number(s) in which PEIMS data should be entered

ORGANIZATION DATA

DISTRICT

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
IDENTIFICATION / DISTRICT-ID
DISTRICT-NAME / E0212
E0213 / -
- / 010
010 / 4 - 9
10 - 43

SHARED SERVICES ARRANGEMENT

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
IDENTIFICATION / DISTRICT-ID
SHARED-SVCS-ARRANGEMT-TYPE-CODE
FISCAL-AGENT-DISTRICT-ID / E0212
E0776
E0777 / -
C049
- / 011
011
011 / 4 - 9
10 - 11
12 - 17

CAMPUS

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
IDENTIFICATION / CAMPUS-ID
CAMPUS-NAME / E0266
E0267 / -
- / 020
020 / 4 - 12
13 - 46

DISTRICT FINANCE DATA

BUDGET

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
DETAIL / DISTRICT-ID
FUND-CODE
FUNCTION-CODE
OBJECT-CODE
ORGANIZATION-CODE
FISCAL-YEAR
PROGRAM-INTENT-CODE
BUDGET-AMOUNT / E0212
E0316
E0317
E0318
E0319
E0974
E0320
E0321 / -
C148
C146
C137
-
-
C147
- / 030
030
030
030
030
030
030
030 / 4 - 9
10 - 12
13 - 14
15 - 18
19 - 21
22
23 - 24
25 - 35

ACTUAL

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
DETAIL / DISTRICT-ID
FUND-CODE
FUNCTION-CODE
OBJECT-CODE
ORGANIZATION-CODE
FISCAL-YEAR
PROGRAM-INTENT-CODE
ACTUAL-AMOUNT / E0212
E0316
E0317
E0318
E0319
E0974
E0320
E0774 / -
C145
C146
C159
-
-
C147
- / 032
032
032
032
032
032
032
032 / 4 - 9
10 - 12
13 - 14
15 - 18
19 - 21
22
23 - 24
25 - 35

SHARED SERVICES ARRANGEMENT - ACTUAL

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
DETAIL / DISTRICT-ID / E0212 / - / 033 / 4 - 9
SHARED-SVCS-ARR-MEMBER-DIST-ID / E0981 / - / 033 / 10 - 15
SHARED-SVCS-ARRANGEMT-TYPE-CODE /
E0776 /
C049 /
033 /
16 - 17
FUND-CODE / E0316 / C160 / 033 / 18 - 20
FISCAL-YEAR / E0974 / - / 033 / 21
ACTUAL-AMOUNT / E0774 / - / 033 / 22 - 32

STAFF DATA

GROUP /
TYPE OF
STAFF / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
IDENTIFICATION/
DEMOGRAPHIC
ID NUMBER CHANGE / ALL STAFF
ALL PROFESSIONAL
STAFF
ALL STAFF
STAFF WITH A NUMBER CHANGE / DISTRICT-ID
STAFF-ID
FIRST-NAME
MIDDLE-NAME
LAST-NAME
GENERATION-CODE
SEX-CODE
ETHNICITY-CODE
TOTAL-YEARS-PROF-EXPERIENCE
HIGHEST-DEGREE-LEVEL-CODE
DEMOGRAPHIC-REVISION-CONFIRMATION-CODE
DATE-OF-BIRTH
PRIOR-ID / E0212
E0505
E0703
E0704
E0705
E0706
E0004
E0005
E0130
E0730
E0924
E0006
E0990 / -
-
-
-
-
C012
C013
C014
-
C015
C088
-
- / 040-090
040-090
040
040
040
040
040
040
040
040
043
043
045 / 4 - 9
10 - 18
19 - 35
36 - 49
50 - 74
75
76
77
78 - 79
80
25
26 - 33
19 - 27

STAFF DATA (continued)

GROUP /
TYPE OF
STAFF / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
EMPLOYMENT
PAYROLL SUMMARY / ALL STAFF
/ YEARS-EXPERIENCE-IN-DISTRICT
NUMBER-DAYS-EMPLOYED
PERCENT-DAY-EMPLOYED /
E0161
E0160
E0760 /
-
-
- /
050
050
050 /
19 - 20
21 - 23
24 - 26
PAYROLL ACCOUNTING
/ ALL STAFF
/ PAYROLL-ACTIVITY-CODE
FUND-CODE
FUNCTION-CODE
OBJECT-CODE
ORGANIZATION-CODE
FISCAL-YEAR
PROGRAM-INTENT-CODE
PAYROLL-AMOUNT /
E0424
E0316
E0317
E0318
E0319
E0974
E0320
E0425
/
C018
C145
C146
C139
-
-
C147
-
/
060
060
060
060
060
060
060
060
/
19 - 20
21 - 23
24 - 25
26 - 29
30 - 32
33
34 - 35
36 - 41
RESPON-SIBILITIES / ALL STAFF WITH A ROLE-ID
/ CAMPUS-ID
ROLE-ID
SERVICE-ID
POPULATION-SERVED-CODE / E0266
E0721
E0724
E0747 / -
C021
C022
C030 / 090
090
090
090 / 19 - 27
28 - 30
31 - 38
53 - 54
ALL PROFESSIONAL
CLASSROOM STAFF AND ALL
PARAPRO-FESSIONAL/
OTHER STAFF / BEGIN-TIME
END-TIME
DAYS-OF-WEEK-CODE
WEEKS-OF-MONTH-CODE
MULTI-SERVICE-INDICATOR-CODE
INSTRUCTIONAL-SETTING-CODE
NUMBER-STUDENTS-IN-CLASS / E0114
E0766
E0729
E0764
E0763
E0173
E0170 / -
-
C027
C039
C020
C035
- / 090
090
090
090
090
090
090 / 39 - 43
44 - 48
49 - 50
51 - 52
55
58 - 59
60 - 62
ESC STAFF / ESC-SSA-STAFF-INDICATOR-CODE /
E1015 /
C169 /
090 /
63

CONTRACTED INSTRUCTIONAL STAFF

GROUP / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
DETAIL / DISTRICT-ID
CAMPUS-ID
PROGRAM-INTENT-CODE
TOTAL-CONTRACTED-INSTR-STAFF-FTES / E0212
E0266
E0320
E0980 / -
-
C147
- / 055
055
055
055 / 4 - 9
10 - 18
19 - 20
21 - 25

STUDENT DATA

GROUP / TYPE OF
STUDENT / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
IDENTIFI-CATION
/ ALL
STUDENTS / DISTRICT-ID
STUDENT-ID
FIRST-NAME
MIDDLE-NAME
LAST-NAME
GENERATION-CODE / E0212
E0001
E0703
E0704
E0705
E0706 / -
-
-
-
-
C012 / 100-203
100-203
100
100
100
100 / 4 - 9
10 - 18
19 - 35
36 - 49
50 - 74
75
DEMO-GRAPHIC / ALL STUDENTS / SEX-CODE
ETHNICITY-CODE
DATE-OF-BIRTH
CAMPUS-ID-OF-RESIDENCE
DEMOGRAPHIC-REVISION-CONFIRMATION-CODE
STUDENT-ATTRIBUTION-CODE
AS-OF-STATUS-CODE
GRADE-LEVEL-CODE
MIGRANT-INDICATOR-CODE
CAMPUS-ID-OF-ENROLLMENT
CAMPUS-ID-OF-ACCOUNTABILITY
BILINGUAL/ESL-SUMMER-SCHOOL-INDICATOR-CODE
EVEN-START-INDICATOR-CODE / E0004
E0005
E0006
E0903
E0924
E1000
E1002
E0017
E0984
E0782
E1027
E1028
E1031
/ C013
C014
-
-
C088
C161
C163
C050
C088
-
-
C088
C172
/ 101
101
101
101
101
101
101
101
101
101
101
101
101
/ 19
20
21 - 28
30 - 38
52
53 - 54
55
56 - 57
58
59 - 67
68 - 76
77
78
ID NUMBER
CHANGE
/ STUDENTS WITH A NUMBER CHANGE / PRIOR-ID
/ E0990 / 105 / 19 - 27

STUDENT DATA (Continued)

ENROLL-MENT / ALL STUDENTS / CAMPUS-ID-OF-ENROLLMENT
GRADE-LEVEL-CODE
ADA-ELIGIBILITY-CODE
LEP-INDICATOR-CODE
HOME-LANGUAGE-CODE
PARENTAL-PERMISSION-CODE
ECONOMIC-DISADVANTAGE-CODE
AT-RISK-INDICATOR-CODE
TITLE-I-PART-A-INDICATOR-CODE
SPECIAL-ED-INDICATOR-CODE
BILINGUAL-INDICATOR-CODE
ESL-INDICATOR-CODE
GIFTED-TALENTED-INDICATOR-CODE
CAREER-AND-TECHNOLOGY-ED-IND-CD
IMMIGRANT-INDICATOR-CODE
LOCAL-STUDENT-ID
SSI-PROMOTION-RETENTION-CODE /
E0782
E0017
E0787
E0790
E0895
E0896
E0785
E0919
E0894
E0794
E0032
E0800
E0034
E0031
E0797
E0923
E1030 /
-
C050
C059
C061
C092
C093
C054
C088
C122
C088
C088
C088
C088
C142
C088
C171 /
110
110
110
110
110
110
110
110
110
110
110
110
110
110
110
110
110 /
19 - 27
28 - 29
31
39
40 - 41
42
43 - 44
45
47
48
49
50
51
52
54
65 – 73
74-75

STUDENT DATA (Continued)

SPECIAL PROGRAM / SPECIAL
EDUCATION / PRIMARY-DISABILITY-CODE
SECONDARY-DISABILITY-CODE
TERTIARY-DISABILITY-CODE
MULTIPLY-DISABLED-INDICATOR-CODE
CHILD-COUNT-FUNDING-TYPE-CODE
EARLY-CHILDHOOD-INTERV-IND-CODE
PRESCHL-PROG-CHLDRN-WITH-DISAB-IND-CD
REG-DAY-SCH-PROG-DEAF-CODE
INSTRUCTIONAL-SETTING-CODE
SPEECH-THERAPY-INDICATOR-CODE
AUDIOLOGICAL-SERV-IND-CODE
COUNSELING-SERVICES-IND-CODE
MEDICAL-DIAGNOSTIC-SERV-IND-CODE
OCCUPATIONAL-THERAPY-IND-CODE
ORIENT-MOBILITY-TRNG-IND-CODE
PHYSICAL-THERAPY-IND-CODE
PSYCHOLOGICAL-SERVICES-IND-CODE
RECREATION-THERAPY-IND-CODE
SCHOOL-HEALTH-SERVICES-IND-CODE
SOCIAL-WORK-SERVICES-IND-CODE
TRANSPORTATION-INDICATOR-CODE
ASSISTIVE-TECH-INDICATOR-CODE
INTERPRETING-SVCS-INDICATOR-CODE
MEDICALLY-FRAGILE-IND-CODE / E0041
E0834
E0835
E0882
E0832
E0900
E0899
E0833
E0173
E0857
E0838
E0840
E0841
E0843
E0844
E0845
E0846
E0847
E0848
E0849
E0851
E0997
E0998
E0999 / C053
C053
C053
C088
C066
C088
C088
C067
C035
C095
C088
C088
C088
C088
C088
C088
C088
C088
C088
C088
C088
C088
C088
C088 / 163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163
163 / 19 - 20
21 - 22
23 - 24
25
26
27
28
29
30 - 31
32
35
37
38
40
41
42
43
44
45
46
47
49
50
51
CAREER AND
TECH-NOLOGY EDUCATION / SGL-PARENT-PREG-TEEN-CODE
WORK-STUDY-VOC-SUPPORT-SERVICE
DAY-CARE-VOC-SUPPORT-SERVICE
TRANSPORTATION-VOC-SUPPORT-SERVICE / E0829
E0888
E0889
E0917 / C064
C088
C088
C088 / 169
169
169
169 / 20
21
22
24
SERVICE-ID
COOPERATIVE-VOC-ED-IND-CODE / E0724
E0920 / C022
C088 / 170
170 / 19 - 26
27

STUDENT DATA (Continued)

GROUP / TYPE OF
STUDENT / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
SCHOOL LEAVER / GRADE
7-12 STUDENTS
/ CAMPUS-ID
LEAVER-REASON-CODE
DATE-OF-GRADUATION
GRADUATION-TYPE-CODE
COLLEGE-ENTRY-INDICATOR-CODE
SPECIAL-ED-INDICATOR-CODE
ECONOMIC-DISADVANTAGE-CODE
LOCAL-STUDENT-ID / E0266
E1001
E0791
E0806
E0792
E0794
E0785
E0923 / -
C162
-
C062
C088
C088
C054
- / 203
203
203
203
203
203
203
203 / 19 - 27
28 - 29,
30 - 31,
32 - 33
34 - 39
40 - 41
42
43
44 - 45
46 - 54
ATTEND-ANCE / ALL
STUDENTS
/ DISTRICT-ID
STUDENT-ID
CAMPUS-ID-OF-ENROLLMENT
INSTRUCTIONAL-TRACK-INDICATOR-CODE
REPORTING-PERIOD-INDICATOR-CODE
NUMBER-DAYS-TAUGHT
GRADE-LEVEL-CODE
TOTAL-DAYS-ABSENT
TOTAL-INELIGIBLE-DAYS-PRESENT
TOTAL-ELIGIBLE-DAYS-PRESENT
TOTAL-ELIG-BILINGUAL/ESL-DAYS-PRESENT
TOTAL-ELIG-PREG-REL-SVCS-DAYS-PRESENT
TOTAL-ELIG-SP-ED-MAINSTREAM-DAYS-PRESENT
GIFTED-TALENTED-INDICATOR-CODE
LOCAL-STUDENT-ID
PEP-INDICATOR-CODE
PRIMARY-DISABILITY-CODE
MULTIPLY-DISABLED-CODE
LEP-INDICATOR-CODE / E0212
E0001
E0782
E0975
E0934
E0935
E0017
E0036
E0936
E0937
E0938
E0939
E0940
E0034
E0923
E1012
E0041
E0882
E0790 / -
-
-
C141
C130
C050
-
-
-
-
-
-
C088
-
-
C088
C053
C088
C061 / 400-415
400-415
400-415
400, 405, & 410
400, 405, & 410
400, 405, & 410
400, 405, & 410
400
400
400
400
400
400
400
400
400
400
400
400 / 4 - 9
10 - 18
19 - 27
28
29
30 - 32
33 - 34
35 - 38
39 - 42
43 - 46
47 - 50
51 - 54
55 - 58
60
61 - 69
70
71 - 72
73
74

STUDENT DATA (Continued)

GROUP / TYPE OF
STUDENT / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
ATTEND-ANCE
(contd.) / SPECIAL EDUCATION STUDENTS / INSTRUCTIONAL-SETTING-CODE
ELIGIBLE-DAYS-PRESENT-IN-INSTR-SETTING
EXCESS-HOURS-IN-INSTRUCTIONAL-SETTING /
E0173
E0944
E0945
/
C035
-
-
/
405
405
405
/
35 - 36,
47 - 48,
59 - 60
37 - 40,
49 - 52,
61 - 64
41 - 46,
53 - 58,
65 - 70
OPTIONAL EXTENDED YEAR PROGRAM STUDENTS / GRADE-LEVEL-CODE
OPTIONAL-EXTENDED-YEAR-PROGRAM-TYPE-CODE
NUMBER-DAYS-TAUGHT
TOTAL-DAYS-ABSENT
TOTAL-ELIGIBLE-DAYS-PRESENT
LOCAL-STUDENT-ID
OEYP-PROMOTION-RETENTION-INDICATOR-CODE / E0017
E1014
E0935
E0036
E0937
E0923
E1029 / C050
C168
-
-
-
-
C170 / 407
407
407
407
407
407
407 / 28 - 29
30
31 - 33
34 - 37
38 - 41
42 - 50
51 - 52
EXTENDED SCHOOL YEAR SERVICES STUDENTS / GRADE-LEVEL-CODE
INSTRUCTIONAL-SETTING-CODE
TOTAL-ESY-CONTACT-HRS-IN-INSTR-SETTING / E0017
E0173
E1013 / C050
C035
- / 408
408
408 / 28 - 29
30 - 31,
36 - 37
32 - 35,
38 - 41
VOCATIONAL EDUCATION
STUDENTS / ELIGIBLE-DAYS-PRESENT-V1
ELIGIBLE-DAYS-PRESENT-V2
ELIGIBLE-DAYS-PRESENT-V3
ELIGIBLE-DAYS-PRESENT-V4
ELIGIBLE-DAYS-PRESENT-V5
ELIGIBLE-DAYS-PRESENT-V6 / E0950
E0951
E0952
E0953
E0954
E0955 / -
-
-
-
-
- / 410
410
410
410
410
410 / 35 - 38
39 - 42
43 - 46
47 - 50
51 - 54
55 - 58
COURSE
COMPLE-TION
/ GRADE 9-12
STUDENTS
/ SERVICE-ID
COURSE-SEQUENCE-CODE
PASS/FAIL-CREDIT-INDICATOR-CODE
DISTANCE-LEARNING-INDICATOR-CODE
DUAL-CREDIT-INDICATOR-CODE / E0724
E0948
E0949
E1010
E1011 / C022
C135
C136
C167
C088 / 415
415
415
415
415 / 28 - 35
36
37 - 38
39 - 40
41

STUDENT DATA (Continued)

GROUP / TYPE OF
STUDENT / DATA
ELEMENT
NAME / DATA
ELEMENT
ID / CODE
TABLE
ID / INPUT
RECORD
TYPE /
COLUMNS
DISCI-PLINARY / STUDENTS SUBJECT TO DISCIPLINE ACTIONS / CAMPUS-ID-OF-DISCIPLINARY-ASSIGNMENT
DISCIPLINARY-ACTION-NUMBER
DISCIPLINARY-ACTION-CODE
DISCIPLINARY-ACTION-REASON-CODE
OFFICIAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT
ACTUAL-LENGTH-OF-DISCIPLINARY-ASSIGNMENT
DISCIPLINARY-LENGTH-DIFFERENCE-REASON-CODE
DISCIPLINARY-INCIDENT-NUMBER
REPORTING-PERIOD-INDICATOR-CODE
DATE-OF-DISCIPLINARY-ACTION
CAMPUS-ID-OF-DISCIPLINARY-RESPONSIBILITY /
E1003
E1004
E1005
E1006
E1007
E1008
E1009
E1016
E0934
E1036
E1037 /
-
-
C164
C165
-
-
C166
-
C130
/
425
425
425
425
425
425
425
425
425
425
425 /
28 - 36
37 - 39
40 - 41
42 - 43
44 - 46
47 - 49
50 - 51
52 - 57
58
59 - 66
67 - 75
RE-STRAINT / SPECIAL EDUCATION STUDENTS WHO HAVE BEEN RESTRAINED / CAMPUS-ID-OF-RESTRAINT-EVENT
RESTRAINT-INSTANCE-NUMBER
RESTRAINT-REASON-CODE
DATE-0F-RESTRAINT-EVENT / E1032
E1035
E1033
E1034 /
C173 / 435
435
435
435 / 19 - 27
28 - 33
37 - 38
41 - 48
TITLE I, PART A / STUDENTS IN MEMBERSHIP ON SUB 3
AS-OF DATE WHO RECEIVE TITLE I PART A SERVICES / TITLE-I-PART-A-INDICATOR-CODE
TITLE-I-PART-A-HOMELESS-INDICATOR-CODE
TITLE-I-PART-A-READING-INDICATOR-CODE
TITLE-I-PART-A-MATHEMATICS-INDICATOR-CODE
TITLE-I-PART-A-SCIENCE-INDICATOR-CODE
TITLE-I-PART-A-SOCIAL-STUDIES-INDICATOR-CODE
TITLE-I-PART-A-GUIDANCE-COUNSELING-SERVICES-INDICATOR-CODE
TITLE-I-PART-A-SOCIAL-WORK-SERVICES-INDICATOR-CODE
TITLE-I-PART-A-HEALTH-SERVICES-INDICATOR-CODE /
E0894
E1017
E1018
E1020
E1021
E1022
E1024
E1025
E1026 /
C088
C088
C088
C088
C088
C088
C088
C088
C088 /
461
461
461
461
461
461
461
461
461 /
28
29
30
31
32
33
34
35
36

B.9