Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectID of the staff created |
InstanceHFCID | smallint | NOT NULL | InstanceHFCID of the staff created |
RecordId | int | NULL | Not Used. |
Description | varchar(187) | NULL | Description about the staff created. User can value this field to the staff name(Format: First,Middle,Last). |
IsVersioned | bit | NOT NULL | Describes about the row is modified or not. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserID of the person who created the staff record. |
CreationTime | smalldatetime | NULL | Date and Time when the staff record is created. |
StaffID | varchar(30) | NOT NULL | Staff's internal identifier - system generated next available number. |
ExternalID | varchar(20) | NULL | Staff's External Identifier - Unique identifier for external staff. |
PrescriberCode | varchar(75) | NULL | Staff's prescriber code - DEA Number |
| | | Identifier assigned to a health care provider(such as a physician, physician assistant, nurse practitioner, optometrist, dentist, or veterinarian) by the United States Drug Enforcement Administration allowing them to write prescriptions for controlled substances. |
ActivationDate | smalldatetime | NOT NULL | Staff's Activation date and time - Date when staff member became active. |
InactivationDate | datetime | NULL | Staff's Inactivation date and time - Date when staff member became InActive. |
Active | bit | NULL | Active indicator. Allowable Values: 0 - Not Active 1 - Active |
DateEnteredPractice | datetime | NULL | Date and time when the staff has started to practice. |
StaffType | tinyint | NOT NULL | StaffType. Allowable values : 0-Medical,1-Paramedical,2-Nursing,3-Support,4-OtherStaff,5-ExternalProvider,6-ExternalProviderOrg. |
IsSchedulable | bit | NULL | describes whether the staff can be scheduled or not. Allowable values: 0 - false, 1 - True |
Name | varchar(187) | NOT NULL | Full Name of the staff. Format : Last Name, First Name, Middle Name. |
MSINumber | varchar(30) | NULL | Staff's MSI number |
StaffSignature | varchar(75) | NULL | Staff Signature |
Remarks | varchar(255) | NULL | Any remarks about the staff entered by admin user. |
IsUser | bit | NULL | Denotes whether this staff is also a user or not. Allowable values : Null - not valued, 0 - false, 1 - True |
PrimarySpeciality_oid | int | NULL | The objectid of primary speciality DDI's objectID |
SecondarySpeciality_oid | int | NULL | The objectid of secondary speciality DDI's objectID |
ProviderType | varchar(64) | NULL | Additional ED staff types. eg, Physician,Mid-Level,Resident,Nurse etc. This is a DDI items(type Staff.ProviderType) that client can set up. |
eRenewEnabled | smallint | NOT NULL | Staff capability to renew Rx(prescription): Available Values : 1-Yes, 0-No |
EPCS_Authority_Status | varchar(20) | NULL | Staff authority for e-Prescribing Controlled Substances |
| | | Available Values : |
| | | NotRequested |
| | | Requested |
| | | Approved |
| | | ApprovedandSSsync |
| | | RevokeRequested |
| | | RevokeApproved |
IsSupervisor | bit | NULL | Identifies a staff member as a supervisor. Available Values : 1-Yes, 0-No , Null - Not valued |
DirectAddress | varchar(256) | NULL | Identifies the direct secured contact email address for a heathcare provider or Organization |
PreferredContactMethod | varchar(6) | NULL | Preferred contact Method. Allowable Values : Email,Fax,Mail. |
OrgAffiliation | varchar(256) | NULL | Name of the Organization provider staff is affiliated with. |
HCPTaxonomy_oid | int | NULL | Objectid of Healthcare Provider Taxonomy DDI. |
HCPDeliveryDirectoryID | varchar(16) | NULL | Delivery Directory ID field returned from Healthcare Provider Directory search. |
eRxChangeEnabled | bit | NOT NULL | Staff capability to change Rx(prescription) : Available Values : 1-Yes, 0-No |
eRxCancelEnabled | bit | NOT NULL | Staff capability to cancel Rx(prescription) : Available Values : 1-Yes, 0-No |
eRxFillEnabled | bit | NOT NULL | Staff capability to refill Rx(prescription) : Available Values : 1-Yes, 0-No |
ExternalProviderId | VARCHAR(256) | NULL | Provider ID provided by document management(DM) from the the Healthcare Provider Directory(HPD). |
ExternalOrganizationId | VARCHAR(256) | NULL | Organization ID provided by document management(DM) from the Healthcare Provider Directory(HPD) |
ExternalDestinationId | INT | NULL | Value provided by document management(DM). |
IsInvalid | bit | NULL | Describes if the external Provider data could not be correctly refreshed or is Invalid. 1-yes(Invalid) , 0 or Null - No |
| | | Applicable Only to the External StaffTypes of 5 and 6 |
DmSecurityId | varchar(64) | NULL | Identifies the Staff in document management. Value is the Unique Security Identifier of the Staff. |
PDMPRole | varchar(64) | NULL | Stores additional staff attribute for Prescription Drug Monitoring Program. eg, Physician,Pharmacist etc. |
PdmpTermsOfUseAcceptedDate | smalldatetime | NULL | Stores date when clinician accepted Terms of Use agreement. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|