Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ServiceCenter
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ServiceCenterID | INTEGER | ? | MANDATORY | FK |
| ServiceCenterCode | CHARACTER(4) | MANDATORY | User entered code that uniquely identifies the service center. | |
| SortName | CHAR(70) | OPTIONAL | Programmatically set sort name. | |
| Class | CHARACTER(6) | OPTIONAL | User entered. User selects service center class code. Field is supported by the lookup types:[ServiceCtrClass]. Values are defined in the LookupCode table for the above lookup types. | |
| POSCode | CHARACTER(3) | OPTIONAL | FK | |
| DepartmentCode | CHARACTER(3) | OPTIONAL | FK | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status for the service center. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| ServiceCenterType | CHARACTER(2) | OPTIONAL | User entered service center type. Types are defined in the LookupCode table for the lookup type 'ServiceCtrType'. Codes for lookup type 'ServiceCtrType' are NOT user definable. Types are aka FacilityType and used for HIPAA billing. Example codes are: 77 Service Location FA Facility LI Independent Lab TL Testing Laboratory | |
| MarketCode | CHAR(6) | OPTIONAL | User entered. User selected service center market code. Service center market codes are defined in the lookup type. Field is supported by the lookup types:[ServiceCenterMarket]. Values are defined in the LookupCode table for the above lookup types. | |
| RegionCode | CHAR(6) | OPTIONAL | User entered. User selected service center region code. Service center region codes are defined in the lookup type. Field is supported by the lookup types:[ServiceCenterRegion]. Values are defined in the LookupCode table for the above lookup types. | |
| PracImmuRegistrySID | INTEGER | ? | OPTIONAL | FK |
| HSLOCCode | CHARACTER(8) | OPTIONAL | User selected HSLOC code for the Service Center. Field is supported by the CodeSystem: [HSLOC], which is derived from ValueSet: [HealthcareServiceLocation Industry standard coding system]. Values are defined in the ValueSetMember table. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Department | ServiceCenter.DepartmentCode = Department.DepartmentCode | RESTRICT if ServiceCenter exists |
| Entity | ServiceCenter.ServiceCenterID = Entity.EntitySID | CASCADE if ServiceCenter exists |
| Child Table | Join Phrase | When deleting ServiceCenter record... |
|---|---|---|
| CLWCorrespondence | CLWCorrespondence.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if CLWCorrespondence exists |
| PatientOMOrderSet | PatientOMOrderSet.ServiceCenterID = ServiceCenter.ServiceCenterID | SET NULL if PatientOMOrderSet exists |
| OBPregnancy | OBPregnancy.PlannedFacilityID = ServiceCenter.ServiceCenterID | SET NULL if OBPregnancy exists |
| RecallNotice | RecallNotice.ServiceCenterID = ServiceCenter.ServiceCenterID | NONE if RecallNotice exists |
| Lab | Lab.LabID = ServiceCenter.ServiceCenterID | CASCADE if Lab exists |
| Encounter | Encounter.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if Encounter exists |
| ApptRecall | ApptRecall.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if ApptRecall exists |
| Referral | Referral.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if Referral exists |
| ProcedureEvent | ProcedureEvent.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if ProcedureEvent exists |
| InpatientVisit | InpatientVisit.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if InpatientVisit exists |
| Staff | Staff.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if Staff exists |