ppddata


Description

Payment and procedure data managing comprehensive payment information, procedure details, and billing status for healthcare services. This table stores payment processing data including ICN numbers, patient information, service dates, paid amounts, billed amounts, procedure codes, error codes, and claim status to support payment reconciliation, billing analysis, and financial reporting for healthcare operations.

Columns

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

Primary key - Unique identifier for each payment/procedure data record
ICN nvarchar 100 √ null

Internal control number - Unique identifier for tracking claims and payments
PatientID nvarchar 510 √ null

Patient identifier - Patient ID associated with this payment/procedure
LastName nvarchar 510 √ null

Patient last name - Last name of the patient who received services
FirstName nvarchar 510 √ null

Patient first name - First name of the patient who received services
ServiceDate datetime 16,3 √ null

Service date - Date when the healthcare service was provided
PaidDate datetime 16,3 √ null

Payment date - Date when payment was received or processed
PaidAmount money 21,4 √ null

Paid amount - Dollar amount that was actually paid for the service
BilledAmount money 21,4 √ null

Billed amount - Dollar amount that was originally billed for the service
Units int 4 √ null

Service units - Number of units of service provided (time, sessions, etc.)
Procedure nvarchar 510 √ null

Procedure code - CPT or procedure code for the service provided
MethodDes nvarchar 510 √ null

Method description - Description of the service delivery method
ProcedureDes nvarchar 510 √ null

Procedure description - Detailed description of the procedure or service
ErrorCode int 4 √ null

Primary error code - Primary error code if payment was rejected or adjusted
ErrorCode2 int 4 √ null

Secondary error code - Additional error code for complex payment issues
ErrorCode3 int 4 √ null

Tertiary error code - Third error code for multiple payment issues
ErrorCode4 int 4 √ null

Quaternary error code - Fourth error code for comprehensive error tracking
ClaimStatus int 4 √ null

Claim status - Current status of the claim (Paid, Denied, Pending, etc.)
Status char 10 √ null

Payment status - Overall payment processing status
Diagnosis nvarchar 40 √ null

Diagnosis code - ICD diagnosis code associated with the service
Billingtype int 4 √ null

Billing type - Type or category of billing (Insurance, Self-pay, etc.)
AgencyID int 4 √ null

Agency reference - Links to agency providing the service
SiteID int 4 √ null

Site reference - Links to site where service was provided
Transtype int 4 √ null

Transaction type - Type of financial transaction (Original, Adjustment, etc.)

Relationships

Close relationships within degrees of separation