Application: ADM System
TableName PrimaryKeys
DAdmAccess SourceID, AccessID 
DAdmAccessScans SourceID, AccessID 
DAdmAccessDesktops SourceID, AccessID, DesktopID 
DAdmAccessDefaults SourceID, AccessID, DesktopID 
DAdmAccessLocations SourceID, AccessID, DesktopID, LocationID 
DAdmAccessModes SourceID, AccessID, DesktopID, ModeID 
DAdmAccessFunctions SourceID, AccessID, DesktopID, SeqID 
DAdmAccessSubFunctions SourceID, AccessID, DesktopID, SeqID, SubfunctionSeqID 
DAdmAccessServices SourceID, AccessID, DesktopID, ServiceID 
DAdmAccessPatientTypes SourceID, AccessID, DesktopID, TypeID 
DAdmAccessWorklists SourceID, AccessID, DesktopID, WorklistID 
DAdmAccessFacilities SourceID, AccessID, FacilityID 
DAdmAccessQuestionnaires SourceID, AccessID, FacilityID, QuestionnaireID 
DAdmAccessQuestCdsScreens SourceID, AccessID, FacilityID, QuestionnaireID, CdsID 
DAdmAccessQuestionnaireScreens SourceID, AccessID, FacilityID, QuestionnaireID, ScreenID 
DAdmAccessProcessScreens SourceID, AccessID, ScreenID 
DAdmAccessScanFunctions SourceID, AccessID, SeqID 
DAdmAccessUsers SourceID, AccessID, UserID 
AdmClinicalAlerts SourceID, AlertSeqID 
AdmClinicalAlertAudit SourceID, AlertSeqID, AuditSeqID 
AdmClinicalAlertProviders SourceID, AlertSeqID, ProviderID 
AdmClinicalAlertText SourceID, AlertSeqID, TextSeqID 
AdmVisitRecurring SourceID, BatchDate 
DAdmBedBoardPriorityFunctions SourceID, BedBoardPriorityID, FunctionID 
DAdmBedBoardRequestSelections SourceID, BedRequestID 
DAdmBedBoardReqSelBedAttribs SourceID, BedRequestID, BedAttributeID 
DAdmBedBoardReqSelFacilities SourceID, BedRequestID, FacilityID 
DAdmBedBoardRequestSelectPri SourceID, BedRequestID, PriorityID 
DAdmBedBoardReqSelServices SourceID, BedRequestID, ServiceID 
DAdmBedBoardRequestStatuses SourceID, BedRequestID, StatusID 
DAdmBedBoardRequestTypes SourceID, BedRequestID, TypeID 
DAdmHousekeepRequestDetail SourceID, BedStatusID, AlertLocationID, OccurrenceID, FromTimeID 
DAdmHousekeepRequestEmail SourceID, BedStatusID, AlertLocationID, OccurrenceID, FromTimeID, SeqID 
DAdmHousekeepRequestPager SourceID, BedStatusID, AlertLocationID, OccurrenceID, FromTimeID, SeqID 
DAdmHousekeepRequestPrint SourceID, BedStatusID, AlertLocationID, OccurrenceID, FromTimeID, SeqID 
DAdmCannedTextItems SourceID, CannedTextID 
DAdmCannedText SourceID, CannedTextID, TextSeqID 
DAdmCanadianSwipeCards SourceID, CardID 
DAdmCharges SourceID, ChargeID 
DAdmChargeLocations SourceID, ChargeID, PatientTypeID, LocationID 
DAdmChargeServices SourceID, ChargeID, PatientTypeID, ServiceID 
DAdmConditions SourceID, ConditionID 
DAdmBedBoardPendingDischarge SourceID, DischargeID 
DAdmBedBoardPendingDischFac SourceID, DischargeID, FacilityID 
DAdmBedBoardPendingDischLoc SourceID, DischargeID, LocationID 
DAdmBedBoardPendingDischServ SourceID, DischargeID, ServiceID 
AdmStatsAccommodation SourceID, FacilityID, AccommodationID, Date 
AdmStatsRoomRateAccommodation SourceID, FacilityID, AccommodationID, Date 
AdmStatsAccommodationOut SourceID, FacilityID, AccommodationID, Date, StatusID 
AdmStatsRoomRateAccomOut SourceID, FacilityID, AccommodationID, Date, StatusID 
AdmStatsHospital SourceID, FacilityID, Date 
AdmStatsObservationPatient SourceID, FacilityID, Date 
AdmNursingCensus SourceID, FacilityID, Date, RoomID, BedID, VisitID 
AdmStatsOutRegistrations SourceID, FacilityID, Date, StatusID 
DAdmTimeRuleServiceExceptions SourceID, FacilityID, ExceptionID 
DAdmTimeRuleIntervalServices SourceID, FacilityID, ExceptionID, SeqID 
DAdmTimeRules SourceID, FacilityID, FinancialClassID 
AdmStatsFinancialClass SourceID, FacilityID, FinancialClassID, Date 
DAdmTimeRuleServices SourceID, FacilityID, FinancialClassID, ServiceID 
AdmStatsLocation SourceID, FacilityID, LocationID, Date 
AdmStatsLocationOut SourceID, FacilityID, LocationID, Date, StatusID 
AdmStatsOutLocation SourceID, FacilityID, LocationID, Date, StatusID 
DAdmOaMessageAdmReg SourceID, FacilityID, PatientStatusID, AdmRegMessageID 
DAdmOaMessageBedChanges SourceID, FacilityID, PatientStatusID, BedChangeMessageID 
DAdmOaMessageCanceled SourceID, FacilityID, PatientStatusID, CancelMessageID 
DAdmOaMessageDischargeDepart SourceID, FacilityID, PatientStatusID, DisDepartMessageID 
DAdmOaMessageEditAttend SourceID, FacilityID, PatientStatusID, EditAttendMessageID 
DAdmOaMessageGuarantorIns SourceID, FacilityID, PatientStatusID, GuarantorInsMessageID 
DAdmOaMessagePre SourceID, FacilityID, PatientStatusID, PreMessageID 
DAdmOaMessageSch SourceID, FacilityID, PatientStatusID, SchMessageID 
DAdmOaMessageSwap SourceID, FacilityID, PatientStatusID, SwapMessageID 
DAdmOaMessageUndoAdm SourceID, FacilityID, PatientStatusID, UndoAdmMessageID 
DAdmOaMessageUndo SourceID, FacilityID, PatientStatusID, UndoMessageID 
DAdmOaMessageUndoSwap SourceID, FacilityID, PatientStatusID, UndoSwapMessageID 
DAdmOaMessageUndoXfer SourceID, FacilityID, PatientStatusID, UndoXferMessageID 
DAdmOaMessageXfer SourceID, FacilityID, PatientStatusID, XferMessageID 
DAdmIncompleteRecordReasons SourceID, FacilityID, PatientTypeID, LocationServiceID 
AdmStatsPatientOrigin SourceID, FacilityID, PostalCodeID, Date, StatusID 
AdmStatsAdmitProvider SourceID, FacilityID, ProviderID, Date 
AdmStatsAttendProvider SourceID, FacilityID, ProviderID, Date 
AdmStatsPrimaryCareProvider SourceID, FacilityID, ProviderID, Date 
AdmReinstatements SourceID, FacilityID, SecondsID, UserID 
AdmReinstatementAccounts SourceID, FacilityID, SecondsID, UserID, ReinstatedID 
DAdmTimeRuleIntervals SourceID, FacilityID, SeqID 
AdmStatsService SourceID, FacilityID, ServiceID, Date 
AdmStatsServiceOut SourceID, FacilityID, ServiceID, Date, StatusID 
DAdmBedBoardRequestEmail SourceID, FacilityID, ServiceID, OccurrenceID, FromTimeID, SeqID 
DAdmBedBoardRequestPager SourceID, FacilityID, ServiceID, OccurrenceID, FromTimeID, SeqID 
DAdmBedBoardRequestPrint SourceID, FacilityID, ServiceID, OccurrenceID, FromTimeID, SeqID 
DAdmBedBoardRequests SourceID, FacilityID, ServiceID, OccurrenceID, TimeFromID 
DAdmBedBoardHousekeep SourceID, HousekeepingID 
DAdmBedBoardHousekeepFacility SourceID, HousekeepingID, FacilityID 
DAdmBedBoardHousekeepPriority SourceID, HousekeepingID, PriorityID 
DAdmBedBoardHousekeepBlocked SourceID, HousekeepingID, ReasonID 
AdmVisitEmrList SourceID, PatientSeqID, TypeID, VisitID 
DAdmBedBoardPriorities SourceID, PriorityID 
DAdmBedBoardBlockReasons SourceID, ReasonID 
DAdmOverrideReasons SourceID, ReasonID 
DAdmVisitReasons SourceID, ReasonID 
DAdmVisitReasonChiefComplaints SourceID, ReasonID, ChiefComplaintID 
DAdmVisitReasonTemplates SourceID, ReasonID, DocumentTemplateID 
DAdmVisitReasonProviders SourceID, ReasonID, ProviderID 
DAdmTransportRequestType SourceID, RequestTypeID 
DAdmTransportRequestFacilities SourceID, RequestTypeID, FacilityID 
DAdmTransportNotifyDetail SourceID, RequestTypeID, OccurrenceID, FromTimeID 
DAdmTransportNotifyEmail SourceID, RequestTypeID, OccurrenceID, FromTimeID, SeqID 
DAdmTransportNotifyPager SourceID, RequestTypeID, OccurrenceID, FromTimeID, SeqID 
DAdmTransportNotifyPrint SourceID, RequestTypeID, OccurrenceID, FromTimeID, SeqID 
DAdmBedBoardReservation SourceID, ReservationID 
DAdmBedBoardReservationFac SourceID, ReservationID, FacilityID 
DAdmBedBoardReservationLoc SourceID, ReservationID, LocationID 
DAdmBedBoardReservationServ SourceID, ReservationID, ServiceID 
DAdmBedBoardReservationStatus SourceID, ReservationID, StatusID 
AdmHousekeeping SourceID, RoomID, BedID 
AdmHousekeepBlocked SourceID, RoomID, BedID, Date, ActualTime 
DAdmBedBoardSelect SourceID, SelectID 
DAdmBedBoardSelectPriorities SourceID, SelectID, PriorityID 
DAdmBedBoardSelectAccommodates SourceID, SelectionID, AccommodationID 
DAdmBedBoardSelectAttributes SourceID, SelectionID, AttributeID 
DAdmBedBoardSelectFacilities SourceID, SelectionID, FacilityID 
DAdmBedBoardSelectLocations SourceID, SelectionID, LocationID 
DAdmBedBoardSelectBlocked SourceID, SelectionID, ReasonID 
DAdmBedBoardSelectServices SourceID, SelectionID, ServiceID 
DAdmBedBoardSelectStatuses SourceID, SelectionID, StatusID 
DAdmBedStatuses SourceID, StatusID 
DAdmBedBoardTransport SourceID, TransportID 
DAdmBedBoardTransportFacility SourceID, TransportID, FacilityID 
DAdmBedBoardTransportFromLoc SourceID, TransportID, LocationID 
DAdmBedBoardTransportToLoc SourceID, TransportID, LocationID 
DAdmBedBoardTransportPriority SourceID, TransportID, PriorityID 
DAdmBedBoardTransportTypes SourceID, TransportID, TypeID 
AdmClinicalAlertUsers SourceID, UserID 
AdmVisitInsuranceVerStatuses SourceID, UserID, Date, InsuranceID, VisitID, InsuranceSeqID 
AdmittingCanadianData SourceID, VisitID 
AdmDepartureData SourceID, VisitID 
AdmittingData SourceID, VisitID 
AdmPatUkGuarantors SourceID, VisitID 
AdmVisitOrders SourceID, VisitID 
AdmProviders SourceID, VisitID 
AdmVisitDiagnosisData2 SourceID, VisitID 
AdmVisitFamilyProviderDetails SourceID, VisitID 
AdmVisitOtherProviderDetails SourceID, VisitID 
AdmVisitReferProviderDetails SourceID, VisitID 
AdmEmployers SourceID, VisitID 
AdmGuarantors SourceID, VisitID 
AdmVisits SourceID, VisitID 
AdmClinDepartureData SourceID, VisitID 
AdmVisitDiagnosesCs SourceID, VisitID 
AdmDischargeInfo SourceID, VisitID 
AdmVisitAddlInfo SourceID, VisitID 
AdmPatUkAccidentAndEmergency SourceID, VisitID 
AdmPatUkDemographics SourceID, VisitID 
AdmPatUkClinicians SourceID, VisitID 
AdmPatUkNextOfKin SourceID, VisitID 
AdmPatUkPersonToNotify SourceID, VisitID 
AdmPatUkRoadTrafficAccidents SourceID, VisitID 
AdmPatUkRtaDrivers SourceID, VisitID 
AdmPatUks SourceID, VisitID 
AdmPatUkOther SourceID, VisitID 
AdmVisitNextOfKin SourceID, VisitID 
AdmVisitPersonToNotify SourceID, VisitID 
AdmVitalSigns SourceID, VisitID 
AdmCanadianAccounts SourceID, VisitID, AccountNumberSeqID 
AdmVisitOtherAgencies SourceID, VisitID, AgencyID 
AdmVisitClinicalAlerts SourceID, VisitID, AlertID, DetailID 
AdmCanadianAlerts SourceID, VisitID, AlertSeqID 
AdmAllergies SourceID, VisitID, AllergyID 
AdmBedDetails SourceID, VisitID, BedAttributeID 
AdmVisitForensicCharges SourceID, VisitID, ChargeID 
AdmVisitMedNecDiagnoses SourceID, VisitID, CodeID 
AdmVisitMedNecDiagnosisSrcs SourceID, VisitID, CodeID, DatabaseID 
AdmVisitMedNecDiagnosisProcSrc SourceID, VisitID, CodeID, ProcedureID, DatabaseID 
AdmVisitMedNecDiagnosisModSrcs SourceID, VisitID, CodeID, ProcedureID, ModID, DatabaseID 
AdmVisitConditions SourceID, VisitID, ConditionSeqID 
AdmConsultingProviders SourceID, VisitID, ConsultingID 
AdmVisitRugs SourceID, VisitID, Date 
AdmBillingCharges SourceID, VisitID, Date, SeqID 
AdmVisitNameAudit SourceID, VisitID, Date, SeqID 
AdmVisitDiagnosisAudit SourceID, VisitID, Date, TimeID 
AdmVisitDiagnosisAuditDetails SourceID, VisitID, Date, TimeID, DiagnosisDate, SeqID 
AdmVisitDiagnosisDates SourceID, VisitID, EffectiveDate 
AdmVisitDiagnosisDates2 SourceID, VisitID, EffectiveDate 
AdmVisitDiagnosisCodes SourceID, VisitID, EffectiveDate, SeqID 
AdmVisitDiagnosisCodes2 SourceID, VisitID, EffectiveDate, SeqID 
AdmEmploymentInformation SourceID, VisitID, EidSeqID 
AdmVisitPprEncounters SourceID, VisitID, EncounterSeqID 
AdmVisitPprEncounterDiagnoses SourceID, VisitID, EncounterSeqID, DiagnosisSeqID 
AdmVisitPprQueries SourceID, VisitID, EncounterSeqID, QueryID 
AdmVisitPprMspQueries SourceID, VisitID, EncounterSeqID, QueryID 
AdmVisitPprQueryMult SourceID, VisitID, EncounterSeqID, QueryID, QuerySeqID 
AdmVisitPprMspQueriesMultCs SourceID, VisitID, EncounterSeqID, QuerySeqID 
AdmVisitPprEncInsuranceAuths SourceID, VisitID, EncounterSeqID, SeqID 
AdmVisitPprScheduleText SourceID, VisitID, EncounterSeqID, TextSeqID 
AdmVisitPprEpiInsuranceAuthMan SourceID, VisitID, EpisodeSeqID, InsuranceID, SeqID 
AdmVisitEvents SourceID, VisitID, EventDate, EventSeqID 
AdmVisitEventOtherLocations SourceID, VisitID, EventDate, EventSeqID, LocationID 
AdmVisitEventUndoLocations SourceID, VisitID, EventDate, EventSeqID, OldLocationID 
AdmVisitEventSegments SourceID, VisitID, EventDate, EventSeqID, SegmentID 
AdmVisitGuardianTypes SourceID, VisitID, GuardianTypeID 
AdmVisitGuardianMedTreat SourceID, VisitID, GuardianTypeID, TreatmentTypeID 
AdmVisitGuardianMedTreatText SourceID, VisitID, GuardianTypeID, TreatmentTypeID, TextSeqID 
AdmVisitPhysicalHandicaps SourceID, VisitID, HandicapID 
AdmInsuranceEligInfo SourceID, VisitID, InsuranceID 
AdmInsuranceEligCanInfo SourceID, VisitID, InsuranceID 
AdmInsuranceEmpInfo SourceID, VisitID, InsuranceID 
AdmInsuranceAuth SourceID, VisitID, InsuranceID 
AdmInsurances SourceID, VisitID, InsuranceID 
AdmInsuredInfo SourceID, VisitID, InsuranceID 
AdmVisitEdi SourceID, VisitID, InsuranceID 
AdmInsuredDataRx SourceID, VisitID, InsuranceID 
AdmVisitInsuranceAuthMan SourceID, VisitID, InsuranceID, AuthID 
AdmInsAuthmReferingProvDetails SourceID, VisitID, InsuranceID, AuthID 
AdmVisitInsuranceAuthManMore SourceID, VisitID, InsuranceID, AuthID 
AdmInsAuthmReferredProvDetails SourceID, VisitID, InsuranceID, AuthID 
AdmVisitInsuranceAuthManCpts SourceID, VisitID, InsuranceID, AuthID, SeqID 
AdmInsuranceAuthProcs SourceID, VisitID, InsuranceID, AuthProcedureSeqID 
AdmVisitEdiData SourceID, VisitID, InsuranceID, ElementID, SeqID 
AdmPocInsuranceImages SourceID, VisitID, InsuranceID, MedicalRecordFormID, FormSeqID 
AdmPocInsuranceImagePages SourceID, VisitID, InsuranceID, MedicalRecordFormID, FormSeqID, PageNumberID 
AdmInsuranceQueries SourceID, VisitID, InsuranceID, QueryID 
AdmInsuranceQueriesMult SourceID, VisitID, InsuranceID, QueryID, QuerySeqID 
AdmVisitInsuranceQueries SourceID, VisitID, InsuranceID, QuerySeqID 
AdmVisitInsuranceAuthReqs SourceID, VisitID, InsuranceID, SeqID 
AdmVisitInsuranceEligCanSwipes SourceID, VisitID, InsuranceID, SeqID 
AdmVisitInsuranceEligTraces SourceID, VisitID, InsuranceID, SeqID 
AdmVisitInsuranceAuthReqSvcs SourceID, VisitID, InsuranceID, SeqID, ServiceSeqID 
AdmInsuranceOrder SourceID, VisitID, InsuranceOrderID 
AdmVisitOtherLocations SourceID, VisitID, LocationID 
AdmPocImages SourceID, VisitID, MedicalRecordFormID, FormSeqID 
AdmPocImagePages SourceID, VisitID, MedicalRecordFormID, FormSeqID, PageNumberID 
AdmCdaGenerated SourceID, VisitID, MessageSeqID 
AdmCdaTransmitted SourceID, VisitID, MessageSeqID, TransMultSeqID 
AdmVisitContacts SourceID, VisitID, NameID 
AdmVisitDutyContacts SourceID, VisitID, NameID 
AdmVisitFamilies SourceID, VisitID, NameID 
AdmVisitGuardianContacts SourceID, VisitID, NameID 
AdmVisitCollectionNotes SourceID, VisitID, NoteSeqID 
AdmVisitCollectionNoteText SourceID, VisitID, NoteSeqID, TextSeqID 
AdmVisitConsultProviderDetails SourceID, VisitID, ProviderID 
AdmVisitQueries SourceID, VisitID, QueryID 
AdmVisitClinicalQueries SourceID, VisitID, QueryID 
AdmVisitQueriesMult SourceID, VisitID, QueryID, QuerySeqID 
AdmVisitClinicalQueriesMult SourceID, VisitID, QueryID, QuerySeqID 
AdmVisitOtherAgencyContacts SourceID, VisitID, ReferalID 
AdmBedRequests SourceID, VisitID, RequestID 
AdmBedRequestReports SourceID, VisitID, RequestID 
AdmBedRequestReportAudits SourceID, VisitID, RequestID 
AdmBedRequestAttributes SourceID, VisitID, RequestID, BedComponentID 
AdmBedRequestQueries SourceID, VisitID, RequestID, QueryID 
AdmBedRequestQueriesMult SourceID, VisitID, RequestID, QueryID, QuerySeqID 
AdmBedReservationDetails SourceID, VisitID, RoomID, BedID, Date, ActualTimeID 
AdmVisitAuthorizations SourceID, VisitID, SeqID 
AdmVisitAppointments SourceID, VisitID, SeqID 
AdmVisitDiagnoses SourceID, VisitID, SeqID 
AdmVisitOccurences SourceID, VisitID, SeqID 
AdmVisitOtherFacilities SourceID, VisitID, SeqID 
AdmVisitValueCodes SourceID, VisitID, SeqID 
AdmVisitDiagnoses2 SourceID, VisitID, SeqID 
AdmExpiredInsuranceQueue SourceID, VisitID, SeqID 
AdmVisitCmServices SourceID, VisitID, SeqID 
AdmExpiredInsurance SourceID, VisitID, SeqID, InsuranceID 
AdmExpiredInsuranceRx SourceID, VisitID, SeqID, InsuranceID 
AdmVisitScheduleText SourceID, VisitID, TextSeqID 
AdmVisitForensicText SourceID, VisitID, TextSeqID 
AdmVisitForensicRestrictText SourceID, VisitID, TextSeqID 
AdmVisitProbationText SourceID, VisitID, TextSeqID 
AdmVisitRestrainingOrdersText SourceID, VisitID, TextSeqID 
AdmVisitOtherVendorAccounts SourceID, VisitID, VendorID 
Application: ADM Status: Historical System
TableName PrimaryKeys
DAdmVisitReasonEncounters SourceID, ReasonID, ContentID 
Last sent on: Feb 29, 2016 at 4:00pm