PowerSchool SIS Arizona
PowerSchool SIS Arizona
Breadcrumbs

Importing into Virtual Tables

It is recommended to import a small test set of data when first importing into a virtual table. See Knowledgebase article 11284 on PowerSource for instructions on importing into virtual tables.

The virtual tables used for Arizona SAIS state reporting are listed below.

Note: The Student ID data element represents the student's ID, not his student number. When importing into virtual tables, the student's id field should be used and not his student_number field.

Also, the TermID data element represents the 2 digit term year. When importing records the TermID value in your import file needs to be the 2 digit term year. The 2 digit term year represents the first 2 digits of the termid of the school year term. For example, the 2011-2012 school year has a termid of 2100. The 2 digit term year for the 2011-2012 school year is 21.

AIMS Labels: AZ_AIMS_Labels

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentNeed]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentNeed]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentNeed]TermID

[VirtualTablesData]user_defined_integer

Group Name

[AZ_AIMS_Labels]user_defined_text

[VirtualTablesData]user_defined_text

Student Needs 011: AZ_StudentNeed

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 011 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentNeed]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentNeed]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentNeed]TermID

[VirtualTablesData]user_defined_integer

Need Code

[AZ_StudentNeed]NeedCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text

Need Entry Date

[AZ_StudentNeed]EntryDate

[VirtualTablesData]user_defined_date

Need Exit Date

[AZ_StudentNeed]ExitDate

Note: The exit date must occur after the entry date.

[VirtualTablesData]user_defined_date2

Primary Nighttime Residence

[AZ_StudentNeed]AZ_PrimaryNighttimeResidence

Valid values:

  • 1 – Sheltered

  • 2 – Doubled Up

  • 3 - Unsheltered

  • 4 – Hotel/Motel

  • 5 – Unknown

[VirtualTablesData]user_defined_text2

Student Assessments 012: AZ_StudentAssessmentFY06

Note: As of fiscal year 2008-2009, 012 transactions are not generated for SAIS.

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentAssessmentFY06]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentAssessmentFY06]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentAssessmentFY06]TermID

[VirtualTablesData]TermID

Oral – Assessment Date

[AZ_StudentAssessmentFY06]AZ_OralAssessmentDate

[VirtualTablesData]user_defined_date

Oral – Assessment Score

[AZ_StudentAssessmentFY06]AZ_OralAssessmentScore

[VirtualTablesData]user_defined_text

Oral – Proficiency Level

[AZ_StudentAssessmentFY06]AZ_OralAssessmentLevel

Valid values:

  • PE – Pre-Emergent

  • E – Emergent

  • B – Basic

  • I – Intermediate

  • P – Proficient

[VirtualTablesData]user_defined_text2

Reading – Assessment Date

[AZ_StudentAssessmentFY06]AZ_ReadingAssessmentDate

[VirtualTablesData]AZ_ReadingAssessmentDate

Reading – Assessment Score

[AZ_StudentAssessmentFY06]AZ_ReadingAssessmentScore2

[VirtualTablesData]AZ_ReadingAssessmentScore2

Reading – Proficiency Level

[AZ_StudentAssessmentFY06]AZ_ReadingAssessmentLevel

Valid values:

  • PE – Pre-Emergent

  • E – Emergent

  • B – Basic

  • I – Intermediate

  • P – Proficient

[VirtualTablesData]AZ_ReadingAssessmentLevel

Writing – Assessment Date

[AZ_StudentAssessmentFY06]AZ_WritingAssessmentDate

[VirtualTablesData]AZ_WritingAssessmentDate

Writing – Assessment Score

[AZ_StudentAssessmentFY06]AZ_WritingAssessmentScore2

[VirtualTablesData]AZ_WritingAssessmentScore2

Writing – Proficiency Level

[AZ_StudentAssessmentFY06]AZ_WritingAssessmentLevel

Valid values:

  • PE – Pre-Emergent

  • E – Emergent

  • B – Basic

  • I – Intermediate

  • P – Proficient

[VirtualTablesData]AZ_WritingAssessmentLevel

Overall Assessment Result

[AZ_StudentAssessmentFY06]AZ_OverallAssessmentResult

[VirtualTablesData]AZ_OverallAssessmentResult

Overall Total Composite Scale Score

[AZ_StudentAssessmentFY06]AZ_OverallTotComposScaledScore

[VirtualTablesData]AZ_OverallTotComposScaledScore

Overall Proficiency Level

[AZ_StudentAssessmentFY06]AZ_OverallProficiencyLevel

Valid values:

  • PE – Pre-Emergent

  • E – Emergent

  • B – Basic

  • I – Intermediate

  • P – Proficient

[VirtualTablesData]AZ_OverallProficiencyLevel

Student Language Program 013: AZ_StudentLanguageProgramParticipation

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 013 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentLanguageProgramParticipation]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentLanguageProgramParticipation]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentLanguageProgramParticipation]TermID

[VirtualTablesData]TermID

Program Need Code

[AZ_StudentLanguageProgramParticipation]LangNeedCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text

Program Code

[AZ_StudentLanguageProgramParticipation]LangProgramCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text2

Program Entry Date

[AZ_StudentLanguageProgramParticipation]EntryDate

[VirtualTablesData]user_defined_date

Program Exit Date

[AZ_StudentLanguageProgramParticipation]ExitDate

[VirtualTablesData]user_defined_date2

Program Exit Reason Code

[AZ_StudentLanguageProgramParticipation]ExitReason

Note: Must be a valid SAIS code.

[VirtualTablesData]ExitReason

Student SPED Service 014: AZ_StudentSPED_Service

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 014 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentSPED_Service]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentSPED_Service]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentSPED_Service]TermID

[VirtualTablesData]TermID

SPED Need Code

[AZ_StudentSPED_Service]SPEDNeedCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text

SPED Service Code

[AZ_StudentSPED_Service]SPEDServiceCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text2

SPED Service Entry Date

[AZ_StudentSPED_Service]EntryDate

[VirtualTablesData]user_defined_date

SPED Service Exit Date

[AZ_StudentSPED_Service]ExitDate

[VirtualTablesData]user_defined_date2

SPED Service Exit Reason Code

[AZ_StudentSPED_Service]ExitReason

[VirtualTablesData]ExitReason

SPED Grade Level

[AZ_StudentSPED_Service]SPEDGradeLevel

[VirtualTablesData]user_defined_numeric

SPED Special Enrollment Code

[AZ_StudentSPED_Service]SPEDSpEnrollmentCode

Note: Must be a valid SAIS code.

[VirtualTablesData]SPEDSpEnrollmentCode

District of Residence

[AZ_StudentSPED_Service]AZ_SPED_DOR

[VirtualTablesData]AZ_SPED_DOR

Federal Primary Need Indicator

[AZ_StudentSPED_Service]AZ_FederalPrimaryNeedIndicator

Valid values:

  • 0 – No

  • 1 – Yes

[VirtualTablesData]AZ_FederalPrimaryNeedIndicator

Concurrency Type

[AZ_StudentSPED_Service]AZ_ConcurrencyType

Valid values:

  • P – Primary

  • S – Secondary

[VirtualTablesData]AZ_ConcurrencyType

Student Support Program 015: AZ_StudentSupportProgramParticipation

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 015 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_StudentSupportProgramParticipation]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_StudentSupportProgramParticipation]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_StudentSupportProgram]TermID

[VirtualTablesData]TermID

Support Need Code

[AZ_StudentSupportProgramParticipation]SupportNeedCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text

Support Program Code

[AZ_StudentSupportProgramParticipation]SupportProgramCode

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text2

Support Entry Date

[AZ_StudentSupportProgramParticipation]EntryDate

[VirtualTablesData]user_defined_date

Support Exit Date

[AZ_StudentSupportProgramParticipation]ExitDate

[VirtualTablesData]user_defined_date2

Receiving CTDS

[AZ_StudentSupportProgramParticipation]AZ_Receiving_CTDS

[VirtualTablesData]AZ_Receiving_CTDS

Community College 020: AZ_CommunityCollege

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_CommunityCollege]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_CommunityCollege]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_CommunityCollege]TermID

[VirtualTablesData]TermID

College Entity ID

[AZ_CommunityCollege]AZ_CommunityCollegeCTDS

[VirtualTablesData]user_defined_text

College Entry Date

[AZ_CommunityCollege]AZ_CommunityCollegeEntryDate

[VirtualTablesData]user_defined_date

College Exit Date

[AZ_CommunityCollege]AZ_CommunityCollegeExitDate

[VirtualTablesData]user_defined_date2

College Classes (Number)

[AZ_CommunityCollege]AZ_CommunityCollegeClassCount

[VirtualTablesData]user_defined_numeric

Early Childhood Participation 023: AZ_EarlyChildhoodParticipation

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 023 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_EarlyChildhoodParticipation]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_EarlyChildhoodParticipation]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_EarlyChildhoodParticipation]TermID

[VirtualTablesData]TermID

Preschool Program Type

[AZ_EarlyChildhoodParticipation]AZ_PreschoolProgramType

Note: Must be a valid SAIS code.

[VirtualTablesData]user_defined_text

Program Entry Date

[AZ_EarlyChildhoodParticipation]AZ_ProgramEntryDate

[VirtualTablesData]user_defined_date

Program Exit Date

[AZ_EarlyChildhoodParticipation]AZ_ProgramExitDate

[VirtualTablesData]user_defined_date2

Program Partner ID

[AZ_EarlyChildhoodParticipation]AZ_ProgramPartnerID

[VirtualTablesData]user_defined_text2

Family Income Indicator

[AZ_EarlyChildhoodParticipation]AZ_FamilyIncomeIndicator

Valid values:

  • 1 – Yes

  • 0 – No

[VirtualTablesData]AZ_FamilyIncomeIndicator

Living in Household Indicator

[AZ_EarlyChildhoodParticipation]AZ_LivingInHouseholdIndicator

Valid values:

  • 1 – Mother

  • 2 – Father

  • 3 – Both

  • 4 – Neither

[VirtualTablesData]AZ_LivingInHouseholdIndicator

Mother Employment Status

[AZ_EarlyChildhoodParticipation]AZ_MotherEmploymentStatus

Valid values:

  • 1 – Yes

  • 0 – No

[VirtualTablesData]AZ_MotherEmploymentStatus

Father Employment Status

[AZ_EarlyChildhoodParticipation]AZ_FatherEmploymentStatus

Valid values:

  • 1 – Yes

  • 0 – No

[VirtualTablesData]AZ_FatherEmploymentStatus

Adult Education ID

[AZ_EarlyChildhoodParticipation]AZ_AdultEducationID

[VirtualTablesData]AZ_AdultEducationID

Exempt from PPVT III or PALS-PreK

[AZ_EarlyChildhoodParticipation]AZ_ExemptPPVT

[VirtualTablesData]AZ_ExemptPPVT

Early Childhood Assessment 024: AZ_EarlyChildhoodAssessment

Note: Importing records into this table triggers SAIS events in PowerSchool. The events are included as transactions the next time you build a SAIS Upload File (there is no need to resend enrollments after importing 024 Needs).

Data Element

Importing: [Table]Field

DDE: [Table]Field

Student ID

[AZ_EarlyChildhoodAssessment]foreignKey

[VirtualTablesData]foreignKey

School ID

[AZ_EarlyChildhoodAssessment]SchoolID

[VirtualTablesData]SchoolID

TermID

[AZ_EarlyChildhoodAssessment]TermID

[VirtualTablesData]TermID

Preschool Assessment Type

[AZ_EarlyChildhoodAssessment]AZ_AssessmentType

Valid values:

  • 1 – Work Sampling

  • 2 – Creative Curriculum

  • 3 – Child Observation Record (COR)

[VirtualTablesData]user_defined_text

Preschool Assessment Date

[AZ_EarlyChildhoodAssessment]AZ_AssessmentDate

[VirtualTablesData]user_defined_date

Responsible Entity ID

[AZ_EarlyChildhoodAssessment]AZ_ResponsibleEntityID

[VirtualTablesData]user_defined_text2

Test Score 1

[AZ_EarlyChildhoodAssessment]AZ_TestScore1

[VirtualTablesData]AZ_TestScore1

Test Score 2

[AZ_EarlyChildhoodAssessment]AZ_TestScore2

[VirtualTablesData]AZ_TestScore2

Test Score 3

[AZ_EarlyChildhoodAssessment]AZ_TestScore3

[VirtualTablesData]AZ_TestScore3

Test Score 4

[AZ_EarlyChildhoodAssessment]AZ_TestScore4

[VirtualTablesData]AZ_TestScore4

Test Score 5

[AZ_EarlyChildhoodAssessment]AZ_TestScore5

[VirtualTablesData]AZ_TestScore5

Test Score 6

[AZ_EarlyChildhoodAssessment]AZ_TestScore6

[VirtualTablesData]AZ_TestScore6

Test Score 7

[AZ_EarlyChildhoodAssessment]AZ_TestScore7

[VirtualTablesData]AZ_TestScore7

Test Score 8

[AZ_EarlyChildhoodAssessment]AZ_TestScore8

[VirtualTablesData]AZ_TestScore8

Test Score 9

[AZ_EarlyChildhoodAssessment]AZ_TestScore9

[VirtualTablesData]AZ_TestScore9

Test Score 10

[AZ_EarlyChildhoodAssessment]AZ_TestScore10

[VirtualTablesData]AZ_TestScore10

Test Score 11

[AZ_EarlyChildhoodAssessment]AZ_TestScore11

[VirtualTablesData]AZ_TestScore11

Test Score 12

[AZ_EarlyChildhoodAssessment]AZ_TestScore12

[VirtualTablesData]AZ_TestScore12