Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Department
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| DepartmentCode | CHARACTER(3) | MANDATORY | Department code is limited to numeric input although stored as a character. User entered. | |
| Name | CHARACTER(30) | MANDATORY | User entered descriptive department name. | |
| RecordStatus | CHARACTER(1) | MANDATORY | User selected record status. 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. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting Department record... |
|---|---|---|
| ServiceCenter | ServiceCenter.DepartmentCode = Department.DepartmentCode | RESTRICT if ServiceCenter exists |
| Charge | Charge.DepartmentCode = Department.DepartmentCode | RESTRICT if Charge exists |
| FinanceCenter | FinanceCenter.DepartmentCode = Department.DepartmentCode | RESTRICT if FinanceCenter exists |
| Procedure | Procedure.DepartmentCode = Department.DepartmentCode | RESTRICT if Procedure exists |
| Staff | Staff.DepartmentCode = Department.DepartmentCode | RESTRICT if Staff exists |