Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL
Base de datos origen: ADW COEXITO
Descripción: Español: Contiene información de encabezado de cada importación de presupuesto exitosa. | English: Contains header information for each successful budget import.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | XCC_BUDGET_DIST_HEADERS_BGC_GL_ID | NUMBER | NO | “DWADW”.”ISEQ$$_337761”.nextval | |
| 2 | APPROVALCOMMENTS | VARCHAR2(2000) | SI | ||
| 3 | APPROVEDBY | VARCHAR2(64) | SI | ||
| 4 | APPROVEDDATE | TIMESTAMP(6) | SI | ||
| 5 | ATTACHMENTURL | VARCHAR2(4000) | SI | ||
| 6 | BUDGETENTRYTYPECODE | VARCHAR2(30) | SI | ||
| 7 | BUDGETTYPECODE | VARCHAR2(30) | SI | ||
| 8 | CREATEDBY | VARCHAR2(64) | SI | ||
| 9 | CREATEDBYJOBCODE | VARCHAR2(30) | SI | ||
| 10 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 11 | DATAPURGEDFLAG | VARCHAR2(1) | SI | ||
| 12 | DATASET | VARCHAR2(500) | SI | ||
| 13 | HEADERID | NUMBER(18,0) | NO | ||
| 14 | IMPORTSOURCECODE | VARCHAR2(30) | SI | ||
| 15 | JUSTIFICATIONTXT | VARCHAR2(1000) | SI | ||
| 16 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 17 | LASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 18 | LASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 19 | OBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 20 | OVERWRITEMODECODE | VARCHAR2(30) | SI | ||
| 21 | PERIODNAMERELEASED | VARCHAR2(15) | SI | ||
| 22 | REQUESTID | NUMBER(18,0) | SI | ||
| 23 | REVISIONDESCRIPTION | VARCHAR2(255) | SI | ||
| 24 | SOURCEAPPLICATION | VARCHAR2(30) | SI | ||
| 25 | SOURCEBUDGET | VARCHAR2(100) | SI | ||
| 26 | STATUSCODE | VARCHAR2(30) | SI | ||
| 27 | AUDIT_ID | NUMBER | NO | ||
| 28 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
Restricciones
CHECK: DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00242207
- Estado: ENABLED
- Columnas: XCC_BUDGET_DIST_HEADERS_BGC_GL_ID
- Condición:
"XCC_BUDGET_DIST_HEADERS_BGC_GL_ID" IS NOT NULL
CHECK: SYS_C00242208
- Estado: ENABLED
- Columnas: HEADERID
- Condición:
"HEADERID" IS NOT NULL
CHECK: SYS_C00242209
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00242210
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_PK
- Estado: ENABLED
- Columnas: XCC_BUDGET_DIST_HEADERS_BGC_GL_ID
UK: DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL__UN
- Estado: ENABLED
- Columnas: HEADERID
DDL
CREATE TABLE "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL"
( "XCC_BUDGET_DIST_HEADERS_BGC_GL_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"APPROVALCOMMENTS" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"APPROVEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"APPROVEDDATE" TIMESTAMP (6),
"ATTACHMENTURL" VARCHAR2(4000) COLLATE "USING_NLS_COMP",
"BUDGETENTRYTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"BUDGETTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"CREATEDBYJOBCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"CREATIONDATE" TIMESTAMP (6),
"DATAPURGEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"DATASET" VARCHAR2(500) COLLATE "USING_NLS_COMP",
"HEADERID" NUMBER(18,0) NOT NULL ENABLE,
"IMPORTSOURCECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"JUSTIFICATIONTXT" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"LASTUPDATEDATE" TIMESTAMP (6),
"LASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP",
"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"OBJECTVERSIONNUMBER" NUMBER(9,0),
"OVERWRITEMODECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"PERIODNAMERELEASED" VARCHAR2(15) COLLATE "USING_NLS_COMP",
"REQUESTID" NUMBER(18,0),
"REVISIONDESCRIPTION" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"SOURCEAPPLICATION" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"SOURCEBUDGET" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"STATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"AUDIT_ID" NUMBER NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
CONSTRAINT "DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_PK" PRIMARY KEY ("XCC_BUDGET_DIST_HEADERS_BGC_GL_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL__UN" UNIQUE ("HEADERID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL" IS 'Español: Contiene información de encabezado de cada importación de presupuesto exitosa. | English: Contains header information for each successful budget import.';
CREATE INDEX "DWADW"."DIM_XCC_BUDGET_DIST_HDR_UPD_IDX" ON "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL" ("LASTUPDATEDATE")
;
CREATE UNIQUE INDEX "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_PK" ON "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL" ("XCC_BUDGET_DIST_HEADERS_BGC_GL_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL__UN" ON "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL" ("HEADERID")
;