Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PatientLTCTManuallyAddedMember contains manually added Care team members.
Column Name Column Datatype Column Null Option Column Comment
PatientLTCTManuallyAddedMemberOidBIGINTNOT NULL The Objectid and Primary key of the Table HPatientLTCTManuallyAddedMember
PersonOidINTNULL Foreign Key references the table Hperson.Objectid
SpecialityOidINTNULL Foreign key ,The Objectid for HDataDictionaryItem under the Type of Speciality
ProviderTypeVARCHAR(6)NULL Indicates whether the current row is for a individual provider or Organization or patient Proxy or power of attorney etc.
Allowable Values : MANPRV - Represents a Manually added Provider(person) ,MANORG - Represents a Manually added Provider Organization
DirectAddressVARCHAR(255)NULL Direct secured contact email address for a heathcare provider or Organization
PreferredContactMethodVARCHAR(6)NULL Describes the preferred contact Method. Email,Fax,Mail.
OrganizationNameVARCHAR(256)NULL Name of the Organization(if the current row represents a provider Organization)
OrgAffiliationVARCHAR(256)NULL Name of the Organization provider is affiliated with(if the current row represents a provider)
NPIProviderNumberVARCHAR(30)NULL Represents the NPI Provider Number for a Manually Entered Provider Or Organization.
PhoneCountryCodeVARCHAR(6)NULL Country Code of the Phone number for the provider or Organization .
PhoneAreaCodeVARCHAR(6)NULL Area Code of the Phone number for the provider or Organization .
PhoneNumberVARCHAR(30)NULL Phone number for the Provider or Organization.
StreetAddressVARCHAR(255)NULL Street address of the Physical address for the provider or Organization.
PostalCodeVARCHAR(10)NULL Zip Code of the Physical address for the provider or Organization
CityVARCHAR(64)NULL City of the Physical address for the provider or Organization
AreaofCountryVARCHAR(50)NULL Area of Country of the Physical address for the provider or Organization
CountryVARCHAR(64)NULL Country of the Physical address for the provider or Organization
FaxPhoneCountryCodeVARCHAR(6)NULL Country Code of the fax number for the provider or Organization .
FaxPhoneAreaCodeVARCHAR(6)NULL Area Code of the fax number for the provideror Organization .
FaxPhoneNumberVARCHAR(30)NULL Fax number for the Provider or Organization.
MobilePhoneNumberVARCHAR(30)NULL Mobile number for the Provider or Organization .
MobileCountryCodeVARCHAR(6)NULL Country Code of the Mobile number for the provider or Organization .
MobileAreaCodeVARCHAR(6)NULL Area Code of the Mobile number for the provider or Organization .
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
StartDTimeMinsSMALLDATETIMENOT NULL The Start DateTime at which a Provider was added to Life Time Care Team for the Patient
EndDTimeMinsSMALLDATETIMENULL 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