asset_org_site |
Base Entity | as_completed_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_completed_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 |
task_db_site |
Base Entity | as_completed_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_completed_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_completed_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 |
gmt_completed |
Base Entity | as_completed_work |
Attribute Name | gmt_completed |
ColumnName | gmt_completed |
Definition | |
Note |
gmt_completed Logical Attribute Properties |
Logical Attribute Name | gmt_completed |
Datatype | TIMESTAMP/DATE |
Nullable | NO |
cp_loc_hr_delta |
Base Entity | as_completed_work |
Attribute Name | cp_loc_hr_delta |
ColumnName | cp_loc_hr_delta |
Definition | |
Note |
cp_loc_hr_delta Logical Attribute Properties |
Logical Attribute Name | cp_loc_hr_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
cp_loc_min_delta |
Base Entity | as_completed_work |
Attribute Name | cp_loc_min_delta |
ColumnName | cp_loc_min_delta |
Definition | |
Note |
cp_loc_min_delta Logical Attribute Properties |
Logical Attribute Name | cp_loc_min_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
gmt_started |
Base Entity | as_completed_work |
Attribute Name | gmt_started |
ColumnName | gmt_started |
Definition | |
Note |
gmt_started Logical Attribute Properties |
Logical Attribute Name | gmt_started |
Datatype | TIMESTAMP/DATE |
Nullable | YES |
st_loc_hr_delta |
Base Entity | as_completed_work |
Attribute Name | st_loc_hr_delta |
ColumnName | st_loc_hr_delta |
Definition | |
Note |
st_loc_hr_delta Logical Attribute Properties |
Logical Attribute Name | st_loc_hr_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
st_loc_min_delta |
Base Entity | as_completed_work |
Attribute Name | st_loc_min_delta |
ColumnName | st_loc_min_delta |
Definition | |
Note |
st_loc_min_delta Logical Attribute Properties |
Logical Attribute Name | st_loc_min_delta |
Datatype | NUMERIC(5, 0) |
Nullable | YES |
by_agent_site |
Base Entity | as_completed_work |
Attribute Name | site_code |
ColumnName | by_agent_site |
Definition | |
Note |
by_agent_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
by_agent_id |
Base Entity | as_completed_work |
Attribute Name | agent_id |
ColumnName | by_agent_id |
Definition | |
Note |
by_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
from_sy_agent_site |
Base Entity | as_completed_work |
Attribute Name | site_code |
ColumnName | from_sy_agent_site |
Definition | |
Note |
from_sy_agent_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
from_sy_agent_id |
Base Entity | as_completed_work |
Attribute Name | agent_id |
ColumnName | from_sy_agent_id |
Definition | |
Note |
from_sy_agent_id Logical Attribute Properties |
Logical Attribute Name | agent_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
priority_lev_db_site |
Base Entity | as_completed_work |
Attribute Name | site_code |
ColumnName | priority_lev_db_site |
Definition | |
Note |
priority_lev_db_site Logical Attribute Properties |
Logical Attribute Name | site_code |
Datatype | CHAR(16) |
Nullable | YES |
priority_lev_db_id |
Base Entity | as_completed_work |
Attribute Name | db_id |
ColumnName | priority_lev_db_id |
Definition | |
Note |
priority_lev_db_id Logical Attribute Properties |
Logical Attribute Name | db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
priority_lev_type_code |
Base Entity | as_completed_work |
Attribute Name | priority_lev_type_code |
ColumnName | priority_lev_type_code |
Definition | |
Note |
priority_lev_type_code Logical Attribute Properties |
Logical Attribute Name | priority_lev_type_code |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_order_db_site |
Base Entity | as_completed_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_completed_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_completed_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 |
work_req_db_site |
Base Entity | as_completed_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_completed_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_completed_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_step_db_site |
Base Entity | as_completed_work |
Attribute Name | work_step_db_site |
ColumnName | work_step_db_site |
Definition | |
Note |
work_step_db_site Logical Attribute Properties |
Logical Attribute Name | work_step_db_site |
Datatype | CHAR(16) |
Nullable | YES |
work_step_db_id |
Base Entity | as_completed_work |
Attribute Name | work_step_db_id |
ColumnName | work_step_db_id |
Definition | |
Note |
work_step_db_id Logical Attribute Properties |
Logical Attribute Name | work_step_db_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
work_step_id |
Base Entity | as_completed_work |
Attribute Name | work_step_id |
ColumnName | work_step_id |
Definition | |
Note |
work_step_id Logical Attribute Properties |
Logical Attribute Name | work_step_id |
Datatype | NUMERIC(10, 0) |
Nullable | YES |
user_tag_ident |
Base Entity | as_completed_work |
Attribute Name | user_tag_ident |
ColumnName | user_tag_ident |
Definition | |
Note |
user_tag_ident Logical Attribute Properties |
Logical Attribute Name | user_tag_ident |
Datatype | NVARCHAR(254) |
Nullable | YES |
name |
Base Entity | as_completed_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_completed_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_completed_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_completed_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_completed_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_completed_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 |
work_ord_step_seq |
Base Entity | as_completed_work |
Attribute Name | work_ord_step_seq |
ColumnName | work_ord_step_seq |
Definition | |
Note |
work_ord_step_seq Logical Attribute Properties |
Logical Attribute Name | work_ord_step_seq |
Datatype | NUMERIC(5, 0) |
Nullable | YES |