IBM DB2 Columns

The following column names are present in the database. The same column name can be used in different tables.

column	type	table
OID	DECIMAL(28)	ACQUISITION_SESSION
START_DATE	TIMESTAMP	ACQUISITION_SESSION
DURATION	DECIMAL(28)	ACQUISITION_SESSION
NB_CDR_NEW	DECIMAL(28)	ACQUISITION_SESSION
NB_CDR_DUPLICATE	DECIMAL(28)	ACQUISITION_SESSION
NB_CDR_CONSOLIDATE	DECIMAL(28)	ACQUISITION_SESSION
SOURCE	VARCHAR(2000)	ACQUISITION_SESSION
DESCRIPTION	VARCHAR(2000)	ACQUISITION_SESSION
ACQUISITION_MODE	DECIMAL(1)	ACQUISITION_SESSION
STATUS	DECIMAL(1)	ACQUISITION_SESSION
INSTALL_DATE	TIMESTAMP	BART_VERSION
VERSION_ID	VARCHAR(20)	BART_VERSION
OID	DECIMAL(28)	CDR
BGRP_OID	DECIMAL(2)	CDR
NAME	VARCHAR(256)	CDR
USER_ID	VARCHAR(256)	CDR
SERVICE_ID	VARCHAR(256)	CDR
SUBSCRIPTION_ID	DECIMAL(28)	CDR
PARTITION_ID	DECIMAL(4)	CDR
CHARGE_ID	DECIMAL(28)	CDR
CONSUMPTION_DATE	TIMESTAMP	CDR
STATUS	DECIMAL(1)	CDR
ACQUISITION_DATE	TIMESTAMP	CDR
ACQUISITION_ID	DECIMAL(28)	CDR
RATING_DATE	TIMESTAMP	CDR
RATING_ID	DECIMAL(28)	CDR
ERROR_CODE	DECIMAL(4)	CDR
ERROR_DESCRIPTION	VARCHAR(1000)	CDR
SOURCE	VARCHAR(1000)	CDR
MAGIC_NUMBER	CHAR(34)	CDR
PROPERTIES	VARCHAR(4000)	CDR
SNAPSHOT_ID	DECIMAL(8)	CDR
CHARGE_TYPE	DECIMAL(1)	CDR
ALIAS	VARCHAR(64)	CERT_STORE
CERTIFICATE	BLOB	CERT_STORE
JOB_ID	DECIMAL(28)	CLEAN_BART_JOB
DELAY	DECIMAL(28)	CLEAN_BART_JOB
SESSION_ID	DECIMAL(28)	COLLECTION
ROOT_ID	DECIMAL(28)	COLLECTION
CONTRACT_ID	DECIMAL(28)	COLLECTION
OID	DECIMAL(28)	ID_TABLE
INST_TYPE	VARCHAR(64)	INSTANCE_CERT_STORE
CERT_ALIAS	VARCHAR(64)	INSTANCE_CERT_STORE
SERVICE	VARCHAR(16)	INSTANCE_CERT_STORE
INST_ID	VARCHAR(64)	INSTANCE_KEY_STORE
KEST_ALIAS	VARCHAR(64)	INSTANCE_KEY_STORE
SERVICE	VARCHAR(16)	INSTANCE_KEY_STORE
ALIAS	VARCHAR(64)	KEY_STORE
CERTIFICATE	BLOB	KEY_STORE
PRIVATE_KEY	BLOB(1024)	KEY_STORE
DIRECTORY_ID	DECIMAL(3)	PARTITION_DIRECTORY
DIRECTORY	VARCHAR(2000)	PARTITION_DIRECTORY
FILE_SIZE	VARCHAR(28)	PARTITION_DIRECTORY
EXTEND_SIZE	VARCHAR(28)	PARTITION_DIRECTORY
ACTIVE	DECIMAL(1)	PARTITION_DIRECTORY
PARTITION_DAYS	DECIMAL(3)	PARTITION_PURGE
PARTITION_ADVANCE_DAYS	DECIMAL(3)	PARTITION_PURGE
LAST_PARTITION_DIRECTORY_ID	DECIMAL(3)	PARTITION_PURGE
PARTITION_DATE	TIMESTAMP	PARTITION_STATUS
DIRECTORY_ID	DECIMAL(2)	PARTITION_STATUS
STATUS	DECIMAL(2)	PARTITION_STATUS
OID	DECIMAL(3)	PROPERTIES
NAME	VARCHAR(256)	PROPERTIES
TYPE	DECIMAL(1)	PROPERTIES
OID	DECIMAL(28)	RATING_SESSION
BGRP_OID	DECIMAL(2)	RATING_SESSION
CDR_SUBSCRIPTION_ID	DECIMAL(28)	RATING_SESSION
START_DATE	TIMESTAMP	RATING_SESSION
DURATION	DECIMAL(28)	RATING_SESSION
RATING_MODE	DECIMAL(1)	RATING_SESSION
MAX_CDR_CONSUMPTION_DATE	TIMESTAMP	RATING_SESSION
NB_CDR_RATED	DECIMAL(28)	RATING_SESSION
NB_CDR_ERROR	DECIMAL(28)	RATING_SESSION
DESCRIPTION	VARCHAR(2000)	RATING_SESSION
STATUS	DECIMAL(1)	RATING_SESSION
JOB_ID	DECIMAL(28)	RATING_SESSION_JOB
BGRP_OID	DECIMAL(2)	RATING_SESSION_JOB
DELAY	DECIMAL(28)	RATING_SESSION_JOB
RATING_MODE	DECIMAL(1)	RATING_SESSION_JOB
SESSION_ID	DECIMAL(28)	RERATING_SESSION
LOCK_CODE	VARCHAR(64)	RERATING_SESSION
SESSION_STATUS	DECIMAL(1)	RERATING_SESSION
RESTORATION_DATE	TIMESTAMP	RERATING_SESSION
SUBSCRIPTION_COUNT	DECIMAL(28)	RERATING_SESSION
IS_ADAPT_FROM_DATE	DECIMAL(1)	RERATING_SESSION
SESSION_ID	DECIMAL(28)	RERATING_SESSION_ORDER
SUBSCRIPTION_ID	DECIMAL(28)	RERATING_SESSION_ORDER
BGRP_OID	DECIMAL(2)	RERATING_SESSION_ORDER
PARTITION_ID	DECIMAL(4)	RERATING_SESSION_ORDER
FROM_DATE	TIMESTAMP	RERATING_SESSION_ORDER
ACTIVATE_DATE	TIMESTAMP	RERATING_SESSION_ORDER
FROM_SNAPSHOT_ID	DECIMAL(8)	RERATING_SESSION_ORDER
ORDER_STATUS	DECIMAL(1)	RERATING_SESSION_ORDER
CHARGE_TYPE	DECIMAL(1)	RERATING_SESSION_ORDER
JOB_ID	DECIMAL(28)	SCHEDULABLE_JOB
CLASS_NAME	VARCHAR(2000)	SCHEDULABLE_JOB
STATUS	DECIMAL(1)	SCHEDULABLE_JOB
RECURRENCE	VARCHAR(2000)	SCHEDULABLE_JOB
POLLING_PERIOD	DECIMAL(28)	SCHEDULABLE_JOB
DESCRIPTION	VARCHAR(2000)	SCHEDULABLE_JOB