Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Adjustment
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ChargeSID | INTEGER | ? | MANDATORY | FK |
| ActivityCount | INTEGER | 0 | MANDATORY | FK |
| JournalSID | INTEGER | ? | MANDATORY | FK |
| PostDate | DATE | MANDATORY | FK | |
| Class | CHARACTER(6) | OPTIONAL | User selects adjustment class code. Adjustment class codes are defined in the LookupCode table for the lookup type 'AdjustClass'. Codes for lookup type 'AdjustClass' are user definable and are intended to facilitate the issues such as adjustment reason (i.e. over-charge, etc.). | |
| Amount | DECIMAL(10,2) | 0 | OPTIONAL | Total amount of adjustment including tax. |
| GLAccountTag | CHARACTER(8) | ? | MANDATORY | FK |
| ErrorCorrection | CHARACTER(1) | OPTIONAL | This field indicates whether or not the gl account type is for recording error corrections. Possible values are: (Y)es (N)o and are validated by the lookup type Confirmation. This field only applies to gl account types of class adjustment. | |
| TaxAmount | DECIMAL(10,2) | 0 | OPTIONAL | Amount of adjustment that was tax. |
| DueToVoid | CHARACTER(1) | OPTIONAL | System set flag to indicate if the adjustment was a result of a charge void. If the value is (Y)es then the adjustment was the result of a charge void. | |
| 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. |
| CreditedPlanID | INTEGER | ? | OPTIONAL | FK |
| Reason | CHAR(10) | OPTIONAL | The value in this field is used as way to categorize adjustments for financial calculations. As of 09/07/2007, possible values are: '', 'SLIDE'. 'CARECR', 'CAIDCR','SLIDEINS'. In the future we are considering other values. This is not related to appointment reasons. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Plan | Adjustment.CreditedPlanID = Plan.PlanID | RESTRICT if Adjustment exists |
| ChargeActivity | Adjustment.ChargeSID = ChargeActivity.ChargeSID and Adjustment.ActivityCount = ChargeActivity.ActivityCount |
CASCADE if Adjustment exists |
| Child Table | Join Phrase | When deleting Adjustment record... |
|---|