ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAU
1
PowerSchool Student Interchange Fields Crosswalk
2
SD FieldFind in PowerSchoolTable Field Name
3
District CodeDistrict Setup-->District Information-->District Number[Prefs]name=districtnumber
4
SASIDState/Province - CO --> CO Demographics --> State ID (SASID)[Students]State_StudentNumber
5
LASIDDemographics --> Student Number[Students]Student_Number
6
First NameDemographics --> First[StudentCoreFields]PSCore_Legal_First_Name, [Students]First_Name
7
Middle NameDemographics --> Middle[StudentCoreFields]PSCore_Legal_Middle_Name, [Students]Middle_Name
8
Last NameDemographics --> Last[StudentCoreFields]PSCore_Legal_Last_Name, [Students]Last_Name
9
GenderDemographics --> Gender[StudentCoreFields]PSCore_Legal_Gender, [Students]Gender
10
DOBDemographics --> DOB[Students]DOB
11
EthnicityDemographics --> Ethnicity[Students]FedEthnicity
12
American Indian/Alaskan NativeDemographics --> Race (check all that apply)[StudentRace]RaceCd = I
13
AsianDemographics --> Race (check all that apply)[StudentRace]RaceCd =A
14
Black/African AmericanDemographics --> Race (check all that apply)[StudentRace]RaceCd = B
15
WhiteDemographics --> Race (check all that apply)[StudentRace]RaceCd = W
16
Native Hawaiian/Pacific IslanderDemographics --> Race (check all that apply)[StudentRace]RaceCd = P
17
Free/Reduced Lunch EligibleLunch --> Lunch Status[S_CO_STU_X]StateLunchStatus
18
Section 504State/Province - CO --> Special Ed --> Section 504 Handicapped[S_CO_STU_X]Handicapped_504, [S_CO_REN_X]Handicapped_504
19
ImmigrantState/Province - CO --> ELL-Migrant-Immigrant --> Immigrant[S_CO_STU_X]Immigrant, [S_CO_REN_X]Immigrant
20
Language BackgroundState/Province - CO --> ELL-Migrant-Immigrant --> Language Background[S_CO_STU_X]English_Learner, [S_CO_REN_X]English_Learner
21
Primary DisabilityState/Province - CO --> Special Ed --> Primary Disability[S_CO_STU_X]Primary_Disability, [S_CO_REN_X]Primary_Disability
22
Attended District Funded HSED ProgramState/Province - CO --> Grad Info--> Attends District Funded HSED Program[S_CO_STU_X]GED_Program
23
HomelessState/Province - CO --> CO Demographics --> Homeless[S_CO_STU_X]Homeless, [S_CO_REN_X]Homeless
24
Cause of Housing CrisisState/Province - CO --> CO Demographics --> Cause of Housing Crisis
25
Additional Cause of Housing CrisisState/Province - CO --> CO Demographics --> Additional Cause of Housing Crisis
26
Primary Nighttime ResidenceState/Province - CO --> CO Demographics --> Primary Nighttime Residence
[S_CO_STU_X]Primary_Night_Residence, [S_CO_REN_X]Primary_Night_Residence

27
Language ProficiencyState/Province - CO --> ELL-Migrant-Immigrant --> Language Proficiency[S_CO_STU_X]LanguageProficiency, [S_CO_REN_X]LanguageProficiency
28
Language Instruction ProgramState/Province - CO --> ELL-Migrant-Immigrant --> Language Instruction Program[S_CO_STU_X]LIP
29
Special Education TransitionState/Province - CO --> Special Ed --> Transition[S_CO_STU_X]Transition, [S_CO_REN_X]Transition
30
Alternate Assessment ParticipantState/Province - CO --> Special Ed --> CSAP Alternate Assessment Participant[S_CO_STU_X]CSAP_Alternate_Assessment, [S_CO_REN_X]CSAP_Alternate_Assessment
31
Postsecondary Program EnrollmentState/Province - CO --> Post-Secondary Enrollment --> Post Secondary Program[S_CO_STU_X]PostSecondaryProgram, [S_CO_REN_X]PostSecondaryProgram
32
Military ConnectedState/Province - CO --> CO Demographics --> Student Demographic Information--> Military Connected[S_CO_STU_X]Military Connected
33
SSA FieldFind in PowerSchoolTable Field Name
34
District CodeDistrict Setup-->District Information-->District Number[Prefs]name=districtnumber
35
SASIDDemographics --> Student Number[Students]State_StudentNumber
36
School CodeDistrict Setup-->District Setup-->Schools/School Info-->School Number[Schools]School_Number, [Schools]Alternate_School_Number
37
First NameDemographics --> First
[Students]First_Name, [StudentCoreFields]PSCore_Legal_First_Name
38
Last NameDemographics --> Last[Students]Last_Name, [StudentCoreFields]PSCore_Legal_Last_Name
39
GenderDemographics --> Gender[Students]Gender, [StudentCoreFields]PSCore_Legal_Gender
40
DOBDemographics --> DOB[Students]DOB
41
Entry DateTransfer Info --> [click on current enrollment] --> Entry Date[Students]EntryDate, [ReEnrollments]EntryDate
42
Grade LevelTransfer Info --> [click on current enrollment] --> Grade Level[Students]Grade_Level, [S_CO_STU_X]Kindergarten, [ReEnrollments]Grade_Level, S_CO_REN_X] Kindergarten
43
Entry TypeTransfer Info --> [click on current enrollment] --> Entry Code[Students]EntryCode, [ReEnrollments]EntryCode
44
Exit Withdraw DateTransfer Info --> [click on current enrollment] --> Exit Date[S_CO_STU_X]Grad_Date, [Students]ExitDate, [ReEnrollments]ExitDate
45
Exit Withdraw TypeTransfer Info --> [click on current enrollment] --> Exit Code[S_CO_STU_X]SeniorExitCode, [Students]ExitCode, [ReEnrollments]ExitCode
46
Retention CodeState/Province - CO --> CO Demographics --> Retention Code[S_CO_STU_X]Retention_Code, [S_CO_REN_X]Retention_Code
47
Pupil's Attendance InformationTransfer Info --> [click on current enrollment] --> Pupils Attendance/Residence Information[S_CO_STU_X]Attend_Info, [S_CO_REN_X]Attend_Info
48
County Code of Residence for Joint School DistrictsTransfer Info --> [click on current enrollment] --> County Code for Parents Residence…[S_CO_STU_X]County_Joint_District, [S_CO_REN_X]County_Joint_District
49
District of Parent's ResidenceTransfer Info --> [click on current enrollment] --> District Code for Parents Residence…[S_CO_STU_X]Parent_Res_District, [S_CO_REN_X]Parent_Res_District
50
Country of Parent's ResidenceTransfer Info --> [click on current enrollment] --> Country Code for Parents Residence…[S_CO_STU_X]Parent_Res_Country, [S_CO_REN_X]Parent_Res_Country
51
State of Parent's ResidenceTransfer Info --> [click on current enrollment] --> State Code for Parents Residence…[S_CO_STU_X]Parent_Res_State, [S_CO_REN_X]Parent_Res_State
52
Public School Finance Funding StatusTransfer Info --> [click on current enrollment] --> Status for Public School Finance Act Funding[S_CO_STU_X]Status_For_Funding, [S_CO_REN_X]Status_For_Funding
53
Date First Enrolled in USTransfer Info --> [click on current enrollment] --> Date First Enrolled in the U.S.[S_CO_STU_X]Date_First_Enrolled_US, [S_CO_REN_X]Date_First_Enrolled_US
54
Primary Schooldefaults to 1Always 1
55
Indepdendent StudyState/Province - CO --> CO Demographics --> Independent Study[S_CO_REN_X]IndependentStudy, [S_CO_STU_X]IndependentStudy
56
Expelled EducationState/Province - CO --> CO Demographics --> Expelled with Educational Services[S_CO_STU_X]Expelled, [S_CO_REN_X]Expelled
57
Home Based EducationState/Province - CO --> CO Demographics --> Home Based Education[S_CO_STU_X]HomeBasedEd, [S_CO_REN_X]HomeBasedEd
58
Gifted General IntellectState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_General_Intellect, [S_CO_REN_X]Gifted_General_Intellect
59
Gifted CreativityState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Creativity, [S_CO_REN_X]Gifted_Creativity
60
Gifted LeadershipState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Leadership, [S_CO_REN_X]Gifted_Leadership
61
Gifted ReadingState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Reading, [S_CO_REN_X]Gifted_Reading
62
Gifted WritingState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Writing, [S_CO_REN_X]Gifted_Writing
63
Gifted MathState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Math, [S_CO_REN_X]Gifted_Math
64
Gifted ScienceState/Province - CO --> Gifted --> [check appropriate box(es)]
[S_CO_STU_X]Gifted_Science, [S_CO_REN_X]Gifted_Science
65
Gifted Social StudiesState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Social_Studies, [S_CO_REN_X]Gifted_Social_Studies
66
Gifted World LangaugeState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_World_Language, [S_CO_REN_X]Gifted_World_Language
67
Gifted Visual ArtsState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Visual_Arts, [S_CO_REN_X]Gifted_Visual_Arts
68
Gifted Drama and TheaterState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Drama_Theater, [S_CO_REN_X]Gifted_Drama_Theater
69
Gifted MusicalState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Music, [S_CO_REN_X]Gifted_Music
70
Gifted DanceState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Dance, [S_CO_REN_X]Gifted_Dance
71
Gifted PsychomotorState/Province - CO --> Gifted --> [check appropriate box(es)][S_CO_STU_X]Gifted_Psychomotor, [S_CO_REN_X]Gifted_Psychomotor
72
Non-School ProgramState/Province - CO --> CO Demographics --> Non-School Program[S_CO_STU_X]NonSchoolPrgm, [S_CO_REN_X]NonSchoolPrgm
73
Days AttendedCalculated based on daily recorded attendanceCalculated.
74
Days Excused Calculated based on daily recorded attendanceCalculated.
75
Days UnexcusedCalculated based on daily recorded attendanceCalculated.
76
Total Possible Attendance DaysCalculated based on daily recorded attendanceCalculated.
77
Habitually Truant StatusCalculated based on daily recorded attendanceCalculated.
78
Total Missed Days Due to OSSCalculated based on daily recorded attendance and disciplinesCalculated.
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100