Table STAGE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| STAGE | STG | Training period | Training |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| STG0 | COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | 3 | ADL | |||||
| AUUID | Single identifier | AUUID | ||||||
| AUZPRH | Display portal | M | 4 | 1 | ||||
| CATACN | Action category | HRCAN | [HRCAN]HRCAN0=[V]GDOSLEG(1);CATACN | Block | ||||
| CATTRG | Target | ADI | [ADI]CODE=453;CATTRG | Block | ||||
| CNTPED | Teaching content | ACB | ||||||
| COD | Code | A | 10 | |||||
| CPCAFT | Induced skill | CPC | [CPC]CPC0=[STG]CPCAFT | Block | CPC | |||
| CPCNEC | Skills prerequisites | CPC | [CPC]CPC0=[STG]CPCNEC | Block | CPC | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[STG]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTRNUM | Contract | CTR | ||||||
| CTY | City | CTY | ||||||
| DES | Title | DES | ||||||
| DIFTRG | Training target | M | 4 | 1 | ||||
| DOM | Domain | ADI | [ADI]CODE=381;DOM | Block | ||||
| ENDTIMSTG | End time | HM | ||||||
| ENDVLY | End date | D | ||||||
| EXMAFT | Induced degree | A | 30 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FICTI | Dummy | M | 4 | 1 | ||||
| FLGDIF | DIF | M | 4 | 1 | ||||
| FLGPLF | Outside of plan | M | 4 | 1 | ||||
| FRTINT | Internal training | M | 4 | 1 | ||||
| LEVAFT | Induced level | NIV | CPC | |||||
| LEVEXM | Level | ADI | [ADI]CODE=382;LEVEXM | Block | ||||
| LEVNEC | Level prerequisites | NIV | CPC | |||||
| NATFIS | Fiscal nature | HRFCN | [HRFCN]HRFCN0=[V]GDOSLEG(1);NATFIS | Block | ||||
| NBRDAY | Days | DCB | 4.2 | |||||
| NBRHOUIPT | Number of hours | DCB | 9.2 | |||||
| NBRPRTMAX | Maximum nb of attendees | C | 4 | |||||
| NBRPRTMIN | Minimum nb of attendees | C | 4 | |||||
| NBRPRTSTD | Participants | C | 4 | |||||
| ORG | Organization | ORF | [ORG]ORG0=[STG]ORG | Block | ||||
| POSCOD | Postal code | POS | ||||||
| REF | Reference | A | 20 | |||||
| RSCNEC | Resources | 10 | ADI | [ADI]CODE=455;RSCNEC | Block | |||
| SHO | Short title | SHO | ||||||
| STGNEC | Training prerequisites | 5 | STG | [STG]STG0=[STG]STGNEC | Block | |||
| STRTIMSTG | Start time | HM | ||||||
| STRVLY | Start date | D | ||||||
| TCHEMP | Trainer | TRN | [TRN]TRN0=CTRNUM;TCHEMP | Block | ||||
| TCHNAM | Trainer surname | A | 30 | |||||
| THM | Theme | ADI | [ADI]CODE=457;THM | Block | ||||
| TRG | Target | A | 250 | |||||
| TYPFRT | System used | HRSUS | [HRSUS]HRSUS0=[V]GDOSLEG(1);TYPFRT | Block | ||||
| TYPSTG | Training period type | M | 15 | 428 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |