BILL_SCHED_PMT_PAT_CSN
Description:
This table contains the patient contacts on the scheduled payment from the Billing Scheduled Payment (BSP) master file.
Primary Key
Column Name
Ordinal Position
SCHED_PMT_ID
1
LINE
2
Column Information
Name
Type
Discontinued?
1
SCHED_PMT_ID
NUMERIC
No
This column stores the unique identifier for the scheduled payment record.
2
LINE
INTEGER
No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3
PAT_ENC_CSN_ID
NUMERIC
No
This column stores the patient contact serial number (CSN) associated with the scheduled payment.