pvCourses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CoursesSeq int 4 null
FileType varchar 5 null
CourseCampus varchar 3 null
CourseCode varchar 15 null
CourseCodeFull varchar 20 √ null
Description varchar 100 √ null
ClassificationCode varchar 15 null
CourseCost money 21,4 √ null
Deposit money 21,4 √ null
InstalmentType varchar 1 null
InstalmentNumber smallint 2 √ null
InstalmentAmount money 21,4 √ null
CourseHoldFlag bit 1 null
CertificateFlag bit 1 null
FeeCode varchar 15 null
DepartmentCode varchar 8 null
CourseNote varchar 2000 √ null
ProgramCode varchar 15 null
StartDate datetime 16,3 √ null
EndDate datetime 16,3 √ null
DurationWeeks smallint 2 √ null
ValedictionDate datetime 16,3 √ null
CRICOSCode varchar 15 null
OSHCMonths smallint 2 √ null
FirstInstallPercent decimal 7,2 √ null
LinkedCourseCampus varchar 3 √ null
LinkedCoursesSeq int 4 √ null
LinkedCourseCode varchar 15 √ null
LinkedCourseCodeFull varchar 20 √ null
LinkedCourseDescription varchar 100 √ null
ActiveFlag bit 1 null
EnrolmentOpenDate datetime 16,3 √ null
EnrolmentClosedDate datetime 16,3 √ null
CourseAgentCommissionControlSeqDefault int 4 √ null
AlternateFinishDate datetime 16,3 √ null
FilingNumber varchar 30 null
EnrolmentOpenFlag bit 1 √ null
CommissionLinkCoursesSeq int 4 √ null
CommissionLinkCourseCode varchar 15 √ null
CommissionLinkCourseDescription varchar 100 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views