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 nameRequired Data Fields
Manage space
Manage content
Integrations