ProviderSignature


Description

Provider electronic signature management storing digital signatures and authentication data for healthcare providers during service documentation and billing processes. This table manages electronic signatures including signature data, timestamps, location tracking, device information, and IP addresses, supporting electronic signature compliance, provider authentication, and audit trails for healthcare documentation and billing verification.

Columns

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

Primary key - Unique identifier for each provider signature record
ProviderId int 4 √ null

Provider reference - Links to AccessUser table for the healthcare provider who created the signature
Signature varchar 2147483647 √ null

Signature data - Electronic signature data, encoded signature image, or signature hash for authentication
CreatedDate datetime 16,3 √ null

Signature timestamp - Date and time when the electronic signature was created
DeletedDate datetime 16,3 √ null

Deletion timestamp - Date and time when the signature record was deleted or invalidated
Latitude float 8 √ null

GPS latitude - Geographic latitude coordinate where the signature was captured for location verification
Longitude float 8 √ null

GPS longitude - Geographic longitude coordinate where the signature was captured for location verification
Agent varchar 500 √ null

User agent string - Browser or device information used to capture the signature for audit and security purposes
Ip varchar 50 √ null

IP address - Internet Protocol address from which the signature was submitted for security tracking and audit trails

Indexes

Constraint Name Type Sort Column(s)
PK__Provider__3214EC2701338DA5 Primary key Asc ID

Relationships

Close relationships within degrees of separation