SiteID |
Definition | Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
RepFlags |
Definition | Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. |
Build |
Definition | Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. |
TouchedBy |
Definition | Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
TouchedWhen |
Definition | The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
Definition | Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
CreatedWhen |
Definition | The date and time that the row was created and will be based on the Enterprise time zone. |
Active |
Definition | Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
GUID |
Definition | Unique primary key value. |
Code |
Definition | The formatted location hierarchy. |
LevelCode |
Definition | The lowest level code within the hierarchy. |
Name |
Definition | The Display Name of the location. |
HL7Code |
Definition | The HL7 code used to describe the location. |
LocationFormatChar |
Definition | Used to format the location name. |
PrintResultsFlag |
Definition | If TRUE, indicates that results are printed at this location. 1 = True; 0 = False |
PrintOrderSummaryFlag |
Definition | If TRUE, indicates that a summary report for orders from this location is printed. 1 = True; 0 = False |
SignOrderFlag |
Definition | Indicates that this location requires that orders be signed. 1 = True; 0 = False |
AckOrderFlag |
Definition | Indicates that this location requires changed orders be checked. 1 = True; 0 = False |
ConfirmDischargeFlag |
Definition | If TRUE, indicates that discharges from this location must be confirmed. 1 = True; 0 = False |
ConfirmTransferFlag |
Definition | If TRUE, indicates that transfers from this location must be confirmed. 1 = True; 0 = False |
ConfirmCancelFlag |
Definition | If TRUE, indicates that cancels from this location must be confirmed. 1 = True; 0 = False |
UseCareVISIONFlag |
Definition | If TRUE, indicates that this location uses Sunrise Clinical Manager. 1 = True; 0 = False |
IsClientLocation |
Definition | If TRUE, indicates that clients can be admitted to this location. 1 = True; 0 = False |
IsPrintLocation |
Definition | If TRUE, indicates that reports can be sent to this location. 1 = True; 0 = False |
IsLocationGroup |
Definition | If TRUE, indicates that this location is a group (for example, Unit or Clinic). 1 = True; 0 = False |
IsFacility |
Definition | True if this location is a facility. 1 = True; 0 = False |
TypeCode |
Definition | Identifies the type of location. |
HL7TypeCode |
Definition | The type of location for HL7. |
ParentGUID |
Definition | The link to the parent location. 0 if this location is a facility |
FacilityGUID |
Definition | The link to this location's facility. |
LocnGrpGUID |
Definition | The link to this location's group. |
ClientIDType |
Definition | Indicates the client ID type that will be auto-generated for this facility. Applies only to a facility |
VisitIDType |
Definition | Indicates the visit ID type that will be auto-generated for this facility. Applies only to a facility |
IsTemporary |
Definition | Indicates if this location can be used as a temporary location. 1 = True; 0 = False |
HasTemporaryChild |
Definition | This is true if at least on child location is a temporary location. 1 = True; 0 = False |
TempLocLikeAssignedLoc |
Definition | Indicates if a certain location group attributes are obtained from a patient's temporary location or from the assigned location. |
HasClientLocChild |
Definition | Indicates whether or not the location has any children which are client locations. |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
DefaultOrderSource |
Definition | This column will hold the default order source for every location. |
DefaultSessionType |
Definition | This column stores default session type for each Location. |
BedStatus |
Definition | Stores empty bed status |
UsesAllergyReview |
Definition | Does the current location uses Allergy Review feature |
Capacity |
Definition | Maximum number of persons allowed in location |
CensusTypeID |
Definition | Census type ID from SXAAMCensusType |
UseDefaultStatus |
Definition | Specifies if the default statuses AssignLocationStatusID and DischargeLocationStatusID are automatically applied to the Location. |
AssignedLocationStatusID |
Definition | The default StatusID to use when a Visit is assigned to this Location. |
DischargeLocationStatusID |
Definition | The default StatusID to use when a Visit is discharged from this location. |
IsSameGenderRequired |
Definition | Specifies if all assignments to this location must be of the same gender. |
ShortName |
Definition | Short name for the location. |
DefaultPrivacyStatusGUID |
Definition | Specifies the default privacy status for this location which is determined by combining the privacy status of the location and the patient (CV3PrivacyStatus) |
IsDisplayHealthIssue |
Definition | Indicates to display health issue summary dialog when open order entry summary dialog is accessed. |
UsingResultsAckType |
Definition | An enumerated type with the following list of possible values: 0 = [No Acknowledgement],1 = [Acknowledge All Results],2 = [Acknowledge For Discharged Only], |
IsAbleToEnterResults |
Definition | Allow the location to manually entered results |
ScanIDTypeCode |
Definition | Identifies the Client ID Type that the facility is using for their patient bar codes. Links to the CV3ClientIDType table. It is possible to have Patient ID Bar codes varying between units. For example, Pediatrics would have a Mother+Baby combination. |
DrugAgencyIdentifier |
Definition | A Facility's Drug Enforcement Agency number |
MedBillingType |
Definition | An enumerated type with the following list of possible values: 0 = [None],1 = [On Admin],2 = [On Dispense], |
UseOrderEntryFlag |
Definition | Indicates that this location is using electronic order entry. This enables all order entry functions. |
IsCloseRuleAppliedOnDC |
Definition | Indicates whether the behavior used to discontinue orders for a closed visit should be used for discharged visits. (Default value = 0) |
OrderTabDateThisChartType |
Definition | Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. |
ResultTabDateThisChartType |
Definition | Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. |
ResultTabDateAllChartsType |
Definition | Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. |
DocTabDateThisChartType |
Definition | Enumerated value that indicates the default Since date for the ‘This Chart’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file. |
DocTabDateAllChartsType |
Definition | Enumerated value that indicates the default Since date for the ‘All Charts’ display type. The enumerated values come from the SinceType enumeration in the CSinceTime header file |
IsDocTabDefaultAllAvailable |
Definition | ‘This Chart’ (0) or ‘All Available’ (1). Default is 0. |
AssignTempId |
Definition | Store the assigning temporary IDs for a location in a unit. Shown on the Location dialog |
AdHocBedType |
Definition | New field to indicate if the Location is a AdHoc location and if it’s a Active AdHoc location. |
IsSurgeryOperatingRoom |
Definition | Indicates if the location is a surgery operating room |
IsPracticeLocation |
Definition | Used to identify whether location is practice location or not |
HideDateOfService |
Definition | It Will contains 3 values Null, 0, 1. NULL means clinical manager is not in use for particular location. |
HideAuthoredDateTime |
Definition | For Field HideDateOfService if value is zero then this field will be either 0 or 1 else it will be null. |
PlaceOfServiceID |
Definition | A foreign key to the PlaceOfServiceID column in the SXAAMPlaceOfService table. |
UnitGUID |
Definition | If the location is not a unit, and belongs to a unit, UnitGUID refers to the unit location GUID. If the location is not a unit, and does not belong to a unit, UnitGUID is null. If the location is a unit, UnitGUID refers to the location itself. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
CanUseACRRadiology |
Definition | Flag for location to Use ACR Radiology |
IsOffsite |
Definition | Indicates Location is considered Off Campus for financial purposes. |