Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgencyID | int | 4 | null |
|
|
Agency identifier - Reference to the agency |
||
| UserName | varchar | 50 | √ | null |
|
|
Username - Username for RA system access |
|
| Passwd | varchar | 20 | √ | null |
|
|
Password - Password for RA system authentication |
|
| DnloadLocation | varchar | 275 | √ | null |
|
|
Download location - File path for downloading RA files |
|
| UploadLocation | varchar | 275 | √ | null |
|
|
Upload location - File path for uploading RA files |
|
| MainBBSnum | varchar | 15 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for RAUpdateInfo_vw records |
|
| AltBBSnum | varchar | 15 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for RAUpdateInfo_vw records |
|
| Category | varchar | 20 | √ | null |
|
|
Agency category - Business category for processing |
|
| Version | varchar | 19 | null |
|
|
Process version - Version identifier for the RA update process |