OEB_GL_PERIODS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_SET_NAME CHARACTER VARYING(15) 15
2 PERIOD_NAME CHARACTER VARYING(15) 15
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATED_BY BIGINT 8
5 START_DATE TIMESTAMP 8
6 END_DATE TIMESTAMP 8
7 YEAR_START_DATE TIMESTAMP 8
8 QUARTER_START_DATE TIMESTAMP 8
9 PERIOD_TYPE CHARACTER VARYING(15) 15
10 PERIOD_YEAR BIGINT 8
11 PERIOD_NUM BIGINT 8
12 QUARTER_NUM BIGINT 8
13 ENTERED_PERIOD_NAME CHARACTER VARYING(15) 15
14 ADJUSTMENT_PERIOD_FLAG CHARACTER VARYING(1) 1
15 CREATION_DATE TIMESTAMP 8
16 CREATED_BY BIGINT 8
17 LAST_UPDATE_LOGIN BIGINT 8
18 DESCRIPTION CHARACTER VARYING(240) 240
19 ATTRIBUTE1 CHARACTER VARYING(150) 150
20 ATTRIBUTE2 CHARACTER VARYING(150) 150
21 ATTRIBUTE3 CHARACTER VARYING(150) 150
22 ATTRIBUTE4 CHARACTER VARYING(150) 150
23 ATTRIBUTE5 CHARACTER VARYING(150) 150
24 ATTRIBUTE6 CHARACTER VARYING(150) 150
25 ATTRIBUTE7 CHARACTER VARYING(150) 150
26 ATTRIBUTE8 CHARACTER VARYING(150) 150
27 CONTEXT CHARACTER VARYING(150) 150
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8