OutsideSource


Description

External organization directory - Comprehensive registry of external organizations, referral sources, and partner entities that interact with the healthcare system. This table manages contact information, organizational details, and relationship data for schools, medical facilities, government agencies, and other external entities involved in patient care coordination, referrals, and service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SourceID int identity 4 √ null
OutsidesourceInProgramType.sourceid FK__Outsideso__sourc__0AB36FCB C
PatientReferral.OutSideSourceID FK__PatientRe__OutSi__753864A1 R

Source primary key - Unique identifier for each external organization
IDNum varchar 20 √ null

External ID number - Organization’s external identification number or code
CompanyName varchar 50 √ null

Organization name - Official name of the external organization
FirstName varchar 20 √ null

Contact first name - First name of primary contact person at the organization
LastName varchar 20 √ null

Contact last name - Last name of primary contact person at the organization
Address varchar 30 √ null

Street address - Physical street address of the organization
City varchar 30 √ null

City - City where the organization is located
State varchar 3 √ null

State - State or province where the organization is located
Zip varchar 10 √ null

ZIP code - Postal code for the organization’s address
Telephone varchar 15 √ null

Phone number - Primary telephone number for the organization
Fax varchar 15 √ null

Fax number - Fax number for the organization
Extension int 4 √ null

Phone extension - Extension number for the primary contact
Comments varchar 4000 √ null

Organization comments - Notes and additional information about the organization
SourceTypeID int 4 √ null
SourceType.sourceTypeID FK_OutsideSource_SourceType R

Source type reference - Links to SourceType table for organization classification
fkPayGroupID int 4 √ null

Payment group reference - Links to payment group for billing purposes
NPI varchar 10 √ null

National Provider Identifier - NPI number for healthcare providers
IsDeleted bit 1 √ null

Deletion flag - Indicates if the organization record has been soft deleted
Address2 nvarchar 1073741823 √ null

Secondary address - Additional address information (suite, floor, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK__OutsideSource__65F62111 Primary key Asc SourceID

Relationships

Close relationships within degrees of separation