Table HREXTRACT
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| HREXTRACT | HREXT | Extract template | Common Data | KSA |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| HREXT0 | EXRTEP | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[HREXT]CREUSR | Other | ||||
| EXRBLODUP | Block duplicate run | M | 4 | 1 | ||||
| EXRCLEPRE | Clear previous data | M | 4 | 1 | ||||
| EXRCODACC | Access code | ACS | [ACS]ACS0=[HREXT]EXRCODACC | Block | ||||
| EXRDETMSG | Detail | A | 100 | |||||
| EXRFILEXT | File extension | A | 10 | |||||
| EXRFILNAM | File name | A | 50 | |||||
| EXRFLDQLF | Field delimiter | A | 1 | |||||
| EXRFLDSEP | Field separator | A | 1 | |||||
| EXRHEAMSG | Header | A | 100 | |||||
| EXRLIVIND | Live run | M | 4 | 1 | ||||
| EXRPRNFLG | M | 4 | 1 | |||||
| EXRPRNRPT | Print report | ARP | [ARP]ARP0=[HREXT]EXRPRNRPT | Block | ||||
| EXRSRCNAM | Generate script | ADC | ||||||
| EXRTEP | Code | HREXT | [HREXT]HREXT0=[HREXT]EXRTEP | Delete | ||||
| EXRTIT | Title | A | 50 | |||||
| EXRVLYOLY | Validation only | M | 4 | 1 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[HREXT]UPDUSR | Other |