Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| companyID | varchar | 33 | √ | null |
|
|
Company identifier - Calculated unique identifier combining type prefix (‘ag:’ for agency from iCS2.dbo.agency, ‘os:’ for outside source from local OutsideSource) with respective ID for unified organization identification |
|
| CompanyName | varchar | 50 | √ | null |
|
|
Company name - Name of the agency from iCS2.dbo.agency or outside organization from local OutsideSource table |
|
| Address | varchar | 50 | √ | null |
|
|
Street address - Physical address of the organization from either iCS2.dbo.agency or local OutsideSource |
|
| City | varchar | 30 | √ | null |
|
|
City - City where the organization is located from either source system |
|
| State | varchar | 20 | √ | null |
|
|
State - State or province where the organization is located from either source system |
|
| Zip | varchar | 15 | √ | null |
|
|
ZIP code - Postal code for the organization’s address from either source system |
|
| Telephone | varchar | 15 | √ | null |
|
|
Phone number - Primary telephone number for the organization from either source system |
|
| Fax | varchar | 15 | √ | null |
|
|
Fax number - Fax number for the organization from either source system |
|
| Ext | int | 4 | √ | null |
|
|
Extension - Phone extension number (Ext from iCS2.dbo.agency or Extension from local OutsideSource) |
|
| agencyID | int | 4 | null |
|
|
Agency ID - Internal agency ID from iCS2.dbo.agency (0 for outside sources to maintain consistent structure) |
||
| sourceID | int | 4 | null |
|
|
Source ID - Outside source ID from local OutsideSource table (0 for agencies to maintain consistent structure) |
Relationships
Close relationships within degrees of separation
