| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOPH96: Deployment |
| 1 | F9698710 | Change Table - Tables | 4 | TA | TICT | Table/Index Change Type | String | UDC | 2 | 0 |
| 2 | F9698712 | Change Table - Indexes | 5 | IX | TICT | Table/Index Change Type | String | UDC | 2 | 0 |
| 3 | F984072 | Table and Index Creation Log | 3 | CL | TICT | Table/Index Change Type | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC H96 / TA (Table/Index Change Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 1 | Create | | N |
| 2 | 2 | Drop | | N |
| 3 | 3 | Regenerate | | N |
