| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPOrganizational Flexibility |
| 1 | /ISDFPS/PM_TPCRO | Assignment of Training Program Function to Partner Role | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 2 | /ISDFPS/PM_TP_O | Flight Programs for Order | 5 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 3 | /ISDFPS/TRNGQUAL | Training - Qualification Mapping | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| TOPPersonnel Categories |
| 4 | PA0806 | Personnel Master Record for Infotype 0806 | 24 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 5 | TRAIN_FUNCT | Functions in Training Program | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 6 | TRAIN_FUNCT_T | Functions in Training Program - Description | 3 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 7 | TRAIN_PLAN_VAL | Planned Data for a Training Course | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 8 | TRAIN_PROG | Training Programs | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 9 | TRAIN_PROG_T | Training Program Description | 3 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 10 | TRAIN_QUALI | Mapping: Qualification to Training | 3 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 11 | TRAIN_STAT | Training Status | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 12 | TRAIN_STAT_T | Training Status Description | 3 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 13 | TRAIN_TRNGS | Training | 2 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
| 14 | TRAIN_TRNGS_T | Training Description | 3 | TPROG_ID | Training Program ID | nvarchar | 15 | 0 | | |
