Overview
Table and view naming standards aid developers by providing uniformity for Data Warehouse database objects.
BOG Views
Views of BOG tables created under DATA_HUB should end with "_VW".
Example: APPLICANTS_ADMITS_VW
Course-Section Tables
Tables containing course-section information should begin with CRSE_SECT.
Example: CRSE_SECT_DETAIL_CURRENT
Info | ||||
---|---|---|---|---|
| ||||
DATA_HUB Tables and Views
DATA_HUB
Tables and ViewsDATA_HUB tables should begin with HUB. DATA_HUB views created under MARTIAN should end with "_V". Example: HUB_BUILDINGS_V
Detail Tablesanchor
Detail Tables
GOFAST Tables GOFAST Tables Anchor
GOFAST Tables
GOFAST tables should begin with GOFAST. Example: GOFAST_DL_CTRL
Grade Tables
Grade Tables Anchor
ID Request Tables ID Request Tables Anchor
ID Request Tables
Data Warehouse ID request tables should begin with IDR. Example: IDR_APPROVAL
OASIS Financial Information Tables (OFI)
OASIS financial information tables should begin with OFI. Example: OFI_JRNL_TRANS
ODS Table (temporary table, control table)
Registration Tables Registration Tables Anchor
Registration Tables
Tables containing OASIS registration information should begin with REG. Tables containing student registration information should begin with REG_STDN. Examples: REG_TRANS_SUM, REG_STDN_CRN_HIST
Snapshot Tables and Materialized Views Snapshot Tables and Materialized Views Anchor
Snapshot Tables and Materialized Views
A snapshot tables and materialized views should have the same name as the table in the production system, and it should be prefixed with the system name. Examples: FAST_PS_FUND_TBL, OASIS_SPRIDEN_USF_ID, GEMS_PS_ACCT_CD_TBL
Summary Table Summary Table Anchor
Summary Table
A summary table name should end with _SUM or SUMMARY. Examples: REG_CS_SCH_SUM, AWS_COURSE_SECTION_SUMMARY
Table/View Groupings Table/View Groupings Anchor
Table/View Groupings
Tables/views sharing a close association should have names that group them together. Examples: GOFAST_DL_BS, GOFAST_DL_REVEXP, and HUB_ADM_EXCEPTIONS_CURR, HUB_ADM_EXCEPTIONS_HIST
Table/View Name Length Table/View Name Length Anchor
Table/View Name Length
If the table/view will be assigned a DAL, the length of the name cannot be longer than 27 characters or the nightly DAL view create process will fail. Back to Top
IT Analytics, SVC4010, Contact Us