FilesExpand file tree

 master

/

AllTableCount.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

551 lines (551 loc) · 33.9 KB

 master

/

AllTableCount.sql

Top

File metadata and controls

• Code
• Blame

551 lines (551 loc) · 33.9 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

372

373

374

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

select 'ABSTRACT_TYPE', count(*) from ABSTRACT_TYPE;

select 'ACCOUNT_TYPE', count(*) from ACCOUNT_TYPE;

select 'ACCT_DD_ATTR_DOC', count(*) from ACCT_DD_ATTR_DOC;

select 'ACTIVITY_TYPE', count(*) from ACTIVITY_TYPE;

select 'AFFILIATION_TYPE', count(*) from AFFILIATION_TYPE;

select 'APPOINTMENT_TYPE', count(*) from APPOINTMENT_TYPE;

select 'ARG_VALUE_LOOKUP', count(*) from ARG_VALUE_LOOKUP;

select 'ATTACHMENT_FILE', count(*) from ATTACHMENT_FILE;

select 'AWARD', count(*) from AWARD;

select 'AWARD_AMOUNT_INFO', count(*) from AWARD_AMOUNT_INFO;

select 'AWARD_AMOUNT_TRANSACTION', count(*) from AWARD_AMOUNT_TRANSACTION;

select 'AWARD_AMT_FNA_DISTRIBUTION', count(*) from AWARD_AMT_FNA_DISTRIBUTION;

select 'AWARD_APPROVED_EQUIPMENT', count(*) from AWARD_APPROVED_EQUIPMENT;

select 'AWARD_APPROVED_FOREIGN_TRAVEL', count(*) from AWARD_APPROVED_FOREIGN_TRAVEL;

select 'AWARD_APPROVED_SUBAWARDS', count(*) from AWARD_APPROVED_SUBAWARDS;

select 'AWARD_ATTACHMENT', count(*) from AWARD_ATTACHMENT;

select 'AWARD_ATTACHMENT_TYPE', count(*) from AWARD_ATTACHMENT_TYPE;

select 'AWARD_BASIS_OF_PAYMENT', count(*) from AWARD_BASIS_OF_PAYMENT;

select 'AWARD_BUDGET_DETAILS_EXT', count(*) from AWARD_BUDGET_DETAILS_EXT;

select 'AWARD_BUDGET_EXT', count(*) from AWARD_BUDGET_EXT;

select 'AWARD_BUDGET_LIMIT', count(*) from AWARD_BUDGET_LIMIT;

select 'AWARD_BUDGET_PERIOD_EXT', count(*) from AWARD_BUDGET_PERIOD_EXT;

select 'AWARD_BUDGET_STATUS', count(*) from AWARD_BUDGET_STATUS;

select 'AWARD_BUDGET_TYPE', count(*) from AWARD_BUDGET_TYPE;

select 'AWARD_CLOSEOUT', count(*) from AWARD_CLOSEOUT;

select 'AWARD_COMMENT', count(*) from AWARD_COMMENT;

select 'AWARD_COST_SHARE', count(*) from AWARD_COST_SHARE;

select 'AWARD_CUSTOM_DATA', count(*) from AWARD_CUSTOM_DATA;

select 'AWARD_DOCUMENT', count(*) from AWARD_DOCUMENT;

select 'AWARD_EXEMPT_NUMBER', count(*) from AWARD_EXEMPT_NUMBER;

select 'AWARD_FUNDING_PROPOALS_BACKUP', count(*) from AWARD_FUNDING_PROPOALS_BACKUP;

select 'AWARD_FUNDING_PROPOSALS', count(*) from AWARD_FUNDING_PROPOSALS;

select 'AWARD_HIERARCHY', count(*) from AWARD_HIERARCHY;

select 'AWARD_IDC_RATE', count(*) from AWARD_IDC_RATE;

select 'AWARD_METHOD_OF_PAYMENT', count(*) from AWARD_METHOD_OF_PAYMENT;

select 'AWARD_NOTEPAD', count(*) from AWARD_NOTEPAD;

select 'AWARD_PAYMENT_SCHEDULE', count(*) from AWARD_PAYMENT_SCHEDULE;

select 'AWARD_PERSONS', count(*) from AWARD_PERSONS;

select 'AWARD_PERSON_CREDIT_SPLITS', count(*) from AWARD_PERSON_CREDIT_SPLITS;

select 'AWARD_PERSON_UNITS', count(*) from AWARD_PERSON_UNITS;

select 'AWARD_PERS_UNIT_CRED_SPLITS', count(*) from AWARD_PERS_UNIT_CRED_SPLITS;

select 'AWARD_REPORT_TERMS', count(*) from AWARD_REPORT_TERMS;

select 'AWARD_REP_TERMS_RECNT', count(*) from AWARD_REP_TERMS_RECNT;

select 'AWARD_SCIENCE_KEYWORD', count(*) from AWARD_SCIENCE_KEYWORD;

select 'AWARD_SPECIAL_REVIEW', count(*) from AWARD_SPECIAL_REVIEW;

select 'AWARD_SPONSOR_CONTACTS', count(*) from AWARD_SPONSOR_CONTACTS;

select 'AWARD_SPONSOR_TERM', count(*) from AWARD_SPONSOR_TERM;

select 'AWARD_STATUS', count(*) from AWARD_STATUS;

select 'AWARD_SYNC_CHANGE', count(*) from AWARD_SYNC_CHANGE;

select 'AWARD_SYNC_LOG', count(*) from AWARD_SYNC_LOG;

select 'AWARD_SYNC_STATUS', count(*) from AWARD_SYNC_STATUS;

select 'AWARD_TEMPLATE', count(*) from AWARD_TEMPLATE;

select 'AWARD_TEMPLATE_COMMENTS', count(*) from AWARD_TEMPLATE_COMMENTS;

select 'AWARD_TEMPLATE_CONTACT', count(*) from AWARD_TEMPLATE_CONTACT;

select 'AWARD_TEMPLATE_REPORT_TERMS', count(*) from AWARD_TEMPLATE_REPORT_TERMS;

select 'AWARD_TEMPLATE_TERMS', count(*) from AWARD_TEMPLATE_TERMS;

select 'AWARD_TEMPL_REP_TERMS_RECNT', count(*) from AWARD_TEMPL_REP_TERMS_RECNT;

select 'AWARD_TRANSACTION_TYPE', count(*) from AWARD_TRANSACTION_TYPE;

select 'AWARD_TRANSFERRING_SPONSOR', count(*) from AWARD_TRANSFERRING_SPONSOR;

select 'AWARD_TYPE', count(*) from AWARD_TYPE;

select 'AWARD_UNIT_CONTACTS', count(*) from AWARD_UNIT_CONTACTS;

select 'AWD_BGT_DET_CAL_AMTS_EXT', count(*) from AWD_BGT_DET_CAL_AMTS_EXT;

select 'AWD_BGT_PER_SUM_CALC_AMT', count(*) from AWD_BGT_PER_SUM_CALC_AMT;

select 'AWD_BUDGET_PER_CAL_AMTS_EXT', count(*) from AWD_BUDGET_PER_CAL_AMTS_EXT;

select 'AWD_BUDGET_PER_DET_EXT', count(*) from AWD_BUDGET_PER_DET_EXT;

select 'BATCH_CORRESPONDENCE', count(*) from BATCH_CORRESPONDENCE;

select 'BATCH_CORRESPONDENCE_DETAIL', count(*) from BATCH_CORRESPONDENCE_DETAIL;

select 'BUDGET', count(*) from BUDGET;

select 'BUDGET_CATEGORY', count(*) from BUDGET_CATEGORY;

select 'BUDGET_CATEGORY_MAPPING', count(*) from BUDGET_CATEGORY_MAPPING;

select 'BUDGET_CATEGORY_MAPS', count(*) from BUDGET_CATEGORY_MAPS;

select 'BUDGET_CATEGORY_TYPE', count(*) from BUDGET_CATEGORY_TYPE;

select 'BUDGET_DETAILS', count(*) from BUDGET_DETAILS;

select 'BUDGET_DETAILS_CAL_AMTS', count(*) from BUDGET_DETAILS_CAL_AMTS;

select 'BUDGET_DOCUMENT', count(*) from BUDGET_DOCUMENT;

select 'BUDGET_MODULAR', count(*) from BUDGET_MODULAR;

select 'BUDGET_MODULAR_IDC', count(*) from BUDGET_MODULAR_IDC;

select 'BUDGET_PERIODS', count(*) from BUDGET_PERIODS;

select 'BUDGET_PERIOD_TYPE', count(*) from BUDGET_PERIOD_TYPE;

select 'BUDGET_PERSONNEL_CAL_AMTS', count(*) from BUDGET_PERSONNEL_CAL_AMTS;

select 'BUDGET_PERSONNEL_DETAILS', count(*) from BUDGET_PERSONNEL_DETAILS;

select 'BUDGET_PERSONS', count(*) from BUDGET_PERSONS;

select 'BUDGET_PER_DET_RATE_AND_BASE', count(*) from BUDGET_PER_DET_RATE_AND_BASE;

select 'BUDGET_PROJECT_INCOME', count(*) from BUDGET_PROJECT_INCOME;

select 'BUDGET_RATE_AND_BASE', count(*) from BUDGET_RATE_AND_BASE;

select 'BUDGET_STATUS', count(*) from BUDGET_STATUS;

select 'BUDGET_SUB_AWARDS', count(*) from BUDGET_SUB_AWARDS;

select 'BUDGET_SUB_AWARD_ATT', count(*) from BUDGET_SUB_AWARD_ATT;

select 'BUDGET_SUB_AWARD_FILES', count(*) from BUDGET_SUB_AWARD_FILES;

select 'CARRIER_TYPE', count(*) from CARRIER_TYPE;

select 'CFDA', count(*) from CFDA;

select 'CITIZENSHIP_TYPE_T', count(*) from CITIZENSHIP_TYPE_T;

select 'CLOSEOUT_REPORT_TYPE', count(*) from CLOSEOUT_REPORT_TYPE;

select 'COEUS_MODULE', count(*) from COEUS_MODULE;

select 'COEUS_SUB_MODULE', count(*) from COEUS_SUB_MODULE;

select 'COMMENT_TYPE', count(*) from COMMENT_TYPE;

select 'COMMITTEE', count(*) from COMMITTEE;

select 'COMMITTEE_DOCUMENT', count(*) from COMMITTEE_DOCUMENT;

select 'COMMITTEE_TYPE', count(*) from COMMITTEE_TYPE;

select 'COMM_BATCH_CORRESP', count(*) from COMM_BATCH_CORRESP;

select 'COMM_BATCH_CORRESP_DETAIL', count(*) from COMM_BATCH_CORRESP_DETAIL;

select 'COMM_DECISION_MOTION_TYPE', count(*) from COMM_DECISION_MOTION_TYPE;

select 'COMM_MEMBERSHIPS', count(*) from COMM_MEMBERSHIPS;

select 'COMM_MEMBERSHIP_TYPE', count(*) from COMM_MEMBERSHIP_TYPE;

select 'COMM_MEMBER_EXPERTISE', count(*) from COMM_MEMBER_EXPERTISE;

select 'COMM_MEMBER_ROLES', count(*) from COMM_MEMBER_ROLES;

select 'COMM_RESEARCH_AREAS', count(*) from COMM_RESEARCH_AREAS;

select 'COMM_SCHEDULE', count(*) from COMM_SCHEDULE;

select 'COMM_SCHEDULE_ACT_ITEMS', count(*) from COMM_SCHEDULE_ACT_ITEMS;

select 'COMM_SCHEDULE_ATTENDANCE', count(*) from COMM_SCHEDULE_ATTENDANCE;

select 'COMM_SCHEDULE_FREQUENCY', count(*) from COMM_SCHEDULE_FREQUENCY;

select 'COMM_SCHEDULE_MINUTES', count(*) from COMM_SCHEDULE_MINUTES;

select 'COMM_SCHEDULE_MINUTE_DOC', count(*) from COMM_SCHEDULE_MINUTE_DOC;

select 'CONTACT_TYPE', count(*) from CONTACT_TYPE;

select 'CORRESPONDENT_TYPE', count(*) from CORRESPONDENT_TYPE;

select 'COST_ELEMENT', count(*) from COST_ELEMENT;

select 'COST_SHARE_TYPE', count(*) from COST_SHARE_TYPE;

select 'CUSTOM_ATTRIBUTE', count(*) from CUSTOM_ATTRIBUTE;

select 'CUSTOM_ATTRIBUTE_DATA_TYPE', count(*) from CUSTOM_ATTRIBUTE_DATA_TYPE;

select 'CUSTOM_ATTRIBUTE_DOCUMENT', count(*) from CUSTOM_ATTRIBUTE_DOCUMENT;

select 'CUSTOM_ATTRIBUTE_DOC_VALUE', count(*) from CUSTOM_ATTRIBUTE_DOC_VALUE;

select 'DEADLINE_TYPE', count(*) from DEADLINE_TYPE;

select 'DEGREE_TYPE', count(*) from DEGREE_TYPE;

select 'DISTRIBUTION', count(*) from DISTRIBUTION;

select 'DOCUMENT_NEXTVALUE', count(*) from DOCUMENT_NEXTVALUE;

select 'EPS_PROPOSAL', count(*) from EPS_PROPOSAL;

select 'EPS_PROPOSAL_BUDGET_EXT', count(*) from EPS_PROPOSAL_BUDGET_EXT;

select 'EPS_PROPOSAL_BUDGET_STATUS', count(*) from EPS_PROPOSAL_BUDGET_STATUS;

select 'EPS_PROPOSAL_DOCUMENT', count(*) from EPS_PROPOSAL_DOCUMENT;

select 'EPS_PROPOSAL_STATUS', count(*) from EPS_PROPOSAL_STATUS;

select 'EPS_PROP_ABSTRACT', count(*) from EPS_PROP_ABSTRACT;

select 'EPS_PROP_CHANGED_DATA', count(*) from EPS_PROP_CHANGED_DATA;

select 'EPS_PROP_COLUMNS_TO_ALTER', count(*) from EPS_PROP_COLUMNS_TO_ALTER;

select 'EPS_PROP_CONG_DISTRICT', count(*) from EPS_PROP_CONG_DISTRICT;

select 'EPS_PROP_COST_SHARING', count(*) from EPS_PROP_COST_SHARING;

select 'EPS_PROP_EXEMPT_NUMBER', count(*) from EPS_PROP_EXEMPT_NUMBER;

select 'EPS_PROP_IDC_RATE', count(*) from EPS_PROP_IDC_RATE;

select 'EPS_PROP_LA_RATES', count(*) from EPS_PROP_LA_RATES;

select 'EPS_PROP_LOCATION', count(*) from EPS_PROP_LOCATION;

select 'EPS_PROP_PERSON', count(*) from EPS_PROP_PERSON;

select 'EPS_PROP_PERSON_BIO', count(*) from EPS_PROP_PERSON_BIO;

select 'EPS_PROP_PERSON_BIO_ATTACHMENT', count(*) from EPS_PROP_PERSON_BIO_ATTACHMENT;

select 'EPS_PROP_PERSON_DEGREE', count(*) from EPS_PROP_PERSON_DEGREE;

select 'EPS_PROP_PERSON_EXT', count(*) from EPS_PROP_PERSON_EXT;

select 'EPS_PROP_PERSON_ROLE', count(*) from EPS_PROP_PERSON_ROLE;

select 'EPS_PROP_PERSON_UNITS', count(*) from EPS_PROP_PERSON_UNITS;

select 'EPS_PROP_PERS_YNQ', count(*) from EPS_PROP_PERS_YNQ;

select 'EPS_PROP_PER_CREDIT_SPLIT', count(*) from EPS_PROP_PER_CREDIT_SPLIT;

select 'EPS_PROP_PER_DOC_TYPE', count(*) from EPS_PROP_PER_DOC_TYPE;

select 'EPS_PROP_RATES', count(*) from EPS_PROP_RATES;

select 'EPS_PROP_SCIENCE_KEYWORD', count(*) from EPS_PROP_SCIENCE_KEYWORD;

select 'EPS_PROP_SITES', count(*) from EPS_PROP_SITES;

select 'EPS_PROP_SPECIAL_REVIEW', count(*) from EPS_PROP_SPECIAL_REVIEW;

select 'EPS_PROP_UNIT_CREDIT_SPLIT', count(*) from EPS_PROP_UNIT_CREDIT_SPLIT;

select 'EPS_PROP_USER_ROLES', count(*) from EPS_PROP_USER_ROLES;

select 'EPS_PROP_YNQ', count(*) from EPS_PROP_YNQ;

select 'EXEMPTION_TYPE', count(*) from EXEMPTION_TYPE;

select 'EXEMPT_STUDIES_CHECKLIST', count(*) from EXEMPT_STUDIES_CHECKLIST;

select 'EXPEDITED_REVIEW_CHECKLIST', count(*) from EXPEDITED_REVIEW_CHECKLIST;

select 'FP_DOC_TYPE_T', count(*) from FP_DOC_TYPE_T;

select 'FREQUENCY', count(*) from FREQUENCY;

select 'FREQUENCY_BASE', count(*) from FREQUENCY_BASE;

select 'FUNDING_SOURCE_TYPE', count(*) from FUNDING_SOURCE_TYPE;

select 'GROUP_TYPES', count(*) from GROUP_TYPES;

select 'IDC_RATE_TYPE', count(*) from IDC_RATE_TYPE;

select 'INSTITUTE_LA_RATES', count(*) from INSTITUTE_LA_RATES;

select 'INSTITUTE_PROPOSAL_DOCUMENT', count(*) from INSTITUTE_PROPOSAL_DOCUMENT;

select 'INSTITUTE_RATES', count(*) from INSTITUTE_RATES;

select 'INV_CREDIT_TYPE', count(*) from INV_CREDIT_TYPE;

select 'IP_REVIEW', count(*) from IP_REVIEW;

select 'IP_REVIEW_ACTIVITY_TYPE', count(*) from IP_REVIEW_ACTIVITY_TYPE;

select 'IP_REVIEW_REQ_TYPE', count(*) from IP_REVIEW_REQ_TYPE;

select 'IP_REVIEW_RESULT_TYPE', count(*) from IP_REVIEW_RESULT_TYPE;

select 'JOB_CODE', count(*) from JOB_CODE;

select 'KC_QRTZ_BLOB_TRIGGERS', count(*) from KC_QRTZ_BLOB_TRIGGERS;

select 'KC_QRTZ_CALENDARS', count(*) from KC_QRTZ_CALENDARS;

select 'KC_QRTZ_CRON_TRIGGERS', count(*) from KC_QRTZ_CRON_TRIGGERS;

select 'KC_QRTZ_FIRED_TRIGGERS', count(*) from KC_QRTZ_FIRED_TRIGGERS;

select 'KC_QRTZ_JOB_DETAILS', count(*) from KC_QRTZ_JOB_DETAILS;

select 'KC_QRTZ_JOB_LISTENERS', count(*) from KC_QRTZ_JOB_LISTENERS;

select 'KC_QRTZ_LOCKS', count(*) from KC_QRTZ_LOCKS;

select 'KC_QRTZ_PAUSED_TRIGGER_GRPS', count(*) from KC_QRTZ_PAUSED_TRIGGER_GRPS;

select 'KC_QRTZ_SCHEDULER_STATE', count(*) from KC_QRTZ_SCHEDULER_STATE;

select 'KC_QRTZ_SIMPLE_TRIGGERS', count(*) from KC_QRTZ_SIMPLE_TRIGGERS;

select 'KC_QRTZ_TRIGGERS', count(*) from KC_QRTZ_TRIGGERS;

select 'KC_QRTZ_TRIGGER_LISTENERS', count(*) from KC_QRTZ_TRIGGER_LISTENERS;

select 'KRA_USER', count(*) from KRA_USER;

select 'KREN_CHNL_PRODCR_T', count(*) from KREN_CHNL_PRODCR_T;

select 'KREN_CHNL_SUBSCRP_T', count(*) from KREN_CHNL_SUBSCRP_T;

select 'KREN_CHNL_T', count(*) from KREN_CHNL_T;

select 'KREN_CNTNT_TYP_T', count(*) from KREN_CNTNT_TYP_T;

select 'KREN_MSG_DELIV_T', count(*) from KREN_MSG_DELIV_T;

select 'KREN_MSG_T', count(*) from KREN_MSG_T;

select 'KREN_NTFCTN_MSG_DELIV_T', count(*) from KREN_NTFCTN_MSG_DELIV_T;

select 'KREN_NTFCTN_T', count(*) from KREN_NTFCTN_T;

select 'KREN_PRIO_T', count(*) from KREN_PRIO_T;

select 'KREN_PRODCR_T', count(*) from KREN_PRODCR_T;

select 'KREN_RECIP_DELIV_T', count(*) from KREN_RECIP_DELIV_T;

select 'KREN_RECIP_LIST_T', count(*) from KREN_RECIP_LIST_T;

select 'KREN_RECIP_PREFS_T', count(*) from KREN_RECIP_PREFS_T;

select 'KREN_RECIP_T', count(*) from KREN_RECIP_T;

select 'KREN_RVWER_T', count(*) from KREN_RVWER_T;

select 'KREN_SNDR_T', count(*) from KREN_SNDR_T;

select 'KREW_ACTN_ITM_T', count(*) from KREW_ACTN_ITM_T;

select 'KREW_ACTN_RQST_T', count(*) from KREW_ACTN_RQST_T;

select 'KREW_ACTN_TKN_T', count(*) from KREW_ACTN_TKN_T;

select 'KREW_APP_DOC_STAT_TRAN_T', count(*) from KREW_APP_DOC_STAT_TRAN_T;

select 'KREW_ATT_T', count(*) from KREW_ATT_T;

select 'KREW_DLGN_RSP_T', count(*) from KREW_DLGN_RSP_T;

select 'KREW_DOC_HDR_CNTNT_T', count(*) from KREW_DOC_HDR_CNTNT_T;

select 'KREW_DOC_HDR_EXT_DT_T', count(*) from KREW_DOC_HDR_EXT_DT_T;

select 'KREW_DOC_HDR_EXT_FLT_T', count(*) from KREW_DOC_HDR_EXT_FLT_T;

select 'KREW_DOC_HDR_EXT_LONG_T', count(*) from KREW_DOC_HDR_EXT_LONG_T;

select 'KREW_DOC_HDR_EXT_T', count(*) from KREW_DOC_HDR_EXT_T;

select 'KREW_DOC_HDR_T', count(*) from KREW_DOC_HDR_T;

select 'KREW_DOC_LNK_T', count(*) from KREW_DOC_LNK_T;

select 'KREW_DOC_NTE_T', count(*) from KREW_DOC_NTE_T;

select 'KREW_DOC_TYP_APP_DOC_STAT_T', count(*) from KREW_DOC_TYP_APP_DOC_STAT_T;

select 'KREW_DOC_TYP_ATTR_T', count(*) from KREW_DOC_TYP_ATTR_T;

select 'KREW_DOC_TYP_PLCY_RELN_T', count(*) from KREW_DOC_TYP_PLCY_RELN_T;

select 'KREW_DOC_TYP_PROC_T', count(*) from KREW_DOC_TYP_PROC_T;

select 'KREW_DOC_TYP_T', count(*) from KREW_DOC_TYP_T;

select 'KREW_EDL_ASSCTN_T', count(*) from KREW_EDL_ASSCTN_T;

select 'KREW_EDL_DEF_T', count(*) from KREW_EDL_DEF_T;

select 'KREW_EDL_DMP_T', count(*) from KREW_EDL_DMP_T;

select 'KREW_EDL_FLD_DMP_T', count(*) from KREW_EDL_FLD_DMP_T;

select 'KREW_HLP_T', count(*) from KREW_HLP_T;

select 'KREW_INIT_RTE_NODE_INSTN_T', count(*) from KREW_INIT_RTE_NODE_INSTN_T;

select 'KREW_OUT_BOX_ITM_T', count(*) from KREW_OUT_BOX_ITM_T;

select 'KREW_RIA_DOCTYPE_MAP_T', count(*) from KREW_RIA_DOCTYPE_MAP_T;

select 'KREW_RIA_DOC_T', count(*) from KREW_RIA_DOC_T;

select 'KREW_RMV_RPLC_DOC_T', count(*) from KREW_RMV_RPLC_DOC_T;

select 'KREW_RMV_RPLC_GRP_T', count(*) from KREW_RMV_RPLC_GRP_T;

select 'KREW_RMV_RPLC_RULE_T', count(*) from KREW_RMV_RPLC_RULE_T;

select 'KREW_RTE_BRCH_PROTO_T', count(*) from KREW_RTE_BRCH_PROTO_T;

select 'KREW_RTE_BRCH_ST_T', count(*) from KREW_RTE_BRCH_ST_T;

select 'KREW_RTE_BRCH_T', count(*) from KREW_RTE_BRCH_T;

select 'KREW_RTE_NODE_CFG_PARM_T', count(*) from KREW_RTE_NODE_CFG_PARM_T;

select 'KREW_RTE_NODE_INSTN_LNK_T', count(*) from KREW_RTE_NODE_INSTN_LNK_T;

select 'KREW_RTE_NODE_INSTN_ST_T', count(*) from KREW_RTE_NODE_INSTN_ST_T;

select 'KREW_RTE_NODE_INSTN_T', count(*) from KREW_RTE_NODE_INSTN_T;

select 'KREW_RTE_NODE_LNK_T', count(*) from KREW_RTE_NODE_LNK_T;

select 'KREW_RTE_NODE_T', count(*) from KREW_RTE_NODE_T;

select 'KREW_RULE_ATTR_T', count(*) from KREW_RULE_ATTR_T;

select 'KREW_RULE_EXPR_T', count(*) from KREW_RULE_EXPR_T;

select 'KREW_RULE_EXT_T', count(*) from KREW_RULE_EXT_T;

select 'KREW_RULE_EXT_VAL_T', count(*) from KREW_RULE_EXT_VAL_T;

select 'KREW_RULE_RSP_T', count(*) from KREW_RULE_RSP_T;

select 'KREW_RULE_T', count(*) from KREW_RULE_T;

select 'KREW_RULE_TMPL_ATTR_T', count(*) from KREW_RULE_TMPL_ATTR_T;

select 'KREW_RULE_TMPL_OPTN_T', count(*) from KREW_RULE_TMPL_OPTN_T;

select 'KREW_RULE_TMPL_T', count(*) from KREW_RULE_TMPL_T;

select 'KREW_STYLE_T', count(*) from KREW_STYLE_T;

select 'KREW_USR_OPTN_T', count(*) from KREW_USR_OPTN_T;

select 'KRIM_ADDR_TYP_T', count(*) from KRIM_ADDR_TYP_T;

select 'KRIM_AFLTN_TYP_T', count(*) from KRIM_AFLTN_TYP_T;

select 'KRIM_ATTR_DEFN_T', count(*) from KRIM_ATTR_DEFN_T;

select 'KRIM_CTZNSHP_STAT_T', count(*) from KRIM_CTZNSHP_STAT_T;

select 'KRIM_DLGN_MBR_ATTR_DATA_T', count(*) from KRIM_DLGN_MBR_ATTR_DATA_T;

select 'KRIM_DLGN_MBR_T', count(*) from KRIM_DLGN_MBR_T;

select 'KRIM_DLGN_T', count(*) from KRIM_DLGN_T;

select 'KRIM_EMAIL_TYP_T', count(*) from KRIM_EMAIL_TYP_T;

select 'KRIM_EMP_STAT_T', count(*) from KRIM_EMP_STAT_T;

select 'KRIM_EMP_TYP_T', count(*) from KRIM_EMP_TYP_T;

select 'KRIM_ENTITY_ADDR_T', count(*) from KRIM_ENTITY_ADDR_T;

select 'KRIM_ENTITY_AFLTN_T', count(*) from KRIM_ENTITY_AFLTN_T;

select 'KRIM_ENTITY_BIO_T', count(*) from KRIM_ENTITY_BIO_T;

select 'KRIM_ENTITY_CACHE_T', count(*) from KRIM_ENTITY_CACHE_T;

select 'KRIM_ENTITY_CTZNSHP_T', count(*) from KRIM_ENTITY_CTZNSHP_T;

select 'KRIM_ENTITY_EMAIL_T', count(*) from KRIM_ENTITY_EMAIL_T;

select 'KRIM_ENTITY_EMP_INFO_T', count(*) from KRIM_ENTITY_EMP_INFO_T;

select 'KRIM_ENTITY_ENT_TYP_T', count(*) from KRIM_ENTITY_ENT_TYP_T;

select 'KRIM_ENTITY_ETHNIC_T', count(*) from KRIM_ENTITY_ETHNIC_T;

select 'KRIM_ENTITY_EXT_ID_T', count(*) from KRIM_ENTITY_EXT_ID_T;

select 'KRIM_ENTITY_NM_T', count(*) from KRIM_ENTITY_NM_T;

select 'KRIM_ENTITY_PHONE_T', count(*) from KRIM_ENTITY_PHONE_T;

select 'KRIM_ENTITY_PRIV_PREF_T', count(*) from KRIM_ENTITY_PRIV_PREF_T;

select 'KRIM_ENTITY_RESIDENCY_T', count(*) from KRIM_ENTITY_RESIDENCY_T;

select 'KRIM_ENTITY_T', count(*) from KRIM_ENTITY_T;

select 'KRIM_ENTITY_VISA_T', count(*) from KRIM_ENTITY_VISA_T;

select 'KRIM_ENT_NM_TYP_T', count(*) from KRIM_ENT_NM_TYP_T;

select 'KRIM_ENT_TYP_T', count(*) from KRIM_ENT_TYP_T;

select 'KRIM_EXT_ID_TYP_T', count(*) from KRIM_EXT_ID_TYP_T;

select 'KRIM_GRP_ATTR_DATA_T', count(*) from KRIM_GRP_ATTR_DATA_T;

select 'KRIM_GRP_DOCUMENT_T', count(*) from KRIM_GRP_DOCUMENT_T;

select 'KRIM_GRP_MBR_T', count(*) from KRIM_GRP_MBR_T;

select 'KRIM_GRP_T', count(*) from KRIM_GRP_T;

select 'KRIM_PERM_ATTR_DATA_T', count(*) from KRIM_PERM_ATTR_DATA_T;

select 'KRIM_PERM_T', count(*) from KRIM_PERM_T;

select 'KRIM_PERM_TMPL_T', count(*) from KRIM_PERM_TMPL_T;

select 'KRIM_PERSON_DOCUMENT_T', count(*) from KRIM_PERSON_DOCUMENT_T;

select 'KRIM_PHONE_TYP_T', count(*) from KRIM_PHONE_TYP_T;

select 'KRIM_PND_ADDR_MT', count(*) from KRIM_PND_ADDR_MT;

select 'KRIM_PND_AFLTN_MT', count(*) from KRIM_PND_AFLTN_MT;

select 'KRIM_PND_CTZNSHP_MT', count(*) from KRIM_PND_CTZNSHP_MT;

select 'KRIM_PND_DLGN_MBR_ATTR_DATA_T', count(*) from KRIM_PND_DLGN_MBR_ATTR_DATA_T;

select 'KRIM_PND_DLGN_MBR_T', count(*) from KRIM_PND_DLGN_MBR_T;

select 'KRIM_PND_DLGN_T', count(*) from KRIM_PND_DLGN_T;

select 'KRIM_PND_EMAIL_MT', count(*) from KRIM_PND_EMAIL_MT;

select 'KRIM_PND_EMP_INFO_MT', count(*) from KRIM_PND_EMP_INFO_MT;

select 'KRIM_PND_GRP_ATTR_DATA_T', count(*) from KRIM_PND_GRP_ATTR_DATA_T;

select 'KRIM_PND_GRP_MBR_T', count(*) from KRIM_PND_GRP_MBR_T;

select 'KRIM_PND_GRP_PRNCPL_MT', count(*) from KRIM_PND_GRP_PRNCPL_MT;

select 'KRIM_PND_NM_MT', count(*) from KRIM_PND_NM_MT;

select 'KRIM_PND_PHONE_MT', count(*) from KRIM_PND_PHONE_MT;

select 'KRIM_PND_PRIV_PREF_MT', count(*) from KRIM_PND_PRIV_PREF_MT;

select 'KRIM_PND_ROLE_MBR_ATTR_DATA_MT', count(*) from KRIM_PND_ROLE_MBR_ATTR_DATA_MT;

select 'KRIM_PND_ROLE_MBR_MT', count(*) from KRIM_PND_ROLE_MBR_MT;

select 'KRIM_PND_ROLE_MT', count(*) from KRIM_PND_ROLE_MT;

select 'KRIM_PND_ROLE_PERM_T', count(*) from KRIM_PND_ROLE_PERM_T;

select 'KRIM_PND_ROLE_RSP_ACTN_MT', count(*) from KRIM_PND_ROLE_RSP_ACTN_MT;

select 'KRIM_PND_ROLE_RSP_T', count(*) from KRIM_PND_ROLE_RSP_T;

select 'KRIM_PRNCPL_T', count(*) from KRIM_PRNCPL_T;

select 'KRIM_ROLE_DOCUMENT_T', count(*) from KRIM_ROLE_DOCUMENT_T;

select 'KRIM_ROLE_MBR_ATTR_DATA_T', count(*) from KRIM_ROLE_MBR_ATTR_DATA_T;

select 'KRIM_ROLE_MBR_T', count(*) from KRIM_ROLE_MBR_T;

select 'KRIM_ROLE_PERM_T', count(*) from KRIM_ROLE_PERM_T;

select 'KRIM_ROLE_RSP_ACTN_T', count(*) from KRIM_ROLE_RSP_ACTN_T;

select 'KRIM_ROLE_RSP_T', count(*) from KRIM_ROLE_RSP_T;

select 'KRIM_ROLE_T', count(*) from KRIM_ROLE_T;

select 'KRIM_RSP_ATTR_DATA_T', count(*) from KRIM_RSP_ATTR_DATA_T;

select 'KRIM_RSP_T', count(*) from KRIM_RSP_T;

select 'KRIM_RSP_TMPL_T', count(*) from KRIM_RSP_TMPL_T;

select 'KRIM_TYP_ATTR_T', count(*) from KRIM_TYP_ATTR_T;

select 'KRIM_TYP_T', count(*) from KRIM_TYP_T;

select 'KRNS_ADHOC_RTE_ACTN_RECIP_T', count(*) from KRNS_ADHOC_RTE_ACTN_RECIP_T;

select 'KRNS_ATT_T', count(*) from KRNS_ATT_T;

select 'KRNS_CAMPUS_T', count(*) from KRNS_CAMPUS_T;

select 'KRNS_CMP_TYP_T', count(*) from KRNS_CMP_TYP_T;

select 'KRNS_DOC_HDR_T', count(*) from KRNS_DOC_HDR_T;

select 'KRNS_LOOKUP_RSLT_T', count(*) from KRNS_LOOKUP_RSLT_T;

select 'KRNS_LOOKUP_SEL_T', count(*) from KRNS_LOOKUP_SEL_T;

select 'KRNS_MAINT_DOC_ATT_T', count(*) from KRNS_MAINT_DOC_ATT_T;

select 'KRNS_MAINT_DOC_T', count(*) from KRNS_MAINT_DOC_T;

select 'KRNS_MAINT_LOCK_T', count(*) from KRNS_MAINT_LOCK_T;

select 'KRNS_NMSPC_T', count(*) from KRNS_NMSPC_T;

select 'KRNS_NTE_T', count(*) from KRNS_NTE_T;

select 'KRNS_NTE_TYP_T', count(*) from KRNS_NTE_TYP_T;

select 'KRNS_PARM_DTL_TYP_T', count(*) from KRNS_PARM_DTL_TYP_T;

select 'KRNS_PARM_T', count(*) from KRNS_PARM_T;

select 'KRNS_PARM_TYP_T', count(*) from KRNS_PARM_TYP_T;

select 'KRNS_PESSIMISTIC_LOCK_T', count(*) from KRNS_PESSIMISTIC_LOCK_T;

select 'KRNS_SESN_DOC_T', count(*) from KRNS_SESN_DOC_T;

select 'KRSB_BAM_PARM_T', count(*) from KRSB_BAM_PARM_T;

select 'KRSB_BAM_T', count(*) from KRSB_BAM_T;

select 'KRSB_FLT_SVC_DEF_T', count(*) from KRSB_FLT_SVC_DEF_T;

select 'KRSB_MSG_PYLD_T', count(*) from KRSB_MSG_PYLD_T;

select 'KRSB_MSG_QUE_T', count(*) from KRSB_MSG_QUE_T;

select 'KRSB_QRTZ_BLOB_TRIGGERS', count(*) from KRSB_QRTZ_BLOB_TRIGGERS;

select 'KRSB_QRTZ_CALENDARS', count(*) from KRSB_QRTZ_CALENDARS;

select 'KRSB_QRTZ_CRON_TRIGGERS', count(*) from KRSB_QRTZ_CRON_TRIGGERS;

select 'KRSB_QRTZ_FIRED_TRIGGERS', count(*) from KRSB_QRTZ_FIRED_TRIGGERS;

select 'KRSB_QRTZ_JOB_DETAILS', count(*) from KRSB_QRTZ_JOB_DETAILS;

select 'KRSB_QRTZ_JOB_LISTENERS', count(*) from KRSB_QRTZ_JOB_LISTENERS;

select 'KRSB_QRTZ_LOCKS', count(*) from KRSB_QRTZ_LOCKS;

select 'KRSB_QRTZ_PAUSED_TRIGGER_GRPS', count(*) from KRSB_QRTZ_PAUSED_TRIGGER_GRPS;

select 'KRSB_QRTZ_SCHEDULER_STATE', count(*) from KRSB_QRTZ_SCHEDULER_STATE;

select 'KRSB_QRTZ_SIMPLE_TRIGGERS', count(*) from KRSB_QRTZ_SIMPLE_TRIGGERS;

select 'KRSB_QRTZ_TRIGGERS', count(*) from KRSB_QRTZ_TRIGGERS;

select 'KRSB_QRTZ_TRIGGER_LISTENERS', count(*) from KRSB_QRTZ_TRIGGER_LISTENERS;

select 'KRSB_SVC_DEF_T', count(*) from KRSB_SVC_DEF_T;

select 'KR_COUNTRY_T', count(*) from KR_COUNTRY_T;

select 'KR_COUNTY_T', count(*) from KR_COUNTY_T;

select 'KR_POSTAL_CODE_T', count(*) from KR_POSTAL_CODE_T;

select 'KR_STATE_T', count(*) from KR_STATE_T;

select 'LOCATION_TYPE', count(*) from LOCATION_TYPE;

select 'MAIL_BY', count(*) from MAIL_BY;

select 'MAIL_TYPE', count(*) from MAIL_TYPE;

select 'MEMBERSHIP_ROLE', count(*) from MEMBERSHIP_ROLE;

select 'MINUTE_ENTRY_TYPE', count(*) from MINUTE_ENTRY_TYPE;

select 'MSG_OF_THE_DAY', count(*) from MSG_OF_THE_DAY;

select 'NARRATIVE', count(*) from NARRATIVE;

select 'NARRATIVE_ATTACHMENT', count(*) from NARRATIVE_ATTACHMENT;

select 'NARRATIVE_STATUS', count(*) from NARRATIVE_STATUS;

select 'NARRATIVE_TYPE', count(*) from NARRATIVE_TYPE;

select 'NARRATIVE_USER_RIGHTS', count(*) from NARRATIVE_USER_RIGHTS;

select 'NOTICE_OF_OPPORTUNITY', count(*) from NOTICE_OF_OPPORTUNITY;

select 'NOTIFICATION', count(*) from NOTIFICATION;

select 'NOTIFICATION_TYPE', count(*) from NOTIFICATION_TYPE;

select 'NOTIFICATION_TYPE_RECIPIENT', count(*) from NOTIFICATION_TYPE_RECIPIENT;

select 'NSF_CODES', count(*) from NSF_CODES;

select 'ORGANIZATION', count(*) from ORGANIZATION;

select 'ORGANIZATION_AUDIT', count(*) from ORGANIZATION_AUDIT;

select 'ORGANIZATION_IDC', count(*) from ORGANIZATION_IDC;

select 'ORGANIZATION_TYPE', count(*) from ORGANIZATION_TYPE;

select 'ORGANIZATION_TYPE_LIST', count(*) from ORGANIZATION_TYPE_LIST;

select 'ORGANIZATION_YNQ', count(*) from ORGANIZATION_YNQ;

select 'PENDING_TRANSACTIONS', count(*) from PENDING_TRANSACTIONS;

select 'PERSON_APPOINTMENT', count(*) from PERSON_APPOINTMENT;

select 'PERSON_DEGREE', count(*) from PERSON_DEGREE;

select 'PERSON_EDITABLE_FIELDS', count(*) from PERSON_EDITABLE_FIELDS;

select 'PERSON_EXT_T', count(*) from PERSON_EXT_T;

select 'PERSON_TRAINING', count(*) from PERSON_TRAINING;

select 'PROPOSAL', count(*) from PROPOSAL;

select 'PROPOSAL_ADMIN_DETAILS', count(*) from PROPOSAL_ADMIN_DETAILS;

select 'PROPOSAL_COMMENTS', count(*) from PROPOSAL_COMMENTS;

select 'PROPOSAL_COST_SHARING', count(*) from PROPOSAL_COST_SHARING;

select 'PROPOSAL_CUSTOM_DATA', count(*) from PROPOSAL_CUSTOM_DATA;

select 'PROPOSAL_EXEMPT_NUMBER', count(*) from PROPOSAL_EXEMPT_NUMBER;

select 'PROPOSAL_IDC_RATE', count(*) from PROPOSAL_IDC_RATE;

select 'PROPOSAL_INV_CERTIFICATION', count(*) from PROPOSAL_INV_CERTIFICATION;

select 'PROPOSAL_IP_REVIEW_JOIN', count(*) from PROPOSAL_IP_REVIEW_JOIN;

select 'PROPOSAL_IP_REV_ACTIVITY', count(*) from PROPOSAL_IP_REV_ACTIVITY;

select 'PROPOSAL_LOG', count(*) from PROPOSAL_LOG;

select 'PROPOSAL_LOG_STATUS', count(*) from PROPOSAL_LOG_STATUS;

select 'PROPOSAL_LOG_TYPE', count(*) from PROPOSAL_LOG_TYPE;

select 'PROPOSAL_NOTEPAD', count(*) from PROPOSAL_NOTEPAD;

select 'PROPOSAL_PERSONS', count(*) from PROPOSAL_PERSONS;

select 'PROPOSAL_PERSON_UNITS', count(*) from PROPOSAL_PERSON_UNITS;

select 'PROPOSAL_PERS_UNIT_CRED_SPLITS', count(*) from PROPOSAL_PERS_UNIT_CRED_SPLITS;

select 'PROPOSAL_PER_CREDIT_SPLIT', count(*) from PROPOSAL_PER_CREDIT_SPLIT;

select 'PROPOSAL_RESPONSE', count(*) from PROPOSAL_RESPONSE;

select 'PROPOSAL_SCIENCE_KEYWORD', count(*) from PROPOSAL_SCIENCE_KEYWORD;

select 'PROPOSAL_SPECIAL_REVIEW', count(*) from PROPOSAL_SPECIAL_REVIEW;

select 'PROPOSAL_STATE', count(*) from PROPOSAL_STATE;

select 'PROPOSAL_STATUS', count(*) from PROPOSAL_STATUS;

select 'PROPOSAL_TYPE', count(*) from PROPOSAL_TYPE;

select 'PROPOSAL_UNITS', count(*) from PROPOSAL_UNITS;

select 'PROPOSAL_UNIT_CONTACTS', count(*) from PROPOSAL_UNIT_CONTACTS;

select 'PROPOSAL_UNIT_CREDIT_SPLIT', count(*) from PROPOSAL_UNIT_CREDIT_SPLIT;

select 'PROP_ROLE_TEMPLATE', count(*) from PROP_ROLE_TEMPLATE;

select 'PROTOCOL', count(*) from PROTOCOL;

select 'PROTOCOL_ACTIONS', count(*) from PROTOCOL_ACTIONS;

select 'PROTOCOL_ACTION_TYPE', count(*) from PROTOCOL_ACTION_TYPE;

select 'PROTOCOL_ATTACHMENT_GROUP', count(*) from PROTOCOL_ATTACHMENT_GROUP;

select 'PROTOCOL_ATTACHMENT_PERSONNEL', count(*) from PROTOCOL_ATTACHMENT_PERSONNEL;

select 'PROTOCOL_ATTACHMENT_PROTOCOL', count(*) from PROTOCOL_ATTACHMENT_PROTOCOL;

select 'PROTOCOL_ATTACHMENT_STATUS', count(*) from PROTOCOL_ATTACHMENT_STATUS;

select 'PROTOCOL_ATTACHMENT_TYPE', count(*) from PROTOCOL_ATTACHMENT_TYPE;

select 'PROTOCOL_ATTACHMENT_TYPE_GROUP', count(*) from PROTOCOL_ATTACHMENT_TYPE_GROUP;

select 'PROTOCOL_CONTINGENCY', count(*) from PROTOCOL_CONTINGENCY;

select 'PROTOCOL_CORRESPONDENCE', count(*) from PROTOCOL_CORRESPONDENCE;

select 'PROTOCOL_DOCUMENT', count(*) from PROTOCOL_DOCUMENT;

select 'PROTOCOL_EXEMPT_CHKLST', count(*) from PROTOCOL_EXEMPT_CHKLST;

select 'PROTOCOL_EXEMPT_NUMBER', count(*) from PROTOCOL_EXEMPT_NUMBER;

select 'PROTOCOL_EXPIDITED_CHKLST', count(*) from PROTOCOL_EXPIDITED_CHKLST;

select 'PROTOCOL_FUNDING_SOURCE', count(*) from PROTOCOL_FUNDING_SOURCE;

select 'PROTOCOL_LOCATION', count(*) from PROTOCOL_LOCATION;

select 'PROTOCOL_MODULES', count(*) from PROTOCOL_MODULES;

select 'PROTOCOL_NOTEPAD', count(*) from PROTOCOL_NOTEPAD;

select 'PROTOCOL_ONLN_RVWS', count(*) from PROTOCOL_ONLN_RVWS;

select 'PROTOCOL_ONLN_RVW_DETERM_RECOM', count(*) from PROTOCOL_ONLN_RVW_DETERM_RECOM;

select 'PROTOCOL_ONLN_RVW_DOCUMENT', count(*) from PROTOCOL_ONLN_RVW_DOCUMENT;

select 'PROTOCOL_ONLN_RVW_STATUS', count(*) from PROTOCOL_ONLN_RVW_STATUS;

select 'PROTOCOL_ORG_TYPE', count(*) from PROTOCOL_ORG_TYPE;

select 'PROTOCOL_PERSONS', count(*) from PROTOCOL_PERSONS;

select 'PROTOCOL_PERSON_ROLES', count(*) from PROTOCOL_PERSON_ROLES;

select 'PROTOCOL_PERSON_ROLE_MAPPING', count(*) from PROTOCOL_PERSON_ROLE_MAPPING;

select 'PROTOCOL_REFERENCES', count(*) from PROTOCOL_REFERENCES;

select 'PROTOCOL_REFERENCE_TYPE', count(*) from PROTOCOL_REFERENCE_TYPE;

select 'PROTOCOL_RESEARCH_AREAS', count(*) from PROTOCOL_RESEARCH_AREAS;

select 'PROTOCOL_REVIEWERS', count(*) from PROTOCOL_REVIEWERS;

select 'PROTOCOL_REVIEWER_TYPE', count(*) from PROTOCOL_REVIEWER_TYPE;

select 'PROTOCOL_REVIEW_TYPE', count(*) from PROTOCOL_REVIEW_TYPE;

select 'PROTOCOL_RISK_LEVELS', count(*) from PROTOCOL_RISK_LEVELS;

select 'PROTOCOL_SPECIAL_REVIEW', count(*) from PROTOCOL_SPECIAL_REVIEW;

select 'PROTOCOL_STATUS', count(*) from PROTOCOL_STATUS;

select 'PROTOCOL_SUBMISSION', count(*) from PROTOCOL_SUBMISSION;

select 'PROTOCOL_SUBMISSION_DOC', count(*) from PROTOCOL_SUBMISSION_DOC;

select 'PROTOCOL_TYPE', count(*) from PROTOCOL_TYPE;

select 'PROTOCOL_UNITS', count(*) from PROTOCOL_UNITS;

select 'PROTOCOL_VOTE_ABSTAINEES', count(*) from PROTOCOL_VOTE_ABSTAINEES;

select 'PROTOCOL_VOTE_RECUSED', count(*) from PROTOCOL_VOTE_RECUSED;

select 'PROTOCOL_VULNERABLE_SUB', count(*) from PROTOCOL_VULNERABLE_SUB;

select 'PROTO_AMEND_RENEWAL', count(*) from PROTO_AMEND_RENEWAL;

select 'PROTO_AMEND_RENEW_MODULES', count(*) from PROTO_AMEND_RENEW_MODULES;

select 'PROTO_CORRESP_TEMPL', count(*) from PROTO_CORRESP_TEMPL;

select 'PROTO_CORRESP_TYPE', count(*) from PROTO_CORRESP_TYPE;

select 'PROTO_NOTIFICATION_TEMPL', count(*) from PROTO_NOTIFICATION_TEMPL;

select 'QUESTION', count(*) from QUESTION;

select 'QUESTIONNAIRE', count(*) from QUESTIONNAIRE;

select 'QUESTIONNAIRE_ANSWER', count(*) from QUESTIONNAIRE_ANSWER;

select 'QUESTIONNAIRE_ANSWER_HEADER', count(*) from QUESTIONNAIRE_ANSWER_HEADER;

select 'QUESTIONNAIRE_CONDITION_TYPE', count(*) from QUESTIONNAIRE_CONDITION_TYPE;

select 'QUESTIONNAIRE_QUESTIONS', count(*) from QUESTIONNAIRE_QUESTIONS;

select 'QUESTIONNAIRE_USAGE', count(*) from QUESTIONNAIRE_USAGE;

select 'QUESTION_EXPLANATION', count(*) from QUESTION_EXPLANATION;

select 'QUESTION_TYPES', count(*) from QUESTION_TYPES;

select 'RATE_CLASS', count(*) from RATE_CLASS;

select 'RATE_CLASS_TYPE', count(*) from RATE_CLASS_TYPE;

select 'RATE_TYPE', count(*) from RATE_TYPE;

select 'REPORT', count(*) from REPORT;

select 'REPORT_CLASS', count(*) from REPORT_CLASS;

select 'RESEARCH_AREAS', count(*) from RESEARCH_AREAS;

select 'RIGHTS', count(*) from RIGHTS;

select 'RISK_LEVEL', count(*) from RISK_LEVEL;

select 'ROLE', count(*) from ROLE;

select 'ROLE_RIGHTS', count(*) from ROLE_RIGHTS;

select 'ROLODEX', count(*) from ROLODEX;

select 'S2S_APPLICATION', count(*) from S2S_APPLICATION;

select 'S2S_APP_ATTACHMENTS', count(*) from S2S_APP_ATTACHMENTS;

select 'S2S_APP_SUBMISSION', count(*) from S2S_APP_SUBMISSION;

select 'S2S_FORM_TO_QUESTIONNAIRE', count(*) from S2S_FORM_TO_QUESTIONNAIRE;

select 'S2S_OPPORTUNITY', count(*) from S2S_OPPORTUNITY;

select 'S2S_OPP_FORMS', count(*) from S2S_OPP_FORMS;

select 'S2S_REVISION_TYPE', count(*) from S2S_REVISION_TYPE;

select 'S2S_SUBMISSION_TYPE', count(*) from S2S_SUBMISSION_TYPE;

select 'SCHEDULE_ACT_ITEM_TYPE', count(*) from SCHEDULE_ACT_ITEM_TYPE;

select 'SCHEDULE_AGENDA', count(*) from SCHEDULE_AGENDA;

select 'SCHEDULE_STATUS', count(*) from SCHEDULE_STATUS;

select 'SCHOOL_CODE', count(*) from SCHOOL_CODE;

select 'SCIENCE_KEYWORD', count(*) from SCIENCE_KEYWORD;

select 'SPECIAL_REVIEW', count(*) from SPECIAL_REVIEW;

select 'SPECIAL_REVIEW_USAGE', count(*) from SPECIAL_REVIEW_USAGE;

select 'SPONSOR', count(*) from SPONSOR;

select 'SPONSOR_FORMS', count(*) from SPONSOR_FORMS;

select 'SPONSOR_FORM_TEMPLATES', count(*) from SPONSOR_FORM_TEMPLATES;

select 'SPONSOR_HIERARCHY', count(*) from SPONSOR_HIERARCHY;

select 'SPONSOR_HIERARCHY_MT', count(*) from SPONSOR_HIERARCHY_MT;

select 'SPONSOR_TERM', count(*) from SPONSOR_TERM;

select 'SPONSOR_TERM_TYPE', count(*) from SPONSOR_TERM_TYPE;

select 'SPONSOR_TYPE', count(*) from SPONSOR_TYPE;

select 'SP_REV_APPROVAL_TYPE', count(*) from SP_REV_APPROVAL_TYPE;

select 'STATE_CODE', count(*) from STATE_CODE;

select 'SUBMISSION_STATUS', count(*) from SUBMISSION_STATUS;

select 'SUBMISSION_TYPE', count(*) from SUBMISSION_TYPE;

select 'SUBMISSION_TYPE_QUALIFIER', count(*) from SUBMISSION_TYPE_QUALIFIER;

select 'TBN', count(*) from TBN;

select 'TIME_AND_MONEY_DOCUMENT', count(*) from TIME_AND_MONEY_DOCUMENT;

select 'TRAINING', count(*) from TRAINING;

select 'TRAINING_STIPEND_RATES', count(*) from TRAINING_STIPEND_RATES;

select 'TRANSACTION_DETAILS', count(*) from TRANSACTION_DETAILS;

select 'TRV_ACCT_USE_RT_T', count(*) from TRV_ACCT_USE_RT_T;

select 'TST_SEARCH_ATTR_INDX_TST_DOC_T', count(*) from TST_SEARCH_ATTR_INDX_TST_DOC_T;

select 'UH_AWARD_EXT_T', count(*) from UH_AWARD_EXT_T;

select 'UH_UNIT_COLLEGE', count(*) from UH_UNIT_COLLEGE;

select 'UNIT', count(*) from UNIT;

select 'UNIT_ADMINISTRATOR', count(*) from UNIT_ADMINISTRATOR;

select 'UNIT_ADMINISTRATOR_TYPE', count(*) from UNIT_ADMINISTRATOR_TYPE;

select 'USER_ROLES', count(*) from USER_ROLES;

select 'USER_TABLES_TEMP', count(*) from USER_TABLES_TEMP;

select 'VALID_AWARD_BASIS_PAYMENT', count(*) from VALID_AWARD_BASIS_PAYMENT;

select 'VALID_BASIS_METHOD_PMT', count(*) from VALID_BASIS_METHOD_PMT;

select 'VALID_CALC_TYPES', count(*) from VALID_CALC_TYPES;

select 'VALID_CE_JOB_CODES', count(*) from VALID_CE_JOB_CODES;

select 'VALID_CE_RATE_TYPES', count(*) from VALID_CE_RATE_TYPES;

select 'VALID_CLASS_REPORT_FREQ', count(*) from VALID_CLASS_REPORT_FREQ;

select 'VALID_FREQUENCY_BASE', count(*) from VALID_FREQUENCY_BASE;

select 'VALID_NARR_FORMS', count(*) from VALID_NARR_FORMS;

select 'VALID_PROTO_ACTION_ACTION', count(*) from VALID_PROTO_ACTION_ACTION;

select 'VALID_PROTO_ACTION_CORESP', count(*) from VALID_PROTO_ACTION_CORESP;

select 'VALID_PROTO_SUB_REV_TYPE', count(*) from VALID_PROTO_SUB_REV_TYPE;

select 'VALID_PROTO_SUB_TYPE_QUAL', count(*) from VALID_PROTO_SUB_TYPE_QUAL;

select 'VALID_RATES', count(*) from VALID_RATES;

select 'VALID_SP_REV_APPROVAL', count(*) from VALID_SP_REV_APPROVAL;

select 'VERSION_HISTORY', count(*) from VERSION_HISTORY;

select 'VULNERABLE_SUBJECT_TYPE', count(*) from VULNERABLE_SUBJECT_TYPE;

select 'WATERMARK', count(*) from WATERMARK;

select 'YNQ', count(*) from YNQ;

select 'YNQ_EXPLANATION', count(*) from YNQ_EXPLANATION;

select 'YNQ_EXPLANATION_TYPE', count(*) from YNQ_EXPLANATION_TYPE;