work_req_db_site
Base Entity work_request
Attribute Name site_code
Definition

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


work_req_db_id
Base Entity work_request
Attribute Name db_id
Definition

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


work_req_id
Base Entity work_request
Attribute Name work_req_id
Definition

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


work_order_id
Base Entity work_request
Attribute Name work_order_id
Definition

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


work_order_db_id
Base Entity work_request
Attribute Name db_id
Definition

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


work_order_db_site
Base Entity work_request
Attribute Name site_code
Definition

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


wm_type_db_site
Base Entity work_request
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 work_request
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 work_request
Attribute Name wm_type_code
Definition

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


gmt_created
Base Entity work_request
Attribute Name gmt_created
Definition

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


loc_hr_delta
Base Entity work_request
Attribute Name loc_hr_delta
Definition

loc_hr_delta Logical Attribute Properties
Logical Attribute Name loc_hr_delta
Datatype SMALLINT
Nullable YES


loc_min_delta
Base Entity work_request
Attribute Name loc_min_delta
Definition

loc_min_delta Logical Attribute Properties
Logical Attribute Name loc_min_delta
Datatype SMALLINT
Nullable YES


by_agent_site
Base Entity work_request
Attribute Name site_code
Definition

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


by_agent_id
Base Entity work_request
Attribute Name agent_id
Definition

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


start_before_gmt
Base Entity work_request
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 work_request
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 work_request
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 work_request
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 work_request
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 work_request
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 work_request
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 work_request
Attribute Name eu_type_code
Definition

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


from_sy_agent_site
Base Entity work_request
Attribute Name site_code
Definition

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


from_sy_agent_id
Base Entity work_request
Attribute Name agent_id
Definition

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


to_agent_site
Base Entity work_request
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 work_request
Attribute Name agent_id
Definition

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


priority_lev_db_site
Base Entity work_request
Attribute Name site_code
Definition

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


priority_lev_db_id
Base Entity work_request
Attribute Name db_id
Definition

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


priority_lev_type_code
Base Entity work_request
Attribute Name priority_lev_type_code
Definition

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


eng_study_entry_db_site
Base Entity work_request
Attribute Name eng_study_entry_db_site
Definition

eng_study_entry_db_site Logical Attribute Properties
Logical Attribute Name eng_study_entry_db_site
Datatype CHAR(16)
Nullable YES


eng_study_entry_db_id
Base Entity work_request
Attribute Name eng_study_entry_db_id
Definition

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


eng_study_entry_id
Base Entity work_request
Attribute Name eng_study_entry_id
Definition

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


user_tag_ident
Base Entity work_request
Attribute Name user_tag_ident
Definition

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


name
Base Entity work_request
Attribute Name name
Definition

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


long_description
Base Entity work_request
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 work_request
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 work_request
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 work_request
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 work_request
Attribute Name rstat_type_cod
Definition

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