Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Unique Architecture generated objectID of this table. |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Not used |
Description | varchar(187) | NULL | Can be vaued by the user as Healthcare Professional Name. Format : First Name, Middle Name, Last Name. |
IsVersioned | bit | NOT NULL | Indicates if any changes were done on a row. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | ObjectID of the user that created the row. |
CreationTime | smalldatetime | NULL | Date/time of when the row is created |
Name | varchar(187) | NULL | Name of the external healthcare professional |
RegistrationNo | varchar(20) | NULL | Registration No of the external healthcare professional |
WorkPlace | varchar(255) | NULL | Workplace address information of the healthcare professional. |
RelationType | varchar(5) | NULL | Healthcare professional relation type to the patient. Entered by the user as free text. For example : PCP. |
ExternalID | varchar(20) | NULL | StaffID of the professional if he's registered to any affiliate hospital |
ExternalStaffType | tinyint | NULL | Not Used. |
|