Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CPID | int | 4 | null |
|
|
Claim program ID - Unique identifier for the claim type and program type combination |
||
| fkClaimTypeID | int | 4 | √ | null |
|
|
Claim type reference - Links to claim type classification |
|
| fkProgramID | int | 4 | √ | null |
|
|
Program reference - Links to program type |
|
| ReqAuth | int | 4 | √ | null |
|
|
Authorization required - Flag indicating if authorization is required for this claim type |
|
| MaxUnit | int | 4 | √ | null |
|
|
Maximum units - Maximum number of units allowed for this claim type |
|
| claimtypename | varchar | 100 | null |
|
|
Claim type name - Descriptive name of the claim type |
||
| programname | varchar | 255 | √ | null |
|
|
Program name - Descriptive name of the program type |
|
| claimid | int | 4 | null |
|
|
Claim reference - Links to the specific claim |
||
| paysourceid | varchar | 30 | √ | null |
|
|
Payment source - Identifier for the payment source or payer |
Relationships
Close relationships within degrees of separation
