Entity ReviewAttachment

Description of Entity ReviewAttachment

It is for uploading an external document, e.g. MS Word (.docx), where the uploaded document will be stored in the Sage EasyPay Enterprise database.


List of all Dependencies of the Entity ReviewAttachment

Name

Code

Class Name

Relation_389026

Relation_389026

Reference


List of Attributes of the Entity ReviewAttachment

Name

Code

MedExRecSysId

MedExRecSysId

ReviewAttachSysId

ReviewAttachSysId

Attached Date

AttachDate

Attachment

Attachment

File Type

AttachFileType

Remarks

Remarks

Medical Result

IsMediExamResult


Entity Attribute MedExRecSysId of the Entity ReviewAttachment

Card of Attribute MedExRecSysId of the Entity ReviewAttachment

Name

MedExRecSysId

Code

MedExRecSysId

Data Type

integer

Mandatory

Yes


Description of Attribute MedExRecSysId of the Entity ReviewAttachment

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


Entity Attribute ReviewAttachSysId of the Entity ReviewAttachment

Card of Attribute ReviewAttachSysId of the Entity ReviewAttachment

Name

ReviewAttachSysId

Code

ReviewAttachSysId

Data Type

integer

Mandatory

Yes


Description of Attribute ReviewAttachSysId of the Entity ReviewAttachment

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


Entity Attribute Attached Date of the Entity ReviewAttachment

Card of Attribute Attached Date of the Entity ReviewAttachment

Name

Attached Date

Code

AttachDate

Data Type

date

Mandatory

No


Description of Attribute Attached Date of the Entity ReviewAttachment

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


Entity Attribute Attachment of the Entity ReviewAttachment

Card of Attribute Attachment of the Entity ReviewAttachment

Name

Attachment

Code

Attachment

Data Type

long binary

Mandatory

No


Description of Attribute Attachment of the Entity ReviewAttachment

Shows the attachment.


Entity Attribute File Type of the Entity ReviewAttachment

Card of Attribute File Type of the Entity ReviewAttachment

Name

File Type

Code

AttachFileType

Data Type

char(20)

Mandatory

No


Description of Attribute File Type of the Entity ReviewAttachment

Shows the type of file to attach.
Example: PDF (.pdf) / Word document (.doc) etc


Entity Attribute Remarks of the Entity ReviewAttachment

Card of Attribute Remarks of the Entity ReviewAttachment

Name

Remarks

Code

Remarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity ReviewAttachment

Store remarks.


Entity Attribute Medical Result of the Entity ReviewAttachment

Card of Attribute Medical Result of the Entity ReviewAttachment

Name

Medical Result

Code

IsMediExamResult

Data Type

smallint

Mandatory

No


Description of Attribute Medical Result of the Entity ReviewAttachment

Indicates if the attachment is regarding the medical results, in a form of a checkbox.