OEB_GL_BUDGET_VERSIONS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BUDGET_VERSION_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 BUDGET_TYPE CHARACTER VARYING(15) 15
5 BUDGET_NAME CHARACTER VARYING(15) 15
6 VERSION_NUM CHARACTER VARYING(15) 15
7 STATUS CHARACTER VARYING(1) 1
8 DATE_OPENED TIMESTAMP 8
9 CREATION_DATE TIMESTAMP 8
10 CREATED_BY BIGINT 8
11 LAST_UPDATE_LOGIN BIGINT 8
12 DESCRIPTION CHARACTER VARYING(240) 240
13 DATE_ACTIVE TIMESTAMP 8
14 DATE_ARCHIVED TIMESTAMP 8
15 ATTRIBUTE1 CHARACTER VARYING(150) 150
16 ATTRIBUTE2 CHARACTER VARYING(150) 150
17 ATTRIBUTE3 CHARACTER VARYING(150) 150
18 ATTRIBUTE4 CHARACTER VARYING(150) 150
19 ATTRIBUTE5 CHARACTER VARYING(150) 150
20 ATTRIBUTE6 CHARACTER VARYING(150) 150
21 ATTRIBUTE7 CHARACTER VARYING(150) 150
22 ATTRIBUTE8 CHARACTER VARYING(150) 150
23 CONTEXT CHARACTER VARYING(150) 150
24 CONTROL_BUDGET_VERSION_ID BIGINT 8
25 IGI_BUD_NYC_FLAG CHARACTER VARYING(1) 1
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8