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. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. 

CreatedWhenUTC 
Definition  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

IncomingReferralID 
Definition  Auto generated unique primary key value. 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

ReferredWhenUTC 
Definition  The DateTime the patient was referred to Sunrise for care. 

ReferralIDCode 
Definition  System-generated ID 

ReferredToCareProviderGUID 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

IncomingReferralStatusID 
Definition  A foreign key to the IncomingReferralStatusID column in the SXAAMREFIncomingReferralStatus table. 

ReferredFromCareProviderGUID 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

ReferredFromFreeTextProviderID 
Definition  A foreign key to the FreeTextCareProviderID column in the SXAAMFreeTextCareProvider table. 

ExpirationDateUTC 
Definition  Expiration Date for IncomingReferral Form 

RequestedFacilityName 
Definition  Requested Facility Name for IncomingReferral Form 

OrderEntryFormGUID 
Definition  A foreign key to the GUID column in the CV3OrderEntryForm table. 

IncomingReferralGUID 
Definition  GUID of the Incoming Referral (to be used to map the UDDI dataitem values to the corresponding referral record) 

RequestedServiceGroupCode 
Definition  The group code for RequestedServiceName 

RequestedFacilityCode 
Definition  The group code for RequestedFacilityName 

RequestedServiceSubGroupCode 
Definition  The subgroup code for RequestedServiceName 

PreferredAddressGUID 
Definition  A foreign key to the GUID column in the CV3Address table. 

IncomingReferralTypeID 
Definition  A foreign key to the IncomingReferralTypeID column in the SXAAMREFIncomingReferralType table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ReferredToFreeTextProviderID 
Definition  A foreign key to the FreeTextCareProviderID column in the SXAAMFreeTextCareProvider table. 

ReferredToLocationGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

ReferredToPreferredAddressGUID 
Definition  A foreign key to the GUID column in the CV3Address table. 

ReferredFromLocationGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

ReferredFromFacilityName 
Definition  Name of the facility 

ReferredFromFacilityCode 
Definition  Code of the Facility 

ReferredFromServiceGroupCode 
Definition  Service Group Code 

ReferredFromServiceSubGroupCode 
Definition  Service Sub Group Code 

ReferredFromClientVisitGUID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

ReferralFormID 
Definition  A foreign key to the ReferralFormID column in the SXAAMREFReferralForm table.