dim_date

11311 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dim_date_key int 4 null
fact_patient_census.dim_date_key Implied ConstraintR
fact_patient_diagnosis.dim_date_key Implied ConstraintR
fact_patient_insurance_active.dim_date_key Implied ConstraintR
stage_patient_census.dim_date_key Implied ConstraintR
stage_patient_diagnosis.dim_date_key Implied ConstraintR
stage_patient_insurance.dim_date_key Implied ConstraintR
calendar_date datetime 16,3 √ null
cal_day_in_week varchar 3 √ null
cal_day_in_week_no int 4 √ null
cal_day_in_month int 4 √ null
cal_day_in_year int 4 √ null
cal_week_in_year int 4 √ null
cal_month_no int 4 √ null
cal_month int 4 √ null
cal_month_name varchar 7 √ null
cal_quarter_no int 4 √ null
cal_quarter int 4 √ null
cal_year int 4 √ null
financial_date datetime 16,3 √ null
fin_day_in_week varchar 3 √ null
fin_day_in_week_no int 4 √ null
fin_day_in_month int 4 √ null
fin_day_in_year int 4 √ null
fin_week_in_month int 4 √ null
fin_week_in_year int 4 √ null
fin_month_no int 4 √ null
fin_month int 4 √ null
fin_month_name varchar 7 √ null
fin_period varchar 20 √ null
fin_quarter_no int 4 √ null
fin_quarter int 4 √ null
fin_year int 4 √ null
current_cal_day varchar 8 √ null
current_cal_week varchar 8 √ null
current_cal_month varchar 8 √ null
current_cal_year varchar 8 √ null
current_cal_mtd varchar 8 √ null
current_cal_ytd varchar 8 √ null
moving_cal_year varchar 8 √ null
current_fin_day varchar 8 √ null
current_fin_week varchar 8 √ null
current_fin_month varchar 8 √ null
current_fin_quarter varchar 8 √ null
current_fin_year varchar 8 √ null
current_fin_mtd varchar 8 √ null
current_fin_ytd varchar 8 √ null
moving_fin_quarter varchar 8 √ null
moving_fin_year varchar 8 √ null
week_day_flag varchar 1 √ null
week_end_flag varchar 1 √ null
holiday_flag varchar 1 √ null
holiday_desc varchar 64 √ null
trading_day_flag varchar 1 √ null
trading_days_in_mth int 4 √ null
trading_days_so_far int 4 √ null
dss_update_time datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
dim_date_idx_0 Primary key Asc dim_date_key

Relationships

Close relationships within degrees of separation