Time Dimension - cre_tob_d_time.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: cre_tob_d_time.sql -- -- Author: Steve Roach -- -- Date: 29-JAN-2006 -- -- Version: 01.00 -- -- -- -- Description: Creates the Scalar Object Type; tob_d_time. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 29-JAN-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- CREATE TYPE tob_d_time AS OBJECT( DAY_ID NUMBER, FMN_ID NUMBER, FQT_ID NUMBER, FWK_ID NUMBER, FYR_ID NUMBER, NMN_ID NUMBER, NQT_ID NUMBER, NWK_ID NUMBER, NYR_ID NUMBER, DAY_END_DATE DATE, DAY_JULIAN_DATE NUMBER(7), DAY_LAST_DAY_IN_MONTH VARCHAR2(1), DAY_LAST_DAY_IN_QUARTER VARCHAR2(1), DAY_NAME VARCHAR2(10), DAY_SHORT_NAME VARCHAR2(3), DAY_START_DATE DATE, DAY_WEEKDAY VARCHAR2(1), FMN_FULL_NAME VARCHAR2(25), FMN_MONTH NUMBER(2), FMN_NAME VARCHAR2(10), FMN_ORDERING NUMBER(6), FMN_SHORT_NAME VARCHAR2(11), FQT_FULL_NAME VARCHAR2(25), FQT_NAME VARCHAR2(3), FQT_ORDERING NUMBER(5), FQT_QUARTER NUMBER(1), FQT_SHORT_NAME VARCHAR2(11), FWK_FULL_NAME VARCHAR2(25), FWK_NAME VARCHAR2(4), FWK_ORDERING NUMBER(6), FWK_SHORT_NAME VARCHAR2(20), FWK_WEEK NUMBER(2), FYR_DAYS_IN_YEAR NUMBER(3), FYR_FULL_NAME VARCHAR2(25), FYR_NAME VARCHAR2(9), FYR_SHORT_NAME VARCHAR2(20), FYR_YEAR NUMBER(4), NMN_DAYS_IN_MONTH NUMBER(2), NMN_MONTH NUMBER(2), NMN_NAME VARCHAR2(10), NMN_ORDERING NUMBER(6), NMN_SHORT_NAME VARCHAR2(3), NQT_DAYS_IN_QUARTER NUMBER(2), NQT_NAME VARCHAR2(11), NQT_ORDERING NUMBER(5), NQT_QUARTER NUMBER(1), NQT_SHORT_NAME VARCHAR2(7), NWK_NAME VARCHAR2(4), NWK_ORDERING NUMBER(6), NWK_WEEK NUMBER(2), NYR_DAYS_IN_YEAR NUMBER(3), NYR_NAME VARCHAR2(4), NYR_YEAR NUMBER(4) ); / SHOW ERRORS