Oracle 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	DATE	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	VARCHAR2(2000 CHAR)	ACQUISITION_SESSION
DESCRIPTION	VARCHAR2(2000 CHAR)	ACQUISITION_SESSION
ACQUISITION_MODE	DECIMAL(1)	ACQUISITION_SESSION
STATUS	DECIMAL(1)	ACQUISITION_SESSION
INSTALL_DATE	DATE	BART_VERSION
VERSION_ID	VARCHAR2(20 CHAR)	BART_VERSION
OID	DECIMAL(28)	CDR
BGRP_OID	DECIMAL(2)	CDR
NAME	VARCHAR2(256 CHAR)	CDR
USER_ID	VARCHAR2(256 CHAR)	CDR
SERVICE_ID	VARCHAR2(256 CHAR)	CDR
SUBSCRIPTION_ID	DECIMAL(28)	CDR
PARTITION_ID	DECIMAL(4)	CDR
CHARGE_ID	DECIMAL(28)	CDR
CONSUMPTION_DATE	DATE	CDR
STATUS	DECIMAL(1)	CDR
ACQUISITION_DATE	DATE	CDR
ACQUISITION_ID	DECIMAL(28)	CDR
RATING_DATE	DATE	CDR
RATING_ID	DECIMAL(28)	CDR
ERROR_CODE	DECIMAL(4)	CDR
ERROR_DESCRIPTION	VARCHAR2(1000 CHAR)	CDR
SOURCE	VARCHAR2(1000 CHAR)	CDR
MAGIC_NUMBER	CHAR(34)	CDR
PROPERTIES	VARCHAR2(4000 CHAR)	CDR
SNAPSHOT_ID	DECIMAL(8)	CDR
CHARGE_TYPE	DECIMAL(1)	CDR
ALIAS	VARCHAR2(64 CHAR)	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	VARCHAR2(64 CHAR)	INSTANCE_CERT_STORE
CERT_ALIAS	VARCHAR2(64 CHAR)	INSTANCE_CERT_STORE
SERVICE	VARCHAR2(16 CHAR)	INSTANCE_CERT_STORE
INST_ID	VARCHAR2(64 CHAR)	INSTANCE_KEY_STORE
KEST_ALIAS	VARCHAR2(64 CHAR)	INSTANCE_KEY_STORE
SERVICE	VARCHAR2(16 CHAR)	INSTANCE_KEY_STORE
ALIAS	VARCHAR2(64 CHAR)	KEY_STORE
CERTIFICATE	BLOB	KEY_STORE
PRIVATE_KEY	RAW(1024)	KEY_STORE
DIRECTORY_ID	DECIMAL(3)	PARTITION_DIRECTORY
DIRECTORY	VARCHAR2(2000 CHAR)	PARTITION_DIRECTORY
FILE_SIZE	VARCHAR2(28 CHAR)	PARTITION_DIRECTORY
EXTEND_SIZE	VARCHAR2(28 CHAR)	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	DATE	PARTITION_STATUS
DIRECTORY_ID	DECIMAL(2)	PARTITION_STATUS
STATUS	DECIMAL(2)	PARTITION_STATUS
TABLESPACE_PREFIX	VARCHAR2(100 CHAR)	PARTITION_TABLESPACE
TABLESPACE_SUFFIX	VARCHAR2(100 CHAR)	PARTITION_TABLESPACE
DATA_FILE_SUFFIX	VARCHAR2(100 CHAR)	PARTITION_TABLESPACE
OID	DECIMAL(3)	PROPERTIES
NAME	VARCHAR2(256 CHAR)	PROPERTIES
TYPE	DECIMAL(1)	PROPERTIES
PROCESS_NAME	VARCHAR2(256 CHAR)	PURGE_ARCHIVE_EXCEPTION
RECORD_DATE	DATE	PURGE_ARCHIVE_EXCEPTION
EXCEPTION	VARCHAR2(2000 CHAR)	PURGE_ARCHIVE_EXCEPTION
SQL	VARCHAR2(4000 CHAR)	PURGE_ARCHIVE_EXCEPTION
OID	DECIMAL(28)	RATING_SESSION
BGRP_OID	DECIMAL(2)	RATING_SESSION
CDR_SUBSCRIPTION_ID	DECIMAL(28)	RATING_SESSION
START_DATE	DATE	RATING_SESSION
DURATION	DECIMAL(28)	RATING_SESSION
RATING_MODE	DECIMAL(1)	RATING_SESSION
MAX_CDR_CONSUMPTION_DATE	DATE	RATING_SESSION
NB_CDR_RATED	DECIMAL(28)	RATING_SESSION
NB_CDR_ERROR	DECIMAL(28)	RATING_SESSION
DESCRIPTION	VARCHAR2(2000 CHAR)	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	VARCHAR2(64 CHAR)	RERATING_SESSION
SESSION_STATUS	DECIMAL(1)	RERATING_SESSION
RESTORATION_DATE	DATE	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	DATE	RERATING_SESSION_ORDER
ACTIVATE_DATE	DATE	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	VARCHAR2(2000 CHAR)	SCHEDULABLE_JOB
STATUS	DECIMAL(1)	SCHEDULABLE_JOB
RECURRENCE	VARCHAR2(2000 CHAR)	SCHEDULABLE_JOB
POLLING_PERIOD	DECIMAL(28)	SCHEDULABLE_JOB
DESCRIPTION	VARCHAR2(2000 CHAR)	SCHEDULABLE_JOB