MTP/CTP Database

--- OBJECT INVENTORY ---
Tables Count: 57
Queries Count: 227
Forms Count: 40
Reports Count: 53
Modules Count: 10
Macros Count: 0
------------------------
--- TABLE RECORD COUNTS ---
Table: Audit | Rows: 35371
Table: Bike_Ped_Funding | Rows: 103
Table: Bike_Ped_List_Additional_Facilities | Rows: 9
Table: Bike_Ped_List_Inputs | Rows: 777
Table: Bike_Ped_Locations | Rows: 1161
Table: Bike_Ped_Related_Plans | Rows: 128
Table: Current_MTP_Horizon_Years | Rows: 4
Table: General Revisions | Rows: 66
Table: Locations | Rows: 63
Table: Modeled Capacities - Statistical Constraints | Rows: 5
Table: MTP_2040_Bike_Ped_Projects | Rows: 563
Table: MTP_2040_Snapshot | Rows: 613
Table: MTP_2045_Bike_Ped_Projects_Final | Rows: 775
Table: MTP_2045_Roadway_Projects_Snapshot_Final | Rows: 773
Table: MTP_2045_Transit_Projects_Final | Rows: 88
Table: MTP_2050_Roadway_Projects_Snapshot_Final | Rows: 931
Table: MTP_2050_Transit_Projects_Snapshot_Final | Rows: 100
Table: Project Revisions | Rows: 3719
Table: Project_Plan_List | Rows: 14
Table: Roadway_Capacity_Look_Up | Rows: 138
Table: Roadway_List_Additional_Facilities | Rows: 175
Table: Roadway_List_Additional_Purpose | Rows: 80
Table: Roadway_List_Benefit_Script_Output | Rows: 544
Table: Roadway_List_Cost_Cross_Section_Values | Rows: 43
Table: Roadway_List_Cost_Facility_Types | Rows: 24
Table: Roadway_List_Cost_Inputs | Rows: 1275
Table: Roadway_List_Funding_Scenario_Parameters | Rows: 3
Table: Roadway_List_GSI_Separation_Modes | Rows: 59
Table: Roadway_List_Inputs | Rows: 1283
Table: Roadway_List_Projected_Cumulative_Costs | Rows: 899
Table: Roadway_List_Purpose_Lookup | Rows: 11
Table: RPT_Scores_Current | Rows: 588
Table: Switchboard Items | Rows: 7
Table: TIP_IDs_COMMITTED_FY36 | Rows: 1364
Table: Transit_Assets | Rows: 19
Table: Transit_Corridors | Rows: 38
Table: Transit_Funding | Rows: 37
Table: Transit_List_Inputs | Rows: 329
Table: Transit_Locations | Rows: 78
Table: Transit_Related_Plans | Rows: 18
Table: Transit_Wake_Transit_ID_Crosswalk | Rows: 107



TIP Primary Database (NCDOT STIP Synchronization)

--- OBJECT INVENTORY ---
Tables Count: 61
Queries Count: 317
Forms Count: 16
Reports Count: 48
Modules Count: 4
Macros Count: 1
------------------------
--- TABLE RECORD COUNTS ---
Table: Activity_Lookup_Table | Rows: 21
Table: Audit | Rows: 12132
Table: AugustItemNProjData | Rows: 11
Table: CAMPO - CTP Roadway Projects - with TIP IDs | Rows: 136
Table: CAMPO_Activity_Tracker_Master_Project_Table | Rows: 845
Table: ItemNCounty_Division | Rows: 1324
Table: ItemNFundingData | Rows: 4409
Table: ItemNMPO_RPO_Data | Rows: 1427
Table: ItemNProjsData | Rows: 891
Table: Project Revisions | Rows: 357
Table: Roadway_List_Inputs | Rows: 1283
Table: STIP_Snapshot | Rows: 238
Table: tblActivities | Rows: 24
Table: tblCashFlowYears | Rows: 26
Table: tblCounty | Rows: 101
Table: tblDescription | Rows: 406
Table: tblDescription_0520 | Rows: 73
Table: tblDescription_0919 | Rows: 281
Skipping missing object: tblDescription_Updated_TIP
Table: tblFiscalYears | Rows: 17
Table: tblFundingData | Rows: 4933
Table: tblFundingData_0520 | Rows: 1626
Table: tblFundingData_0919 | Rows: 1695
Skipping missing object: tblFundingData_Updated_TIP
Table: tblInflationFactors | Rows: 28
Table: tblMPO | Rows: 592
Table: tblMPO_0520 | Rows: 287
Table: tblMPO_0919 | Rows: 292
Skipping missing object: tblMPO_Updated_TIP
Table: tblMPOData | Rows: 39
Table: tblProgramParameters | Rows: 25
Table: tblPrograms | Rows: 25
Table: tblProjectCountyLink | Rows: 698
Table: tblProjectCountyLink_0520 | Rows: 362
Table: tblProjectCountyLink_0919 | Rows: 352
Skipping missing object: tblProjectCountyLink_Updated_TIP
Table: tblProjectData | Rows: 505
Table: tblProjectData_0520 | Rows: 224
Table: tblProjectData_0919 | Rows: 238
Skipping missing object: tblProjectData_Updated_TIP
Table: tblRoutes | Rows: 667
Table: tblRoutes_0520 | Rows: 362
Table: tblRoutes_0919 | Rows: 364
Skipping missing object: tblRoutes_Updated_TIP
Table: tblSource | Rows: 113
Table: tblTIER | Rows: 3
Table: tblYears | Rows: 36
---------------------------



TIP Database (CAMPO Notes - Internal Use)

--- OBJECT INVENTORY ---
Tables Count: 21
Queries Count: 18
Forms Count: 7
Reports Count: 7
Modules Count: 0
Macros Count: 0
------------------------
--- TABLE RECORD COUNTS ---
Table: ConsultantStaff | Rows: 3
Table: Master_Project_Table | Rows: 845
Table: Meetings | Rows: 2766
Table: Staff | Rows: 14
Table: Switchboard Items | Rows: 1
Table: TIP_Sections | Rows: 166
---------------------------



LAPP Database (Fund Tracking)

--- OBJECT INVENTORY ---
Tables Count: 28
Queries Count: 5
Forms Count: 8
Reports Count: 3
Modules Count: 4
Macros Count: 0
------------------------
--- TABLE RECORD COUNTS ---
Table: LAPP_Notes | Rows: 266
Table: LAPP_Project_Entry | Rows: 0
Table: LAPP_Universe | Rows: 220
Table: lkupExposure | Rows: 4
Table: Name AutoCorrect Save Failures | Rows: 0
Table: Phase_Awards | Rows: 247
Table: tblCMAQ_Master | Rows: 2113
Table: tblCMAQ_Weekly | Rows: 2214
Table: tblRALEIGH_Master | Rows: 1234
Table: tblRALEIGH_Weekly | Rows: 1738
Table: tblSTOPLIGHT | Rows: 213
Table: tblVersion | Rows: 1
---------------------------



Wake Transit Database (Work Plan - Primary Repository)

--- OBJECT INVENTORY ---
Tables Count: 26
Queries Count: 79
Forms Count: 9
Reports Count: 27
Modules Count: 7
Macros Count: 1
------------------------
--- TABLE RECORD COUNTS ---
Table: BackupDates | Rows: 2
Table: Op/Cap Categories | Rows: 10
Table: Op/Cap Subcategories | Rows: 43
Table: Program and Horizon Year Options | Rows: 26
Table: ProgramAndHorizonYear | Rows: 2
Table: Projects | Rows: 332
Table: Projects - Service Details | Rows: 57
Table: Subprojects | Rows: 108
Table: tblAuditTrail | Rows: 8893
---------------------------