Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
TokenOid | BIGINT | NOT NULL | Token Object ID |
Patient_Oid | INT | NOT NULL | HPatient Object ID |
ActivationToken | varchar(36) | NOT NULL | Activation Token |
CreatedUserId | INT | NOT NULL | Object ID of the person that created the row |
CreationDateTime | datetime | NOT NULL | Activation Token Start Time |
ActivationTokenEndTime | datetime | NOT NULL | Activation Token End Time |
IsProxyUser | bit | NOT NULL | Is Proxy User. Allowable values 0 or 1 |
PermanentToken | varchar(36) | NOT NULL | Permanent Token |
PermanentTokenLinkStartTime | datetime | NULL | Permanent Token Link Start Time |
PermanentTokenLinkEndTime | datetime | NULL | Permanent Token Link End Time |
TokenStatus | varchar(15) | NOT NULL | Supports various token status: 'generated/linked/revoked/expired' |
SourceSystem | varchar(30) | NULL | Contains the Application identifier of the system that created the proxy-patient linking. For HL7 => MSH.3; For Soarian initiated => 'SC'. If NULL then defaulted as 'SC'. |
LastCngDTime | datetime | NOT NULL | UTC time |
IsRevokedByJob | bit | NULL | Is Token Revoked By Job ? |
LinkTokenFailedCount | smallint | NULL | Link Token Failed Count. If this exceeds Arc_PLA_HospitalConfig.LinkTokenMaxAttempt, then the token is expired |
LinkTokenLastFailureReason | varchar(512) | NULL | Reason for failure of last LinkToken attempt |
PatientRecordId | INT | NOT NULL | PatientRecordId in the HPatient Table. It is used for 2-key validation to ensure the data is fetched for the correct patient. |