Entity CourseContact

Description of Entity CourseContact

A Contact tab on the Course Scheduler window is for recording the contact person or persons in charge of the training course. This may be employees in the company or from the training provider.


List of all Dependencies of the Entity CourseContact

Name

Code

Class Name

Relation_313029

Relation_313029

Reference

Relation_216738

Relation_216738

Reference


List of Attributes of the Entity CourseContact

Name

Code

Course Code

CourseCode

CourseContactSysId

CourseContactSysId

Contact > Person

ContactPerson

Contact 1

ContactNo1

Contact 2

ContactNo2

Contact Fax

ContactFax

Email

ContactEmail


Entity Attribute Course Code of the Entity CourseContact

Card of Attribute Course Code of the Entity CourseContact

Name

Course Code

Code

CourseCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Course Code of the Entity CourseContact

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


Entity Attribute CourseContactSysId of the Entity CourseContact

Card of Attribute CourseContactSysId of the Entity CourseContact

Name

CourseContactSysId

Code

CourseContactSysId

Data Type

integer

Mandatory

Yes


Description of Attribute CourseContactSysId of the Entity CourseContact

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


Entity Attribute Contact > Person of the Entity CourseContact

Card of Attribute Contact > Person of the Entity CourseContact

Name

Contact > Person

Code

ContactPerson

Data Type

char(50)

Mandatory

No


Description of Attribute Contact > Person of the Entity CourseContact

Shows the name of the person to contact other than the employee.


Entity Attribute Contact 1 of the Entity CourseContact

Card of Attribute Contact 1 of the Entity CourseContact

Name

Contact 1

Code

ContactNo1

Data Type

char(20)

Mandatory

No


Description of Attribute Contact 1 of the Entity CourseContact

Stores the contact number.


Entity Attribute Contact 2 of the Entity CourseContact

Card of Attribute Contact 2 of the Entity CourseContact

Name

Contact 2

Code

ContactNo2

Data Type

char(20)

Mandatory

No


Description of Attribute Contact 2 of the Entity CourseContact

Stores a second contact number.


Entity Attribute Contact Fax of the Entity CourseContact

Card of Attribute Contact Fax of the Entity CourseContact

Name

Contact Fax

Code

ContactFax

Data Type

char(20)

Mandatory

No


Description of Attribute Contact Fax of the Entity CourseContact

Stores the fax number.


Entity Attribute Email of the Entity CourseContact

Card of Attribute Email of the Entity CourseContact

Name

Email

Code

ContactEmail

Data Type

char(100)

Mandatory

No


Description of Attribute Email of the Entity CourseContact

Stores the email address.