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