OEB_GL_PERIOD_STATUSES_C

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 APPLICATION_ID BIGINT 8
2 SET_OF_BOOKS_ID BIGINT 8
3 PERIOD_NAME CHARACTER VARYING(15) 15
4 LAST_UPDATE_DATE TIMESTAMP 8
5 LAST_UPDATED_BY BIGINT 8
6 CLOSING_STATUS CHARACTER VARYING(1) 1
7 START_DATE TIMESTAMP 8
8 END_DATE TIMESTAMP 8
9 YEAR_START_DATE TIMESTAMP 8
10 QUARTER_NUM BIGINT 8
11 QUARTER_START_DATE TIMESTAMP 8
12 PERIOD_TYPE CHARACTER VARYING(15) 15
13 PERIOD_YEAR BIGINT 8
14 EFFECTIVE_PERIOD_NUM BIGINT 8
15 PERIOD_NUM BIGINT 8
16 ADJUSTMENT_PERIOD_FLAG CHARACTER VARYING(1) 1
17 CREATION_DATE TIMESTAMP 8
18 CREATED_BY BIGINT 8
19 LAST_UPDATE_LOGIN BIGINT 8
20 ATTRIBUTE1 CHARACTER VARYING(150) 150
21 ATTRIBUTE2 CHARACTER VARYING(150) 150
22 ATTRIBUTE3 CHARACTER VARYING(150) 150
23 ATTRIBUTE4 CHARACTER VARYING(150) 150
24 ATTRIBUTE5 CHARACTER VARYING(150) 150
25 CONTEXT CHARACTER VARYING(150) 150
26 ELIMINATION_CONFIRMED_FLAG CHARACTER VARYING(1) 1
27 CHRONOLOGICAL_SEQ_STATUS_CODE CHARACTER VARYING(1) 1
28 TRACK_BC_YTD_FLAG CHARACTER VARYING(1) 1
29 MIGRATION_STATUS_CODE CHARACTER VARYING(30) 30
30 LEDGER_ID BIGINT 8
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
33 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
34 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8