Overview

HUB/BOG naming standards aid developers by providing uniformity for Data Warehouse database objects.

Tables

Follow identifier naming convention described in the above section. (scope, primary identifier, modifier)

.  Ex: HUB_PERSON_CURRENT

Indexes

 table_name_

idx##  Ex: HUB_PERSON_CURRENT_IDX01

Primary

Key Constraint

 table_name_

pk  Ex: HUB_PERSON_CURRENT_PK

Back to Top

Unique Key Constraint

 table_name_

uk##  Ex: HUB_PERSON_CURRENT_UK

Back to Top

Foreign Key Constraint AnchorForeign Key Constraint

Foreign Key Constraint

 table_name _

fk##  Ex: HUB_PERSON_CURRENT_UK

Back to Top

Sequence AnchorSequence

Sequence

 table_name_seq## (if associated with a table. Else follows identifier naming convention from the above section)

  Ex: HUB_PERSON_CURRENT_SEQ

Back to Top

Trigger AnchorTrigger

Trigger

 table_name_action_

trg  Ex: HUB_PERSON_CURRENT_INS_UPD_TRG

Back to Top

Snapshots and Materialized

Views

The name of the source object, pre-pended by system name. (Scope, primary identifier, modifier)

.  Ex: snapshot of spbpers becomes OASIS_SPBPERS.

Back to Top

Views

Same as tables. (scope, primary identifier,

modifier  Ex: HUB_STUDENT_COURSES

Back to Top

Function AnchorFunction

Function

 F_ scope_primary identifier_

modifier  Ex : F_OASIS_EXTERNAL_ID

Back to Top

Procedure AnchorProcedure

Procedure

 P_ scope_primary identifier_

modifier  Ex: P_REG_STUDENT_EXEMPTIONS

Back to Top

Package AnchorPackage

Package

 scope_primary identifier_modifier_

pkg  Ex: COMMON_DATALOAD_PKG

Back to Top

Dblink AnchorDblink

Dblink

1st type - system name (like OASIS) will point at database in same state as you are in. in other words, from DWDVLP, OASIS dblink will point at db: dvlp. In DWTEST same name will point at pprd. In DWHOUSE same name will point at prod. This allows code to be promoted without modifying.

2nd type, if actual database name, it points at actual database. For example, in DWDVLP, GEMSPRO dblink will point at GEMSPRO database, GEMS dblink will point at GEMSDVLP database. (Note: in some cases these 2 types are the same. System and db have same name. Those are solved on case by case basis).

Back to Top

Insert Script

tablename_ins.

sql  Ex : HUB_ROOMS_INS.sql

The following are the exceptions:

• For table hub_xref_rule inserts, the script should be named as xref_kw_qualifier_ins.sql
• For table q$error inserts, the insert script should be named as q$error_catname_ins.sql

Back to Top

Data Analytics & Reporting Team (DART)IT Analytics, SVC4010, Contact Us