Schema lookuptable.xsd


schema location:  ..\lookuptable.xsd
attributeFormDefault: 
elementFormDefault: 
 
Elements  Complex types  Simple types 
lookupTable  fileListType  datePlusHour 
historyLogType 
limitationsType 
limitType 
ratingSetType 
ratingsType 
ticketComplexType 
ticketStatusType 


element lookupTable
diagram lookuptable_p1.png
properties
content complex
children error message pjmTicketId companyTicketId groupName companyShortName transTicketId ticketStatus ticketType reasonId startDateTime endDateTime comments pjmComments equipmentId excludeConditionalRatings historyLog ratings limitations fileAttachmentCount fileList
source <xs:element name="lookupTable">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="error" type="xs:string" minOccurs="0" maxOccurs="unbounded"/>
      <xs:element name="message" type="xs:string" minOccurs="0" maxOccurs="unbounded"/>
      <xs:element name="pjmTicketId" type="xs:long" minOccurs="0"/>
      <xs:element name="companyTicketId" type="xs:string" minOccurs="0"/>
      <xs:element name="groupName" type="xs:string" minOccurs="0"/>
      <xs:element name="companyShortName" type="xs:string" minOccurs="0"/>
      <xs:element name="transTicketId" type="xs:long" minOccurs="0"/>
      <xs:element name="ticketStatus" type="xs:long" minOccurs="0">
        <xs:annotation>
          <xs:documentation>-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed</xs:documentation>
        </xs:annotation>
      </xs:element>
      <xs:element name="ticketType" type="ticketComplexType"/>
      <xs:element name="reasonId" type="xs:long" minOccurs="1"/>
      <xs:element name="startDateTime" type="datePlusHour" minOccurs="1">
        <xs:annotation>
          <xs:documentation>The format is mm/dd/yyyy hh24. This is the planned start date/hour of the change (and, where provided, the planned end date/hour), which means the change is planned to be effective on the provided date/hour and will continue to be effective until the end date/hour. For example, if 01/16/2025 12 is provided, then the change is planned to be effective beginning 01/16/2025 12 and will be incorporated into PJM AAR Facility Rating forecasts for 01/16/2025 HE 1300 and beyond until the end date/hour, or unless superseded by other information for the given facility.</xs:documentation>
        </xs:annotation>
      </xs:element>
      <xs:element name="endDateTime" type="datePlusHour" minOccurs="0">
        <xs:annotation>
          <xs:documentation>The format is mm/dd/yyyy hh24. See startDateTime for more details.</xs:documentation>
        </xs:annotation>
      </xs:element>
      <xs:element name="comments" type="xs:string" minOccurs="0"/>
      <xs:element name="pjmComments" type="xs:string" minOccurs="0"/>
      <xs:element name="equipmentId" type="xs:long" minOccurs="1"/>
      <xs:element name="excludeConditionalRatings" type="xs:boolean" default="false" minOccurs="0"/>
      <xs:element name="historyLog" type="historyLogType" minOccurs="0"/>
      <xs:element name="ratings" type="ratingsType" minOccurs="1"/>
      <xs:element name="limitations" type="limitationsType" minOccurs="0"/>
      <xs:element name="fileAttachmentCount" type="xs:unsignedInt" minOccurs="0"/>
      <xs:element name="fileList" type="fileListType" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

element lookupTable/error
diagram lookuptable_p2.png
type xs:string
properties
minOcc 0
maxOcc unbounded
content simple
source <xs:element name="error" type="xs:string" minOccurs="0" maxOccurs="unbounded"/>

element lookupTable/message
diagram lookuptable_p3.png
type xs:string
properties
minOcc 0
maxOcc unbounded
content simple
source <xs:element name="message" type="xs:string" minOccurs="0" maxOccurs="unbounded"/>

element lookupTable/pjmTicketId
diagram lookuptable_p4.png
type xs:long
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="pjmTicketId" type="xs:long" minOccurs="0"/>

element lookupTable/companyTicketId
diagram lookuptable_p5.png
type xs:string
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="companyTicketId" type="xs:string" minOccurs="0"/>

element lookupTable/groupName
diagram lookuptable_p6.png
type xs:string
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="groupName" type="xs:string" minOccurs="0"/>

element lookupTable/companyShortName
diagram lookuptable_p7.png
type xs:string
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="companyShortName" type="xs:string" minOccurs="0"/>

element lookupTable/transTicketId
diagram lookuptable_p8.png
type xs:long
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="transTicketId" type="xs:long" minOccurs="0"/>

element lookupTable/ticketStatus
diagram lookuptable_p9.png
type xs:long
properties
minOcc 0
maxOcc 1
content simple
annotation
documentation
-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed
source <xs:element name="ticketStatus" type="xs:long" minOccurs="0">
  <xs:annotation>
    <xs:documentation>-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed</xs:documentation>
  </xs:annotation>
</xs:element>

element lookupTable/ticketType
diagram lookuptable_p10.png
type ticketComplexType
properties
content complex
attributes
Name  Type  Use  Default  Fixed  Annotation
implementation  derived by: xs:string  required      
type  derived by: xs:string  required      
source <xs:element name="ticketType" type="ticketComplexType"/>

element lookupTable/reasonId
diagram lookuptable_p11.png
type xs:long
properties
content simple
source <xs:element name="reasonId" type="xs:long" minOccurs="1"/>

element lookupTable/startDateTime
diagram lookuptable_p12.png
type datePlusHour
properties
content simple
facets
Kind Value Annotation
pattern \d{2}/\d{2}/\d{4}\s+\d{2}
annotation
documentation
The format is mm/dd/yyyy hh24. This is the planned start date/hour of the change (and, where provided, the planned end date/hour), which means the change is planned to be effective on the provided date/hour and will continue to be effective until the end date/hour. For example, if 01/16/2025 12 is provided, then the change is planned to be effective beginning 01/16/2025 12 and will be incorporated into PJM AAR Facility Rating forecasts for 01/16/2025 HE 1300 and beyond until the end date/hour, or unless superseded by other information for the given facility.
source <xs:element name="startDateTime" type="datePlusHour" minOccurs="1">
  <xs:annotation>
    <xs:documentation>The format is mm/dd/yyyy hh24. This is the planned start date/hour of the change (and, where provided, the planned end date/hour), which means the change is planned to be effective on the provided date/hour and will continue to be effective until the end date/hour. For example, if 01/16/2025 12 is provided, then the change is planned to be effective beginning 01/16/2025 12 and will be incorporated into PJM AAR Facility Rating forecasts for 01/16/2025 HE 1300 and beyond until the end date/hour, or unless superseded by other information for the given facility.</xs:documentation>
  </xs:annotation>
</xs:element>

element lookupTable/endDateTime
diagram lookuptable_p13.png
type datePlusHour
properties
minOcc 0
maxOcc 1
content simple
facets
Kind Value Annotation
pattern \d{2}/\d{2}/\d{4}\s+\d{2}
annotation
documentation
The format is mm/dd/yyyy hh24. See startDateTime for more details.
source <xs:element name="endDateTime" type="datePlusHour" minOccurs="0">
  <xs:annotation>
    <xs:documentation>The format is mm/dd/yyyy hh24. See startDateTime for more details.</xs:documentation>
  </xs:annotation>
</xs:element>

element lookupTable/comments
diagram lookuptable_p14.png
type xs:string
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="comments" type="xs:string" minOccurs="0"/>

element lookupTable/pjmComments
diagram lookuptable_p15.png
type xs:string
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="pjmComments" type="xs:string" minOccurs="0"/>

element lookupTable/equipmentId
diagram lookuptable_p16.png
type xs:long
properties
content simple
source <xs:element name="equipmentId" type="xs:long" minOccurs="1"/>

element lookupTable/excludeConditionalRatings
diagram lookuptable_p17.png
type xs:boolean
properties
minOcc 0
maxOcc 1
content simple
default false
source <xs:element name="excludeConditionalRatings" type="xs:boolean" default="false" minOccurs="0"/>

element lookupTable/historyLog
diagram lookuptable_p18.png
type historyLogType
properties
minOcc 0
maxOcc 1
content complex
children ticketStatus
source <xs:element name="historyLog" type="historyLogType" minOccurs="0"/>

element lookupTable/ratings
diagram lookuptable_p19.png
type ratingsType
properties
content complex
children ratingSet
source <xs:element name="ratings" type="ratingsType" minOccurs="1"/>

element lookupTable/limitations
diagram lookuptable_p20.png
type limitationsType
properties
minOcc 0
maxOcc 1
content complex
children limit
source <xs:element name="limitations" type="limitationsType" minOccurs="0"/>

element lookupTable/fileAttachmentCount
diagram lookuptable_p21.png
type xs:unsignedInt
properties
minOcc 0
maxOcc 1
content simple
source <xs:element name="fileAttachmentCount" type="xs:unsignedInt" minOccurs="0"/>

element lookupTable/fileList
diagram lookuptable_p22.png
type fileListType
properties
minOcc 0
maxOcc 1
content complex
children file
source <xs:element name="fileList" type="fileListType" minOccurs="0"/>

complexType fileListType
diagram lookuptable_p23.png
children file
used by
element lookupTable/fileList
source <xs:complexType name="fileListType">
  <xs:sequence>
    <xs:element name="file" maxOccurs="unbounded">
      <xs:complexType>
        <xs:sequence>
          <xs:element name="fileName" type="xs:string"/>
          <xs:element name="fileTimestamp" type="xs:string"/>
        </xs:sequence>
      </xs:complexType>
    </xs:element>
  </xs:sequence>
</xs:complexType>

element fileListType/file
diagram lookuptable_p24.png
properties
minOcc 1
maxOcc unbounded
content complex
children fileName fileTimestamp
source <xs:element name="file" maxOccurs="unbounded">
  <xs:complexType>
    <xs:sequence>
      <xs:element name="fileName" type="xs:string"/>
      <xs:element name="fileTimestamp" type="xs:string"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

element fileListType/file/fileName
diagram lookuptable_p25.png
type xs:string
properties
content simple
source <xs:element name="fileName" type="xs:string"/>

element fileListType/file/fileTimestamp
diagram lookuptable_p26.png
type xs:string
properties
content simple
source <xs:element name="fileTimestamp" type="xs:string"/>

complexType historyLogType
diagram lookuptable_p27.png
children ticketStatus
used by
element lookupTable/historyLog
source <xs:complexType name="historyLogType">
  <xs:sequence>
    <xs:element name="ticketStatus" type="ticketStatusType" maxOccurs="unbounded">
      <xs:annotation>
        <xs:documentation>-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed</xs:documentation>
      </xs:annotation>
    </xs:element>
  </xs:sequence>
</xs:complexType>

element historyLogType/ticketStatus
diagram lookuptable_p28.png
type ticketStatusType
properties
minOcc 1
maxOcc unbounded
content complex
children user status timestamp
annotation
documentation
-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed
source <xs:element name="ticketStatus" type="ticketStatusType" maxOccurs="unbounded">
  <xs:annotation>
    <xs:documentation>-1=Retired, 1=Submitted, 2=Received, 3=Denied, 4=Approved, 6=Cancelled by Company, 7=Cancelled by PJM, 8=Revised, 9=Implemented, 10=Implemented w/o Approve, 11=Restored, 12=Completed</xs:documentation>
  </xs:annotation>
</xs:element>

complexType limitationsType
diagram lookuptable_p29.png
children limit
used by
element lookupTable/limitations
source <xs:complexType name="limitationsType">
  <xs:sequence>
    <xs:element name="limit" type="limitType" maxOccurs="unbounded"/>
  </xs:sequence>
</xs:complexType>

element limitationsType/limit
diagram lookuptable_p30.png
type limitType
properties
minOcc 1
maxOcc unbounded
content complex
attributes
Name  Type  Use  Default  Fixed  Annotation
id  xs:long        
tempSet  xs:string        
category  xs:string        
source <xs:element name="limit" type="limitType" maxOccurs="unbounded"/>

complexType limitType
diagram lookuptable_p31.png
used by
element limitationsType/limit
attributes
Name  Type  Use  Default  Fixed  Annotation
id  xs:long        
tempSet  xs:string        
category  xs:string        
source <xs:complexType name="limitType">
  <xs:attribute name="id" type="xs:long"/>
  <xs:attribute name="tempSet" type="xs:string"/>
  <xs:attribute name="category" type="xs:string"/>
</xs:complexType>

attribute limitType/@id
type xs:long
source <xs:attribute name="id" type="xs:long"/>

attribute limitType/@tempSet
type xs:string
source <xs:attribute name="tempSet" type="xs:string"/>

attribute limitType/@category
type xs:string
source <xs:attribute name="category" type="xs:string"/>

complexType ratingSetType
diagram lookuptable_p32.png
used by
element ratingsType/ratingSet
attributes
Name  Type  Use  Default  Fixed  Annotation
tempSet  xs:string        
nl  xs:long        
lt  xs:long        
st  xs:long        
ld  xs:long        
cndReason  xs:string        
source <xs:complexType name="ratingSetType">
  <xs:attribute name="tempSet" type="xs:string"/>
  <xs:attribute name="nl" type="xs:long"/>
  <xs:attribute name="lt" type="xs:long"/>
  <xs:attribute name="st" type="xs:long"/>
  <xs:attribute name="ld" type="xs:long"/>
  <xs:attribute name="cndReason" type="xs:string"/>
</xs:complexType>

attribute ratingSetType/@tempSet
type xs:string
source <xs:attribute name="tempSet" type="xs:string"/>

attribute ratingSetType/@nl
type xs:long
source <xs:attribute name="nl" type="xs:long"/>

attribute ratingSetType/@lt
type xs:long
source <xs:attribute name="lt" type="xs:long"/>

attribute ratingSetType/@st
type xs:long
source <xs:attribute name="st" type="xs:long"/>

attribute ratingSetType/@ld
type xs:long
source <xs:attribute name="ld" type="xs:long"/>

attribute ratingSetType/@cndReason
type xs:string
source <xs:attribute name="cndReason" type="xs:string"/>

complexType ratingsType
diagram lookuptable_p33.png
children ratingSet
used by
element lookupTable/ratings
source <xs:complexType name="ratingsType">
  <xs:sequence>
    <xs:element name="ratingSet" type="ratingSetType" maxOccurs="unbounded">
      <xs:annotation>
        <xs:documentation>nl=normal, lt=long term, st=short term, ld=load dump. nl, lt, st, ld are positive numbers with a maximum of 6 digits.</xs:documentation>
      </xs:annotation>
    </xs:element>
  </xs:sequence>
</xs:complexType>

element ratingsType/ratingSet
diagram lookuptable_p34.png
type ratingSetType
properties
minOcc 1
maxOcc unbounded
content complex
attributes
Name  Type  Use  Default  Fixed  Annotation
tempSet  xs:string        
nl  xs:long        
lt  xs:long        
st  xs:long        
ld  xs:long        
cndReason  xs:string        
annotation
documentation
nl=normal, lt=long term, st=short term, ld=load dump. nl, lt, st, ld are positive numbers with a maximum of 6 digits.
source <xs:element name="ratingSet" type="ratingSetType" maxOccurs="unbounded">
  <xs:annotation>
    <xs:documentation>nl=normal, lt=long term, st=short term, ld=load dump. nl, lt, st, ld are positive numbers with a maximum of 6 digits.</xs:documentation>
  </xs:annotation>
</xs:element>

complexType ticketComplexType
diagram lookuptable_p35.png
used by
element lookupTable/ticketType
attributes
Name  Type  Use  Default  Fixed  Annotation
implementation  derived by: xs:string  required      
type  derived by: xs:string  required      
source <xs:complexType name="ticketComplexType">
  <xs:attribute name="implementation" use="required">
    <xs:simpleType>
      <xs:restriction base="xs:string">
        <xs:enumeration value="immediate"/>
        <xs:enumeration value="planned"/>
      </xs:restriction>
    </xs:simpleType>
  </xs:attribute>
  <xs:attribute name="type" use="required">
    <xs:simpleType>
      <xs:restriction base="xs:string">
        <xs:enumeration value="permanent"/>
        <xs:enumeration value="temporary"/>
      </xs:restriction>
    </xs:simpleType>
  </xs:attribute>
</xs:complexType>

attribute ticketComplexType/@implementation
type restriction of xs:string
properties
use required
facets
Kind Value Annotation
enumeration immediate
enumeration planned
source <xs:attribute name="implementation" use="required">
  <xs:simpleType>
    <xs:restriction base="xs:string">
      <xs:enumeration value="immediate"/>
      <xs:enumeration value="planned"/>
    </xs:restriction>
  </xs:simpleType>
</xs:attribute>

attribute ticketComplexType/@type
type restriction of xs:string
properties
use required
facets
Kind Value Annotation
enumeration permanent
enumeration temporary
source <xs:attribute name="type" use="required">
  <xs:simpleType>
    <xs:restriction base="xs:string">
      <xs:enumeration value="permanent"/>
      <xs:enumeration value="temporary"/>
    </xs:restriction>
  </xs:simpleType>
</xs:attribute>

complexType ticketStatusType
diagram lookuptable_p36.png
children user status timestamp
used by
element historyLogType/ticketStatus
source <xs:complexType name="ticketStatusType">
  <xs:sequence>
    <xs:element name="user" type="xs:string"/>
    <xs:element name="status" type="xs:long"/>
    <xs:element name="timestamp" type="xs:string"/>
  </xs:sequence>
</xs:complexType>

element ticketStatusType/user
diagram lookuptable_p37.png
type xs:string
properties
content simple
source <xs:element name="user" type="xs:string"/>

element ticketStatusType/status
diagram lookuptable_p38.png
type xs:long
properties
content simple
source <xs:element name="status" type="xs:long"/>

element ticketStatusType/timestamp
diagram lookuptable_p39.png
type xs:string
properties
content simple
source <xs:element name="timestamp" type="xs:string"/>

simpleType datePlusHour
type restriction of xs:string
properties
base xs:string
used by
elements lookupTable/endDateTime lookupTable/startDateTime
facets
Kind Value Annotation
pattern \d{2}/\d{2}/\d{4}\s+\d{2}
source <xs:simpleType name="datePlusHour">
  <xs:restriction base="xs:string">
    <xs:pattern value="\d{2}/\d{2}/\d{4}\s+\d{2}"/>
  </xs:restriction>
</xs:simpleType>


XML Schema documentation generated by XMLSpy Schema Editor http://www.altova.com/xmlspy