Entity CourseSchedule

Description of Entity CourseSchedule

This determines if a course is available for registration (via a Training record).


List of all Dependencies of the Entity CourseSchedule

Name

Code

Class Name

Relation_293549

Relation_293549

Reference

Relation_287053

Relation_287053

Reference

Relation_216739

Relation_216739

Reference

Relation_216738

Relation_216738

Reference

Relation_296810

Relation_296810

Reference

Relation_274438

Relation_274438

Reference

Relation_274439

Relation_274439

Reference

Relation_287502

Relation_287502

Reference


List of Attributes of the Entity CourseSchedule

Name

Code

Course Code

CourseCode

Organisation Code

OrganisationCode

CourseScheduleSysId

CourseScheduleSysId

Course Date From

CourseStartDate

Start Time

CourseStartTime

Course Date To

CourseEndDate

End Time

CourseEndTime

Duration

CourseDuration

Unit

CourseUnit

Course Fee

CourseFee

Remarks

CourseRemarks


Entity Attribute Course Code of the Entity CourseSchedule

Card of Attribute Course Code of the Entity CourseSchedule

Name

Course Code

Code

CourseCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Course Code of the Entity CourseSchedule

Shows the code for the course. This is the primary key for the Course table.


Entity Attribute Organisation Code of the Entity CourseSchedule

Card of Attribute Organisation Code of the Entity CourseSchedule

Name

Organisation Code

Code

OrganisationCode

Data Type

char(20)

Mandatory

No


Description of Attribute Organisation Code of the Entity CourseSchedule

Shows the organisation code. This code is the same as the reference number. It is also the primary key for the Organisation table.


Entity Attribute CourseScheduleSysId of the Entity CourseSchedule

Card of Attribute CourseScheduleSysId of the Entity CourseSchedule

Name

CourseScheduleSysId

Code

CourseScheduleSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CourseScheduleSysId of the Entity CourseSchedule

A system generated identity. It is blind to the user. This is the primary key for the CourseSchedule table.


Entity Attribute Course Date From of the Entity CourseSchedule

Card of Attribute Course Date From of the Entity CourseSchedule

Name

Course Date From

Code

CourseStartDate

Data Type

date

Mandatory

No


Description of Attribute Course Date From of the Entity CourseSchedule

Shows the starting date of the course.
It is in the format: DD-MM-YYYY.


Entity Attribute Start Time of the Entity CourseSchedule

Card of Attribute Start Time of the Entity CourseSchedule

Name

Start Time

Code

CourseStartTime

Data Type

time

Mandatory

No


Description of Attribute Start Time of the Entity CourseSchedule

Shows the starting time of the course.


Entity Attribute Course Date To of the Entity CourseSchedule

Card of Attribute Course Date To of the Entity CourseSchedule

Name

Course Date To

Code

CourseEndDate

Data Type

date

Mandatory

No


Description of Attribute Course Date To of the Entity CourseSchedule

Shows the end date of the course.
It is in the format: DD-MM-YYYY.


Entity Attribute End Time of the Entity CourseSchedule

Card of Attribute End Time of the Entity CourseSchedule

Name

End Time

Code

CourseEndTime

Data Type

time

Mandatory

No


Description of Attribute End Time of the Entity CourseSchedule

Shows the time for when the course ends.


Entity Attribute Duration of the Entity CourseSchedule

Card of Attribute Duration of the Entity CourseSchedule

Name

Duration

Code

CourseDuration

Data Type

double

Mandatory

No


Description of Attribute Duration of the Entity CourseSchedule

Shows the number for the course duration.
Example: "6" days


Entity Attribute Unit of the Entity CourseSchedule

Card of Attribute Unit of the Entity CourseSchedule

Name

Unit

Code

CourseUnit

Data Type

char(20)

Mandatory

No


Description of Attribute Unit of the Entity CourseSchedule

Shows the unit for the course duration.
Example: Hours / Days / Weeks / Months / Years


Entity Attribute Course Fee of the Entity CourseSchedule

Card of Attribute Course Fee of the Entity CourseSchedule

Name

Course Fee

Code

CourseFee

Data Type

double

Mandatory

No


Description of Attribute Course Fee of the Entity CourseSchedule

Shows the fee of the course.


Entity Attribute Remarks of the Entity CourseSchedule

Card of Attribute Remarks of the Entity CourseSchedule

Name

Remarks

Code

CourseRemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity CourseSchedule

Stores any remarks about the course schedule.