| TABLE_Name |
varchar (10) |
VARCHAR2 (10 CHAR) |
varchar(10) |
varchar (10) |
false |
table name |
| TABLE_Name5 |
char (5) |
CHAR (5 CHAR) |
char(5) |
char (5) |
true |
5 digit table name |
| TABLE_Prefix |
varchar (5) |
VARCHAR2 (5 CHAR) |
varchar(5) |
varchar (5) |
true |
prefix of the names (without _) |
| TABLE_Text |
varchar (255) |
VARCHAR2 (255 CHAR) |
varchar(255) |
varchar (255) |
true |
description |
| TABLE_Lfd |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
sequence number for import |
| TABLE_UType |
char (2) |
CHAR (2 CHAR) |
char(2) |
char (2) |
true |
update type of the table |
| TABLE_CheckFlg |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
C=build checksum |
| TABLE_Check |
int |
NUMBER(38,0) |
int |
int |
true |
checksum |
| TABLE_WhereIni |
varchar (250) |
VARCHAR2 (250 CHAR) |
varchar(250) |
varchar (250) |
true |
WHERE clause for DB.Unload - INITIAL |
| TABLE_WhereDef |
varchar (250) |
VARCHAR2 (250 CHAR) |
varchar(250) |
varchar (250) |
true |
WHERE clause for DB.Unload - DEFAULT |
| TABLE_Children |
varchar(1024) |
VARCHAR2 (1024 CHAR) |
varchar(1024) |
varchar(1024) |
true |
child tables |
| TABLE_AvgLen |
int |
NUMBER(38,0) |
int |
int |
true |
average length of the records |
| TABLE_IlmFlag |
char (1) |
CHAR (1 CHAR) |
char(1) |
char (1) |
true |
Type of Table: S=Statistics(Partitioned), R=Reports(Partitioned), M=Misc(Partitioned), O=Object definition, E=Empty (data in these table is not necessary to start a server) |
| TABLE_IlmKey |
varchar (20) |
VARCHAR2 (20 CHAR) |
varchar(20) |
varchar (20) |
true |
Field with Partition Key if available |
| TABLE_LoadAtomic |
smallint |
NUMBER(38,0) |
smallint |
smallint |
true |
1=Ensure that Initialdata in this table is deleted and loaded in a single transaction |