| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/D_CAG_CG_R | Capacity Graph Type R: Basic PN Capacity from Single Res. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
2 | /MRSS/D_CAG_CG_S | Capacity Graph Type S: Net PN Capacity from Single Res. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
3 | /MRSS/D_CAG_CG_T | Capacity Graph Type T: Gross PN Capacity from Single Res. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
4 | /MRSS/D_CAG_CG_U | Capacity Graph Type U: Basic PN Capacity from Single Res. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
5 | /MRSS/D_CAG_CG_V | Capacity Graph Type V: Basic PN Cap. with Oncalls fr.Sin.Res | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
6 | /MRSS/D_DAG_ASG | Demand Agr. Graph for Demand that is planned | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
7 | /MRSS/D_DAG_DEM | Demand Agr. Graph for Total and Attribute specific Demand | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
8 | /MRSS/D_DAG_MOB | OBSOLETE DB Table - NOT IN USE | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
9 | /MRSS/D_DAG_PAS | Demand Agr. Graph for Preparation/Warp-up of Assignments | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
10 | /MRSS/D_DAG_PDE | Demand Agr. Graph for expected Prep/Warp-up of unpl. Dem. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
11 | /MRSS/D_DAG_RSB | Demand Agr. Graph for virtual Reserve Base(non existing Dem) | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
12 | /MRSS/D_DAG_RSV | Demand Agr. Graph for virtual Reservation (non existing Dem) | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
13 | /MRSS/D_DAG_TAS | Demand Agr. Graph for Travel Times of Assignments | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
14 | /MRSS/D_DAG_TDE | Demand Agr. Graph for expected Travel Times of unpl. Dem. | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
15 | /MRSS/D_DAG_TRV | OBSOLETE DB Table - NOT IN USE | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
16 | /MRSS/D_DAG_UNA | Demand Agr. Graph for Demand that is not planned yet | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
TOPMaintenance Orders |
17 | /MRSS/D_CAG_CG_A | Type A Capacity Graphs: W/ Cap. Assignments & Reservations | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
18 | /MRSS/D_CAG_CG_B | Type B Capacity Graphs: W/o Cap. Assgmnts, w/ Reservations | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
19 | /MRSS/D_CAG_CG_C | Type C Capacity Graphs: with Cap. Assgmnts, w/o Reservations | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
20 | /MRSS/D_CAG_CG_D | Type D Capacity Graphs: w/o Cap. Assgmnts, w/ Reservations | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
21 | /MRSS/D_CAG_CG_G | Type G Capacity Graphs: Basic Availability w/o On-Call Times | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
22 | /MRSS/D_CAG_CG_H | Capacity Graph Type H: Basic Availability | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
23 | /MRSS/D_CAG_CG_J | Type J Capacity Graphs: W/ Cap. Assgn & Resv, w/o Oncall | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
24 | /MRSS/D_CAG_CG_K | Type K Capacity Graphs: W/o Cap. Assgmnts, w/Res, w/o Oncal | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
25 | /MRSS/D_CAG_CG_L | Type L Cap. Graphs: with Cap. Assgmnts, w/o Res, W/o Oncall | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
26 | /MRSS/D_CAG_CG_M | Type M Capacity Graphs: w/o Cap. Assgmnts, w/Res. w/o Oncall | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
27 | /MRSS/D_CAG_CG_P | Capacity Graph Type P: Basic Availability for Planning Node | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
28 | /MRSS/D_CAG_CG_Q | Capacity Graph Type Q: Net Availability for Planning Nodes | 5 | BEGTSTMP | Timestamp (with Conversion Routine) | decimal | 15 | 0 | | |
29 | /MRSS/D_CAG_LONG | Day wise Capacity Graphs | 4 | BEGTSTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |