e-Transcript District Setup

Data Element

Additional Information

[Table]FieldName

Length

Required

GPA Calculation Method

The Setup for GPA Calculation Methods is required. The list of GPA methods will be displayed as an option on the eTranscript report submission page.

Exclude from e-Transcript

Choose True from the pop-up menu to exclude the calculation from the e-Transcript.

Note: Excluding this GPA Calculation Method will prevent it from displaying as an option on the e-Transcript Report Parameter page.

[GEN.S_IN_GEN_X]Exclude_From_Transcript

1

GPA Range Maximum

Enter the maximum possible grade point value a student can receive for an overall GPA, for example: 4.0 or 12.0.

Note: If you need to override this value for an individual student, use the GPA Range Maximum Override field on the individual student’s page: Student Selection > State/Province - IN > Transcript tab > e-Transcript Information.

[GEN.S_IN_GEN_X]GPA_Range_Maximum

If blank, 4.0 will extract

18

GPA Type Override

Choose a GPA Type Override from the pop-up menu.

• Weighted

• NonWeighted

• UserDefined

[GEN.S_IN_GEN_X]GPA_Academic_Summary_Type

50

GPA Type - User Defined Description

If UserDefined is selected for the GPA Type above, enter a description. This field is used to describe the GPA Type.

[GEN.S_IN_GEN_X]GPA_Type_User_Defined_Desc

80

Data Element

Additional Information

[Table]FieldName

Length

Required

Test

Enter the name of the test so that test results for the named test will extract.

[S_IN_TST_X]Test_Code

60

Required to extract test data

Data Element

Additional Information

[Table]FieldName

Length

Required

Sub Test Code

Enter the sub test code. Field must be populated for student test results of this test score to extract.

[S_IN_TSC_X]Sub_Test_Code

60

Required to extract test score data

Score Type

Select the data type of score that will be extracted for the particular Test Score. Default value is Number.

Valid values:

• Number

• Percent

• Alpha

[TestScore.S_IN_TSC_X]Score_Type

10

Optional

Data Element

Additional Information

[Table]FieldName

Length

Required

Private School Number

For private schools only. Enter the school number prefix assigned by the state. When populated, this value is used as the school's state identifier in the e-Transcript XML output instead of the PowerSchool school number.

[Schools]IN_SchoolNumberPrefix

4

Optional

Include Historical Grades from this School in e-Transcript

Choose True from the pop-up menu to include grades from this school in e-Transcripts.

Note: If this is set to False, you can force a grade to be included in e-Transcript by setting the 'Include in e-Transcript' field to True on the Stored Grade.

[S_IN_SCH_X]Include_In_Transcript

1

Optional

CEEB ACT Code

Enter the CEEB ACT Code.

The CEEB ACT Code is the unique identifier assigned by the College Entrance Examining Board and ACT for each K-12 data exchange partner.

[S_IN_SCH_X]CEEB_ACT_Code

6

Required

Data Element

Additional Information

[Table]FieldName

Length

Required

Excluded Grade Level

Enter an integer grade level to exclude from the e-Transcript. Stored grades recorded while a student was in an excluded grade level do not appear in the e-Transcript output for the school. Enter one grade level per record: create multiple records to exclude multiple grade levels. Enter integer values only (for example: 9, 10, 11, 12).

[S_IN_SCH_EXCLUDED_GRD_LEVELS_C]Grade_Level

Optional

Data Element

Additional Information

[Table]FieldName

Length

Required

PowerSchool Term

Select the PowerSchool term for which this mapping applies. The term is used to match stored grade records during e-Transcript extraction.

[S_IN_Final_Grade_Mapping_S]termid

Required

Final Grade Store Code

Enter the store code of the final grade for this term (for example: S1, S2, Y1). This value is matched against the stored grade's store code during extraction. Maximum length is 2 characters.

[S_IN_Final_Grade_Mapping_S]storecode

2

Required

Completion Date

Enter the date on which the term or course was completed. This date is extracted as the course completion date in the e-Transcript output.

[S_IN_Final_Grade_Mapping_S]completion_date

Required

Course Length

Select the course length for this mapping record. This value determines how the course duration is reported in the e-Transcript.

Valid values:

• Semester

• Trimester

• Quarter

• Full Year

[S_IN_Final_Grade_Mapping_S]course_length

30

Optional

PowerSchool Term Override

Select a term to override the reporting term for this mapping record. Use this field when a full-year class needs to be reported as two separate semester entries.

Example:

If no override is needed, leave this field blank. The term selected in the PowerSchool Term field will be used instead.

[S_IN_Final_Grade_Mapping_S]termid_override

Optiona

Data Element

Additional Information

[Table]FieldName

Length

Required

Immunization Name

Enter the medical name of the immunization. This name is used to identify the immunization record in the mapping list.

[S_IN_IMMUNIZATION_MAPPING_S]Immunization_Name

50

Required

Immunization CPT Code

Enter the CPT code of the immunization. For CPT codes, review the pop-up for common CPT codes provided by the state.

[S_IN_IMMUNIZATION_MAPPING_S]CPT_Code

20

Required

Immunization Date Custom Field Name

Enter the name of the custom field in the Students table where the immunization date is stored. This must match the custom field name exactly as defined in PowerSchool.

[S_IN_IMMUNIZATION_MAPPING_S]Custom_Field_Name

32

Required

Custom Field Date Format

Select the date format used by the immunization date custom field. The selected format is used when extracting the immunization date in the e-Transcript.

[S_IN_IMMUNIZATION_MAPPING_S]Date_Format

Required