Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ReferralActivity
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ReferralSID | INTEGER | ? | MANDATORY | FK |
| ActivityCount | INTEGER | 0 | MANDATORY | Activity Count. System generated number. |
| Class | CHARACTER(6) | OPTIONAL | System defined. Referral activity class. Field is supported by the lookup types:[ReferralActivity]. Values are defined in the LookupCode table for the above lookup types. | |
| ActivityDate | DATE | OPTIONAL | Referral Activity Date. System generated. | |
| Description | CHARACTER(60) | OPTIONAL | Referral Activity Description. Describes type of activity recorded. For example Referral Issued to Dr. Carrignton. Patient Notification Authorization Requested for Plan BCBSFL Authorization Received for Plan BCBSFL Approved Services Overridden by User1 Approved Provider Overriden by User1 | |
| 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... |
|---|---|---|
| Referral | ReferralActivity.ReferralSID = Referral.ReferralSID | CASCADE if ReferralActivity exists |
| Child Table | Join Phrase | When deleting ReferralActivity record... |
|---|