Agency


Description

Primary healthcare provider organizations that use the iCentral system. This is the CENTRAL AUTHORITY table for agency information referenced across all client databases (Sandbox, iCentralMarketPlace, etc.). Each agency represents a distinct organization (clinic, therapy center, school district, etc.) that provides services to clients and submits claims for reimbursement. Agencies have their own configurations, billing settings, user access controls, and reporting requirements. This table serves as the master agency directory for the entire multi-tenant system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AgencyID int 4 null
AgencyAddons.fkAgencyID FK_AgencyAddon_Agency R
AgencyApps.fkAgencyID FK_AgencyApps_Agency R
AgencyConfirmation.AgencyID FK_AgencyConfirmation_Agency R
agencyInCategoryType.fkAgencyID FK__agencyInCategoryType__AgencyId C
AgencyPaymentInfo.fkAgencyID FK_AgencyPaymentInfo_Agency R
AgencyProgramType.AgencyID FK_AgencyProgramType_Agency R
AgencyScanForms.AgencyID FK__AgencySca__Agenc__7F2BE32F C
AgencySubTab.AgencyID FK__AgencySub__Agenc__18EBB532 C
Agreement.fkAgencyID FK_Agreement_Agency R
InvoiceItem.fkAgencyID FK_InvoiceItem_Agency R

Primary key - Agency unique identifier for each record
ProviderID varchar 15 null

Reference identifier - Foreign key reference to related entity or lookup table
CompanyName varchar 50 √ null

Agency name - Official business name of the healthcare provider organization, used in cross-database views like Sandbox.dbo.AgencyOutsideSrc_vw for unified organization directories
Address varchar 50 √ null

Street address - Primary business address for the agency, shared across all client database integrations
State varchar 20 √ null

State/Province - Geographic location for regulatory and billing purposes, used for compliance and service area determination across all systems
City varchar 20 √ null

City - Geographic location for service area determination and regional reporting across integrated databases
Zip varchar 15 √ null

Postal code - Used for geographic reporting and service area mapping
Telephone varchar 15 √ null

Primary phone - Main business contact number
Ext int 4 √ null

Phone extension - Extension number for the primary contact
Fax varchar 15 √ null

Fax number - Used for document transmission and legacy communications
ClearingHouseID int 4 √ null

Billing clearinghouse - Reference to the electronic billing service provider used for claims submission
Status char 10 √ null

Status indicator - Current operational status or state of Agency records
Category varchar 20 √ null

Data field - Category information for Agency business operations
contactid int 4 √ null

Contact reference - Reference to the primary contact person for this agency
SignUpCode uniqueidentifier 16 √ (newid())

Unique signup identifier - GUID used for secure agency registration and initial system access
agreement varchar 3 √ null

Agreement code - Reference to the service agreement or contract type governing the agency’s use of the system
evalbegin smalldatetime 16 √ null

Evaluation start date - Beginning of trial or evaluation period for new agencies
evalend smalldatetime 16 √ null

Evaluation end date - End of trial period, after which full billing may commence
ToBill varchar 5 √ null

Billing flag - Indicates whether this agency should be billed for system usage
Address2 varchar 20 √ null

Address line 2 - Additional address information
Email varchar 100 √ null

Primary email - Main contact email for administrative communications
ContactName varchar 100 √ null

Primary contact - Name of the main administrative contact person
Edition varchar 100 √ null

System edition - Version or feature set level assigned to this agency
varchar 50 √ null

Logo filename - Custom logo file for agency branding on reports and forms
DatePayrollStart smalldatetime 16 √ null

Payroll start date - Beginning of payroll cycle for staff billing calculations
LogoutMin int 4 √ null

Session timeout - Number of minutes of inactivity before automatic user logout
Invoice varchar 20 √ null

Invoice identifier - Custom invoice numbering or identifier format for this agency
implementationEndDate smalldatetime 16 √ null

Implementation end date - Date when the agency’s system implementation was completed
RateClaim money 21,4 √ null

Per-claim rate - Billing rate charged per individual claim processed
RateUnit money 21,4 √ null

Per-unit rate - Billing rate charged per service unit or transaction
RateFlat money 21,4 √ null

Flat rate - Fixed monthly or periodic billing rate regardless of usage
RateSCUnit money 21,4 √ null

Special care unit rate - Billing rate for specialized care or premium service units
billAhead int 4 √ null

Bill ahead days - Number of days in advance to generate bills for this agency
ContactID2 int 4 √ null

Secondary contact - Reference to an additional contact person for this agency
SupportMinutes int 4 √ null

Support allocation - Number of support minutes allocated per billing period
AllocatedSpace decimal 12,2 √ null

Storage allocation - Amount of data storage space allocated to this agency (in GB)
InvoiceName varchar 100 √ null

Invoice display name - Custom name to display on invoices and billing documents
PayInDays int 4 √ null

Payment terms - Number of days allowed for payment of invoices
companyNameFull varchar 100 √ null

Full company name - Complete legal business name for formal documents
LoginUrl varchar 50 √ null

Custom login URL - Agency-specific login URL or subdomain
website nvarchar 4000 √ null

Agency website - Official website URL for the healthcare provider organization
StripeInfo nvarchar 1073741823 √ null

Payment processor data - Encrypted payment processing configuration and account information
IsSocial bit 1 ((1))

Social features enabled - Whether social networking features are enabled for this agency
CustomRatesPerUser bit 1 ((0))

Custom user rates - Whether this agency has custom per-user billing rates
EnableSpecificFolder varchar 255 √ null

Folder restrictions - Specific folder path restrictions for file access and storage
DefaultAttestation varchar 2147483647 √ null

Default attestation text - Standard attestation or disclaimer text for this agency’s forms
LockDate datetime 16,3 √ null

Account lock date - Date when the agency account was locked or suspended
DefaultViewCalendar int 4 √ null

Default calendar view - Default calendar view setting for agency users
StartWorkingTime nvarchar 40 √ null

Business hours start - Standard start time for business operations
EndWorkingTime nvarchar 40 √ null

Business hours end - Standard end time for business operations
TaxID nvarchar 1073741823 √ null

Tax identification - Federal tax ID or EIN for billing and tax purposes
EndDateDiagnosisRequired bit 1 √ null

Diagnosis end date required - Whether diagnosis end dates are mandatory for this agency
DownloadDbCode varchar 100 √ null

Database download code - Special code for database download and backup operations
HomePageColor varchar 20 √ null

UI color scheme - Custom color scheme for the agency’s user interface
DefaultSignatureHeader varchar 2147483647 √ null

Default signature header - Standard header text for electronic signatures
BillingEmail1 varchar 50 √ null

Primary billing email - Primary email address for billing communications
BillingEmail2 varchar 50 √ null

Secondary billing email - Secondary email address for billing communications
BillingAddress1 varchar 1000 √ null

Billing address line 1 - Primary billing address for invoices
BillingAddress2 varchar 1000 √ null

Billing address line 2 - Additional billing address information
BillingCity varchar 100 √ null

Billing city - City for billing address
BillingState varchar 100 √ null

Billing state - State or province for billing address
BillingZip varchar 50 √ null

Billing postal code - ZIP or postal code for billing address
SalesTaxExemption bit 1 √ null

Sales tax exempt - Whether this agency is exempt from sales tax charges
ReferringNPI varchar 20 √ null

Referring provider NPI - National Provider Identifier for referring physicians
ReferringCompany varchar 100 √ null

Referring organization - Name of referring healthcare organization
ShowWelcomePopup bit 1 √ null

Welcome popup enabled - Whether to show welcome popup for new users
EnableMFA bit 1 √ null

Multi-factor authentication - Whether MFA is enabled for this agency
ForceMFAForAllUsers bit 1 √ null

Force MFA for all users - Whether MFA is mandatory for all agency users
MFADeviceTrustDurationDays int 4 √ null

MFA device trust duration - Number of days to trust MFA devices
EnablePhoneLogin bit 1 √ null

Phone login enabled - Whether users can log in using phone number

Indexes

Constraint Name Type Sort Column(s)
PK_ClientCompany Primary key Asc AgencyID
IX_Agency Must be unique Asc ProviderID
IX_Category Performance Asc Category
IX_Status Performance Asc Status

Relationships

Close relationships within degrees of separation