complexType "ol_req_for_workTYPE"
Namespace:
Content:
complex, 44 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 44 attributes and 1 element
Used:
XML Representation Summary
<...
    req_db_site
 = 
xsd:hexBinary
    req_db_id
 = 
xsd:unsignedInt
    request_id
 = 
xsd:unsignedInt
    ord_list_db_site
 = 
xsd:hexBinary
    ord_list_db_id
 = 
xsd:unsignedInt
    ord_list_id
 = 
xsd:unsignedInt
    wm_type_db_site
 = 
xsd:hexBinary
    wm_type_db_id
 = 
xsd:unsignedInt
    wm_type_code
 = 
xsd:unsignedInt
    task_db_site
 = 
xsd:hexBinary
    task_db_id
 = 
xsd:unsignedInt
    task_type_code
 = 
xsd:unsignedInt
    auto_approve
 = 
("Y" | "N")
    start_before_gmt
 = 
xsd:dateTime
    end_before_gmt
 = 
xsd:dateTime
    start_after_gmt
 = 
xsd:dateTime
    end_after_gmt
 = 
xsd:dateTime
    repeat_interval
 = 
xsd:unsignedInt
    int_eu_db_site
 = 
xsd:hexBinary
    int_eu_db_id
 = 
xsd:unsignedInt
    int_eu_type_code
 = 
xsd:unsignedInt
    to_agent_site
 = 
xsd:hexBinary
    to_agent_id
 = 
xsd:unsignedInt
    sol_pack_db_site
 = 
xsd:hexBinary
    sol_pack_db_id
 = 
xsd:unsignedInt
    sol_pack_id
 = 
xsd:unsignedInt
    rec_ord_db_site
 = 
xsd:hexBinary
    rec_ord_db_id
 = 
xsd:unsignedInt
    rec_ord_list_id
 = 
xsd:unsignedInt
    rec_gmt_recomm
 = 
xsd:dateTime
    rec_by_agent_site
 = 
xsd:hexBinary
    rec_by_agent_id
 = 
xsd:unsignedInt
    work_req_db_site
 = 
xsd:hexBinary
    work_req_db_id
 = 
xsd:unsignedInt
    work_req_id
 = 
xsd:unsignedInt
    work_order_db_site
 = 
xsd:hexBinary
    work_order_db_id
 = 
xsd:unsignedInt
    work_order_id
 = 
xsd:unsignedInt
    name
 = 
xsd:string
    long_description
 = 
xsd:string
    gmt_last_updated
 = 
xsd:dateTime
    last_upd_db_site
 = 
xsd:hexBinary
    last_upd_db_id
 = 
xsd:unsignedInt
    rstat_type_code
 = 
xsd:unsignedShort
    >
   
Content: 
lcinfo?
</...>
Content Elements (1):
lcinfo (type lcinfo)
Known Usage Locations
Annotation
Request for Work for Ordered List/Route (Subset of Request table)
XML Source (w/o annotations (45))
<xsd:complexType name="ol_req_for_workTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="req_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="req_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="request_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ord_list_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="ord_list_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ord_list_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="wm_type_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="wm_type_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="wm_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="task_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="task_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="task_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="auto_approve" type="charYN" use="optional"/>
<xsd:attribute name="start_before_gmt" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="end_before_gmt" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="start_after_gmt" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="end_after_gmt" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="repeat_interval" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="int_eu_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="int_eu_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="int_eu_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="to_agent_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="to_agent_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="sol_pack_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="sol_pack_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="sol_pack_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rec_ord_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="rec_ord_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rec_ord_list_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rec_gmt_recomm" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="rec_by_agent_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="rec_by_agent_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="work_req_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="work_req_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="work_req_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="work_order_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="work_order_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="work_order_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="name" type="varchar254" use="optional"/>
<xsd:attribute name="long_description" type="varchar4000" use="optional"/>
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
</xsd:complexType>
Attribute Detail (defined in this component only; 44/44)
req_db_site
Type:
Use:
required
Foreign key reference to Request.req_db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="req_db_site" type="site_codeSimpleType" use="required"/>

req_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Request.req_db_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="req_db_id" type="xsd:unsignedInt" use="required"/>

request_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Request.request_id, Included in composite primary key
XML Source (w/o annotations (1))
<xsd:attribute name="request_id" type="xsd:unsignedInt" use="required"/>

ord_list_db_site
Type:
Use:
required
Foreign key reference to Ordered_List.ord_list_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="ord_list_db_site" type="site_codeSimpleType" use="required"/>

ord_list_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Ordered_List.ord_list_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="ord_list_db_id" type="xsd:unsignedInt" use="required"/>

ord_list_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Ordered_List.ord_list_id
XML Source (w/o annotations (1))
<xsd:attribute name="ord_list_id" type="xsd:unsignedInt" use="required"/>

wm_type_db_site
Type:
Use:
required
Foreign key reference to Work_Manage_Type.wm_type_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="wm_type_db_site" type="site_codeSimpleType" use="required"/>

wm_type_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Work_Manage_Type.wm_type_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="wm_type_db_id" type="xsd:unsignedInt" use="required"/>

wm_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Work_Manage_Type.wm_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="wm_type_code" type="xsd:unsignedInt" use="required"/>

task_db_site
Type:
Use:
required
Foreign key reference to Work_Task_Type.task_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="task_db_site" type="site_codeSimpleType" use="required"/>

task_db_id
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Work_Task_Type.task_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="task_db_id" type="xsd:unsignedInt" use="required"/>

task_type_code
Type:
xsd:unsignedInt, predefined
Use:
required
Foreign key reference to Work_Task_Type.task_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="task_type_code" type="xsd:unsignedInt" use="required"/>

auto_approve
Type:
Use:
optional
Request automatic generation of work order
Attribute Value
enumeration of xsd:string
Enumeration:
"Y", "N"
Length:
1
XML Source (w/o annotations (1))
<xsd:attribute name="auto_approve" type="charYN" use="optional"/>

start_before_gmt
Type:
Use:
optional
Request for action to begin before this time
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="start_before_gmt" type="dateTimeWithoutTimezone" use="optional"/>

end_before_gmt
Type:
Use:
optional
Request for action to end before this time
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="end_before_gmt" type="dateTimeWithoutTimezone" use="optional"/>

start_after_gmt
Type:
Use:
optional
Request for action to begin after this time
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="start_after_gmt" type="dateTimeWithoutTimezone" use="optional"/>

end_after_gmt
Type:
Use:
optional
Request for action to end after this time
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="end_after_gmt" type="dateTimeWithoutTimezone" use="optional"/>

repeat_interval
Type:
xsd:unsignedInt, predefined
Use:
optional
Time interval to re-submit time-based actions
XML Source (w/o annotations (1))
<xsd:attribute name="repeat_interval" type="xsd:unsignedInt" use="optional"/>

int_eu_db_site
Type:
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_db_site (time interval eng unit reference)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="int_eu_db_site" type="site_codeSimpleType" use="optional"/>

int_eu_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="int_eu_db_id" type="xsd:unsignedInt" use="optional"/>

int_eu_type_code
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Eng_Unit_Type.eu_type_code
XML Source (w/o annotations (1))
<xsd:attribute name="int_eu_type_code" type="xsd:unsignedInt" use="optional"/>

to_agent_site
Type:
Use:
optional
Foreign key reference to Agent.org_agent_site (agent to receive the request for work)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="to_agent_site" type="site_codeSimpleType" use="optional"/>

to_agent_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Agent.agent_id
XML Source (w/o annotations (1))
<xsd:attribute name="to_agent_id" type="xsd:unsignedInt" use="optional"/>

sol_pack_db_site
Type:
Use:
optional
Foreign key reference to Solution_Package.sol_pack_db_site (associated solution package)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="sol_pack_db_site" type="site_codeSimpleType" use="optional"/>

sol_pack_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Solution_Package.sol_pack_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="sol_pack_db_id" type="xsd:unsignedInt" use="optional"/>

sol_pack_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Solution_Package.sol_pack_id
XML Source (w/o annotations (1))
<xsd:attribute name="sol_pack_id" type="xsd:unsignedInt" use="optional"/>

rec_ord_db_site
Type:
Use:
optional
Foreign key reference to Ol_Recommendation.ord_list_db_site (associated ordered list recommendation)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="rec_ord_db_site" type="site_codeSimpleType" use="optional"/>

rec_ord_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Ol_Recommendation.ord_list_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="rec_ord_db_id" type="xsd:unsignedInt" use="optional"/>

rec_ord_list_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Ol_Recommendation.ord_list_id
XML Source (w/o annotations (1))
<xsd:attribute name="rec_ord_list_id" type="xsd:unsignedInt" use="optional"/>

rec_gmt_recomm
Type:
Use:
optional
Foreign key reference to Ol_Recommendation.gmt_recommendation
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="rec_gmt_recomm" type="dateTimeWithoutTimezone" use="optional"/>

rec_by_agent_site
Type:
Use:
optional
Foreign key reference to Ol_Recommendation.by_agent_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="rec_by_agent_site" type="site_codeSimpleType" use="optional"/>

rec_by_agent_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Ol_Recommendation.by_agent_id
XML Source (w/o annotations (1))
<xsd:attribute name="rec_by_agent_id" type="xsd:unsignedInt" use="optional"/>

work_req_db_site
Type:
Use:
optional
Foreign key reference to Work_Request.work_req_db_site
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="work_req_db_site" type="site_codeSimpleType" use="optional"/>

work_req_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Work_Request.work_req_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="work_req_db_id" type="xsd:unsignedInt" use="optional"/>

work_req_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Work_Request.work_req_id
XML Source (w/o annotations (1))
<xsd:attribute name="work_req_id" type="xsd:unsignedInt" use="optional"/>

work_order_db_site
Type:
Use:
optional
Foreign key reference to Work_Order.work_order_db_site (associated work order)
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="work_order_db_site" type="site_codeSimpleType" use="optional"/>

work_order_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Work_Order.work_order_db_id
XML Source (w/o annotations (1))
<xsd:attribute name="work_order_db_id" type="xsd:unsignedInt" use="optional"/>

work_order_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Work_Order.work_order_id
XML Source (w/o annotations (1))
<xsd:attribute name="work_order_id" type="xsd:unsignedInt" use="optional"/>

name
Type:
Use:
optional
Full user-defined name/description
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="name" type="varchar254" use="optional"/>

long_description
Type:
Use:
optional
Long_description field
Attribute Value
xsd:string
MaxLength:
4000
XML Source (w/o annotations (1))
<xsd:attribute name="long_description" type="varchar4000" use="optional"/>

gmt_last_updated
Type:
Use:
optional
UTC/GMT timestamp for the last change to this record
Attribute Value
xsd:dateTime
Pattern:
[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\.?[0-9]{0,9}
XML Source (w/o annotations (1))
<xsd:attribute name="gmt_last_updated" type="dateTimeWithoutTimezone" use="optional"/>

last_upd_db_site
Type:
Use:
optional
Foreign key reference to Site_Database.db_site which identifies the database creating/updating/soft deleting this entry
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_site" type="site_codeSimpleType" use="optional"/>

last_upd_db_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Site_Database.db_id which identifies the database creating/updating/soft deleting this entry
XML Source (w/o annotations (1))
<xsd:attribute name="last_upd_db_id" type="xsd:unsignedInt" use="optional"/>

rstat_type_code
Type:
xsd:unsignedShort, predefined
Use:
optional
Foreign key reference to Row_Status_Type.rstat_type_cod which determines the status of this entry
XML Source (w/o annotations (1))
<xsd:attribute name="rstat_type_code" type="xsd:unsignedShort" use="optional"/>
Content Element Detail (defined in this component only; 1/1)
lcinfo
Type:
lcinfo, complex content
XML Source
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>

XML schema documentation generated with DocFlex/XML 1.7.2b using DocFlex/XML | XSDDoc 2.1.0b template set