Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
ReferralTreatmentPlan
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ReferralSID | INTEGER | ? | MANDATORY | |
| TreatmentNumber | INTEGER | 0 | MANDATORY | |
| TreatmentCodeType | CHARACTER(1) | MANDATORY | The treatment plan procedure type. Possible values: (P)rocedure (G)roup | |
| TreatmentCode | CHARACTER(10) | MANDATORY | Procedure code which represents a procedure performed. User entered. | |
| Units | DECIMAL(10,2) | OPTIONAL | Units allowed for procedure or group. | |
| Visits | INTEGER | 0 | OPTIONAL | The number of allowed visits for the procedure or group. |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | Allowed amount for procedure or group. |
| Memo | CHARACTER(32000) | OPTIONAL | Narrative text associated with treatment. | |
| 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Procedure | ReferralTreatmentPlan.TreatmentCode = Procedure.ProcedureCode | RESTRICT if ReferralTreatmentPlan exists |
| Referral | ReferralTreatmentPlan.ReferralSID = Referral.ReferralSID | CASCADE if ReferralTreatmentPlan exists |
| Child Table | Join Phrase | When deleting ReferralTreatmentPlan record... |
|---|---|---|
| ReferralTreatmentResult | ReferralTreatmentResult.ReferralSID = ReferralTreatmentPlan.ReferralSID and ReferralTreatmentResult.TreatmentNumber = ReferralTreatmentPlan.TreatmentNumber |
RESTRICT if ReferralTreatmentResult exists |
| RefTreatmentPlanModifier | RefTreatmentPlanModifier.ReferralSID = ReferralTreatmentPlan.ReferralSID and RefTreatmentPlanModifier.TreatmentNumber = ReferralTreatmentPlan.TreatmentNumber |
CASCADE if RefTreatmentPlanModifier exists |