Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ClearingHouseID | int identity | 4 | √ | null |
|
|
Primary key - ClearingHouse unique identifier for each record |
||||
| ClearingHouseName | Unknown | 0 | null |
|
|
Clearinghouse name - Official name of the clearinghouse organization |
|||||
| ContactInfo | Unknown | 0 | null |
|
|
Contact information - Phone, email, and address details for the clearinghouse |
|||||
| Name | varchar | 50 | null |
|
|
Clearinghouse name - Official business name of the clearinghouse organization |
|||||
| Description | varchar | 500 | √ | null |
|
|
Clearinghouse description - Detailed description of the clearinghouse services and capabilities |
||||
| Address | varchar | 50 | √ | null |
|
|
Street address - Primary business address of the clearinghouse |
||||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this clearinghouse is currently operational |
|||||
| State | varchar | 30 | √ | null |
|
|
State - State or province where the clearinghouse is located |
||||
| City | varchar | 50 | √ | null |
|
|
City - City where the clearinghouse is located |
||||
| Zip | varchar | 10 | √ | null |
|
|
ZIP code - Postal code for the clearinghouse address |
||||
| Telephone | varchar | 15 | √ | null |
|
|
Phone number - Primary business phone number for the clearinghouse |
||||
| Fax | varchar | 15 | √ | null |
|
|
Fax number - Fax number for document transmission to the clearinghouse |
||||
| Website | varchar | 100 | √ | null |
|
|
Website URL - Official website address for the clearinghouse |
||||
| Modem | varchar | 15 | √ | null |
|
|
Primary modem number - Main phone number for dial-up connections |
||||
| Notes | varchar | 500 | √ | null |
|
|
Administrative notes - Internal notes about the clearinghouse relationship and special instructions |
||||
| Signupdate | datetime | 16,3 | √ | null |
|
|
Signup date - Date when the relationship with this clearinghouse was established |
||||
| Address2 | varchar | 50 | √ | null |
|
|
Address line 2 - Additional address information (suite, building, etc.) |
||||
| Modem2 | varchar | 15 | √ | null |
|
|
Secondary modem number - Backup phone number for dial-up connections |
||||
| DnloadPath | varchar | 255 | √ | null |
|
|
Download path - File path for downloading files from the clearinghouse |
||||
| UploadPath | varchar | 255 | √ | null |
|
|
Upload path - File path for uploading files to the clearinghouse |
||||
| InterchangeQualifier | varchar | 2 | √ | null |
|
|
Interchange qualifier - EDI interchange qualifier code for electronic data exchange |
||||
| InterchangeID | varchar | 15 | √ | null |
|
|
Interchange ID - Unique identifier for EDI interchange communications |
||||
| AuthInfoQualifier | varchar | 2 | √ | null |
|
|
Authorization info qualifier - EDI authorization information qualifier code |
||||
| AuthInfo | varchar | 10 | √ | null |
|
|
Authorization information - Authorization data for secure EDI communications |
||||
| SecInfoQualifier | varchar | 2 | √ | null |
|
|
Security info qualifier - EDI security information qualifier code |
||||
| SecInfo | varchar | 10 | √ | null |
|
|
Security information - Security data for encrypted EDI communications |
||||
| InterchangeStandard | varchar | 1 | √ | null |
|
|
Interchange standard - EDI standard version used for data exchange (X12, EDIFACT, etc.) |
||||
| InterchangeControlVersion | varchar | 5 | √ | null |
|
|
Interchange control version - Version number of the EDI interchange control standards |
||||
| ETIN_Number | varchar | 20 | √ | null |
|
|
ETIN number - Electronic Transmitter Identification Number for IRS reporting |
||||
| RemitInterchangeID | varchar | 15 | √ | null |
|
|
Remittance interchange ID - Identifier for electronic remittance advice communications |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClearingHouse | Primary key | Asc | ClearingHouseID |