PowerSchool SIS Wyoming

S_WY_CRS_X (ver 15.8.0)

This table is an extension of the Courses table.

Column Name

Version

Data Type

Description

CoursesDCID

15.8.0

 Number(10,0)         

Primary Key

InstructionLevel

15.8.0

Varchar2(2)

Instruction Level for the course. Migrated from [Courses.WY_Instruction_Level].

MediumOfInst

15.8.0

Varchar2(2)

Medium of Instruction for the course. Migrated from [Courses.WY_Medium_Of_Inst].

ProviderID

15.8.0

Varchar2(7)

WDE ID of the School or Institution that is the service provider of the course. This is required only if the service provider is not the current school. Migrated from [Courses.WY_Provider_ID].

Milestones

15.8.0

Number(11,0)

Milestones for the course. This is required only if the Medium of Instruction of the course is Distance Education or Correspondence Instruction. Migrated from [Courses.WY_Milestones].

ScholarshipCourse

15.8.0

Varchar2(1)

Identifies course as a Diploma course. Migrated from [Courses.WY_Scholarship_Course].

DeliveryMethod

18.6.0

Varchar2(20)

Method of Delivery for a virtual education course.

VirtualEducation

18.6.0

Varchar2(1)

Identifies course as a virtual education course.

CareerTechnicalEducation

18.6.0

Varchar2(1)

Identifies course as a career and technical education course.

CollegeConcurrent

18.6.0

Varchar2(1)

Identifies course as a college concurrent course.

CreditRecovery

18.6.0

Varchar2(1)

Identifies course as a credit recovery course.