Data Dictionary -- BU Parameter Setup

Srl. No.	Table Name	Comment
1	bps_processparam_his	Stores the History of User setting Values
2	bps_processparam_sys	Stores the Information of User Setting Values

Table Name :	bps_processparam_his
Comment :	Stores the History of User setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
timestamp	fin_int	int(4)	Yes	Timestamp	No
bu_id	fin_varchar	varchar(800)	Yes	Business unit id	No
language_id	fin_int	int(4)	Yes	Language id	No
parameter_code	fin_varchar	varchar(800)	No	Parameter code	No
parameter_category	fin_varchar	varchar(800)	No	Parameter category	No
parameter_type	fin_varchar	varchar(800)	Yes	Parameter type	No
ou_id	fin_int	int(4)	Yes	Organization unit id	No
parameter_text	fin_varchar	varchar(800)	Yes	Parameter text	No
extension_flag	fin_varchar	varchar(800)	Yes	Extension flag	No
createdby	fin_varchar	varchar(800)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_varchar	varchar(800)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	bps_processparam_sys
Comment :	Stores the Information of User Setting Values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_int	int(4)	No	Organization unit id	Yes
parameter_type	fin_varchar	varchar(800)	No	Parameter type	Yes
parameter_category	fin_varchar	varchar(800)	No	Parameter category	Yes
parameter_code	fin_varchar	varchar(800)	No	Parameter code	Yes
language_id	fin_int	int(4)	No	Language id	Yes
bu_id	fin_varchar	varchar(800)	No	Business unit id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_varchar	varchar(800)	No	Parameter text	Yes
extension_flag	fin_varchar	varchar(800)	Yes	Extension flag	No
createdby	fin_varchar	varchar(800)	Yes	Created by	No
createddate	fin_datetime	datetime(8)	Yes	Created date	No
modifiedby	fin_varchar	varchar(800)	Yes	Modified by	No
modifieddate	fin_datetime	datetime(8)	Yes	Modified date	No