ReportHTML

Entity [Attachment]

Description

This entity holds the information of user (HCP/Client) provided attachment.

The anchor point of an attachment could be either at the package level or to a specific form inside the package.

Because the metadata of attachments is quite different from the Forms, this deserves a separate entity.

List of attributes

Attachment ID

The primary key in form of GUID.

Char (32)

Parent ID

To which entity this attachment belongs. It can be either a reference to the GUID key in Package, or a reference to the GUID key in FormReceived.

With GUID as the key, system does not have to capture parent type (Package/FormReceived). Can be altered at physical implementation.

Char (32)

Originating Communication ID

An attachment can also be an acquisition during the adjudication process as a result of communication, in which case, trace to the communication ID may be needed.

Chart (32)

Status Code

The status code of this attachment.
Received
PDF converted?
OPSDoc Integrated
Adjudication process status(e.g.):
Reviewed
Require more supporting document
... ...

Varchar (20)

Receive Date

Same as in the FormReceived entity.

Date & Time

OPSDoc Integration Date

Same as in the FormReceived entity.

Date & Time

Receive Channel ID

Same as in the FormReceived entity.

Integer

Format Type Code

Same as in the FormReceived entity.

Varchar (20)

Original Name

The original document name when user uploaded this attachment.

Varchar (100)

Checksum

Same as in the FormReceived entity.

Varchar (100)

Original Object ID

Repository created document key for the original formation (vs converted PDF version).

Varchar (100)

Conversion Date

The datetime if this form is converted to PDF view.

Varchar (100)

Conversion Checksum

The checksum of converted PDF view.

Varchar (100)

OPSDoc Object ID

Repository created document key for the attachment. If the attachment is converted to pdf view, this object ID should be the reference to the PDF version. The Original Object ID should reference the original document.

Varchar (100)

OPSDoc Name

Same as in the FormReceived entity.

Varchar (100)

JSON Received

Same as in the FormReceived entity.

Long binary

JSON OPSDoc

Same as in the FormReceived entity.

Long binary

Date Created

The data and time this record was created.

Date & Time

Date Updated

The data and time this record was last updated. For the full update history should be captured with an audit table.

Date & Time

Created By

The ID/Code of the user/system component who created this record.

Varchar (20)

Updated By

The ID/Code of the user/system component who last updated this record.

Varchar (20)

Home