Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientLTCTOid | BIGINT | NOT NULL | The Objectid and Primary key of the Table PatientLifeTimeCareTeam |
PatientOid | INT | NOT NULL | Foreign key references the Objectid of table HPatient |
StaffOid | INT | NULL | HStaff.Objectid for the provider(Internal or External) that is a member of the Lifetime Care team of the Patient |
PatientLTCTManuallyAddedMemberOid | BIGINT | NULL | Foreign Key references the ObjectId of the Table PatientLTCTManuallyAddedMember |
ProviderRoleOid | INT | NULL | Foreign key ,The Objectid for HDataDictionaryItem under the ItemTypeCode of CT.LifeTimeCareTeamRole |
LTCTNote | VARCHAR(255) | NULL | Comment that was added while adding a provider to LifeTimeCareteam. |
MemberType | VARCHAR(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 |
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 |
LTCTAssocStartDTimeMins | SMALLDATETIME | NOT NULL | The Start DateTime at which a Provider was added to Life Time Care Team for the Patient |
LTCTAssocEndDTimeMins | 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. |
|