Table HRDSANCHEAD
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| HRDSANCHEAD | HRDSNH | Sanction header | Common Data | DCP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| HRDSNH0 | SANNBR | No | |
| HRDSNH1 | REFNUM+CTRNUM+CTRDAT | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACNEMP | Action taken by | MAT | [ID]ID0=[HRDSNH]ACNEMP | Delete | ||||
| AUUID | Single identifier | AUUID | ||||||
| CMT | Comments | AC0 | 2 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[HRDSNH]CREUSR | Other | ||||
| CTRDAT | Date | D | ||||||
| CTRNUM | Contract | CTR | ||||||
| DPADAT | Departure date | D | ||||||
| ENDDAT | End date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[HRDSNH]FCY | Delete | ||||
| NAM | Name | A | 40 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[HRDSNH]REFNUM | Delete | ||||
| REN | Reason | A | 250 | |||||
| SANDAT | Date | D | ||||||
| SANNBR | Sanction no. | HRDS | [HRDSNH]HRDSNH0=[HRDSNH]SANNBR | Delete | ||||
| SANTYP | Sanction type | M | 5 | 10686 | ||||
| SRN | Employee's first name | A | 40 | |||||
| STRDAT | Start date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[HRDSNH]UPDUSR | Other | ||||
| VLY | Validated | M | 4 | 1 |