Agency


Description

Healthcare provider organizations representing the primary agencies that deliver healthcare services. This table stores the core organizational information for multi-tenant healthcare providers including early intervention programs, special education services, therapy providers, and other healthcare organizations using the system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AgencyID int 4 null
AccessUser.AgencyID Company_has_many_users R

Primary key - Unique identifier for each healthcare provider agency
ProviderID varchar 15 √ null

Provider identifier - External provider ID for insurance billing and regulatory reporting
CompanyName varchar 50 √ null

Agency name - Official name of the healthcare provider organization
Address varchar 50 √ null

Primary address - Street address of the agency’s main office
State varchar 15 √ null

State - State/province where the agency is located
City varchar 20 √ null

City - City where the agency’s main office is located
Zip varbinary 10 √ null

Postal code - ZIP/postal code for the agency’s address
Telephone varchar 15 √ null

Main phone - Primary telephone number for the agency
Ext int 4 √ null

Phone extension - Extension number for the main phone line
Fax varbinary 15 √ null

Fax number - Fax number for document transmission
ClearingHouseID int 4 √ null

Clearinghouse reference - Links to clearinghouse for electronic claims processing
Status char 5 √ null

Agency status - Current operational status of the agency (Active, Inactive, etc.)
ContactPerson varchar 50 √ null

Primary contact - Name of the main contact person for the agency
ContactPhone varchar 15 √ null

Contact phone - Direct phone number for the primary contact person
ContactFax varbinary 15 √ null

Contact fax - Fax number for the primary contact person
DatePayrollStart smalldatetime 16 √ null

Payroll start date - Date when payroll processing began for this agency

Indexes

Constraint Name Type Sort Column(s)
PK_ClientCompany Primary key Asc AgencyID
IX_Agency Performance Asc ProviderID

Relationships

Close relationships within degrees of separation