Table SESSIONS
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| SESSIONS | SES | Session | Training |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SES0 | COD | No | |
| SES1 | STG+STRDAT+COD | No | |
| SES2 | STG+COD | No | |
| SES3 | STRDAT+ENDDAT | Yes | |
| SES4 | REFNUMRH+COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD | Address | 3 | ADL | |||||
| AUUID | Single identifier | AUUID | ||||||
| CATACN | Action category | HRCAN | [HRCAN]HRCAN0=[V]GDOSLEG(1);CATACN | Block | ||||
| CERTYP | Certificate type | A | 10 | KPO | ||||
| COD | Session code | A | 15 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[SES]CRY | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CTRNUM | Contract | CTR | ||||||
| CTY | City | CTY | ||||||
| DATCNT | Certificate date | D | ||||||
| DES | Title | DES | ||||||
| DOM | Domain | ADI | [ADI]CODE=381;DOM | Block | ||||
| ENDDAT | End date | D | ||||||
| ENDTIM | End time | HM | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FLGCLO | Closed | M | 4 | 1 | ||||
| FLGCVTSTG | Training period agreement | M | 4 | 1 | ||||
| FLGDIF | DIF | M | 4 | 1 | ||||
| FLGINV | Invoice | M | 4 | 1 | ||||
| FLGSHEPRS | Attendance sheet | M | 4 | 1 | ||||
| FRTINT | Internal training | M | 4 | 1 | ||||
| LEVSTGQLF | Level training qual. | A | 10 | KPO | ||||
| NATFIS | Fiscal nature | HRFCN | [HRFCN]HRFCN0=[V]GDOSLEG(1);NATFIS | Block | ||||
| NBRDAY | Days | DCB | 4.2 | |||||
| NBRDAYSTG | Days | DCB | 4.2 | |||||
| NBRHOUBRK | Rest break | DCB | 9.2 | |||||
| NBRHOUIPT | Number of hours | DCB | 9.2 | |||||
| NBRHOUIPTHTT | Number of hours outside of WT | DCB | 9.2 | |||||
| NBRHOUSTG | Hours | DCB | 4.2 | |||||
| NBRPRTMAX | Maximum nb of attendees | C | 4 | |||||
| NBRPRTMIN | Minimum nb of attendees | C | 4 | |||||
| NBRPRTSTD | Participants | C | 4 | |||||
| ORG | Organization | ORF | [ORG]ORG0=[SES]ORG | Block | ||||
| POSCOD | Postal code | POS | ||||||
| REFNUMRH | HR administrator follow-up | MAT | [ID]ID0=[SES]REFNUMRH | Delete | ||||
| RSCNEC | Resources | 10 | ADI | [ADI]CODE=455;RSCNEC | Block | |||
| SHO | Short title | SHO | ||||||
| STASES | Session status | M | 15 | 466 | ||||
| STG | Training period | STG | [STG]STG0=[SES]STG | Block | ||||
| STGINI | Training initiative | A | 10 | KPO | ||||
| STGPRO | Training provider | A | 10 | KPO | ||||
| STGTYP | Training type | A | 10 | KPO | ||||
| STRDAT | Start date | D | ||||||
| STRTIM | Start time | HM | ||||||
| SUIACN | Follow-up actions | 10 | ADI | [ADI]CODE=466;SUIACN | Block | |||
| SUICMT | Follow-up comment | 10 | A | 100 | ||||
| SUIDAT | Tracking date | 10 | D | |||||
| TCHEMP | Trainer | TRN | [TRN]TRN0=CTRNUM;TCHEMP | Block | ||||
| TCHNAM | Trainer surname | A | 30 | |||||
| THM | Theme | ADI | [ADI]CODE=457;THM | Block | ||||
| TYPCNT | Certificate type | M | 15 | 468 | ||||
| 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 |