Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PatientLifeTimeCareTeam contains patient/Care team association.
Column Name Column Datatype Column Null Option Column Comment
PatientLTCTOidBIGINTNOT NULL The Objectid and Primary key of the Table PatientLifeTimeCareTeam
PatientOidINTNOT NULL Foreign key references the Objectid of table HPatient
StaffOidINTNULL HStaff.Objectid for the provider(Internal or External) that is a member of the Lifetime Care team of the Patient
PatientLTCTManuallyAddedMemberOidBIGINTNULL Foreign Key references the ObjectId of the Table PatientLTCTManuallyAddedMember
ProviderRoleOidINTNULL Foreign key ,The Objectid for HDataDictionaryItem under the ItemTypeCode of CT.LifeTimeCareTeamRole
LTCTNoteVARCHAR(255)NULL Comment that was added while adding a provider to LifeTimeCareteam.
MemberTypeVARCHAR(6)NOT NULL Mnemonic that indicates whether the current team member is internal or External,Provider or Organization or manually entered.
Allowable Values :INTPRV - Represents an Internal Provider,EXTPRV - Represents an External Provider
INTORG - Represents an Internal Organization ,EXTORG - Represents an External Organization
MANPRV - Represents an Manually added Provider(person) ,MANORG - Represents an Manually added Provider Organization,NXTKIN - Next of Kin
CreatedByUserOidINTNOT NULL Foreign key ,The Objectid of table HSUser for the user that added a provider to LifeTime Careteam of the Patient
EndedByUserOidINTNULL The Objectid of table HSUser for the user that removed the user from the LifeTimeCareTeam of the Patient
IsEndedBITNULL Indicates if the association represented by current row is active or ended. Allowable Values: 0 - Active, 1 - Ended
LTCTAssocStartDTimeMinsSMALLDATETIMENOT NULL The Start DateTime at which a Provider was added to Life Time Care Team for the Patient
LTCTAssocEndDTimeMinsSMALLDATETIMENULL The End DateTime at which a Provider was removed from the Life Time Care Team of a Patient
LastCngDtimeDATETIMENOT NULLSystem UTC date /time when row was updated.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates