This section supplies a list of the data fields a .NET database interface needs to support. For detailed information on the interfaces implemented from the Noah side, and for samples, please refer to the document on creating a database interface to Noah 4. 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. 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)Required Data Fields
Manage space
Manage content
Integrations