Maria, There are a couple places to look.
First, there are views created for each form created. These would be beter to tap for your universe as they use the form name and field database names and not the c53687... names.
Second you can join thearschema and field tables. I've attached a .def file that you can import that will do it for you in a Remedy form. Select a form in a search screen and click search. All associated fields are displayed in a table field.
On 8/2/06, Maria Calabrese <[EMAIL PROTECTED]> wrote:
Hello,
We are working on upgrading to ARS6.3 and Help Desk 6.
We are looking at the reporting aspect at this time. We curretly use
Business Objects. We will have to recreate the Business Objects universe.
Does anyone know of a data dictionary that would give us a list of all the
fields used in the application and how they're being used to that we can
build this universe?
Any help will be greatly appreciated.
Thanks
Maria Calabrese
Bose Corporation
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
#
# File exported Tue Sep 26 16:15:32 2006
#
begin schema
name : ADMIN-ARSchema.
core-version : 2
upgrade-version: 0
num-fields : 26
timestamp : 1159312424
owner : smcdonald
last-changed : steve_mcdonald
default-vui : Default Admin View
num-vuis : 1
export-version : 8
schema-type : 3
ext-table : arschema
key-field : schemaid
next-field-id : 536870938
get-list-flds :
5\1\10\0\\536870917\32\0\\536870920\10\0\\536870918\10\0\\536870919\10\0\
object-prop : 1\60018\4\0\\
archive : 0\0\0
arch-time : 0\0\0\0
arch-from :
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1159312424
vui-locale :
vui-type : 1
owner : smcdonald
last-changed : steve_mcdonald
display-prop : 7\20\4\18\Default Admin
View\60019\4\21\ViewWebAlias536870912\201\2\66375\202\2\86600\264\6\0\251\6\0\252\6\0\
}
field {
id : 1
name : schemaid
datatype : 4
fieldtype : 3
ext-field : schemaid
create-mode : 2
option : 3
timestamp : 1125437242
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 15
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
display-instance :
536870912\12\20\4\8\schemaid\3\41\2\2475\5500\13500\7900\7\40\2147483647\231\6\0\143\40\4294967295\170\40\0\21\41\2\0\400\5850\2400\151\41\2\5962\0\11024\210&
display-instance : 0\65\41\2\0\0\0\0\66\41\2\0\0\0\0\61\40\7\228\40\1\
}
field {
id : 536870913
name : coreversion
datatype : 2
fieldtype : 3
ext-field : coreversion
create-mode : 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\11\coreversion\3\41\2\31500\18000\55687\20100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483648\23&
display-instance :
1\6\0\143\40\4294967295\21\41\2\0\400\6187\2100\151\41\2\6750\0\24187\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870914
name : defaultvui
datatype : 4
fieldtype : 3
ext-field : defaultvui
create-mode : 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 254
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\10\defaultvui\3\41\2\32512\10500\58612\12600\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483649\231\6\0\14&
display-instance :
3\40\4294967295\21\41\2\0\400\5175\2100\151\41\2\5737\0\23174\2100\65\41\2\7372350\0\7372350\0\66\41\2\23737\0\26099\2100\228\40\1\
}
field {
id : 536870915
name : lastchanged
datatype : 4
fieldtype : 3
ext-field : lastchanged
create-mode : 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
maxlength : 30
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\11\lastchanged\3\41\2\1350\13000\25875\15100\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483650\231\6\0\14&
display-instance :
3\40\4294967295\21\41\2\0\400\6525\2100\151\41\2\7087\0\24524\2100\65\41\2\787\0\787\0\66\41\2\787\0\787\0\228\40\1\
}
field {
id : 536870916
name : maxstatenums
datatype : 2
fieldtype : 3
ext-field : maxstatenums
create-mode : 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\12\maxstatenums\3\41\2\30150\15500\55687\17600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483651\2&
display-instance :
31\6\0\143\40\4294967295\21\41\2\0\400\7537\2100\151\41\2\8100\0\25537\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870917
name : name
datatype : 4
fieldtype : 3
ext-field : name
create-mode : 2
option : 2
timestamp : 1125434010
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 254
menu-style : 2
qbe-match-op : 3
fulltext-optns : 0
char-menu : ADMIN-Schema-FormName
display-instance :
536870912\19\14\40\1\170\40\0\20\4\4\name\3\41\2\17325\5500\43312\7600\4\6\1\5\6\2\60\40\1\61\40\32\27\8\16\28\6\4\29\6\1\7\40\2147483652\231\6\1\143\40\4294&
display-instance :
967295\21\41\2\0\400\2925\2100\151\41\2\3487\0\23062\2100\65\41\2\23625\0\25987\2100\66\41\2\0\0\0\0\228\40\1\
}
field {
id : 536870918
name : nextfieldid
datatype : 2
fieldtype : 3
ext-field : nextfieldid
create-mode : 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\11\nextfieldid\3\41\2\14962\8000\25874\10100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483653\231\&
display-instance :
6\0\143\40\4294967295\21\41\2\0\400\5287\2100\151\41\2\5850\0\10912\2100\65\41\2\1125\0\1125\0\66\41\2\1125\0\1125\0\64\6\0\228\40\1\
}
field {
id : 536870919
name : nextid
datatype : 2
fieldtype : 3
ext-field : nextid
create-mode : 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\6\nextid\3\41\2\16425\15500\25875\17600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\9\27\8\16\28\6\4\29\6\1\7\40\2147483654\231\6\0\1&
display-instance :
43\40\4294967295\21\41\2\0\400\3150\2100\151\41\2\3262\0\9449\2100\65\41\2\450\0\450\0\66\41\2\450\0\450\0\64\6\0\228\40\1\
}
field {
id : 536870920
name : numfields
datatype : 2
fieldtype : 3
ext-field : numfields
create-mode : 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\9\numfields\3\41\2\2925\8000\13500\10100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483655\231\6\0\&
display-instance :
143\40\4294967295\21\41\2\0\400\4950\2100\151\41\2\5512\0\10574\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870921
name : numvuis
datatype : 2
fieldtype : 3
ext-field : numvuis
create-mode : 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\7\numvuis\3\41\2\33300\8000\43312\10100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483656\231\6\0\1&
display-instance :
43\40\4294967295\21\41\2\0\400\4387\2100\151\41\2\4950\0\10012\2100\65\41\2\7360537\0\7360537\0\66\41\2\7360537\0\7360537\0\64\6\0\228\40\1\
}
field {
id : 536870922
name : owner
datatype : 4
fieldtype : 3
ext-field : owner
create-mode : 2
option : 2
timestamp : 1070988415
owner : smcdonald
last-changed : smcdonald
maxlength : 30
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\5\owner\3\41\2\4612\10500\25874\12600\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483657\231\6\0\143\40\42&
display-instance :
94967295\21\41\2\0\400\3262\2100\151\41\2\3825\0\21262\2100\65\41\2\7370437\0\7370437\0\66\41\2\7370437\0\7370437\0\228\40\1\
}
field {
id : 536870923
name : schematype
datatype : 2
fieldtype : 3
ext-field : schematype
create-mode : 2
option : 2
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\10\schematype\3\41\2\45337\5500\55687\7600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\4\27\8\16\28\6\4\29\6\1\7\40\2147483658\231\6\&
display-instance :
0\143\40\4294967295\21\41\2\0\400\6412\2100\151\41\2\6975\0\10350\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870924
name : timestamp
datatype : 2
fieldtype : 3
ext-field : timestamp
create-mode : 2
option : 2
timestamp : 1144678429
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\9\timestamp\3\41\2\56587\18000\65812\20100\4\6\0\5\6\2\62\6\0\60\40\1\61\40\4\27\8\16\28\6\4\29\6\1\7\40\2147483659\231\6\&
display-instance :
0\143\40\4294967295\21\41\2\0\400\5287\2100\151\41\2\5850\0\9225\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870925
name : upgrdversion
datatype : 2
fieldtype : 3
ext-field : upgrdversion
create-mode : 2
option : 2
timestamp : 1070988416
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\12\upgrdversion\3\41\2\1012\18000\25874\20100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483660\23&
display-instance :
1\6\0\143\40\4294967295\21\41\2\0\400\6862\2100\151\41\2\7425\0\24862\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870926
name : Text
datatype : 31
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070382845
owner : smcdonald
last-changed : smcdonald
display-instance :
536870912\18\14\40\1\170\40\0\3\41\2\23625\1500\41062\4000\4\6\1\5\6\2\81\4\7\Header1\80\4\8\ARSchema\1\6\3\91\6\2\90\6\2\7\40\2147483661\143\40\4294967295\2&
display-instance :
1\41\2\8437\2000\25874\4500\151\41\2\8437\2000\25874\4500\65\41\2\0\0\0\0\66\41\2\0\0\0\0\83\4\8\ARSchema\40\41\0\\
}
field {
id : 536870927
name : Modified Date
datatype : 7
fieldtype : 3
ext-field : modified_date
create-mode : 2
option : 4
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
display-instance : 536870912\20\14\40\1\170\40\0\20\4\13\Modified
Date\3\41\2\30150\13000\58612\15100\4\6\1\5\6\2\60\40\1\61\40\29\27\8\16\28\6\4\29\6\1\7\40\2147483662\231\6\0&
display-instance :
\143\40\4294967295\21\41\2\0\400\7987\2100\151\41\2\8100\0\25537\2100\65\41\2\1237\0\1237\0\66\41\2\26100\0\28462\2100\240\40\0\228\40\1\
}
field {
id : 536870928
name : tblFields
datatype : 33
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1159312078
owner : smcdonald
last-changed : steve_mcdonald
tablefield-schema : ADMIN-Field.
tablefield-server : @
tablefield-query : 4\1\99\536870929\1\536870922\
tablefield-numcols: 6
tablefield-maxret : 0
display-instance :
536870912\26\227\6\1\5023\6\0\224\40\1\226\6\1\5001\6\0\14\40\1\5009\4\42\{2}
entries returned - {3} entries matched\5013\4\10\Select All\5014\4\12\DeSelect &
display-instance : All\5015\4\7\Refresh\5008\4\25\Table has Not been
Loaded\5016\4\6\Report\170\40\0\20\4\13\Schema
Fields\3\41\2\1125\22500\62662\68500\4\6\1\5\6\2\40\41\&
display-instance :
4\1125\22500\62662\22500\62662\68500\1125\68500\7\40\2147483663\143\40\4294967295\21\41\2\0\0\0\0\151\41\2\1125\22500\62662\33000\65\41\2\1125\22500\626&
display-instance : 62\33000\66\41\2\1125\22500\62662\33000\5003\6\2\5004\6\4\
}
field {
id : 536870929
name : int_schema_id
datatype : 2
fieldtype : 3
ext-field : Integer Field
create-mode : 2
option : 4
timestamp : 1125433071
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\22\14\40\1\170\40\0\20\4\13\int_schema_id\3\41\2\44550\8000\55687\10100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\4\27\8\16\28\6\4\29\6\1\7\40\2147483664\23&
display-instance :
1\6\0\143\40\4294967295\21\41\2\0\400\7650\2100\151\41\2\7762\0\11137\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\240\40\0\228\40\1\
}
field {
id : 536870930
name : Text2
datatype : 31
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548484
owner : smcdonald
last-changed : smcdonald
display-instance :
536870912\17\14\40\1\170\40\0\3\41\2\1125\21000\14062\22200\4\6\1\5\6\2\81\4\8\Required\80\4\21\Fields
for this Form:\1\6\3\91\6\2\90\6\2\7\40\2147483666\143&
display-instance :
\40\4294967295\21\41\1\15412\0\151\41\1\13162\49300\65\41\2\0\0\0\0\66\41\2\0\0\0\0\83\4\21\Fields
for this Form:\
}
field {
id : 536870933
name : Rows
datatype : 4
fieldtype : 3
ext-field : Character Field
create-mode : 2
option : 4
timestamp : 1070986804
owner : smcdonald
last-changed : smcdonald
maxlength : 10
menu-style : 1
qbe-match-op : 1
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\4\Rows\3\41\2\4950\15500\15187\17600\4\6\1\5\6\2\60\40\1\61\40\10\27\8\16\28\6\4\29\6\1\7\40\2147483668\231\6\0\143\40\429&
display-instance :
4967295\21\41\2\0\400\3375\2100\151\41\2\3487\0\10237\2100\65\41\2\-15187\0\-15187\0\66\41\2\-15187\0\-15187\0\228\40\1\
}
field {
id : 536880912
name : colCreateMode
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870913
colfield-collength: 254
colfield-datasrc : 0
display-instance : 536870912\4\20\4\10\createmode\4\6\1\220\40\10000\221\40\6\
}
field {
id : 536880913
name : colDataType
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870914
colfield-collength: 254
colfield-datasrc : 0
display-instance : 536870912\4\20\4\8\datatype\4\6\1\220\40\10000\221\40\4\
}
field {
id : 536880915
name : colFieldID
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870916
colfield-collength: 254
colfield-datasrc : 0
display-instance :
536870912\6\20\4\7\fieldid\4\6\1\220\40\10000\221\40\1\222\40\1\223\6\0\
}
field {
id : 536880916
name : colFieldName
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870917
colfield-collength: 254
colfield-datasrc : 0
display-instance : 536870912\4\20\4\9\fieldname\4\6\1\220\40\10000\221\40\2\
}
field {
id : 536880917
name : colFieldType
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870918
colfield-collength: 254
colfield-datasrc : 0
display-instance : 536870912\4\20\4\9\fieldtype\4\6\1\220\40\10000\221\40\3\
}
field {
id : 536880919
name : colLastChanged
datatype : 34
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1070548843
owner : smcdonald
last-changed : smcdonald
colfield-parent : 536870928
colfield-datafield: 536870920
colfield-collength: 254
colfield-datasrc : 0
display-instance : 536870912\4\20\4\11\lastchanged\4\6\1\220\40\10000\221\40\5\
}
end
begin schema
name : ADMIN-Field.
core-version : 2
upgrade-version: 0
num-fields : 13
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
default-vui : Default Admin View
num-vuis : 1
export-version : 8
schema-type : 3
ext-table : field
key-field : timestamp
next-field-id : 536870925
get-list-flds :
4\536870916\10\0\\536870917\25\0\\536870914\10\0\\536870918\10\0\
object-prop : 1\60018\4\0\\
archive : 0\0\0
arch-time : 0\0\0\0
arch-from :
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1159312348
vui-locale :
vui-type : 1
owner : smcdonald
last-changed : steve_mcdonald
display-prop : 7\20\4\18\Default Admin
View\60019\4\21\ViewWebAlias536870912\201\2\51412\202\2\49900\264\6\0\251\6\0\252\6\0\
}
field {
id : 1
name : timestamp
datatype : 4
fieldtype : 3
ext-field : timestamp
create-mode : 2
option : 3
timestamp : 1083938293
owner : smcdonald
last-changed : smcdonald
maxlength : 15
menu-style : 2
qbe-match-op : 1
fulltext-optns : 0
display-instance :
536870912\14\20\4\9\timestamp\3\41\2\7762\26000\32737\28400\7\40\2147483647\231\6\0\143\40\4294967295\170\40\0\21\41\2\0\400\6862\2400\151\41\2\7425\0\24975\&
display-instance :
2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\61\40\29\4\6\0\5\6\2\228\40\1\
}
field {
id : 536870913
name : createmode
datatype : 2
fieldtype : 3
ext-field : createmode
create-mode : 2
option : 2
timestamp : 1159312348
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\10\createmode\3\41\2\32512\13000\44437\15100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483648\231\&
display-instance :
6\0\143\40\4294967295\21\41\2\0\400\6300\2100\151\41\2\6862\0\11924\2100\65\41\2\7360425\0\7360425\0\66\41\2\7360425\0\7360425\0\64\6\0\228\40\1\
}
field {
id : 536870914
name : datatype
datatype : 2
fieldtype : 3
ext-field : datatype
create-mode : 2
option : 2
timestamp : 1159312348
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\8\datatype\3\41\2\34200\10500\44437\12600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483649\231\6\0&
display-instance :
\143\40\4294967295\21\41\2\0\400\4612\2100\151\41\2\5175\0\10237\2100\65\41\2\7360425\0\7360425\0\66\41\2\7360425\0\7360425\0\64\6\0\228\40\1\
}
field {
id : 536870915
name : defaultvalue
datatype : 4
fieldtype : 3
ext-field : defaultvalue
create-mode : 2
option : 2
timestamp : 1159312348
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 255
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\18\14\40\1\170\40\0\20\4\12\defaultvalue\3\41\2\787\20500\44437\22600\4\6\1\5\6\2\60\40\1\61\40\57\27\8\16\28\6\4\29\6\1\7\40\2147483650\231\6\0\14&
display-instance :
3\40\4294967295\21\41\2\0\400\6525\2100\151\41\2\7087\0\40724\2100\65\41\2\900\0\900\0\66\41\2\41287\0\43649\2100\
}
field {
id : 536870916
name : fieldid
datatype : 2
fieldtype : 3
ext-field : fieldid
create-mode : 2
option : 2
timestamp : 1083938286
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\7\fieldid\3\41\2\4275\8000\18000\10100\4\6\1\5\6\2\62\6\0\60\40\1\61\40\16\27\8\16\28\6\4\29\6\1\7\40\2147483651\231\6\0\1&
display-instance :
43\40\4294967295\21\41\2\0\400\3037\2100\151\41\2\3600\0\13725\2100\65\41\2\7368412\0\7368412\0\66\41\2\7368412\0\7368412\0\64\6\0\228\40\1\
}
field {
id : 536870917
name : fieldname
datatype : 4
fieldtype : 3
ext-field : fieldname
create-mode : 2
option : 2
timestamp : 1159312348
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 254
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\9\fieldname\3\41\2\19687\8000\44437\10100\4\6\1\5\6\2\60\40\1\61\40\32\27\8\16\28\6\4\29\6\1\7\40\2147483652\231\6\1\143\4&
display-instance :
0\4294967295\21\41\2\0\400\5062\2100\151\41\2\5625\0\24750\2100\65\41\2\7372350\0\7372350\0\66\41\2\0\0\0\0\228\40\1\
}
field {
id : 536870918
name : fieldtype
datatype : 2
fieldtype : 3
ext-field : fieldtype
create-mode : 2
option : 2
timestamp : 1083938288
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\9\fieldtype\3\41\2\14175\10500\24187\12600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483653\231\6\&
display-instance :
0\143\40\4294967295\21\41\2\0\400\4387\2100\151\41\2\4950\0\10012\2100\65\41\2\7360425\0\7360425\0\66\41\2\7360425\0\7360425\0\64\6\0\228\40\1\
}
field {
id : 536870919
name : foption
datatype : 2
fieldtype : 3
ext-field : foption
create-mode : 2
option : 2
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\7\foption\3\41\2\35212\15500\44437\17600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483654\231\6\0\&
display-instance :
143\40\4294967295\21\41\2\0\400\3600\2100\151\41\2\4162\0\9224\2100\65\41\2\7370100\0\7370100\0\66\41\2\7370100\0\7370100\0\64\6\0\228\40\1\
}
field {
id : 536870920
name : lastchanged
datatype : 4
fieldtype : 3
ext-field : lastchanged
create-mode : 2
option : 2
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 30
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\11\lastchanged\3\41\2\787\15500\24187\17600\4\6\1\5\6\2\60\40\1\61\40\27\27\8\16\28\6\4\29\6\1\7\40\2147483655\231\6\0\143&
display-instance :
\40\4294967295\21\41\2\0\400\6525\2100\151\41\2\7087\0\23399\2100\65\41\2\337\0\337\0\66\41\2\337\0\337\0\228\40\1\
}
field {
id : 536870921
name : owner
datatype : 4
fieldtype : 3
ext-field : owner
create-mode : 2
option : 2
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
maxlength : 30
menu-style : 1
qbe-match-op : 3
fulltext-optns : 0
display-instance :
536870912\19\14\40\1\170\40\0\20\4\5\owner\3\41\2\4050\13000\24187\15100\4\6\1\5\6\2\60\40\1\61\40\27\27\8\16\28\6\4\29\6\1\7\40\2147483656\231\6\0\143\40\42&
display-instance :
94967295\21\41\2\0\400\3262\2100\151\41\2\3825\0\20137\2100\65\41\2\7370550\0\7370550\0\66\41\2\7370550\0\7370550\0\228\40\1\
}
field {
id : 536870922
name : schemaid
datatype : 2
fieldtype : 3
ext-field : schemaid
create-mode : 2
option : 2
timestamp : 1083938293
owner : smcdonald
last-changed : smcdonald
range-low : -2147483647
range-high : 2147483647
display-instance :
536870912\21\14\40\1\170\40\0\20\4\8\schemaid\3\41\2\2250\10500\12937\12600\4\6\1\5\6\2\62\6\0\60\40\1\61\40\7\27\8\16\28\6\4\29\6\1\7\40\2147483657\231\6\0\&
display-instance :
143\40\4294967295\21\41\2\0\400\5062\2100\151\41\2\5625\0\10687\2100\65\41\2\0\0\0\0\66\41\2\0\0\0\0\64\6\0\228\40\1\
}
field {
id : 536870923
name : Text
datatype : 31
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
display-instance :
536870912\17\14\40\1\170\40\0\3\41\2\9000\2000\43312\6000\4\6\1\5\6\2\81\4\7\Header1\80\4\5\Field\1\6\3\91\6\2\90\6\2\7\40\2147483658\143\40\4294967295\21\41&
display-instance :
\2\9000\0\32512\4000\151\41\2\9000\2000\34312\6000\65\41\2\0\0\0\0\66\41\2\0\0\0\0\83\4\5\Field\
}
field {
id : 536870924
name : modified date
datatype : 7
fieldtype : 3
ext-field : modified_date
create-mode : 2
option : 4
timestamp : 1159312349
owner : smcdonald
last-changed : steve_mcdonald
display-instance : 536870912\19\14\40\1\170\40\0\20\4\13\modified
date\3\41\2\675\18000\44437\20100\4\6\1\5\6\2\60\40\1\61\40\57\27\8\16\28\6\4\29\6\1\7\40\2147483659\231\6\0\1&
display-instance :
43\40\4294967295\21\41\2\0\400\7087\2100\151\41\2\7200\0\40837\2100\65\41\2\0\0\0\0\66\41\2\41400\0\43762\2100\228\40\1\
}
end
begin active link
name : ADMIN-Field-FillModifiedDate
timestamp : 1070386895
export-version : 8
owner : smcdonald
last-changed : smcdonald
actlink-order : 0
wk-conn-type : 1
schema-name : ADMIN-Field.
actlink-mask : 278544
enable : 1
actlink-query : 4\6\1\1\2\0\
action {
set-field : 0\536870924\102\1\*\1\*\1\1\0\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
begin active link
name : ADMIN-Schema-FillModifiedDate
timestamp : 1070548075
export-version : 8
owner : smcdonald
last-changed : smcdonald
actlink-order : 0
wk-conn-type : 1
schema-name : ADMIN-ARSchema.
actlink-mask : 278544
enable : 1
actlink-query : 4\6\1\536870924\2\0\
action {
set-field : 0\536870929\102\1\*\1\*\1\1\0\1\4\
set-field : 1\536870927\102\1\*\1\*\1\536870924\0\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
begin active link
name : ADMIN-Schema-FillRows
timestamp : 1070983930
export-version : 8
owner : smcdonald
last-changed : smcdonald
actlink-order : 0
wk-conn-type : 1
schema-name : ADMIN-ARSchema.
actlink-mask : 278544
enable : 1
actlink-query : 4\6\1\1\2\0\
action {
set-field : [EMAIL PROTECTED] count(*) from t$1$\1\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
begin active link
name : ADMIN-Schema-GetInfo
timestamp : 1125433149
export-version : 8
owner : smcdonald
last-changed : steve_mcdonald
actlink-order : 0
wk-conn-type : 1
schema-name : ADMIN-ARSchema.
actlink-mask : 278544
enable : 1
actlink-query : 4\6\1\536870924\2\0\
action {
set-field : 0\536870929\102\1\*\1\*\1\1\0\1\4\
set-field : 1\536870927\102\1\*\1\*\1\536870924\0\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
begin active link
name : ADMIN-Schema-SetFieldID
timestamp : 1070986872
export-version : 8
owner : smcdonald
last-changed : smcdonald
actlink-order : 0
wk-conn-type : 1
schema-name : ADMIN-ARSchema.
actlink-mask : 128
actlink-focus : 536870928
enable : 1
actlink-query : 1\4\6\1\1\2\0\4\6\1\536880915\2\0\
action {
set-field : 0\536870934\102\1\*\1\*\1\536880915\0\1\4\
}
object-prop : 2\60016\4\1\0\60017\4\1\0\
end
begin char menu
name : ADMIN-Schema-FormName
timestamp : 1125433017
owner : steve_mcdonald
last-changed : steve_mcdonald
refresh-code : 1
char-menu : [EMAIL PROTECTED] name from arschema order by name
end
