| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /PICM/C_IAM_STCD | PICM: PICM - IAM status mapping | 2 | STACD | Status Code | nvarchar | 2 | 0 | | |
| 2 | /PICM/C_STATUS | PICM: Status Code | 5 | STACD | Status Code | nvarchar | 2 | 0 | | |
| 3 | /PICM/C_STA_T | PICM: Status text | 5 | STACD | Status Code | nvarchar | 2 | 0 | | |
| TOPLogbook |
| 4 | ADFSH_FLGTDET | Flight Scheduling: Flight Schedule Details | 10 | STACD | Flight Scheduling: Flight Status Code | nvarchar | 1 | 0 | | |
| 5 | ADFSH_FLGTMAS | Flight Scheduling: Flight Schedule Master | 14 | STACD | Flight Scheduling: Flight Status Code | nvarchar | 1 | 0 | | |
| 6 | ADFSH_FLGTSTAT | Flight Scheduling: Status of Flight | 2 | STACD | Flight Scheduling: Flight Status Code | nvarchar | 1 | 0 | | |
| 7 | ADFSH_FLGTSTAT_T | Flight Scheduling: Status of Flight Description | 3 | STACD | Flight Scheduling: Flight Status Code | nvarchar | 1 | 0 | | |
