Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientLTCTManuallyAddedMemberOid | BIGINT | NOT NULL | The Objectid and Primary key of the Table HPatientLTCTManuallyAddedMember |
PersonOid | INT | NULL | Foreign Key references the table Hperson.Objectid |
SpecialityOid | INT | NULL | Foreign key ,The Objectid for HDataDictionaryItem under the Type of Speciality |
ProviderType | VARCHAR(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 |
DirectAddress | VARCHAR(255) | NULL | Direct secured contact email address for a heathcare provider or Organization |
PreferredContactMethod | VARCHAR(6) | NULL | Describes the preferred contact Method. Email,Fax,Mail. |
OrganizationName | VARCHAR(256) | NULL | Name of the Organization(if the current row represents a provider Organization) |
OrgAffiliation | VARCHAR(256) | NULL | Name of the Organization provider is affiliated with(if the current row represents a provider) |
NPIProviderNumber | VARCHAR(30) | NULL | Represents the NPI Provider Number for a Manually Entered Provider Or Organization. |
PhoneCountryCode | VARCHAR(6) | NULL | Country Code of the Phone number for the provider or Organization . |
PhoneAreaCode | VARCHAR(6) | NULL | Area Code of the Phone number for the provider or Organization . |
PhoneNumber | VARCHAR(30) | NULL | Phone number for the Provider or Organization. |
StreetAddress | VARCHAR(255) | NULL | Street address of the Physical address for the provider or Organization. |
PostalCode | VARCHAR(10) | NULL | Zip Code of the Physical address for the provider or Organization |
City | VARCHAR(64) | NULL | City of the Physical address for the provider or Organization |
AreaofCountry | VARCHAR(50) | NULL | Area of Country of the Physical address for the provider or Organization |
Country | VARCHAR(64) | NULL | Country of the Physical address for the provider or Organization |
FaxPhoneCountryCode | VARCHAR(6) | NULL | Country Code of the fax number for the provider or Organization . |
FaxPhoneAreaCode | VARCHAR(6) | NULL | Area Code of the fax number for the provideror Organization . |
FaxPhoneNumber | VARCHAR(30) | NULL | Fax number for the Provider or Organization. |
MobilePhoneNumber | VARCHAR(30) | NULL | Mobile number for the Provider or Organization . |
MobileCountryCode | VARCHAR(6) | NULL | Country Code of the Mobile number for the provider or Organization . |
MobileAreaCode | VARCHAR(6) | NULL | Area Code of the Mobile number for the provider or Organization . |
CreatedByUserOid | INT | NOT NULL | Foreign key ,The Objectid of table HSUser for the user that added a provider to LifeTime Careteam of the Patient |
EndedByUserOid | INT | NULL | The Objectid of table HSUser for the user that removed the user from the LifeTimeCareTeam of the Patient |
IsEnded | BIT | NULL | Indicates if the association represented by current row is active or ended. Allowable Values: 0 - Active, 1 - Ended |
StartDTimeMins | SMALLDATETIME | NOT NULL | The Start DateTime at which a Provider was added to Life Time Care Team for the Patient |
EndDTimeMins | SMALLDATETIME | NULL | The End DateTime at which a Provider was removed from the Life Time Care Team of a Patient |
LastCngDtime | DATETIME | NOT NULL | System UTC date /time when row was updated. |