|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
ops_processparam_his |
Stores the User setting values that are done in OPS component. |
timestamp |
int |
Time Stamp |
No |
No |
|
|
|
|
parameter_type |
sql_variant |
Parameter Type |
|
|
|
|
|
|
parameter_category |
|
Parameter Category |
|
|
|
|
|
|
language_id |
int |
Language Id |
|
|
|
|
|
|
parameter_code |
sql_variant |
Parameter Code |
|
|
|
|
|
|
ou_id |
int |
Organization Unit Id |
|
|
|
|
|
|
parameter_text |
sql_variant |
Parameter Text |
|
|
|
|
|
|
extension_flag |
|
Extension Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
ops_processparam_sys |
Stores the history of user setting values that are done in OPS component. |
ou_id |
int |
Organization Unit Id |
Yes |
|
|
|
|
|
parameter_type |
sql_variant |
Parameter Type |
|
|
|
|
|
|
parameter_category |
|
Parameter Category |
|
|
|
|
|
|
parameter_code |
|
Parameter Code |
|
|
|
|
|
|
language_id |
int |
Language Id |
|
|
|
|
|
|
timestamp |
|
Time Stamp |
No |
|
|
|
|
|
parameter_text |
sql_variant |
Parameter Text |
|
|
|
|
|
|
extension_flag |
|
Extension Flag |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|