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.