req_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

req_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


req_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

req_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable NO


request_id
Base Entity ol_req_for_work
Attribute Name request_id
Definition

request_id Logical Attribute Properties
Logical Attribute Name request_id
Datatype INTEGER
Nullable NO


ord_list_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

ord_list_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


ord_list_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

ord_list_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable NO


ord_list_id
Base Entity ol_req_for_work
Attribute Name ord_list_id
Definition

ord_list_id Logical Attribute Properties
Logical Attribute Name ord_list_id
Datatype INTEGER
Nullable NO


wm_type_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

wm_type_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


wm_type_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

wm_type_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable NO


wm_type_code
Base Entity ol_req_for_work
Attribute Name wm_type_code
Definition

wm_type_code Logical Attribute Properties
Logical Attribute Name wm_type_code
Datatype INTEGER
Nullable NO


task_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

task_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable NO


task_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

task_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable NO


task_type_code
Base Entity ol_req_for_work
Attribute Name task_type_code
Definition

task_type_code Logical Attribute Properties
Logical Attribute Name task_type_code
Datatype INTEGER
Nullable NO


auto_approve
Base Entity ol_req_for_work
Attribute Name auto_approve
Definition

auto_approve Logical Attribute Properties
Logical Attribute Name auto_approve
Datatype CHAR(1)
Nullable YES


start_before_gmt
Base Entity ol_req_for_work
Attribute Name start_before_gmt
Definition

start_before_gmt Logical Attribute Properties
Logical Attribute Name start_before_gmt
Datatype DATETIME
Nullable YES


end_before_gmt
Base Entity ol_req_for_work
Attribute Name end_before_gmt
Definition

end_before_gmt Logical Attribute Properties
Logical Attribute Name end_before_gmt
Datatype DATETIME
Nullable YES


start_after_gmt
Base Entity ol_req_for_work
Attribute Name start_after_gmt
Definition

start_after_gmt Logical Attribute Properties
Logical Attribute Name start_after_gmt
Datatype DATETIME
Nullable YES


end_after_gmt
Base Entity ol_req_for_work
Attribute Name end_after_gmt
Definition

end_after_gmt Logical Attribute Properties
Logical Attribute Name end_after_gmt
Datatype DATETIME
Nullable YES


repeat_interval
Base Entity ol_req_for_work
Attribute Name repeat_interval
Definition

repeat_interval Logical Attribute Properties
Logical Attribute Name repeat_interval
Datatype INTEGER
Nullable YES


int_eu_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

int_eu_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


int_eu_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

int_eu_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


int_eu_type_code
Base Entity ol_req_for_work
Attribute Name eu_type_code
Definition

int_eu_type_code Logical Attribute Properties
Logical Attribute Name eu_type_code
Datatype INTEGER
Nullable YES


to_agent_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

to_agent_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


to_agent_id
Base Entity ol_req_for_work
Attribute Name agent_id
Definition

to_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


sol_pack_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

sol_pack_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


sol_pack_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

sol_pack_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


sol_pack_id
Base Entity ol_req_for_work
Attribute Name sol_pack_id
Definition

sol_pack_id Logical Attribute Properties
Logical Attribute Name sol_pack_id
Datatype INTEGER
Nullable YES


rec_ord_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

rec_ord_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


rec_ord_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

rec_ord_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


rec_ord_list_id
Base Entity ol_req_for_work
Attribute Name ord_list_id
Definition

rec_ord_list_id Logical Attribute Properties
Logical Attribute Name ord_list_id
Datatype INTEGER
Nullable YES


rec_gmt_recomm
Base Entity ol_req_for_work
Attribute Name gmt_recommendation
Definition

rec_gmt_recomm Logical Attribute Properties
Logical Attribute Name gmt_recommendation
Datatype DATETIME
Nullable YES


rec_by_agent_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

rec_by_agent_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


rec_by_agent_id
Base Entity ol_req_for_work
Attribute Name agent_id
Definition

rec_by_agent_id Logical Attribute Properties
Logical Attribute Name agent_id
Datatype INTEGER
Nullable YES


work_req_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

work_req_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


work_req_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

work_req_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


work_req_id
Base Entity ol_req_for_work
Attribute Name work_req_id
Definition

work_req_id Logical Attribute Properties
Logical Attribute Name work_req_id
Datatype INTEGER
Nullable YES


work_order_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

work_order_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


work_order_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

work_order_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


work_order_id
Base Entity ol_req_for_work
Attribute Name work_order_id
Definition

work_order_id Logical Attribute Properties
Logical Attribute Name work_order_id
Datatype INTEGER
Nullable YES


name
Base Entity ol_req_for_work
Attribute Name name
Definition

name Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(254)
Nullable YES


long_description
Base Entity ol_req_for_work
Attribute Name long_description
Definition

long_description Logical Attribute Properties
Logical Attribute Name long_description
Datatype VARCHAR(4000)
Nullable YES


gmt_last_updated
Base Entity ol_req_for_work
Attribute Name gmt_last_updated
Definition

gmt_last_updated Logical Attribute Properties
Logical Attribute Name gmt_last_updated
Datatype DATETIME
Nullable YES


last_upd_db_site
Base Entity ol_req_for_work
Attribute Name site_code
Definition

last_upd_db_site Logical Attribute Properties
Logical Attribute Name site_code
Datatype CHAR(16)
Nullable YES


last_upd_db_id
Base Entity ol_req_for_work
Attribute Name db_id
Definition

last_upd_db_id Logical Attribute Properties
Logical Attribute Name db_id
Datatype INTEGER
Nullable YES


rstat_type_code
Base Entity ol_req_for_work
Attribute Name rstat_type_cod
Definition

rstat_type_code Logical Attribute Properties
Logical Attribute Name rstat_type_cod
Datatype SMALLINT
Nullable YES