| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOPH95: Tech Resources/Applications |
| 1 | F952411 | User Generated Contents History | 12 | UC | UGCARRSN | Archive Reason Code | 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 H95 / UH (Archive Reason Code - UGC) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | 00 | Initial Published Record | | N |
| 2 | 01 | Previous Published Record | | N |
| 3 | 02 | Published Record Deleted | | N |
| 4 | 03 | Restore - New Published Record | | N |
| 5 | 04 | Restore - Existing Published | | N |
| 6 | 05 | Replaced By History | | N |
| 7 | 06 | Oracle Update Package | | N |
| 8 | 07 | Transfer - Update | | N |
| 9 | 08 | Transfer - New Record | | N |
| 10 | 09 | Install - Update | | N |
| 11 | 10 | Install - New Record | | N |
