The HSENVEXT table is used for adding test environment information and is populated during the Environment Extraction phase. The following table describes the columns in the HSENVEXT table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| MCRECID | BINARY | 4 | 0 | machine/company ID |
| FILRECID | BINARY | 9 | 0 | file ID |
| METHOD | CHARACTER | 10 | 0 | method name |
| NUMREC | BINARY | 9 | 0 | number of read records |
| REDBYT | DECIMAL | 18 | 0 | size reduction in bytes (difference in byte between original and reduced file size) |
| REDPERC | DECIMAL | 5 | 2 | size reduction percentage |
| CPUTIME | DECIMAL | 11 | 6 | CPU time in seconds |
| ELPTIME | DECIMAL | 11 | 6 | elapsed time in seconds |
| DATESIM | CHAR | 8 | 0 | date of last simulated extraction |
| DATEEXT | CHAR | 8 | 0 | date of last real extraction |