Table Name bps_processparam_his
Table Comment Stores the User setting values that are done in BPS component.
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|
|
timestamp |
int |
NULL |
Time Stamp |
No |
No |
|
bu_id |
varchar(20) |
|
Business Unit Id |
|
|
|
language_id |
int |
|
Language Id |
|
|
|
parameter_code |
varchar(40) |
|
Parameter Code |
|
|
|
parameter_category |
|
|
Parameter Category |
|
|
|
parameter_type |
varchar(6) |
|
Parameter Type |
|
|
|
ou_id |
int |
|
Organization Unit Id |
|
|
|
parameter_text |
varchar(255) |
|
Parameter Text |
|
|
|
extension_flag |
varchar(1) |
|
Extension Flag |
|
|
|
createdby |
varchar(15) |
|
Created By |
|
|
|
createddate |
datetime |
|
Created Date |
|
|
|
modifiedby |
varchar(15) |
|
Modified By |
|
|
|
modifieddate |
datetime |
|
Modified Date |
|
|
Table Name bps_processparam_sys
Table Comment Stores the history of user setting values that are done in BPS component.
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|
|
ou_id |
int |
NOT NULL |
Organization Unit Id |
Yes |
No |
|
parameter_type |
varchar(6) |
|
Parameter Type |
|
|
|
parameter_category |
varchar(40) |
|
Parameter Category |
|
|
|
parameter_code |
|
|
Parameter Code |
|
|
|
language_id |
int |
|
Language Id |
|
|
|
bu_id |
varchar(20) |
|
Business Unit Id |
|
|
|
timestamp |
int |
NULL |
Time Stamp |
No |
|
|
parameter_text |
varchar(255) |
|
Parameter Text |
|
|
|
extension_flag |
varchar(1) |
|
Extension Flag |
|
|
|
createdby |
varchar(15) |
|
Created By |
|
|
|
createddate |
datetime |
|
Created Date |
|
|
|
modifiedby |
varchar(15) |
|
Modified By |
|
|
|
modifieddate |
datetime |
|
Modified Date |
|
|