pvStudentCoursesFinancial


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StudentCoursesSeq int 4 null
ID int 4 null
CoursesSeq int 4 null
CourseFileType varchar 5 null
Coursecampus varchar 3 null
CourseCode varchar 15 null
CourseCodeFull varchar 20 √ null
sqlcCourseCode varchar 20 √ null
CourseDescription varchar 100 √ null
CourseColumn smallint 2 null
CourseStatus varchar 15 null
CourseStatusDate datetime 16,3 √ null
CourseStatusDescription varchar 255 null
CourseStatusMeaning varchar 30 √ null
EnquiryDate datetime 16,3 √ null
ApplicationDate datetime 16,3 √ null
EnrolDate datetime 16,3 √ null
CompletedDate datetime 16,3 √ null
DeferredOnDate datetime 16,3 √ null
DeferredTillDate datetime 16,3 √ null
StudentCourseNote varchar 255 null
AgentID int 4 √ null
CourseAgentCommissionControlSeq int 4 √ null
CommissionPayableFlag bit 1 null
CertificateIssuedFlag bit 1 null
CourseDeposit money 21,4 √ null
CourseInstalmentType varchar 1 null
CourseInstalmentNumber smallint 2 √ null
LinkedCoursesSeq int 4 √ null
LinkedCourseCode varchar 15 √ null
LinkedCourseCodeFull varchar 20 √ null
LinkedCourseDescription varchar 100 √ null
TotalFeeAmount money 21,4 √ null
TotalChargedAmount money 21,4 √ null
TotalPaidAmount money 21,4 √ null
TotalOwingAmount money 21,4 √ null
StartDate datetime 16,3 √ null
EndDate datetime 16,3 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views