Overview

Column naming standards aid developers by providing uniformity for Data Warehouse database objects.

Snapshot Tables and Materialize Views Column Names

• Snapshot table and materialized view column names should have the same column names as those in the source table (only applies to snapshot tables).  Columns in other tables should only contain the source table name when it is necessary to differentiate it from another column (see Ambiguous and Vague column names below).
• Examples: STVTERM_CODE, SHRLGPA_GPA

Ambiguous and Vague

Column Names

Ambiguous and Vague

• Ambiguous and vague column names should contain a prefix for clarity, or in some situations, the source table name.

• Examples: CS_LEVL_CODE, STDN_LEVL_CODE (differentiates between course-section and student level codes) or SPRIDEN_ID (ID only would be too vague.  Could also use USFID).

Back to Top

Code Value Column Names

Code ValueCode Value

• Column groupings should start with a common prefix.

• Examples: LEVL_CODE, DEPT_CODE 

Back to Top

 Description

 Description Column Names

• Description column names should end in DESC.

• Examples: COLL_DESC, FUND_DESC

Flag Column Names AnchorFlagFlag

• Flag columns contain only one of two values which is often a one character value (e.g. Y/N).  These column names should end with FLG, except when the source column name ends in IND (indicator), in which case, it's okay to use IND, instead of FLG.
• Examples: REG_FLG (values: 1/-1) VET_FLG (values: Y/N), UGDC_ADMIT_FLG (values: 1/0)

Count and Summation Column Names

• Count and

Summation

• Count and

  summation column names should end with CNT or TOTAL.

• Examples: WEB_TRANS_CNT, CREDIT_HRS_TOTAL

Back to Top

Column Groupings

• Column

GroupingsColumn Groupings

• Column

  groupings should start with a common prefix.

• Examples: ML_STREET_LINE1, ML_STREET_LINE2, ML_CITY, ML_STATE, ML_ZIP

Back to Top

Data Types and Lengths

• Data

Types and LengthsData Types and Lengths

• Data

  types and lengths should be the same as the source column, unless data conversion is incorporated into the process.

• PIDM  NUMBER(8), BIRTH_DATE  DATE

Back to Top

State and Operational ReportingIT Analytics, SVC4010, AISteam@usf.eduContact Us