Users (Oracle Schemas) 27




Download 9.21 Mb.
NameUsers (Oracle Schemas) 27
page1/71
A typeUser
manual-guide.com > manual > User
  1   2   3   4   5   6   7   8   9   ...   71


Integrated Compliance Information System



ICIS Interim Reporting Solution



Technical Specification

Final

February 16, 2006


Table of Content


Table of Content i

List of Figures iv

Introduction 1

Purpose 1

Scope 1

Architecture 1

Assumptions 2

Logical View 2

Physical View 3

Environment 5

Initial and Periodic initialization of Reporting Instance 5

Data Design 6

Data Design Assumptions 6

Physical Data Model 7

Facilities 9

Permit Dimension 11

Program Reports 11

Limit/DMR/Violation Dimension 12

Final Order Dimension 14

Complying Action/SEP 15

Enforcement Action Dimension 16

Compliance Monitoring Dimension 16

Fact Tables 17

Metadata 18

Database Design 22

Production Environment Configuration 22

Production Server Memory Configuration 23

Production Server Disk Layout 24

NCC Storage Area Network (SAN) Layout 25

Non-Default Oracle 9i Initialization Parameters 27

Users (Oracle Schemas) 27

Physical Model 29

Extract, Transformation and Loading 30

Extraction 30

Transformation 34

User Presentation – Universes 39

Overall Universe Organization 39

Security Implementation 44

Included Special Objects and Conditions 45

Outer Joins 47

Contexts and Aggregate Awareness 47

Attachment A – IIRS Physical Data Dictionary 49

Subject Area: 1. Facility Dimension 49

Subject Area: 2.1. Program Report Subject Area 62

Subject Area: 2. Permit Dimension 88

Subject Area: 3. Limit Dimension 119

Subject Area: 4.1. Complying Action Subject Area 138

Subject Area: 4. Final Order Dimension 144

Subject Area: 5. Enforcement Action Dimension 151

Subject Area: 6. Compliance Monitoring Dimension 173

Subject Area: 7. Schedule/Violation Dimension 205

Subject Area: 8. Single Event Violation Dimension 210

Subject Area: 9. DMR Violation 211

Subject Area: Main Fact 221

Attachment B – Transformation Design Specifications 224

Facility Dimension Subject Area 224

Permit Dimension Subject Area 230

Final Order Dimension Subject Area 236

Enforcement Action Dimension Subject Area 237

Single Event Violation Dimension Subject Area 239

Compliance Monitoring Dimension Subject Area 241

Limit Dimension Subject Area 244

DMR Violation Subject Area 246

Schedule Violation Dimension Subject Area 249

Program Reports Dimension Subject Area 251

Log Manager Utility 252

Sequence Manager Utility 256

Reference Data Transformation 259

Attachment C – Instructions for Installing IIRS 260

IIRS Installation and Configuration Instructions 260

Instance Creation Parameters for Step 1 265

User (Schemas) Needed for IIRS – Created During Step 4 265

IIRS Tablespaces Created During Step 8 266

Attachment D – Periodic Maintenance 267

Attachment E – Transformation Log Analysis 268

Attachment F – Metadata Analysis 272


  1   2   3   4   5   6   7   8   9   ...   71

Share in:

Related:

Users (Oracle Schemas) 27 iconPartners in 17 Categories Recognized at Oracle OpenWorld for Excellence...

Users (Oracle Schemas) 27 iconIdc white Paper sponsored by Oracle Corporation, "Oracle e-business...

Users (Oracle Schemas) 27 iconFull life cycle development, implementation and support with expertise...

Users (Oracle Schemas) 27 iconOracle® e-business Suite, Siebel crm, PeopleSoft Enterprise and jd...

Users (Oracle Schemas) 27 iconAbstract This integration is a part of Siebel Integrations between...

Users (Oracle Schemas) 27 iconUsers do not dismantle or refit or replace electric components by...

Users (Oracle Schemas) 27 iconHello, I’m Terry Froggatt; I was the secretary of the 900-users group...

Users (Oracle Schemas) 27 iconOracle® SuperCluster T5-8

Users (Oracle Schemas) 27 iconOracle® SuperCluster M6-32

Users (Oracle Schemas) 27 iconOracle R12. 1 Fa, pa, gl and ap modules, sap

Users (Oracle Schemas) 27 iconOracle Financials Senior Consultant/pm mr. G r reddy

Users (Oracle Schemas) 27 iconManual updates of Oracle 4 to 6 are now supported with idmis 5 11

Users (Oracle Schemas) 27 iconOracle – 9i to 10g database Upgrade using dbua

Users (Oracle Schemas) 27 iconSelf-Paced R12 Oracle gl configuration Training

Users (Oracle Schemas) 27 iconMysql, Oracle, Hibernate, TokyoTyrant (Nosql)

Users (Oracle Schemas) 27 iconInformatica PowerExchange for Oracle e-business Suite

Users (Oracle Schemas) 27 iconLearn how to set up and configure an Oracle rac 10

Users (Oracle Schemas) 27 iconRd Party Software with Oracle e-business Suite

Users (Oracle Schemas) 27 iconCaci and Oracle Deliver Solution and Services to Improve

Users (Oracle Schemas) 27 iconTriNet Improves Business Visibility with Oracle® Essbase




manual




When copying material provide a link © 2017
contacts
manual-guide.com
search