Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

Staff

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to define practice level providers.

Field Datatype Default Null Option Comment
PracticeID INTEGER ?   MANDATORY FK
StaffID INTEGER ?   MANDATORY FK
StaffCode CHARACTER(6)   MANDATORY User entered code that uniquely identifies the staff member at the practice.
PositionCode CHARACTER(8)   OPTIONAL FK
DepartmentCode CHARACTER(3)   OPTIONAL FK
Class CHARACTER(6)   OPTIONAL User selects class (staff classes are defined in the MMCode table for the code type 'StaffClass' in the MMCodeType table and are user definable).
BillingLocationID INTEGER ?   OPTIONAL FK
FinanceCenterID INTEGER ?   OPTIONAL FK
ServiceCenterID INTEGER ?   OPTIONAL FK
DefaultSupervisor INTEGER ?   OPTIONAL FK
DefaultBillingProvider INTEGER ?   OPTIONAL FK
GLAcctSuffix CHARACTER(5)   OPTIONAL GL account suffix used to build gl account number dynamically.
RecordStatus CHARACTER(1)   MANDATORY User selected record status for the staff. 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.
PatientAssignable CHARACTER(1)   MANDATORY Patient assignable indicator, (Y)es position may have patients assigned or (N)o otherwise. User entered.
Billable CHARACTER(1)   MANDATORY Billable indicator, (Y)es - position is billable or (N)o otherwise. User entered.
Scheduled CHARACTER(1)   MANDATORY Scheduled indicator, (Y)es - position may be scheduled or (N)o otherwise. User entered.
ProviderType CHARACTER(1)   MANDATORY Defines the type of provider. Valid values are supported by the lookup type 'ProviderType'.
RxAllowed CHARACTER(1)   MANDATORY This flag indicates whether or not a staff member may issue prescriptions.
GroupBillingOverride CHARACTER(1) ?   OPTIONAL Indicates whether the provider has special instructions regarding Group Billing. Possible values: ? - No special Instruction, I - Provider always uses Individual Billing G - Provider always uses Group Billing
BillingOverrideStaffID INTEGER ?   OPTIONAL FK
SupervisorBillingOverride CHARACTER(1) ?   OPTIONAL Indicates whether the provider has special billing instructions regarding the supervising provider. Possible values: P - Use Plan Setting A - Always report supervisor as billing and performing provider O - Only report supervisor as billing provider N - Never report supervising provider as billing provider
CreditedStaffOverride CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether the a different provider gets credit for this provider's charges. Possible values: N - No, S - Supervisor get credit. O - Some other provider gets credit and is indicated by the CreditedStaffID field.
CreditedStaffID INTEGER ?   OPTIONAL FK
UseCosignature CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether the provider uses cosignature during the transcription sealing process. Possible values: N - Never O - Optional R - Required
UseSupervisor CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether the provider uses supervisor during the charge posting process. Possible values: N - Never O - Optional R - Required
MMUserSID INTEGER ?   OPTIONAL FK
DefaultSpecialtyCode CHARACTER(10)   OPTIONAL User entered. Specialty code. If it is a taxonomy specialty code, the first two characters must represent the provider type as validated by the lookup type mentioned. Field is supported by the lookup types:[TaxonomyProviderType]. Values are defined in the LookupCode table for the above lookup types.
UseCosignatureRx CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether the provider uses cosignature when issuing prescriptions. Lookup Type: CosignatureUsageMethod
SendCosignTaskRx CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether to send a Cosignature task to the supervisor before issuing the prescription. Lookup Type: CosignatureUsageMethod
UseCosignatureOrders CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether the provider uses cosignature when ordering labs or custom orders. Lookup Type: CosignatureUsageMethod
SendCosignTaskOrders CHARACTER(1) No_Value__N_   OPTIONAL Indicates whether to send a Cosignature task to the supervisor before marking a lab or custom order as Ordered. Lookup Type: CosignatureUsageMethod
UDSStaffingCategory CHAR(15)   OPTIONAL UDS Staffing Category.
ExcludeFromUDS LOGICAL Logical_False   MANDATORY Indicates if the Staff should be exluded from the UDS report.
OSHPDProvCategory CHAR(15)   OPTIONAL LookupType: OSHPDProvCategory
ExcludeFromOSHPD LOGICAL Logical_False   OPTIONAL When YES, the Staff will be excluded from OSHPD encounter reporting.
PhysicalBillLocationID INTEGER ?   OPTIONAL FK - Entity table. This is the provider's physical billing address and is only used as an exception. If the provider's correspondence address contains a PO box, we will need to report a physical address.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Entity Staff.PhysicalBillLocationID = Entity.EntitySID RESTRICT if Staff exists
Specialty Staff.DefaultSpecialtyCode = Specialty.SpecialtyCode SET NULL if Staff exists
Provider Staff.CreditedStaffID = Provider.ProviderID RESTRICT if Staff exists
Provider Staff.BillingOverrideStaffID = Provider.ProviderID RESTRICT if Staff exists
Practice Staff.PracticeID = Practice.PracticeID RESTRICT if Staff exists
Position Staff.PositionCode = Position.PositionCode RESTRICT if Staff exists
Department Staff.DepartmentCode = Department.DepartmentCode RESTRICT if Staff exists
Provider Staff.DefaultBillingProvider = Provider.ProviderID NONE if Staff exists
Provider Staff.DefaultSupervisor = Provider.ProviderID RESTRICT if Staff exists
Provider Staff.StaffID = Provider.ProviderID RESTRICT if Staff exists
Entity Staff.BillingLocationID = Entity.EntitySID RESTRICT if Staff exists
ServiceCenter Staff.ServiceCenterID = ServiceCenter.ServiceCenterID RESTRICT if Staff exists
FinanceCenter Staff.FinanceCenterID = FinanceCenter.FinanceCenterID RESTRICT if Staff exists

Child Tables
Child TableJoin PhraseWhen deleting Staff record...
RxChangeRequest RxChangeRequest.PracticeID = Staff.PracticeID and
RxChangeRequest.StaffID = Staff.StaffID		 RESTRICT if RxChangeRequest exists
PatientRxFill PatientRxFill.PracticeID = Staff.PracticeID and
PatientRxFill.StaffID = Staff.StaffID		 CASCADE if PatientRxFill exists
DURAlert DURAlert.PracticeID = Staff.PracticeID and
DURAlert.StaffID = Staff.StaffID		 RESTRICT if DURAlert exists
CardioOrder CardioOrder.PracticeID = Staff.PracticeID and
CardioOrder.StaffID = Staff.StaffID		 RESTRICT if CardioOrder exists
PatientOrderSet PatientOrderSet.PracticeID = Staff.PracticeID and
PatientOrderSet.SupervisingProviderID = Staff.StaffID		 RESTRICT if PatientOrderSet exists
PatientRx PatientRx.PracticeID = Staff.PracticeID and
PatientRx.SupervisingProviderID = Staff.StaffID		 RESTRICT if PatientRx exists
PracPersonSecureMessage PracPersonSecureMessage.PracticeID = Staff.PracticeID and
PracPersonSecureMessage.StaffID = Staff.StaffID		 RESTRICT if PracPersonSecureMessage exists
PatientRxDenial PatientRxDenial.PracticeID = Staff.PracticeID and
PatientRxDenial.StaffID = Staff.StaffID		 NONE if PatientRxDenial exists
RISStudy RISStudy.PracticeID = Staff.PracticeID and
RISStudy.SupervisingStaffID = Staff.StaffID		 RESTRICT if RISStudy exists
CLWCorrespondence CLWCorrespondence.PracticeID = Staff.PracticeID and
CLWCorrespondence.StaffID = Staff.StaffID		 RESTRICT if CLWCorrespondence exists
PatientVacDoseReaction PatientVacDoseReaction.PracticeID = Staff.PracticeID and
PatientVacDoseReaction.StaffID = Staff.StaffID		 SET NULL if PatientVacDoseReaction exists
PatientVacDoseAction PatientVacDoseAction.PracticeID = Staff.PracticeID and
PatientVacDoseAction.StaffID = Staff.StaffID		 RESTRICT if PatientVacDoseAction exists
PatientVacDose PatientVacDose.PracticeID = Staff.PracticeID and
PatientVacDose.StaffID = Staff.StaffID		 RESTRICT if PatientVacDose exists
RISStudy RISStudy.PracticeID = Staff.PracticeID and
RISStudy.StaffID = Staff.StaffID		 RESTRICT if RISStudy exists
Eligibility Eligibility.PracticeID = Staff.PracticeID and
Eligibility.StaffID = Staff.StaffID		 CASCADE if Eligibility exists
LabOrderTask LabOrderTask.PracticeID = Staff.PracticeID and
LabOrderTask.StaffID = Staff.StaffID		 CASCADE if LabOrderTask exists
RecallNotice RecallNotice.PracticeID = Staff.PracticeID and
RecallNotice.StaffID = Staff.StaffID		 NONE if RecallNotice exists
WorkersComp WorkersComp.PracticeID = Staff.PracticeID and
WorkersComp.StaffID = Staff.StaffID		 NONE if WorkersComp exists
TMSCatalog TMSCatalog.PracticeID = Staff.PracticeID and
TMSCatalog.PerformingProviderID = Staff.StaffID		 NONE if TMSCatalog exists
TMSCatalog TMSCatalog.PracticeID = Staff.PracticeID and
TMSCatalog.SupervisingProviderID = Staff.StaffID		 RESTRICT if TMSCatalog exists
PatientRx PatientRx.PracticeID = Staff.PracticeID and
PatientRx.StaffID = Staff.StaffID		 RESTRICT if PatientRx exists
RxRequest RxRequest.PracticeID = Staff.PracticeID and
RxRequest.StaffID = Staff.StaffID		 NONE if RxRequest exists
Encounter Encounter.PracticeID = Staff.PracticeID and
Encounter.StaffID = Staff.StaffID		 RESTRICT if Encounter exists
ApptRecall ApptRecall.PracticeID = Staff.PracticeID and
ApptRecall.StaffID = Staff.StaffID		 RESTRICT if ApptRecall exists
ApptStaff ApptStaff.PracticeID = Staff.PracticeID and
ApptStaff.StaffID = Staff.StaffID		 RESTRICT if ApptStaff exists
Charge Charge.PracticeID = Staff.PracticeID and
Charge.StaffID = Staff.StaffID		 CASCADE if Charge exists
Patient Patient.PracticeID = Staff.PracticeID and
Patient.StaffID = Staff.StaffID		 RESTRICT if Patient exists
ProcedureEvent ProcedureEvent.PracticeID = Staff.PracticeID and
ProcedureEvent.StaffID = Staff.StaffID		 RESTRICT if ProcedureEvent exists
ProcedureEvent ProcedureEvent.PracticeID = Staff.PracticeID and
ProcedureEvent.SupervisingStaffID = Staff.StaffID		 RESTRICT if ProcedureEvent exists
LabOrder LabOrder.PracticeID = Staff.PracticeID and
LabOrder.StaffID = Staff.StaffID		 RESTRICT if LabOrder exists
InpatientVisit InpatientVisit.PracticeID = Staff.PracticeID and
InpatientVisit.StaffID = Staff.StaffID		 RESTRICT if InpatientVisit exists