# SUB_INST: Sub-installations
- Name: `SUB_INST`
- Catalog: `AccountView`
- Label: Sub-installations
- Partition-specific: true
- Select: true
- Insert: false
- Update: false
- Delete: false
## Table Columns
The columns of the table `SUB_INST` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `CNG_DATE` | `datetime` | Date modified | ☐ | |
| `CNG_NR` | `int32` | Change number | ☐ | |
| `CNG_USR` | `string(20)` | Employee last modified | ☐ | |
| `INP_DATE` | `datetime` | Entry date | ☐ | |
| `INP_USR` | `string(20)` | Entered by employee | ☐ | |
| `INST_CODE` | `string(10)` | Sub-installation | ☐ | |
| `INST_DESC` | `string(40)` | Sub-installation description | ☐ | |
| `INST_DIR` | `string(240)` | Sub-installation folder | ☐ | |
| `INST_UPD` | `boolean` | Sub-installation must be updated | ☐ | |
| `partition_code` | `string` | Partition code | ☑ | |
| `partition_name` | `string` | Partition name | ☑ | |