source: Scheduling/branches/GUI1.2/csSchema20040428.xsd@ 1154

Last change on this file since 1154 was 614, checked in by Sam Habiel, 15 years ago

Initial committ of scheduling package
File size: 10.0 KB
Line 
1<?xml version="1.0" standalone="yes"?>
2<xs:schema id="GlobalDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
3 <xs:element name="GlobalDataSet" msdata:IsDataSet="true">
4 <xs:complexType>
5 <xs:choice maxOccurs="unbounded">
6 <xs:element name="VersionInfo">
7 <xs:complexType>
8 <xs:sequence>
9 <xs:element name="ERROR" type="xs:string" minOccurs="0" />
10 <xs:element name="MAJOR_VERSION" type="xs:string" minOccurs="0" />
11 <xs:element name="MINOR_VERSION" type="xs:string" minOccurs="0" />
12 <xs:element name="BUILD" type="xs:string" minOccurs="0" />
13 </xs:sequence>
14 </xs:complexType>
15 </xs:element>
16 <xs:element name="SchedulingUser">
17 <xs:complexType>
18 <xs:sequence>
19 <xs:element name="MANAGER" type="xs:string" minOccurs="0" />
20 </xs:sequence>
21 </xs:complexType>
22 </xs:element>
23 <xs:element name="AccessTypes">
24 <xs:complexType>
25 <xs:sequence>
26 <xs:element name="BMXIEN" type="xs:int" />
27 <xs:element name="ACCESS_TYPE_NAME" type="xs:string" minOccurs="0" />
28 <xs:element name="BLUE" type="xs:int" minOccurs="0" />
29 <xs:element name="DEPARTMENT_NAME" type="xs:string" minOccurs="0" />
30 <xs:element name="DISPLAY_COLOR" type="xs:string" minOccurs="0" />
31 <xs:element name="GREEN" type="xs:int" minOccurs="0" />
32 <xs:element name="INACTIVE" type="xs:string" minOccurs="0" />
33 <xs:element name="RED" type="xs:int" minOccurs="0" />
34 </xs:sequence>
35 </xs:complexType>
36 </xs:element>
37 <xs:element name="AccessGroup">
38 <xs:complexType>
39 <xs:sequence>
40 <xs:element name="BMXIEN" type="xs:int" minOccurs="0" />
41 <xs:element name="ACCESS_GROUP" type="xs:string" />
42 </xs:sequence>
43 </xs:complexType>
44 </xs:element>
45 <xs:element name="AccessGroupType">
46 <xs:complexType>
47 <xs:sequence>
48 <xs:element name="ACCESS_GROUP_TYPEID" type="xs:int" />
49 <xs:element name="ACCESS_GROUP_ID" type="xs:int" minOccurs="0" />
50 <xs:element name="ACCESS_GROUP" type="xs:string" minOccurs="0" />
51 <xs:element name="ACCESS_TYPE_ID" type="xs:int" minOccurs="0" />
52 <xs:element name="ACCESS_TYPE" type="xs:string" minOccurs="0" />
53 </xs:sequence>
54 </xs:complexType>
55 </xs:element>
56 <xs:element name="ResourceGroup">
57 <xs:complexType>
58 <xs:sequence>
59 <xs:element name="RESOURCE_GROUPID" type="xs:int" minOccurs="0" />
60 <xs:element name="RESOURCE_GROUP" type="xs:string" />
61 </xs:sequence>
62 </xs:complexType>
63 </xs:element>
64 <xs:element name="Resources">
65 <xs:complexType>
66 <xs:sequence>
67 <xs:element name="RESOURCEID" type="xs:int" />
68 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
69 <xs:element name="INACTIVE" type="xs:string" minOccurs="0" />
70 <xs:element name="TIMESCALE" type="xs:int" minOccurs="0" />
71 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" minOccurs="0" />
72 <xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" />
73 </xs:sequence>
74 </xs:complexType>
75 </xs:element>
76 <xs:element name="GroupResources">
77 <xs:complexType>
78 <xs:sequence>
79 <xs:element name="RESOURCE_GROUPID" type="xs:int" minOccurs="0" />
80 <xs:element name="RESOURCE_GROUP" type="xs:string" minOccurs="0" />
81 <xs:element name="RESOURCE_GROUP_ITEMID" type="xs:int" minOccurs="0" />
82 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" />
83 <xs:element name="RESOURCEID" type="xs:int" minOccurs="0" />
84 </xs:sequence>
85 </xs:complexType>
86 </xs:element>
87 <xs:element name="HospitalLocation">
88 <xs:complexType>
89 <xs:sequence>
90 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" />
91 <xs:element name="HOSPITAL_LOCATION" type="xs:string" minOccurs="0" />
92 <xs:element name="DEFAULT_PROVIDER" type="xs:string" minOccurs="0" />
93 <xs:element name="STOP_CODE_NUMBER" type="xs:string" minOccurs="0" />
94 <xs:element name="INACTIVATE_DATE" type="xs:dateTime" minOccurs="0" />
95 <xs:element name="REACTIVATE_DATE" type="xs:dateTime" minOccurs="0" />
96 </xs:sequence>
97 </xs:complexType>
98 </xs:element>
99 <xs:element name="ClinicSetupParameters">
100 <xs:complexType>
101 <xs:sequence>
102 <xs:element name="HOSPITAL_LOCATION_ID" type="xs:int" />
103 <xs:element name="HOSPITAL_LOCATION" type="xs:string" minOccurs="0" />
104 <xs:element name="CREATE_VISIT" type="xs:string" minOccurs="0" />
105 <xs:element name="VISIT_SERVICE_CATEGORY" type="xs:string" minOccurs="0" />
106 <xs:element name="PROVIDER" msdata:ReadOnly="true" msdata:Expression="Parent.DEFAULT_PROVIDER" type="xs:string" minOccurs="0" />
107 <xs:element name="CLINIC_STOP" msdata:ReadOnly="true" msdata:Expression="Parent.STOP_CODE_NUMBER" type="xs:string" minOccurs="0" />
108 <xs:element name="INACTIVATE_DATE" msdata:ReadOnly="true" msdata:Expression="Parent.INACTIVATE_DATE" type="xs:string" minOccurs="0" />
109 <xs:element name="REACTIVATE_DATE" msdata:ReadOnly="true" msdata:Expression="Parent.REACTIVATE_DATE" type="xs:string" minOccurs="0" />
110 </xs:sequence>
111 </xs:complexType>
112 </xs:element>
113 <xs:element name="ScheduleUser">
114 <xs:complexType>
115 <xs:sequence>
116 <xs:element name="USERID" type="xs:int" />
117 <xs:element name="USERNAME" type="xs:string" minOccurs="0" />
118 </xs:sequence>
119 </xs:complexType>
120 </xs:element>
121 <xs:element name="ResourceUser">
122 <xs:complexType>
123 <xs:sequence>
124 <xs:element name="RESOURCEUSER_ID" type="xs:int" />
125 <xs:element name="RESOURCEID" type="xs:int" minOccurs="0" />
126 <xs:element name="OVERBOOK" type="xs:string" minOccurs="0" />
127 <xs:element name="MODIFY_SCHEDULE" type="xs:string" minOccurs="0" />
128 <xs:element name="USERID" type="xs:string" minOccurs="0" />
129 <xs:element name="USERID1" type="xs:int" minOccurs="0" />
130 </xs:sequence>
131 </xs:complexType>
132 </xs:element>
133 <xs:element name="Provider">
134 <xs:complexType>
135 <xs:sequence>
136 <xs:element name="BMXIEN" type="xs:int" minOccurs="0" />
137 <xs:element name="NAME" type="xs:string" minOccurs="0" />
138 </xs:sequence>
139 </xs:complexType>
140 </xs:element>
141 </xs:choice>
142 </xs:complexType>
143 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
144 <xs:selector xpath=".//AccessTypes" />
145 <xs:field xpath="BMXIEN" />
146 </xs:unique>
147 <xs:unique name="AccessGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
148 <xs:selector xpath=".//AccessGroup" />
149 <xs:field xpath="ACCESS_GROUP" />
150 </xs:unique>
151 <xs:unique name="Constraint2">
152 <xs:selector xpath=".//AccessGroup" />
153 <xs:field xpath="BMXIEN" />
154 </xs:unique>
155 <xs:unique name="AccessGroupType_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
156 <xs:selector xpath=".//AccessGroupType" />
157 <xs:field xpath="ACCESS_GROUP_TYPEID" />
158 </xs:unique>
159 <xs:unique name="ResourceGroup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
160 <xs:selector xpath=".//ResourceGroup" />
161 <xs:field xpath="RESOURCE_GROUP" />
162 </xs:unique>
163 <xs:unique name="Resources_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
164 <xs:selector xpath=".//Resources" />
165 <xs:field xpath="RESOURCEID" />
166 </xs:unique>
167 <xs:unique name="HospitalLocation_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
168 <xs:selector xpath=".//HospitalLocation" />
169 <xs:field xpath="HOSPITAL_LOCATION_ID" />
170 </xs:unique>
171 <xs:unique name="ClinicSetupParameters_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
172 <xs:selector xpath=".//ClinicSetupParameters" />
173 <xs:field xpath="HOSPITAL_LOCATION_ID" />
174 </xs:unique>
175 <xs:unique name="ScheduleUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
176 <xs:selector xpath=".//ScheduleUser" />
177 <xs:field xpath="USERID" />
178 </xs:unique>
179 <xs:unique name="ResourceUser_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
180 <xs:selector xpath=".//ResourceUser" />
181 <xs:field xpath="RESOURCEUSER_ID" />
182 </xs:unique>
183 <xs:keyref name="ResourceUser" refer="Resources_Constraint1">
184 <xs:selector xpath=".//ResourceUser" />
185 <xs:field xpath="RESOURCEID" />
186 </xs:keyref>
187 <xs:keyref name="GroupResource" refer="ResourceGroup_Constraint1">
188 <xs:selector xpath=".//GroupResources" />
189 <xs:field xpath="RESOURCE_GROUP" />
190 </xs:keyref>
191 <xs:keyref name="AccessGroupType" refer="Constraint2">
192 <xs:selector xpath=".//AccessGroupType" />
193 <xs:field xpath="ACCESS_GROUP_ID" />
194 </xs:keyref>
195 </xs:element>
196 <xs:annotation>
197 <xs:appinfo>
198 <msdata:Relationship name="HospitalLocationClinic" msdata:parent="HospitalLocation" msdata:child="ClinicSetupParameters" msdata:parentkey="HOSPITAL_LOCATION_ID" msdata:childkey="HOSPITAL_LOCATION_ID" />
199 </xs:appinfo>
200 </xs:annotation>
201</xs:schema>
Note: See TracBrowser for help on using the repository browser.