CREATE TABLE APPLICATION_DATES ( 
  THE_DATE       DATE          NOT NULL, 
  MMDDYYYY       VARCHAR2 (10) NOT NULL, -- 'MM/DD/YYYY/ 
  YYYYMMDD       VARCHAR2 (10) NOT NULL, -- 'YYYY/MM/DD'
  MM             VARCHAR2 (2)  NOT NULL, -- 'MM'
  MON            VARCHAR2 (3)  NOT NULL, -- Month abbreviation
  MONTH          VARCHAR2 (15) NOT NULL, -- Month spelled out
  D              VARCHAR2 (1)  NOT NULL, -- Day of the Week
  DD             VARCHAR2 (2)  NOT NULL, -- Day of the Month
  DDD            VARCHAR2 (3)  NOT NULL, -- Day of the Year
  DAY            VARCHAR2 (15) NOT NULL, -- Day spelled out
  DY             VARCHAR2 (3)  NOT NULL, -- Day abbreviation
  DDSPTH         VARCHAR2 (80) NOT NULL, -- DD With suffix (th,rd)
  YYYY           VARCHAR2 (4)  NOT NULL, -- 'YYYY'
  YEAR           VARCHAR2 (80) NOT NULL, -- Year spelled out
  QUARTER        VARCHAR2 (1)  NOT NULL, -- 'Q'
  WW             VARCHAR2 (2)  NOT NULL, -- Week of the Year
  W              VARCHAR2 (1)  NOT NULL, -- Week of the Month
  JULIAN         VARCHAR2 (80) NOT NULL, -- Julian Date
  HOLIDAY        CHAR (1)      DEFAULT 'N' NOT NULL, 
  BUSINESS_DAY   CHAR (1)      DEFAULT 'N' NOT NULL, 
  REMARK         VARCHAR2 (4000), 
  CONSTRAINT APPLD_PK
  PRIMARY KEY ( THE_DATE ) ) ;