041 – Student Enrollment

1

Record ID

The identifier of this record.

Always "041"

3

N

2

Record Version

The version of this record.

Always "04"

2

N

3

Record Type

One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:

• N – New
• E – Edit
• D – Delete

N/A

1

N

4

Filler

N/A

N/A

2

N

5

District ID

The district number.

[Prefs]Value

[Prefs]Name=districtnumber

3

N

6

School ID

The school number.
If the student has a concurrent enrollment, then the concurrent school number is reported, otherwise, the primary school number is reported.

[Schools]Alternate_School_Number - if populated

Otherwise:

[Students]Enrollment_SchoolID

[ReEnrollments]SchoolID

[S_TN_STU_ConcurrentEnroll_C]PrimarySchoolID (Service School ID)

4

N

7

School Year

The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full-year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.

[Terms]FirstDay

[Terms]LastDay

4

N

8

Instructional Program Number

The number is used to uniquely identify the program within the school.

Valid values: 01, 02, 03, 04, 05, or 06.

If the student has a concurrent enrollment, then the concurrent track is reported, otherwise, the primary track is reported.

[Students]Track

[ReEnrollments]Track

[S_TN_STU_ConcurrentEnroll_C]ConTrack
(Service School Instructional Program Number)

2

N

9

Student Social Security Number

The student's social security number.

[Students]SSN

9

N

10

Student PIN

The student's PIN, if the social security number is not provided or reported.

[S_TN_STU_X]StudentPIN

9

N

11

Local Student Key

The internal ID assigned to the student's record in the PowerSchool database.

[Students]ID

[ReEnrollments]StudentID

10

N

12

Instr Service Period Type of Service

The type of service for this school enrollment.

Valid values:

• N/A
• P – Primary Provider Where Student is Enrolled
• S – Selective Services Only (Visiting Student)
  Note: A value of S is always reported for concurrent enrollments.

[S_TN_STU_X]ISPToS

[S_TN_REN_X]ISPToS

1

Y

13

Enrollment Date

The first day of the student's school enrollment.

If the student has a concurrent enrollment, then the concurrent entry date is reported, otherwise, the primary entry date is reported.

Note: If the student's enrollment date changes, a Delete and an Add record are triggered. The Delete record is sent with the old enrollment date and the Add record is sent with the new enrollment date. In addition, records 042-052 and 080-083 must be resent for the student. The 080 record must be resent manually, but the other records are automatically queued, upon changing the enrollment date, to the Resent Student Data page, Start Page > Special Functions > Interfaces to Other Systems > EIS > Resend Student Data.

[Students]EntryDate

[ReEnrollments]EntryDate

[S_TN_STU_ConcurrentEnroll_C]EntryDate (Service School Enrollment Date)

8

Y

14

Enrollment Reason

The school enrollment entry code.

If the student has a concurrent enrollment, then the concurrent entry code is reported, otherwise, the primary entry code is reported.

[Students]EntryCode

[ReEnrollments]EntryCode

[S_TN_STU_ConcurrentEnroll_C]EntryCode (Service School Enrollment Reason)

2

Y

15

English Language Background

The student's English language background for this school enrollment.

[S_TN_STU_X]ELB

[S_TN_REN_X]ELB

1

Y

16

Course of Study

The student's course of study for this school enrollment.

Valid values:

• [blank] – N/A
• T – Technical
• U – University
• D – Dual

[S_TN_STU_X]CourseOfStudy

[S_TN_REN_X]CourseOfStudy

1

Y

17

Filler

N/A

N/A

1

NN

18

Filler

N/A

N/A

2

NN

19

Primary District ID

The district of residence ID for this school enrollment. This value is the ID of the district in which the student resides during this school enrollment.

For concurrent enrollments, this value is extracted from the concurrent enrollment record.

[Students]DistrictOfResidence

[ReEnrollments]DistrictOfResidence

[S_TN_STU_ConcurrentEnroll_C]PrimaryDOR

3

Y

20

Primary School ID

The school number of the school in which the student is enrolled.

The Primary School ID is reported if populated. Otherwise, the Enrollment School ID is reported.

For concurrent enrollments, the Primary School ID is reported from the concurrent enrollment record.

[Students]Enrollment_SchoolID

[S_TN_STU_X]PrimarySchoolID

[ReEnrollments]SchoolID

[S_TN_STU_ConcurrentEnroll_C]PrimarySchoolID

4

Y

21

State Assigned Student ID

The state assigned student identifier.

[Students]State_Studentnumber

9

N

22

Homeless Primary Night Time Residence

Indicated the student's Homeless Primary Night Time Residence

[S_TN_STU_X]HomelessPrimaryNightTimeRes

[S_TN_REN_X]HomelessPrimaryNightTimeRes

2

Y

23

Homeless Served by McKinney - Vento

Indicated if the student is served by McKinney - Vento

[S_TN_STU_X]HomelessServedByMcKinney

[S_TN_REN_X]HomelessServedByMcKinney

1

Y

24

Homeless Unaccompanied Youth

Indicated if the student is homeless unaccompanied youth.

[S_TN_STU_X]HomelessUnaccompaniedYouth

[S_TN_REN_X]HomelessUnaccompaniedYouth

1

Y

Valid Values:

• Y- Yes, If immunizations are entered, Y is reported
• N -No, If no immunizations are entered, N is reported
• M - Medically Waived, M is reported
• R - Religiously Waived, R is reported
• Blank - If no value is specified, by default Y is reported. 

Note: If a vaccination date is entered for one disease and Medically or Religiously Waived for another, then Y is reported. 

Derived from the following query:

select Case when sum(ADMINISTERED_DOSE_COUNT) > 0 then 'Y'
                 When max(EXEMPTION_CODE) = 'Medical' then 'M'
                 WHen max(EXEMPTION_CODE) = 'Religious' then 'R'
                 else 'N' END immuniStatus
                 from psrw_healthimmunization where studentid = :STUDENTID (edited)

Derived from the following query:

SELECT CASE WHEN YearDif <= 0 THEN trim(to_Char(0,'00')) ELSE trim(to_char(YearDif,'00')) END ELSYearDiff FROM  (
                 SELECT   (EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM  nvl(DateFirstEnrolledInESLProgram,sysdate))) YearDif
                 FROM S_TN_STU_X WHERE STUDENTSDCID =  (SELECT DCID FROM students WHERE id = :STUDENTID))

27

Filler

N/A

N/A

19

N