HCHB_FACILITIES

3552 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fa_id int 4 null
fa_name varchar 50 null
fa_street varchar 100 √ null
fa_city varchar 50 √ null
fa_state char 2 √ null
fa_zip varchar 10 √ null
fa_comment varchar 1000 √ null
fa_telephone varchar 25 √ null
fa_fax varchar 20 √ null
fa_pmid int 4 null
fa_rftid int 4 null
fa_parentcompany varchar 50 √ null
fa_active char 1 null
fa_insertdate datetime 16,3 null
fa_lastupdate datetime 16,3 null
fa_referringfacility char 1 null
fa_inpatientfacility char 1 null
fa_roomandboardrate float 8 null
fa_medicaidnumber varchar 100 √ null
fa_NPI varchar 50 √ null
fa_SSN varchar 11 √ null
fa_EIN varchar 11 √ null
fa_includeonclaims char 1 null
fa_webaccess char 1 null
fa_vnweb char 1 null
fa_rrtid int 4 null
fa_AddressMapped char 1 √ null
fa_faxVisitNote char 1 null
fa_Latitude decimal 20,15 √ null
fa_Longitude decimal 20,15 √ null
fa_hospiceinpatientencounters char 1 null
fa_LatLongMethod varchar 10 √ null
fa_OutpatientTreatmentProvider char 1 null
fa_GLCode varchar 50 √ null
fa_dsmnetwork int 4 √ null
fa_dsmaddress varchar 8000 √ null
fa_focid int 4 √ null
AVA_insert_date datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_FACILITIES Primary key Asc fa_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors