Table DEMANDE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| DEMANDE | DEM | Training request | Training |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DEM0 | DEMNUM | No | |
| DEM1 | STG+DEMNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CMT | Comments | AC0 | 2 | |||||
| CODCSI | Program code | CSI | [CSI]CSI0=[DEM]CODCSI | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTR | Contract | CTR | ||||||
| DATDEM | Request date | D | ||||||
| DATEND | End date | D | ||||||
| DATSTR | Start date | D | ||||||
| DEMNUM | Request number | VCR | ||||||
| DESCATACN | Action category | HRCAN | [HRCAN]HRCAN0=[V]GDOSLEG(1);DESCATACN | Block | ||||
| DESNATFIS | Fiscal nature | HRFCN | [HRFCN]HRFCN0=[V]GDOSLEG(1);DESNATFIS | Block | ||||
| DOM | Domain | ADI | [ADI]CODE=381;DOM | Block | ||||
| ENDDAT | Plan end date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FLGPLF | Outside of plan | M | 4 | 1 | ||||
| FLGPRO | Profession period | M | 4 | 1 | ||||
| ORI | Source | M | 15 | 456 | ||||
| ORIDEM | Request source | M | 15 | 472 | ||||
| PIO | Priority | M | 15 | 2953 | ||||
| REFNUM | Requester ID number | MAT | [ID]ID0=[DEM]REFNUM | Block | ||||
| SES | Session | SES | [SES]SES0=SES | Block | ||||
| STG | Training period | STG | [STG]STG0=STG | Block | ||||
| STRDAT | Plan start date | D | ||||||
| THM | Theme | ADI | [ADI]CODE=457;THM | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| YEAPLF | Plan year | HRPLF | [PLF]PLF0=[DEM]YEAPLF | BSRA |