Signatures


Description

Electronic signature records storing digital signatures and authentication data for healthcare documents and forms. This table manages signature capture including table associations, signature data, user authentication, geolocation tracking, and audit trails to support comprehensive electronic signature workflows, document authentication, and compliance with digital signature regulations for healthcare documentation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkSID int identity 4 √ null

Primary key - Unique identifier for each signature record
TableName varchar 50 √ null

Table name - Name of the database table that this signature is associated with
FieldID int 4 √ null

Field identifier - Identifier of the specific record or field that was signed
fkSignatureTypeID int 4 √ null

Signature type reference - Links to SignatureTypes table for the type of signature
Signator varchar 255 √ null

Signatory name - Name of the person who provided the signature
Signature ntext 1073741823 √ null

Signature data - Digital signature data (image, encrypted data, or signature hash)
Agent varchar 500 √ null

User agent - Browser or application information from the signing session
Ip varchar 50 √ null

IP address - IP address from which the signature was captured
Host varchar 100 √ null

Host information - Host or server information for the signing session
DateCreated smalldatetime 16 √ (getdate())

Creation date - Date and time when the signature was captured
CreatedBy int 4 √ null

Created by user - UserID of the person who facilitated the signature capture
Active bit 1 √ ((1))

Active status - Boolean indicating if the signature is currently active and valid
SCMode int 4 √ null

Service coordination mode - Mode or context for service coordination signatures
Latitude float 8 √ null

GPS latitude - Latitude coordinate where the signature was captured (for mobile signatures)
Longitude float 8 √ null

GPS longitude - Longitude coordinate where the signature was captured (for mobile signatures)
DeletedBy int 4 √ null

Deleted by user - UserID of the person who deleted or invalidated the signature
DeletedDate datetime 16,3 √ null

Deletion date - Date when the signature was deleted or invalidated
OldJsonSignature ntext 1073741823 √ null

Legacy signature data - Previous JSON format signature data for migration compatibility
IsCheckedAttestation bit 1 ((0))

Attestation checked flag - Boolean indicating if attestation requirements were verified
AttestationContent varchar 2147483647 √ null

Attestation content - Text content of the attestation statement that was agreed to
fkClaimId int 4 √ null

Claim reference - Links to Claim table if signature is associated with a specific claim
FkScClaimId int 4 √ null

Service coordination claim reference - Links to service coordination claim if applicable

Indexes

Constraint Name Type Sort Column(s)
PK_Signatures Primary key Asc pkSID
IX_Claim Performance Asc fkClaimId
IX_FieldID_DeletedDate_SignatureType Performance Asc/Asc/Asc FieldID + DeletedDate + fkSignatureTypeID
IX_fkScClaimID_DeletedDate_SignatureType Performance Asc/Asc/Asc FkScClaimId + DeletedDate + fkSignatureTypeID
IX_Main Performance Asc/Asc/Asc/Asc TableName + FieldID + fkSignatureTypeID + Active
IX_Signatures_CreatedBy_SignatureType_DateCreated Performance Asc/Asc CreatedBy + fkSignatureTypeID

Relationships

Close relationships within degrees of separation