Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
Referral
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ReferralSID | INTEGER | ? | MANDATORY | System generated unique number using the ReferralSID. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| RefType | CHARACTER(1) | MANDATORY | Referral type determines the type of referral. Valid values are: Referral (O)ut and Referral (I)n Referral type is supported by the lookup type Referral Type. | |
| RefNumber | CHARACTER(20) | OPTIONAL | User defined referral number. This number may be auto generated. | |
| RefClass | CHARACTER(6) | OPTIONAL | User defined referral classifications. Referral Class is supported by the lookup type Referral Class. | |
| RefStatus | CHARACTER(2) | OPTIONAL | Referral Status. The status values are system generated and are as follows: (I)ssued , (P)ending Authorization , (A)pproved (D)enied , (C)losed and (N)ew | |
| RefReason | CHARACTER(10) | OPTIONAL | User defined reason codes that describe reason for referral. This code is supported by the Lookup Type Referral Reason | |
| FromProviderID | INTEGER | ? | MANDATORY | FK |
| SpecialtyCode | CHARACTER(10) | OPTIONAL | FK | |
| ToProviderID | INTEGER | ? | OPTIONAL | FK |
| ServiceCenterID | INTEGER | ? | OPTIONAL | FK |
| StartDate | DATE | OPTIONAL | User entered date the referral became effective. | |
| EndDate | DATE | OPTIONAL | Referral End Date. User supplied value. This field defaults based on the Plan Referral parameter settings. | |
| ReferenceDate | DATE | OPTIONAL | Referral reference date. User defined. | |
| ApptDate | DATE | OPTIONAL | Patient scheduled appointment date. | |
| ApptTime | INTEGER | 0 | OPTIONAL | Aptient scheduled appointment time. |
| CloseDate | DATE | OPTIONAL | Date referral was closed. | |
| AdmitDate | DATE | OPTIONAL | Date patient was admited to the service center. | |
| ELOS | INTEGER | 0 | OPTIONAL | Estimated Length of Stay at service center. |
| DischargeDate | DATE | OPTIONAL | Date patient was discharged from the service center. | |
| InpatientFlag | CHARACTER(1) | OPTIONAL | Indicates if the referral is for inpatient treatment. Possible Values: (Y)es (N)o | |
| OnHoldFlag | CHARACTER(1) | OPTIONAL | Indicates if the referral is on hold. Possible values: (Y)es (N)o | |
| AllowedVisits | INTEGER | 0 | OPTIONAL | Maximum number of visits allowed in the referral. Zero means unlimited. |
| AllowedAmount | DECIMAL(10,2) | 0 | OPTIONAL | Maximum dollar amount allowed on the referral. Zero means unlimited. Note: If the referral has a treatment plan sepecified, the allowed amount will be derived from the treatment plan detail lines, otherwise the header value will be used. |
| UsedVisits | DECIMAL(10,2) | OPTIONAL | Number of visits used in the referral. Note: If the referral has results specified, the used visits will be derived from the result detail lines, otherwise the header value will be used. | |
| UsedAmount | DECIMAL(10,2) | OPTIONAL | Number of dollars used in the referral. Note: If the referral has a results specified, the used amount will be derived from the result detail lines, otherwise the header value will be used. | |
| AuthNumber | CHARACTER(30) | OPTIONAL | User specified referral authorization number. | |
| SourceReferralSID | INTEGER | ? | OPTIONAL | The referral SID of the parent referral. This field will be set by the system whenever a referral is referred to a provider within the same database. |
| 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. |
| DNSortReferralNumber | CHARACTER(20) | OPTIONAL | This is a denormalized field that is maintained by a customized write trigger and used for sorting purposes. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Provider | Referral.ToProviderID = Provider.ProviderID | RESTRICT if Referral exists |
| Provider | Referral.FromProviderID = Provider.ProviderID | RESTRICT if Referral exists |
| Specialty | Referral.SpecialtyCode = Specialty.SpecialtyCode | RESTRICT if Referral exists |
| ServiceCenter | Referral.ServiceCenterID = ServiceCenter.ServiceCenterID | RESTRICT if Referral exists |
| Practice | Referral.PracticeID = Practice.PracticeID | CASCADE if Referral exists |
| Patient | Referral.PracticeID = Patient.PracticeID and Referral.PatientID = Patient.PatientID |
RESTRICT if Referral exists |
| Child Table | Join Phrase | When deleting Referral record... |
|---|---|---|
| Appointment | Appointment.ReferralSID = Referral.ReferralSID | RESTRICT if Appointment exists |
| ReferralTreatmentResult | ReferralTreatmentResult.ReferralSID = Referral.ReferralSID | CASCADE if ReferralTreatmentResult exists |
| EAObjectData | EAObjectData.EAObjectSID = Referral.ReferralSID | CASCADE if EAObjectData exists |
| ReferralActivity | ReferralActivity.ReferralSID = Referral.ReferralSID | CASCADE if ReferralActivity exists |
| ReferralTreatmentPlan | ReferralTreatmentPlan.ReferralSID = Referral.ReferralSID | CASCADE if ReferralTreatmentPlan exists |
| ReferralDiagnosis | ReferralDiagnosis.ReferralSID = Referral.ReferralSID | CASCADE if ReferralDiagnosis exists |
| ProcedureEvent | ProcedureEvent.ReferralSID = Referral.ReferralSID | SET NULL if ProcedureEvent exists |
| ReferralNote | ReferralNote.ReferralSID = Referral.ReferralSID | CASCADE if ReferralNote exists |