| 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. | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
2 | /MRSS/D_CAG_CG_S | Capacity Graph Type S: Net PN Capacity from Single Res. | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
3 | /MRSS/D_CAG_CG_T | Capacity Graph Type T: Gross PN Capacity from Single Res. | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
4 | /MRSS/D_CAG_CG_U | Capacity Graph Type U: Basic PN Capacity from Single Res. | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
5 | /MRSS/D_CAG_CG_V | Capacity Graph Type V: Basic PN Cap. with Oncalls fr.Sin.Res | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
6 | /MRSS/D_NN_ORG | Org unit assignment of N.N. Resources | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
7 | /MRSS/D_READ_LOG | resource logs table | 5 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
TOPMaintenance Orders |
8 | /MRSS/D_CAG_CG_A | Type A Capacity Graphs: W/ Cap. Assignments & Reservations | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
9 | /MRSS/D_CAG_CG_B | Type B Capacity Graphs: W/o Cap. Assgmnts, w/ Reservations | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
10 | /MRSS/D_CAG_CG_C | Type C Capacity Graphs: with Cap. Assgmnts, w/o Reservations | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
11 | /MRSS/D_CAG_CG_D | Type D Capacity Graphs: w/o Cap. Assgmnts, w/ Reservations | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
12 | /MRSS/D_CAG_CG_G | Type G Capacity Graphs: Basic Availability w/o On-Call Times | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
13 | /MRSS/D_CAG_CG_H | Capacity Graph Type H: Basic Availability | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
14 | /MRSS/D_CAG_CG_J | Type J Capacity Graphs: W/ Cap. Assgn & Resv, w/o Oncall | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
15 | /MRSS/D_CAG_CG_K | Type K Capacity Graphs: W/o Cap. Assgmnts, w/Res, w/o Oncal | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
16 | /MRSS/D_CAG_CG_L | Type L Cap. Graphs: with Cap. Assgmnts, w/o Res, W/o Oncall | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
17 | /MRSS/D_CAG_CG_M | Type M Capacity Graphs: w/o Cap. Assgmnts, w/Res. w/o Oncall | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
18 | /MRSS/D_CAG_CG_P | Capacity Graph Type P: Basic Availability for Planning Node | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
19 | /MRSS/D_CAG_CG_Q | Capacity Graph Type Q: Net Availability for Planning Nodes | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
20 | /MRSS/D_CAG_LONG | Day wise Capacity Graphs | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
21 | /MRSS/D_CH_RES | Time of Last Change for Resources | 2 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
22 | /MRSS/D_CLOCK | Time Recording Information for the Scheduling Engine | 2 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
23 | /MRSS/D_DEM_INFO | Informative Fields for Demand Items | 26 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
24 | /MRSS/D_GEO_GPS | Data table to hold actual GPS coordinates of a resource | 2 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
25 | /MRSS/D_TOUR_ATT | Attributes of Tour (Centroid) | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
26 | /MRSS/D_TRAVEL | Travel Times | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
TOPMaintenance Processing |
27 | /MRSS/D_BAS_ASG | MRS Basis Assignments | 5 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
28 | /MRSS/D_BAS_RES | Resource Master Data | 4 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
29 | /MRSS/D_DPR_REJ | Rejected resoruces | 9 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
30 | /MRSS/D_RES_QUAL | Resource Qualifications | 5 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
TOPSAP Multiresource Scheduling |
31 | /MRSS/D_OVERBOOK | Overbooking percentage for Internal resources | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
32 | /MRSS/D_POT_MD | Pot Master data attributes | 6 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
33 | /MRSS/D_POT_RES | Capacity Pots Resource table | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
34 | /MRSS/D_RES_CAP | Resource capacity and overbook information | 3 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |
TOPWorkforce Management Core |
35 | WFDSD_CANDIDATE | Candidate table | 4 | RESOURCE_KEY | GUID | varbinary | 16 | 0 | | |