req_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | req_db_site |
Definition | |
Note |
req_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
req_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | req_db_id |
Definition | |
Note |
req_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
request_id |
Base Entity | as_req_for_work |
Attribute Name | request_id |
ColumnName | request_id |
Definition | |
Note |
request_id Logical Attribute Properties |
Logical Attribute Name | request_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
asset_org_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | asset_org_site |
Definition | |
Note |
asset_org_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
asset_id |
Base Entity | as_req_for_work |
Attribute Name | asset_id |
ColumnName | asset_id |
Definition | |
Note |
asset_id Logical Attribute Properties |
Logical Attribute Name | asset_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
wm_type_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | wm_type_db_site |
Definition | |
Note |
wm_type_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
wm_type_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | wm_type_db_id |
Definition | |
Note |
wm_type_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
wm_type_code |
Base Entity | as_req_for_work |
Attribute Name | wm_type_code |
ColumnName | wm_type_code |
Definition | |
Note |
wm_type_code Logical Attribute Properties |
Logical Attribute Name | wm_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
task_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | task_db_site |
Definition | |
Note |
task_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | NO |
task_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | task_db_id |
Definition | |
Note |
task_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
task_type_code |
Base Entity | as_req_for_work |
Attribute Name | task_type_code |
ColumnName | task_type_code |
Definition | |
Note |
task_type_code Logical Attribute Properties |
Logical Attribute Name | task_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | NO |
auto_approve |
Base Entity | as_req_for_work |
Attribute Name | auto_approve |
ColumnName | auto_approve |
Definition | |
Note |
auto_approve Logical Attribute Properties |
Logical Attribute Name | auto_approve |
Datatype | CHAR(1) |
Nullable | YES |
start_before_gmt |
Base Entity | as_req_for_work |
Attribute Name | start_before_gmt |
ColumnName | start_before_gmt |
Definition | |
Note |
start_before_gmt Logical Attribute Properties |
Logical Attribute Name | start_before_gmt |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
end_before_gmt |
Base Entity | as_req_for_work |
Attribute Name | end_before_gmt |
ColumnName | end_before_gmt |
Definition | |
Note |
end_before_gmt Logical Attribute Properties |
Logical Attribute Name | end_before_gmt |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
start_after_gmt |
Base Entity | as_req_for_work |
Attribute Name | start_after_gmt |
ColumnName | start_after_gmt |
Definition | |
Note |
start_after_gmt Logical Attribute Properties |
Logical Attribute Name | start_after_gmt |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
end_after_gmt |
Base Entity | as_req_for_work |
Attribute Name | end_after_gmt |
ColumnName | end_after_gmt |
Definition | |
Note |
end_after_gmt Logical Attribute Properties |
Logical Attribute Name | end_after_gmt |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
repeat_interval |
Base Entity | as_req_for_work |
Attribute Name | repeat_interval |
ColumnName | repeat_interval |
Definition | |
Note |
repeat_interval Logical Attribute Properties |
Logical Attribute Name | repeat_interval |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
int_eu_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | int_eu_db_site |
Definition | |
Note |
int_eu_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
int_eu_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | int_eu_db_id |
Definition | |
Note |
int_eu_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
int_eu_type_code |
Base Entity | as_req_for_work |
Attribute Name | eu_type_code |
ColumnName | int_eu_type_code |
Definition | |
Note |
int_eu_type_code Logical Attribute Properties |
Logical Attribute Name | eu_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
to_agent_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | to_agent_site |
Definition | |
Note |
to_agent_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
to_agent_id |
Base Entity | as_req_for_work |
Attribute Name | agent_id |
ColumnName | to_agent_id |
Definition | |
Note |
to_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
sol_pack_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | sol_pack_db_site |
Definition | |
Note |
sol_pack_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
sol_pack_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | sol_pack_db_id |
Definition | |
Note |
sol_pack_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
sol_pack_id |
Base Entity | as_req_for_work |
Attribute Name | sol_pack_id |
ColumnName | sol_pack_id |
Definition | |
Note |
sol_pack_id Logical Attribute Properties |
Logical Attribute Name | sol_pack_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
rec_asset_org_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | rec_asset_org_site |
Definition | |
Note |
rec_asset_org_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
rec_asset_id |
Base Entity | as_req_for_work |
Attribute Name | asset_id |
ColumnName | rec_asset_id |
Definition | |
Note |
rec_asset_id Logical Attribute Properties |
Logical Attribute Name | asset_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
rec_gmt_recomm |
Base Entity | as_req_for_work |
Attribute Name | gmt_recommendation |
ColumnName | rec_gmt_recomm |
Definition | |
Note |
rec_gmt_recomm Logical Attribute Properties |
Logical Attribute Name | gmt_recommendation |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
rec_by_agent_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | rec_by_agent_site |
Definition | |
Note |
rec_by_agent_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
rec_by_agent_id |
Base Entity | as_req_for_work |
Attribute Name | agent_id |
ColumnName | rec_by_agent_id |
Definition | |
Note |
rec_by_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_req_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | work_req_db_site |
Definition | |
Note |
work_req_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
work_req_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | work_req_db_id |
Definition | |
Note |
work_req_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_req_id |
Base Entity | as_req_for_work |
Attribute Name | work_req_id |
ColumnName | work_req_id |
Definition | |
Note |
work_req_id Logical Attribute Properties |
Logical Attribute Name | work_req_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_order_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | work_order_db_site |
Definition | |
Note |
work_order_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
work_order_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | work_order_db_id |
Definition | |
Note |
work_order_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_order_id |
Base Entity | as_req_for_work |
Attribute Name | work_order_id |
ColumnName | work_order_id |
Definition | |
Note |
work_order_id Logical Attribute Properties |
Logical Attribute Name | work_order_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
name |
Base Entity | as_req_for_work |
Attribute Name | name |
ColumnName | name |
Definition | |
Note |
name Logical Attribute Properties |
Logical Attribute Name | name |
Datatype | NVARCHAR(254) |
Nullable | YES |
long_description |
Base Entity | as_req_for_work |
Attribute Name | long_description |
ColumnName | long_description |
Definition | |
Note |
long_description Logical Attribute Properties |
Logical Attribute Name | long_description |
Datatype | VARCHAR(4000) |
Nullable | YES |
gmt_last_updated |
Base Entity | as_req_for_work |
Attribute Name | gmt_last_updated |
ColumnName | gmt_last_updated |
Definition | |
Note |
gmt_last_updated Logical Attribute Properties |
Logical Attribute Name | gmt_last_updated |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
last_upd_db_site |
Base Entity | as_req_for_work |
Attribute Name | site_code |
ColumnName | last_upd_db_site |
Definition | |
Note |
last_upd_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
last_upd_db_id |
Base Entity | as_req_for_work |
Attribute Name | db_id |
ColumnName | last_upd_db_id |
Definition | |
Note |
last_upd_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
rstat_type_code |
Base Entity | as_req_for_work |
Attribute Name | rstat_type_cod |
ColumnName | rstat_type_code |
Definition | |
Note |
rstat_type_code Logical Attribute Properties |
Logical Attribute Name | rstat_type_cod |
Datatype | NUMERIC(5, 0) |
Nullable | YES |