PowerSchool SIS Oregon

S_OR_REN_CTE_X (ver 14.6.0)

This table is an extension of the [Reenrollments] table. These fields are related to Career and Technical Education.

Column Name

Version

Data Type

Description

ReEnrollmentsDCID

14.6.0

Number(10,0)

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

AcdmDsvntgFg

15.10.3

Number(1,0)

Indicates the student is academically disadvantaged and requires special services and assistance in order to succeed. Migrated from [ReEnrollments.OR_PTEAcdmDisadv].

Asmt1AdminDt

15.10.3

Date

The date the first CTE assessment was administered. Migrated from [ReEnrollments.OR_CTEAsmt1AdminDt].

Asmt1PassCd

15.10.3

Varchar2(1)

The pass status for the first CTE assessment. Migrated from [ReEnrollments.OR_CTEAsmt1PassCd].

Asmt1TypCd

15.10.3

Varchar2(2)

Indicates the first CTE assessment type. Migrated from [ReEnrollments.OR_CTEAsmt1TypCd].

Asmt2AdminDt

15.10.3

Date

The date the second CTE assessment was administered. Migrated from [ReEnrollments.OR_CTEAsmt2AdminDt].

Asmt2PassCd

15.10.3

Varchar2(1)

The pass status for the second CTE assessment. Migrated from [ReEnrollments.OR_CTEAsmt2PassCd].

Asmt2TypCd

15.10.3

Varchar2(2)

Indicates the second CTE assessment type. Migrated from [ReEnrollments.OR_CTEAsmt2TypCd].

AssessmentIDCode1

15.10.3

Varchar2(10)

CTE Technical Skill/Credential Identification Code for first assessment.

AssessmentIDCode2

15.10.3

Varchar2(10)

CTE Technical Skill/Credential Identification Code for the second assessment.

CareerRltdLrnExp1

15.10.3

Varchar2(1)

Code indicating the first type of Career-Related Learning Experience in which the student participated. Migrated from [ReEnrollments.OR_PTECareerRltdLrnExp1].

CareerRltdLrnExp2

15.10.3

Varchar2(1)

Code indicating the second type of Career-Related Learning Experience in which the student participated. Migrated from [ReEnrollments.OR_PTECareerRltdLrnExp2].

CareerRltdLrnExp3

15.10.3

Varchar2(1)

Code indicating the third type of Career-Related Learning Experience in which the student participated. Migrated from [ReEnrollments.OR_PTECareerRltdLrnExp3].

CareerRltdLrnExp4

15.10.3

Varchar2(1)

Code indicating the fourth type of Career-Related Learning Experience in which the student participated. Migrated from [ReEnrollments.OR_PTECareerRltdLrnExp4].

CTEAsmt1CIPCd

14.6.0

Varchar2(7)

NCES Classification of Instructional Programs (CIP) code indicating the career area and program area for the first assessment taken by the student with one implied decimal point (format: XX.XXXX)

CTEAsmt2CIPCd

14.6.0

Varchar2(7)

NCES Classification of Instructional Programs (CIP) code indicating the career area and program area for the second assessment taken by the student with one implied decimal point (format: XX.XXXX)

StdntLdrOrg1

15.10.3

Varchar2(1)

Code indicating the first type of Student Leadership Organization to which the student belongs. Migrated from [ReEnrollments.OR_PTEStdntLdrOrg1].

StdntLdrOrg2

15.10.3

Varchar2(1)

Code indicating the second type of Student Leadership Organization to which the student belongs. Migrated from [ReEnrollments.OR_PTEStdntLdrOrg2].

StdntLdrOrg3

15.10.3

Varchar2(1)

Code indicating the third type of Student Leadership Organization to which the student belongs. Migrated from [ReEnrollments.OR_PTEStdntLdrOrg3].

StdntLdrOrg4

15.10.3

Varchar2(1)

Code indicating the fourth type of Student Leadership Organization to which the student belongs. Migrated from [ReEnrollments.OR_PTEStdntLdrOrg4].

YrEndStatus

15.10.3

Varchar2(1)

Code indicating the student's status as of the end of the school year. Migrated from [ReEnrollments.OR_PTEYrEndStatus].