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
Back to TopDetail Tablesanchor
Detail Tables
A detail table should end with DETAIL.
- Examples: CRSE_SECT_DETAIL, GRDE_DETAIL
Back to TopGOFAST Tablesanchor
GOFAST Tables
GOFAST TablesGOFAST tables should begin with GOFAST.
- Example: GOFAST_DL_CTRL
Back to TopGrade Tables Grade Tables Anchor
Grade Tables
Grade tables should begin with GRDE.
- Example: GRDE_DETAIL
Back to TopID 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 Anchor
OASIS OASIS financial information tables should begin with OFI.
- Example: OFI_JRNL_TRANS
ODS Table (temporary table, control table)
Anchor
- Examples: ;ODS_GOFAST_GRANT_BUDGET_TREE, ODS_GOFAST_DL_CTRL
Registration TablesanchorRegistration
Tables
- Examples: REG_TRANS_SUM, REG_STDN_CRN_HIST
Back to TopSnapshot Tables and Materialized Views
Snapshot Tables and Materialized Views Anchor
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
Back to TopSummary 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
Back to TopTable/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
Back to TopTable/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.
Data Analytics & Reporting Team (DART), SVC4010, Contact Us