Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt

This section supplies a list of the data fields a .NET database interface needs to support. For  for samples, please refer to the Noah 4 Business System Development page on himsa.com.

The database interface is necessary for the Noah 4 system to communicate with a Business System vendor’s database. A description of the objects used by Noah when interfacing to its own database is supplied. Developers can use this as a reference when designing their own database interface.

Required Data Fields

The tables below only list information relevant to the Noah 4 Managed Database Interface. The issue of inter-table relations has not been considered.  The information listed in these tables should only be considered as an absolute minimum set of fields; it is possible, of course, to choose to have as many fields in the database as are deemed necessary.

NOTE: Some of the methods could potentially corrupt the relational integrity of the database. It is the implementers’ responsibility to prevent this.

Patient Table

Field

Type

Description

ID

Int32

Unique (within the database) Patient identifier

PatientGUID

Guid

Global unique patient identifier

ActivePatient

Short

1=true, 0 = false

PatientNo

String(20)

Dispenser’s Patient identification

CreateDate

DateTime

Date of record creation

FirstName

String(30)

Patient’s First Name

LastName

String(30)

Patient’s Last Name

MiddleName

String(30)

Patient’s Middle Name

Gender

Short (enum)

Patient’s Gender {0=Unknown,1=Male,2=Female}

BirthDate

DateTime

Patient’s Birth date

Salutation

String(30)

Salutation

Title

String(30)

Title

Address1

String(30)

Address line 1

Address2

String(30)

Address line 2

Address3

String(30)

Address line 3

Province

String(30)

Province or State

Zip

String(20)

Zip Code

City

String(30)

City

Country

String(30)

Country

 

 

 

HomePhone

String(30)

Home phone

WorkPhone

String(30)

Work phone

MobilePhone

String(30)

Mobile phone

EMail

String(50)

Email

SSNumber

String(20)

Social security number

Physician

String(30)

Main Physician

Referral

String(30)

Physician being referred to

Insurance1

String(30)

Insurance information

Insurance2

String(30)

Insurance information

Other1

String(30)

Other 1

Other2

String(30)

Other 2


NOTE :   The setup tables below, for both user and patient, store setup data as BLOB files. The setup data consist of user, or patient, preferences. For example, NOAHaud stores profile settings as User Setup data. Thus, if a user moves to a different workstation in a network, the user’s specific profile-settings are automatically transferred to that workstation.

Patient Setup Table

Field

Type

Description

PatientID

Int32

ID of associated patient (> patient table)

ModuleID

Int32

ID of module that added this setup

SetupData

BLOB

Maximum BLOB size can be retrieved through BusinessAPI, GetNoahProperties , MaxSetupBlobSize


User Table

Field

Type

Description

UserID

Int32

Unique identifier for user

CreateDate

DateTime

Date of record creation

UserInitials

String(3)

Three letter initials used for logon

UserName

String(30)

Full user name


Action Table

Field Name

Type

Description

ID

Int32

Unique identifier for action

(NOTE: An Action object holds information about an action performed during a patient’s visit. In addition to the actual action data, an Action object contains information about what kind of action it is, what user created it, a description of the action and a reference to an Actions collection of referenced actions. A reference, which is of type long, holds an ActionID of the action it is referencing. ActionReferences link, for example, audiograms to selections/fittings.)

SessionID

Int32

ID of session in which the action belongs (> session)

UserID

Int32

ID of user who created the action (> user table)*

CreateDate

DateTime

Date of creation

LastModifiedDate

DateTime

Date of last modification

Description

String(64)

Description of the action

ModuleID

Int32

ID of module that created the action

DeviceType

Short

Module specific code for external equipment

DataTypeCode

Short

Code describing the action

DataFmtStd

Short

Code describing the format of the PublicData field

DataFmtExt

Short

Code describing the format of the private part of the PublicData field

Removed

BOOL

Action marked as removed

Hidden

BOOL

Action marked as hidden

PublicBlob

BLOB

Maximum BLOB size can be retrieved through BusinessAPI, GetNoahProperties , MaxBigBlobSize

PrivateBlob

BLOB

Maximum BLOB size can be retrieved through BusinessAPI, GetNoahProperties , MaxSmallBlobSize

ActionGroup

DateTime

Value used for Action grouping.


*Action records must not be deleted if the referenced user is deleted.


Session Table

Field Name

Type

Description

ID

Int32

Unique identifier for session

PatientID

Int32

ID of patient the session belongs to (> patient table)

CreateDate

DateTime

Date of creation (when first action was added)


FastView Table

Field Name

Type

Description

ActionID

Int32

The ID of the action this FastView is related to

LastModifiedDate

Int32

Date of last modification

CreateDate

DateTime

Date of creation

Data

BLOB

Maximum BLOB size can be retrieved through BusinessAPI, GetNoahProperties , MaxFastViewBlobSize

Format

Int32

Pdf = 1, Rtf = 2, Jpg = 3

Version

Int32

Version