PaySourceIDs


Description

Payment source identifier management storing various identifier types and transmission IDs for payment sources across different programs. This table manages payment source identifiers including source IDs, ID types, transmitter IDs, and program associations, supporting electronic billing, claims transmission, and payment source identification for healthcare billing and reimbursement processes.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkSourceID varchar 20 √ null

Source identifier - Identifier for the payment source
IDType varchar 10 √ null

ID type - Type or category of the identifier (e.g., ‘NPI’, ‘TaxID’, ‘MemberID’)
TransmitterID varchar 20 √ null

Transmitter ID - Electronic transmission identifier for claims processing
fkProgramID int 4 √ null

Program reference - Links to program type that uses this payment source identifier

Relationships

Close relationships within degrees of separation