OEB_AP_TERMS_TL

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 TERM_ID BIGINT 8
2 LAST_UPDATE_DATE TIMESTAMP 8
3 LAST_UPDATED_BY BIGINT 8
4 CREATION_DATE TIMESTAMP 8
5 CREATED_BY BIGINT 8
6 LAST_UPDATE_LOGIN BIGINT 8
7 NAME CHARACTER VARYING(50) 50
8 ENABLED_FLAG CHARACTER VARYING(1) 1
9 DUE_CUTOFF_DAY BIGINT 8
10 DESCRIPTION CHARACTER VARYING(240) 240
11 TYPE CHARACTER VARYING(15) 15
12 START_DATE_ACTIVE TIMESTAMP 8
13 END_DATE_ACTIVE TIMESTAMP 8
14 RANK BIGINT 8
15 ATTRIBUTE_CATEGORY CHARACTER VARYING(150) 150
16 ATTRIBUTE1 CHARACTER VARYING(150) 150
17 ATTRIBUTE2 CHARACTER VARYING(150) 150
18 ATTRIBUTE3 CHARACTER VARYING(150) 150
19 ATTRIBUTE4 CHARACTER VARYING(150) 150
20 ATTRIBUTE5 CHARACTER VARYING(150) 150
21 ATTRIBUTE6 CHARACTER VARYING(150) 150
22 ATTRIBUTE7 CHARACTER VARYING(150) 150
23 ATTRIBUTE8 CHARACTER VARYING(150) 150
24 ATTRIBUTE9 CHARACTER VARYING(150) 150
25 ATTRIBUTE10 CHARACTER VARYING(150) 150
26 ATTRIBUTE11 CHARACTER VARYING(150) 150
27 ATTRIBUTE12 CHARACTER VARYING(150) 150
28 ATTRIBUTE13 CHARACTER VARYING(150) 150
29 ATTRIBUTE14 CHARACTER VARYING(150) 150
30 ATTRIBUTE15 CHARACTER VARYING(150) 150
31 LANGUAGE CHARACTER VARYING(4) 4
32 SOURCE_LANG CHARACTER VARYING(4) 4
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8