Entity Course

Description of Entity Course

Each training course, conducted internally or externally, needs to have a course record before it can be used in the employee's training record.


List of all Dependencies of the Entity Course

Name

Code

Class Name

Relation_216783

Relation_216783

Reference

Relation_216746

Relation_216746

Reference

Relation_216732

Relation_216732

Reference

Relation_274444

Relation_274444

Reference

Relation_287502

Relation_287502

Reference

Relation_216717

Relation_216717

Reference

Relation_353212

Relation_353212

Reference

Relation_353217

Relation_353217

Reference


List of Attributes of the Entity Course

Name

Code

Course Code

CourseCode

Course Level

CourseLevel

Active

CourseActive

Description

CourseDesc

Title

CourseTitle

Reference No

CourseRefNo

Bond Duration

CourseBondDuration

Bond Unit

CourseBondUnit

Language

CourseLanguage


Entity Attribute Course Code of the Entity Course

Card of Attribute Course Code of the Entity Course

Name

Course Code

Code

CourseCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Course Code of the Entity Course

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


Entity Attribute Course Level of the Entity Course

Card of Attribute Course Level of the Entity Course

Name

Course Level

Code

CourseLevel

Data Type

integer

Mandatory

No


Description of Attribute Course Level of the Entity Course

Shows the level of the course.


Entity Attribute Active of the Entity Course

Card of Attribute Active of the Entity Course

Name

Active

Code

CourseActive

Data Type

smallint

Mandatory

No


Description of Attribute Active of the Entity Course

Indicates if the course is active or not, in a form of a checkbox.


Entity Attribute Description of the Entity Course

Card of Attribute Description of the Entity Course

Name

Description

Code

CourseDesc

Data Type

char(100)

Mandatory

No


Description of Attribute Description of the Entity Course

Stores a description about the course.


Entity Attribute Title of the Entity Course

Card of Attribute Title of the Entity Course

Name

Title

Code

CourseTitle

Data Type

char(100)

Mandatory

No


Description of Attribute Title of the Entity Course

Shows the title of the course.
Example: Customer Service / Financial Course etc


Entity Attribute Reference No of the Entity Course

Card of Attribute Reference No of the Entity Course

Name

Reference No

Code

CourseRefNo

Data Type

char(50)

Mandatory

No


Description of Attribute Reference No of the Entity Course

Shows the reference number of the course.


Entity Attribute Bond Duration of the Entity Course

Card of Attribute Bond Duration of the Entity Course

Name

Bond Duration

Code

CourseBondDuration

Data Type

double

Mandatory

No


Description of Attribute Bond Duration of the Entity Course

Shows the duration of the bond for the course.


Entity Attribute Bond Unit of the Entity Course

Card of Attribute Bond Unit of the Entity Course

Name

Bond Unit

Code

CourseBondUnit

Data Type

char(20)

Mandatory

No


Description of Attribute Bond Unit of the Entity Course

Shows the unit of the bond.
Example: Months / Years


Entity Attribute Language of the Entity Course

Card of Attribute Language of the Entity Course

Name

Language

Code

CourseLanguage

Data Type

char(20)

Mandatory

No


Description of Attribute Language of the Entity Course

Shows what language the course would be held in.