complexType "sg_proposed_eventTYPE"
Namespace:
Content:
complex, 38 attributes, 1 element
Defined:
globally in CRIS_Complete_V3-2-1_[31-Dec-2008].xsd, see XML source
Includes:
definitions of 38 attributes and 1 element
Used:
XML Representation Summary
<...
    sg_prop_db_site
 = 
xsd:hexBinary
    sg_prop_db_id
 = 
xsd:unsignedInt
    sg_prop_event_id
 = 
xsd:unsignedInt
    segment_site
 = 
xsd:hexBinary
    segment_id
 = 
xsd:unsignedInt
    ev_db_site
 = 
xsd:hexBinary
    ev_db_id
 = 
xsd:unsignedInt
    event_type_code
 = 
xsd:unsignedInt
    severity_lev_db_site
 = 
xsd:hexBinary
    severity_lev_db_id
 = 
xsd:unsignedInt
    severity_lev_type_code
 = 
xsd:unsignedInt
    gmt_proposed
 = 
xsd:dateTime
    pr_loc_hr_delta
 = 
xsd:short
    pr_loc_min_delta
 = 
xsd:unsignedShort
    by_org_asite
 = 
xsd:hexBinary
    by_agent_id
 = 
xsd:unsignedInt
    likelihood_prob
 = 
xsd:double
    est_gmt_start
 = 
xsd:dateTime
    st_loc_hr_delta
 = 
xsd:short
    st_loc_min_delta
 = 
xsd:unsignedShort
    est_gmt_occur_end
 = 
xsd:dateTime
    end_loc_hr_delta
 = 
xsd:short
    end_loc_min_delta
 = 
xsd:unsignedShort
    ch_patt_db_site
 = 
xsd:hexBinary
    ch_patt_db_id
 = 
xsd:unsignedInt
    ch_patt_type_code
 = 
xsd:unsignedInt
    user_tag_ident
 = 
xsd:string
    name
 = 
xsd:string
    gmt_audited
 = 
xsd:dateTime
    aud_loc_hr_delta
 = 
xsd:short
    aud_loc_min_delta
 = 
xsd:unsignedShort
    aud_quality_code
 = 
xsd:unsignedShort
    aud_by_org_asite
 = 
xsd:hexBinary
    aud_by_agent_id
 = 
xsd:unsignedInt
    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
Proposed Past/Present/Future Segment Events including Diagnostic/Prognostic Event Outputs
XML Source (w/o annotations (39))
<xsd:complexType name="sg_proposed_eventTYPE">
<xsd:sequence>
<xsd:element minOccurs="0" name="lcinfo" type="lcinfo"/>
</xsd:sequence>
<xsd:attribute name="sg_prop_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="sg_prop_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="sg_prop_event_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="segment_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="segment_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="ev_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="ev_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="event_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="severity_lev_db_site" type="site_codeSimpleType" use="required"/>
<xsd:attribute name="severity_lev_db_id" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="severity_lev_type_code" type="xsd:unsignedInt" use="required"/>
<xsd:attribute name="gmt_proposed" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="pr_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="pr_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="by_org_asite" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="by_agent_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="likelihood_prob" type="xsd:double" use="optional"/>
<xsd:attribute name="est_gmt_start" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="st_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="st_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="est_gmt_occur_end" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="end_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="end_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="ch_patt_db_site" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="ch_patt_db_id" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="ch_patt_type_code" type="xsd:unsignedInt" use="optional"/>
<xsd:attribute name="user_tag_ident" type="varchar254" use="optional"/>
<xsd:attribute name="name" type="varchar254" use="optional"/>
<xsd:attribute name="gmt_audited" type="dateTimeWithoutTimezone" use="optional"/>
<xsd:attribute name="aud_loc_hr_delta" type="xsd:short" use="optional"/>
<xsd:attribute name="aud_loc_min_delta" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="aud_quality_code" type="xsd:unsignedShort" use="optional"/>
<xsd:attribute name="aud_by_org_asite" type="site_codeSimpleType" use="optional"/>
<xsd:attribute name="aud_by_agent_id" type="xsd:unsignedInt" 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; 38/38)
sg_prop_db_site
Type:
Use:
required
Foreign key reference to Site_Database.db_site, Included in composite primary key
Attribute Value
xsd:hexBinary
Length:
8
XML Source (w/o annotations (1))
<xsd:attribute name="sg_prop_db_site" type="site_codeSimpleType" use="required"/>

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

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

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

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

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

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

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

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

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

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

gmt_proposed
Type:
Use:
optional
Timestamp when proposed as an event
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_proposed" type="dateTimeWithoutTimezone" use="optional"/>

pr_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Hours from GMT when proposed as an event
XML Source (w/o annotations (1))
<xsd:attribute name="pr_loc_hr_delta" type="xsd:short" use="optional"/>

pr_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Minutes from GMT when proposed as an event
XML Source (w/o annotations (1))
<xsd:attribute name="pr_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

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

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

likelihood_prob
Type:
xsd:double, predefined
Use:
optional
Likelihood probability between 0 and 1
XML Source (w/o annotations (1))
<xsd:attribute name="likelihood_prob" type="xsd:double" use="optional"/>

est_gmt_start
Type:
Use:
optional
Estimated GMT event started or will start
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="est_gmt_start" type="dateTimeWithoutTimezone" use="optional"/>

st_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Hours from GMT for local start time
XML Source (w/o annotations (1))
<xsd:attribute name="st_loc_hr_delta" type="xsd:short" use="optional"/>

st_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Minutes from GMT for local start time
XML Source (w/o annotations (1))
<xsd:attribute name="st_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

est_gmt_occur_end
Type:
Use:
optional
Estimated GMT event ended or will end
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="est_gmt_occur_end" type="dateTimeWithoutTimezone" use="optional"/>

end_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Hours from GMT for local end time
XML Source (w/o annotations (1))
<xsd:attribute name="end_loc_hr_delta" type="xsd:short" use="optional"/>

end_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Minutes from GMT for local end time
XML Source (w/o annotations (1))
<xsd:attribute name="end_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

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

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

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

user_tag_ident
Type:
Use:
optional
Short user-defined tag/identifier
Attribute Value
xsd:string
MaxLength:
254
XML Source (w/o annotations (1))
<xsd:attribute name="user_tag_ident" type="varchar254" 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"/>

gmt_audited
Type:
Use:
optional
GMT proposed event audited
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_audited" type="dateTimeWithoutTimezone" use="optional"/>

aud_loc_hr_delta
Type:
xsd:short, predefined
Use:
optional
Hours from GMT for local audit time
XML Source (w/o annotations (1))
<xsd:attribute name="aud_loc_hr_delta" type="xsd:short" use="optional"/>

aud_loc_min_delta
Type:
xsd:unsignedShort, predefined
Use:
optional
Minutes from GMT for local audit time
XML Source (w/o annotations (1))
<xsd:attribute name="aud_loc_min_delta" type="xsd:unsignedShort" use="optional"/>

aud_quality_code
Type:
xsd:unsignedShort, predefined
Use:
optional
Foreign key reference to Data_Qual_Type.dqual_type_code (propsed event, not inspected, good/confirmed, bad/incorrect, or under review)
XML Source (w/o annotations (1))
<xsd:attribute name="aud_quality_code" type="xsd:unsignedShort" use="optional"/>

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

aud_by_agent_id
Type:
xsd:unsignedInt, predefined
Use:
optional
Foreign key reference to Agent.agent_id (Audited by Agent)
XML Source (w/o annotations (1))
<xsd:attribute name="aud_by_agent_id" type="xsd:unsignedInt" 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