Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_TIME_OTM
Base de datos origen: ADW COEXITO
Descripción: Español: Dimensión de tiempo utilizada para análisis temporal consistente en todo el modelo. | English: Time dimension used for consistent temporal analysis across the model.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | TIME_OTM_ID | NUMBER | NO | ||
| 2 | AUDIT_ID | NUMBER | NO | ||
| 3 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ | |
| 4 | FULL_DATE | DATE | NO | ||
| 5 | YEAR_NUM | NUMBER(4,0) | NO | ||
| 6 | MONTH_NUM | NUMBER(2,0) | NO | ||
| 7 | DAY_NUM | NUMBER(2,0) | NO | ||
| 8 | WEEK_NUM | NUMBER(2,0) | NO | ||
| 9 | SEMESTER_NUM | NUMBER(1,0) | NO | ||
| 10 | QUARTER_NUM | NUMBER(1,0) | NO | ||
| 11 | DAY_NAME | VARCHAR2(20) | SI | ||
| 12 | MONTH_NAME | VARCHAR2(20) | SI | ||
| 13 | IS_WEEKEND | CHAR(1) | SI | ||
| 14 | IS_WORKING_DAY | CHAR(1) | SI | ||
| 15 | IS_HOLIDAY | CHAR(1) | SI | ||
| 16 | HOLIDAY_NAME | VARCHAR2(200) | SI |
Restricciones
CHECK: DIM_TIME_OTM_ROW_ACTIVE_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
ROW_ACTIVE IN ('A','I')
CHECK: SYS_C0085812
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C0085882
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
CHECK: SYS_C0093886
- Estado: ENABLED
- Columnas: FULL_DATE
- Condición:
"FULL_DATE" IS NOT NULL
CHECK: SYS_C0093887
- Estado: ENABLED
- Columnas: YEAR_NUM
- Condición:
"YEAR_NUM" IS NOT NULL
CHECK: SYS_C0093888
- Estado: ENABLED
- Columnas: MONTH_NUM
- Condición:
"MONTH_NUM" IS NOT NULL
CHECK: SYS_C0093889
- Estado: ENABLED
- Columnas: DAY_NUM
- Condición:
"DAY_NUM" IS NOT NULL
CHECK: SYS_C0093890
- Estado: ENABLED
- Columnas: WEEK_NUM
- Condición:
"WEEK_NUM" IS NOT NULL
CHECK: SYS_C0093891
- Estado: ENABLED
- Columnas: SEMESTER_NUM
- Condición:
"SEMESTER_NUM" IS NOT NULL
CHECK: SYS_C0093892
- Estado: ENABLED
- Columnas: QUARTER_NUM
- Condición:
"QUARTER_NUM" IS NOT NULL
PK: DIM_TIEMPO_OTM_PK
- Estado: ENABLED
- Columnas: TIME_OTM_ID
DDL
CREATE TABLE "DWADW"."DIM_TIME_OTM"
( "TIME_OTM_ID" NUMBER,
"AUDIT_ID" NUMBER NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
"FULL_DATE" DATE NOT NULL ENABLE,
"YEAR_NUM" NUMBER(4,0) NOT NULL ENABLE,
"MONTH_NUM" NUMBER(2,0) NOT NULL ENABLE,
"DAY_NUM" NUMBER(2,0) NOT NULL ENABLE,
"WEEK_NUM" NUMBER(2,0) NOT NULL ENABLE,
"SEMESTER_NUM" NUMBER(1,0) NOT NULL ENABLE,
"QUARTER_NUM" NUMBER(1,0) NOT NULL ENABLE,
"DAY_NAME" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"MONTH_NAME" VARCHAR2(20) COLLATE "USING_NLS_COMP",
"IS_WEEKEND" CHAR(1) COLLATE "USING_NLS_COMP",
"IS_WORKING_DAY" CHAR(1) COLLATE "USING_NLS_COMP",
"IS_HOLIDAY" CHAR(1) COLLATE "USING_NLS_COMP",
"HOLIDAY_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP",
CONSTRAINT "DIM_TIEMPO_OTM_PK" PRIMARY KEY ("TIME_OTM_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_TIME_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_TIME_OTM" IS 'Español: Dimensión de tiempo utilizada para análisis temporal consistente en todo el modelo. | English: Time dimension used for consistent temporal analysis across the model.';
CREATE UNIQUE INDEX "DWADW"."DIM_TIEMPO_OTM_PK" ON "DWADW"."DIM_TIME_OTM" ("TIME_OTM_ID")
;