Skip to main content
Skip table of contents

052 – Student CTSO Membership

Introduction

This extract includes a record for each student CTSO membership during the current school year.

Report Input

For help with navigation and extract generation, see Create Selected Student Related Extract File.

Extract Output

Each of the fields displayed in the output of the report are described below. SeeUnderstanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Length

Track

1

Record ID

The identifier of this record.

Always "052"

3

N

2

Record Version

The version of this record.

Always "02"

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.

[ClubMembership]SchoolID

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 used to uniquely identify the program within the school.
Valid values: 01, 02, 03, 04, 05, or 06.

[Students]Track

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.

[Students]TN_StudentPIN

9

N

11

Local Student Key

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

[Students]ID

10

N

12

CTSO ID

The student's CTSO membership.

[ClubMembership]TN_ClubID

15

Y

13

CTSO Membership Begin Date

The first day of the student's CTSO membership.

[ClubMembership]TN_Club_MembBeginDate

8

Y

14

CTSO Membership End Date

The last day of the student's CTSO membership.

Note: Do not report the last day of the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.

[ClubMembership]TN_Club_MembEndDate

8

Y

15

State Assigned Student ID

The state assigned student identifier.

[Students]State_Studentnumber

9

N

16 CTSO ChapterIDChapter ID (name or number) assigned by the National CTSO.[S_TN_STU_ClubMembership_C]TN_Club_ChapterID20Y
17CTSO MembershipIDStudent membership ID assigned by the National CTSO.[S_TN_STU_ClubMembership_C]TN_Club_MembershipID9Y

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.