Export from Child/Virtual Table (Ohio test results)

nteeters
Journeyman

Export from Child/Virtual Table (Ohio test results)

Hello!

 

Would like to use DDE, Quick Export, or an Export Template that will export values from our FA tab in PowerSchool. The table information is below which states "This table is a child table of the [Students] table."

 

I have not had success with identifying the fields for export, such as these which do not seem to work:

 

[students.s_oh_stu_assessment_c]test_type

[students]s_oh_stu_assessment_c.test_type

 

Thank you for any information you can share!

S_OH_STU_ASSESSMENT_C ver 17.8.0

This table is a child table of the [Students] table.

Column Name

Version

Data Type

Description

ID

17.8.0

Number(10)

Primary key that relates the extended table back to the Students table.

ForeignKey17.8.0Number(11)The Student ID associated with the student for this record. Migrated from [Oh_Student_Assessment.foreignKey].
Assessment_Area17.8.0Varchar2(4)
A one to four character code that identifies the test or subject area of the assessment administered. Migrated from [OH_Student_Assessment.assessment_area].
Import_ID17.8.0Number(11)Used by the FA Import functionality to remove tests. Migrated from [OH_Student_Assessment.user_defined_integer].
Performance_Level17.8.0Varchar2(1)The Performance Level achieved. Used for Grad Pathways and not state reportable. Migrated from [OH_Student_Assessment.performance_level].
Promotion_status_yn17.8.0Varchar2(1)Indication of student's status for promotion based on test results.  Obsolete prior to FY17. Migrated from [OH_Student_Assessment.promotion_status].
Required_Test_Type17.8.0Varchar2(3)The type of test/form of the assessment reported on the record. Migrated from [OH_Student_Assessment.required_test_type].
Schoolid17.2.0Number(11)The School building associated with the assessment. Migrated from [OH_Student_Assessment.schoolid].
Score17.8.0Varchar2(3)A three character field containing the score on the reported assessment. Migrated from [OH_Student_Assessment.score].
Score_not_Reported17.8.0Varchar2(1)
Identifies the reason why the student did not take the required assessment and/or does not have a score to report. Migrated from [OH_Student_Assessment.score_not_reported].
Student_Grade_Level17.8.0Varchar2(2)
The grade level of the student at the time the reported assessment was administered. Migrated from [OH_Student_Assessment.student_grade_level].
Test_Type17.8.0Varchar2(2)Two letter code that identifies the test. Migrated from [OH_Student_Assessment.test_type].
Test_Grade_Level17.8.0Varchar2(2)The grade level of the assessment administered. Migrated from [OH_Student_Assessment.test_grade_level].
Test_Date17.8.0Varchar2(6)The date the test was administered in year and month (YYYYMM). Migrated from [OH_Student_Assessment.test_date].
Test_Day17.8.0Number(11)The day of the month the test was administered. Migrated from [OH_Student_Assessment.test_day].
Type_of_Accommodation17.8.0Varchar2(2)The accommodation received by the student, if any. Migrated from [OH_Student_Assessment.type_of_accommodation].
Exclude_from_FA17.9.0BooleanThis is used to exclude a record from the FA Student Assessment Report.

 

 

 

0 Replies