Entity Organisation

Description of Entity Organisation

Information about external organisations are stored here.


List of all Dependencies of the Entity Organisation

Name

Code

Class Name

Relation_238040

Relation_238040

Reference

Relation_244180

Relation_244180

Reference

Relation_274438

Relation_274438

Reference

Relation_366823

Relation_366823

Reference

Relation_389014

Relation_389014

Reference

Relation_389027

Relation_389027

Reference

Relation_397826

Relation_397826

Reference

Relation_401063

Relation_401063

Reference

Relation_423954

Relation_423954

Reference

Relation_265141

Relation_265141

Reference

Relation_480714

Relation_480714

Reference


List of Attributes of the Entity Organisation

Name

Code

Organisation Code

OrganisationCode

Name

OrganisationName

Ref No

OrganisationRefNo

URL

OrganisationURL

Address

Address1

Address2

Address2

Address3

Address3

Country

Country

City

City

State

State

Postal Code

PCode

Contact 1

ContactNo1

Contact 2

ContactNo2

Email

ContactEmail

Contact Fax

ContactFax

Medical Vendor

IsMedicalVendor

Training Organiser

IsTrainingOrganiser

Offer Membership

IsMembership

Contractor

IsContractor

Supplier

IsSupplier

Contractor Code

ContractorCode


Entity Attribute Organisation Code of the Entity Organisation

Card of Attribute Organisation Code of the Entity Organisation

Name

Organisation Code

Code

OrganisationCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Organisation Code of the Entity Organisation

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 Name of the Entity Organisation

Card of Attribute Name of the Entity Organisation

Name

Name

Code

OrganisationName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity Organisation

Shows the name of the organisation.


Entity Attribute Ref No of the Entity Organisation

Card of Attribute Ref No of the Entity Organisation

Name

Ref No

Code

OrganisationRefNo

Data Type

char(20)

Mandatory

No


Description of Attribute Ref No of the Entity Organisation

Shows the reference number for the organisation. This number is the same as the organisation code.


Entity Attribute URL of the Entity Organisation

Card of Attribute URL of the Entity Organisation

Name

URL

Code

OrganisationURL

Data Type

char(100)

Mandatory

No


Description of Attribute URL of the Entity Organisation

Shows the URL of the organisation.


Entity Attribute Address of the Entity Organisation

Card of Attribute Address of the Entity Organisation

Name

Address

Code

Address1

Data Type

char(40)

Mandatory

No


Description of Attribute Address of the Entity Organisation

First line of the address.


Entity Attribute Address2 of the Entity Organisation

Card of Attribute Address2 of the Entity Organisation

Name

Address2

Code

Address2

Data Type

char(40)

Mandatory

No


Description of Attribute Address2 of the Entity Organisation

Second line of the address.


Entity Attribute Address3 of the Entity Organisation

Card of Attribute Address3 of the Entity Organisation

Name

Address3

Code

Address3

Data Type

char(40)

Mandatory

No


Description of Attribute Address3 of the Entity Organisation

Third line of the address.


Entity Attribute Country of the Entity Organisation

Card of Attribute Country of the Entity Organisation

Name

Country

Code

Country

Data Type

char(20)

Mandatory

No


Description of Attribute Country of the Entity Organisation

Stores the country of the person's / organisation's address.


Entity Attribute City of the Entity Organisation

Card of Attribute City of the Entity Organisation

Name

City

Code

City

Data Type

char(20)

Mandatory

No


Description of Attribute City of the Entity Organisation

Stores the city of the person's / organisation's address.


Entity Attribute State of the Entity Organisation

Card of Attribute State of the Entity Organisation

Name

State

Code

State

Data Type

char(20)

Mandatory

No


Description of Attribute State of the Entity Organisation

Stores the state of the person's / organisation's address.


Entity Attribute Postal Code of the Entity Organisation

Card of Attribute Postal Code of the Entity Organisation

Name

Postal Code

Code

PCode

Data Type

char(20)

Mandatory

No


Description of Attribute Postal Code of the Entity Organisation

Stores the postal code of the organisation's address.


Entity Attribute Contact 1 of the Entity Organisation

Card of Attribute Contact 1 of the Entity Organisation

Name

Contact 1

Code

ContactNo1

Data Type

char(20)

Mandatory

No


Description of Attribute Contact 1 of the Entity Organisation

Stores the contact number.


Entity Attribute Contact 2 of the Entity Organisation

Card of Attribute Contact 2 of the Entity Organisation

Name

Contact 2

Code

ContactNo2

Data Type

char(20)

Mandatory

No


Description of Attribute Contact 2 of the Entity Organisation

Stores a second contact number.


Entity Attribute Email of the Entity Organisation

Card of Attribute Email of the Entity Organisation

Name

Email

Code

ContactEmail

Data Type

char(100)

Mandatory

No


Description of Attribute Email of the Entity Organisation

Stores the email address.


Entity Attribute Contact Fax of the Entity Organisation

Card of Attribute Contact Fax of the Entity Organisation

Name

Contact Fax

Code

ContactFax

Data Type

char(20)

Mandatory

No


Description of Attribute Contact Fax of the Entity Organisation

Stores the fax number.


Entity Attribute Medical Vendor of the Entity Organisation

Card of Attribute Medical Vendor of the Entity Organisation

Name

Medical Vendor

Code

IsMedicalVendor

Data Type

smallint

Mandatory

No


Description of Attribute Medical Vendor of the Entity Organisation

Indicates if the organisation is a medical vendor, in a form of a checkbox.


Entity Attribute Training Organiser of the Entity Organisation

Card of Attribute Training Organiser of the Entity Organisation

Name

Training Organiser

Code

IsTrainingOrganiser

Data Type

smallint

Mandatory

No


Description of Attribute Training Organiser of the Entity Organisation

Indicates if the organisation is a training organiser, in a form of a checkbox.


Entity Attribute Offer Membership of the Entity Organisation

Card of Attribute Offer Membership of the Entity Organisation

Name

Offer Membership

Code

IsMembership

Data Type

smallint

Mandatory

No


Description of Attribute Offer Membership of the Entity Organisation

Indicates if the organisation offers membership, in a form of a checkbox.


Entity Attribute Contractor of the Entity Organisation

Card of Attribute Contractor of the Entity Organisation

Name

Contractor

Code

IsContractor

Data Type

smallint

Mandatory

No


Description of Attribute Contractor of the Entity Organisation

Indicates if the organisation is a contractor, in a form of a checkbox.


Entity Attribute Supplier of the Entity Organisation

Card of Attribute Supplier of the Entity Organisation

Name

Supplier

Code

IsSupplier

Data Type

smallint

Mandatory

No


Description of Attribute Supplier of the Entity Organisation

Indicates if the organisation is a supplier, in a form of a checkbox.


Entity Attribute Contractor Code of the Entity Organisation

Card of Attribute Contractor Code of the Entity Organisation

Name

Contractor Code

Code

ContractorCode

Data Type

char(20)

Mandatory

No


Description of Attribute Contractor Code of the Entity Organisation

Displays the contractor code.