Data Dictionary -- OU Parameter Setup

Srl. No.	Table Name	Comment
1	OpSet_FAD_FAR_Addr_Det	Store the Details of FAD FAR Address
2	ops_processparam_his	Stores the History of User Setting Values
3	ops_processparam_sys	Stores the Information of User Setting Values

Table Name :	OpSet_FAD_FAR_Addr_Det
Comment :	Store the Details of FAD FAR Address

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
FAD_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Organization unit instance	No
FAD_Addressid	udd_addressidhr	Varchar(20)	No	Addressid	No
FAD_Operationtype	udd_operationtype	Varchar(80)	No	Operation type	No
FAD_Address1	udd_address1	Varchar(510)	No	Address1	No
FAD_Address2	udd_address2	Varchar(510)	Yes	Address2	No
FAD_Address3	udd_address3	Varchar(510)	Yes	Address3	No
FAD_City	udd_citymlt	Varchar(64)	No	City	No
FAD_State	udd_statemlt	Varchar(64)	No	State	No
FAD_Country	udd_countrymlt	Varchar(80)	No	Country	No
FAD_Zipcode	udd_zipcodemlt	Varchar(30)	No	Zipcode	No
FAD_Phoneno	udd_phonenomlt	Varchar(36)	Yes	Phone number	No
FAD_Faxno	udd_faxnomlt	Varchar(140)	Yes	Fax number	No
FAD_Emailid	udd_emailidmlt	Varchar(140)	Yes	Email id	No
FAD_Createdby	udd_crtbymlt	Varchar(60)	No	Created by	No
FAD_Createddate	udd_crtdatemlt	Varchar(60)	No	Created date	No
FAD_LastModifiedby	udd_modbymlt	Varchar(60)	Yes	Last Modified by	No
FAD_LastModifieddate	udd_moddatemlt	Varchar(22)	Yes	Last Modified date	No
FAD_Remarks	udd_remarksmlt	Varchar(510)	Yes	Remarks	No
FAD_timestamp	udd_timestamp	int(4)	No	Timestamp	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

Table Name :	ops_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
parameter_type	fin_param_type	varchar(6)	Yes	Parameter type	No
parameter_category	fin_param_categ	varchar(16)	Yes	Parameter category	No
language_id	fin_languageid	int(4)	Yes	Language id	No
parameter_code	fin_paramcode	varchar(30)	Yes	Parameter code	No
ou_id	fin_ouinstid	int(4)	Yes	Organization unit id	No
parameter_text	fin_remarks	varchar(100)	Yes	Parameter text	No
extension_flag	fin_eflag	varchar(1)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Createdby	No
createddate	fin_datetime	datetime(8)	Yes	Createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modifiedby	No
modifieddate	fin_datetime	datetime(8)	Yes	Modifieddate	No
REPLICATION_KEY	fin_bigint	Bigint(8)	No	REPLICATION_KEY	Yes

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ou_id	fin_ouinstid	int(4)	No	Organization unit id	Yes
parameter_type	fin_param_type	varchar(6)	No	Parameter type	Yes
parameter_category	fin_param_categ	varchar(16)	No	Parameter category	Yes
parameter_code	fin_paramcode	varchar(30)	No	Parameter code	Yes
language_id	fin_languageid	int(4)	No	Language id	Yes
timestamp	fin_int	int(4)	Yes	Timestamp	No
parameter_text	fin_remarks	varchar(100)	Yes	Parameter text	No
extension_flag	fin_eflag	varchar(1)	Yes	Extension flag	No
createdby	fin_ctxt_user	varchar(30)	Yes	Createdby	No
createddate	fin_datetime	datetime(8)	Yes	Createddate	No
modifiedby	fin_ctxt_user	varchar(30)	Yes	Modifiedby	No
modifieddate	fin_datetime	datetime(8)	Yes	Modifieddate	No