Table: Office
An office in a company.
| Name | Type | Description | Remarks |
|---|---|---|---|
| AccessLevel |
bit |
||
| AccessoryReplenish |
int |
||
| Address | Address
|
||
| BillingAddress |
int |
||
| BillingEIN |
varchar(15) |
||
| BillingNPI |
varchar(10) |
||
| BillingProviderName |
varchar(100) |
||
| CLExpirationMonth |
int |
The default number of months for contact lens Rx expiration. |
Default value is 12 months. |
| CLIANumber |
varchar(20) |
||
| CloseDate | |||
| CLReplenish |
int |
||
| CLSupplierAccount |
varchar(20) |
Account number by the contact lens supplier to identify the office. |
|
| CLSupplierID |
int |
||
|
CompanyId |
varchar(20) |
CompanyInfo The company the office belongs to. |
CompanyID is the foreign key to CompanyInfo table. |
| CostCenter |
nchar(20) |
||
| CreatePatientStockOrders |
bit |
||
| CreditCardProcessType |
bit |
CreditCardProcessType Indicates the type of credit card processing used by the office. |
|
| DefaultDC |
varchar(8) |
||
| DisableVendorOrdering |
bit |
Indicates if the vendor ordering is disabled in POS. |
|
| DisplayDetailedTaxOnReceipt |
bit |
Indicates if the tax detail is printed on the receipt. |
|
| Distance | |||
| DrSchedules |
int |
Indicates a doctor's schedule range. Valid values include: 1 = Weekly; 2 = Biweekly; 3 = Triweekly; 4 = Quadweekly. |
|
| EGExpirationMonth |
int |
The default number of months for eyeglass Rx expiration. |
Default value is 12 months. |
| EmployeeSchedule |
int |
||
| EMROfficeNum |
varchar(20) |
Identifier used to integrated the office with the EMR system. |
|
| EMRSystem |
int |
||
| ExamRooms |
int |
Number of exam rooms in the office. |
|
| ExternalID1 |
varchar(50) |
||
| ExternalID2 |
varchar(50) |
||
| ExternalOfficeNum |
varchar(8) |
||
|
PhoneNum |
varchar(14) |
Fax number of the office. |
|
| FrameReplenish |
int |
||
| GatewayEDIChildSiteID |
varchar(20) |
Child site id for the EDI 837 5010 |
|
| GatewayEDISiteID |
varchar(20) |
Trizetto partner id. |
|
| GLCashAccount |
varchar(50) |
GL cash account for the office. |
|
| GLCenter |
varchar(10) |
||
| GLChargeAccount |
varchar(50) |
GL charge account for the office. |
|
| GLSalesTaxAccount |
varchar(50) |
GL sales tax account for the office. |
|
| GLSalesTaxCenter |
varchar(50) |
GL sales tax center for the office. |
|
| IntegratedWithLabSystem |
bit |
||
| IPAddress |
varchar(15) |
IPAddressMask of the office. |
Used to determine if the workstation is on the office's subnet. |
| IsAccessoryAutoOrder |
bit |
Indicates if accessory orders automatically creates a stock order. |
|
| IsActive |
bit |
Indicates if the office is active. |
Used in combination with IsLiveOffice and IsRetail. |
| IsCallCenter |
bit |
Indicates if the office is a call center. |
|
| IsCLAutoOrder |
bit |
Indicates if contact lens orders automatically creates a stock order. |
|
| ISComparable | |||
| IsDefaultFamilyCheck |
bit |
Indicates if the EPM family check out is enabled. |
|
| IsFrameAutoOrder |
bit |
Indicates if eyeglass orders automatically creates a stock order. |
|
| IsIntegratedEMROffice |
bit |
Indicates if the office is integrated with an EMR system. |
|
| IsInventory |
bit |
Indicates if the office tracks inventory quantities. |
|
| IsLiveOffice |
bit |
Indicates if the office is live. |
Used in combination with IsActive and IsRetail. |
| IsMobileOffice |
bit |
Works in conjuction with ServiceLocation. |
|
| IsOnETime |
bit |
Indicates if the office uses ETime functionality. |
|
| isOverrideCompanyBillingInfo |
bit |
||
| IsPatientSharingDisabled |
bit |
Indicates if an office can access another office's patient data. |
|
| IsRetail |
bit |
Indicates if the office is a retail location. |
Used in combination with IsLiveOffice and IsActive. |
| IsShadowOffice |
bit |
||
| IsSingleLocation |
bit |
||
| IsTaxChargeOnReceivable |
bit |
Indicates if the tax is charged on the insurance receivable. |
|
| IsTaxOnCopay |
bit |
Indicates if the co-pay is taxable. |
|
| LabAccount |
varchar(20) |
||
| Latitude |
decimal(18,7) |
Latitude of the office location used by the back office appointment book. |
|
| LocationType |
int |
||
| Logo |
image |
Bytes of the office logo used on screens and reports. |
|
| LogoType |
varchar(50) |
Image extension (i.e., PNG) |
|
| Longitude |
decimal(18,7) |
Longitude of the office location used by the back office appointment book. |
|
| Market | User-defined region for office. |
MarketId is a foreign key to CatElementLU of LookupType 41. |
|
|
OfficeName |
varchar(40) |
User friendly name of the office that appears in the POS drop down. |
Column name in table is OfficeName. |
| NationalProviderId |
varchar(50) |
The office's default NationalProviderId (NPI). |
|
| NoCreditCardValidation |
bit |
||
| NpiType |
int |
||
| OfficeId |
int |
||
| OfficeKey |
varchar(10) |
||
| OfficeLegalName |
varchar(100) |
||
| OfficeLogo |
bit |
Indicates if the office logo is used instead of the company logo. |
|
|
OfficeTypeId |
int |
GenLookup User-defined classification for office. |
OfficeTypeId is a foreign key to CatElementLU of LookupType 42. |
| OverrideCompanyBillingPreference |
int |
||
| PageBreakOnSelectedStockPickListPref |
bit |
||
| PasswordExpireDays |
int |
||
| PaymentProcessBinNumber |
varchar(16) |
||
| PaymentProcessMerchantID |
varchar(16) |
||
| PaymentProcessMerchantPassword |
varchar(50) |
||
| PaymentProcessTerminalID |
varchar(16) |
||
| PayrollDepartment |
varchar(16) |
||
|
PhoneNum |
varchar(14) |
Phone number of the office. |
|
| PostingDate |
datetime |
||
| PrintLogo |
image |
Bytes of the office logo that can override the office logo. |
|
| PrintLogoType |
varchar(50) |
Image extension (i.e., JPG) |
|
| ScheduleStartDate | |||
| StockPickListPreference |
int |
Indicates if the pick list is displayed as a section or collection. |
|
|
bit |
|||
| TimeZone |
int |
UseDST UTC Timezone offset. |
|
| UseBES |
bit |
||
| UseDST |
bit |
Indicates if Daylight Saving Time (DST) should be used. |
related to: TimeZone |
| VendorBillToAddress |
int |
||
| VwCbsId |
bigint |
Office's identifier for VisionWeb integration. |