Specify schema

Title	Accession
Description	Accession

Name	Fields	Unique	Nullable
AccessionDateIDX	DateAccessioned
AccessionNumberIDX	AccessionNumber
FK81EF38243EBC6278	RepositoryAgreementID
FK81EF38245327F942	ModifiedByAgentID
FK81EF38247699B003	CreatedByAgentID
FK81EF382497C961D8	DivisionID
FK81EF3824DC8B4810	AddressOfRecordID
PRIMARY	AccessionID

Name	Field	Related table	Related field
FK2DC981613925EE20	AccessionID	accessionagent	AccessionID
FKA569B4473925EE20	AccessionID	accessionattachment	AccessionID
FK4F2602D53925EE20	AccessionID	accessionauthorization	AccessionID
FK9ED8DF0B3925EE20	AccessionID	accessioncitation	AccessionID
FK8D3C72E53925EE20	AccessionID	appraisal	AccessionID
FKC1D4635D3925EE20	AccessionID	collectionobject	AccessionID
FKC3EACC33925EE20	AccessionID	deaccession	AccessionID
FK577D85223925EE20	AccessionID	treatmentevent	AccessionID

Name	Field	Related table	Related field
FK81EF38243EBC6278	RepositoryAgreementID	repositoryagreement	RepositoryAgreementID
FK81EF38245327F942	ModifiedByAgentID	agent	AgentID
FK81EF38247699B003	CreatedByAgentID	agent	AgentID
FK81EF382497C961D8	DivisionID	division	UserGroupScopeId
FK81EF3824DC8B4810	AddressOfRecordID	addressofrecord	AddressOfRecordID

View: Accession (Common)

<view name="Accession"
      class="edu.ku.brc.specify.datamodel.Accession"
      busrules="edu.ku.brc.specify.datamodel.busrules.AccessionBusRules">
    <desc><![CDATA[The Accession form.]]></desc>
    <altviews>
        <altview name="Accession View" viewdef="Accession" mode="view" default="true"/>
        <altview name="Accession Edit" viewdef="Accession" mode="edit"/>
    </altviews>
</view>

View def.: Accession

<viewdef type="form"
      name="Accession"
      class="edu.ku.brc.specify.datamodel.Accession"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The Accession form.]]></desc>
    <enableRules/>
 
    <columnDef>p,0px,190px,5px,130px,2px,141px,5px,110px,2px,140px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,200px,5px,135px,2px,153px,5px,125px,2px,153px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,220px,5px,153px,2px,189px,5px,133px,2px,189px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="1px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="accessionNumber" uitype="formattedtext"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="type" uitype="combobox"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="status" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" id="divLabel" label=" " initialize="align=right"/>
            <cell type="field" id="4" name="divisionCBX" uitype="combobox" ignore="true"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="dateAccessioned" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="dateReceived" uitype="formattedtext" uifieldformatter="Date" default="today"/>
        </row>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
            <cell type="subview" viewname="AccessionAgent" id="8" name="accessionAgents" desc="Agents" colspan="13" rows="3"/>
        </row>
        <row>
            <cell type="subview" viewname="AccessionAuthorization" id="9" desc="Authorization" name="accessionAuthorizations" colspan="13"/>
        </row>
        <row> 
            <cell type="subview" viewname="AccessionItems" id="25" desc="Collection Object" name="collectionObjects" colspan="13" rows="2" initialize="addsearch=true"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="13"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="accessionAttachments" colspan="13" initialize="addsearch=true;btn=true;icon=AccessionAttachment;hc=xxx"/>
        </row>
        <row>
            <cell type="separator" label="" colspan="13"/>
        </row>
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
        </row>
        <!-- <row>
            <cell type="label" labelfor="99"/>
            <cell type="field" id="99" name="this" uitype="plugin" initialize="name=WebLinkButton;weblink=AccessionNumber"/>
        </row>               
        <row>
            <cell type="label" labelfor="26"/>
            <cell type="field" id="26" name="dateAcknowledged" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="27"/>
            <cell type="field" id="27" name="verbatimDate" uitype="text"/>
        	<cell type="label" labelfor="tv"/>
        	<cell type="field" id="tv" name="totalValue" uitype="text"/>
        </row>
        <row>
        	<cell type="label" labelfor="29"/>
        	<cell type="field" id="29" name="number1" uitype="text"/>
        	<cell type="label" labelfor="30"/>
        	<cell type="field" id="30" name="number2" uitype="text"/>
        </row> 
        <row>
        	<cell type="field" id="34" uitype="checkbox" name="yesNo1" label="yesNo1"/>                	
        	<cell type="field" id="35" uitype="checkbox" name="yesNo2" label="yesNo2"/>
        </row>
        <row>
        	<cell type="label" labelfor="31"/>
        	<cell type="field" id="31" name="text1" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
        	<cell type="label" labelfor="32"/>
        	<cell type="field" id="32" name="text2" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
        	<cell type="label" labelfor="33"/>
        	<cell type="field" id="33" name="text3" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
    		      	<row>
    				      <cell type="label" labelfor="28"/>
    			       	<cell type="field" id="28" name="accessionCondition" uitype="textareabrief" rows="2" colspan="10"/>
    		      	</row>
        <row>
            <cell type="subview" id="ra" name="repositoryAgreement" viewname="RepositoryAgreement" colspan="10"/>
        </row>
        <row>
            <cell type="subview" id="6" name="addressOfRecord" viewname="AddressOfRecord" colspan="10"/>
        </row>
        <row>
            <cell type="subview" viewname="Appraisal" id="15" name="appraisals" colspan="12"/>
        </row>
        <row>
            <cell type="subview" viewname="TreatmentEventForAccession" id="13" name="treatmentEvents" colspan="12" initialize="btn=true"/>
        </row> -->
    </rows>
</viewdef>

View: AccessionCO (Common)

<view name="AccessionCO"
      class="edu.ku.brc.specify.datamodel.Accession"
      busrules="edu.ku.brc.specify.datamodel.busrules.AccessionBusRules">
    <desc><![CDATA[The Accession form as seen in the CO form.]]></desc>
    <altviews>
        <altview name="AccessionCO View" viewdef="AccessionCO" mode="view" default="true"/>
        <altview name="AccessionCO Edit" viewdef="AccessionCO" mode="edit"/>
    </altviews>
</view>

View def.: AccessionCO

<viewdef type="form"
      name="AccessionCO"
      class="edu.ku.brc.specify.datamodel.Accession"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The Accession form.]]></desc>
    <enableRules/>
 
    <columnDef>p,0px,190px,5px,130px,2px,141px,5px,110px,2px,140px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,200px,5px,135px,2px,156px,5px,125px,2px,150px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,220px,5px,153px,2px,189px,5px,133px,2px,189px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,0px,p:g,5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="1px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="accessionNumber" uitype="formattedtext"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="type" uitype="combobox"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="status" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" id="divLabel" label=" " initialize="align=right"/>
            <cell type="field" id="4" name="divisionCBX" uitype="combobox" ignore="true"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="dateAccessioned" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="dateReceived" uitype="formattedtext" uifieldformatter="Date" default="today"/>
        </row>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
            <cell type="subview" viewname="AccessionAgent" id="8" name="accessionAgents" desc="Agents" colspan="13"/>
        </row>
        <row>
            <cell type="subview" viewname="AccessionAuthorization" id="9" desc="Authorization" name="accessionAuthorizations" colspan="13"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="13"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="accessionAttachments" colspan="13" initialize="addsearch=true;btn=true;icon=AccessionAttachment;hc=xxx"/>
        </row>
        <row>
            <cell type="separator" label="" colspan="13"/>
        </row>
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
        </row>
    </rows>
</viewdef>

Name	Type	Index	Title	Pick list	Description
AccessionID	int(11)	PRI
TimestampCreated	datetime		Created		The date the record was created.
TimestampModified	datetime		Last edited		The timestamp the record was last edited.
Version	int(11)		Version		version
AccessionCondition	varchar(255)		Accession Condition		Physical description of the condition of the accession.
AccessionNumber	varchar(60)	MUL	Accession number		An auto-incremented identifier for the accession. The number sequence resets each year. the Accession number is prefaced by 'ACC-' so it can be easily differentiated from a Repository agreement number.
DateAccessioned	date	MUL	Accession opened		The date that the first specimens in the accession were received at the herbarium or, if that date is unknown, the date that the accession record was created.
DateAcknowledged	date		Date Acknowledged		dateAcknowledged
DateReceived	date		Date Received		Date material was received.
Number1	float(20,10)		Number1		A user-visible identifier of the Accession. Typically an integer, but may include alphanumeric characters as prefix, suffix, and separators.
Number2	float(20,10)		Number2		User definable.
Remarks	text		Comments		Any additional comments about the accession.
Status	varchar(32)		Status	AccessionStatus Complete Open	The status of the accession ('Open' or 'Complete').
Text1	text		Permit status	PermitStatus Permit on file Not collected under permit Permit not supplied (status unknown) Permission obtained but not documented Permit forthcoming Permit not required Collected before 12 Oct 2014, permit status not assessed	This field is used to indicate what type of authorisation (or lack of) the collection objects in the accession were collected under.
Text2	text		Exchange in no.		The Exchange in number for ‘Exchange in’ accessions. More than one accession record can (and probably will) link to the same Exchange in record.
Text3	text		Permit qualifier		Information about the scope and applicability of the permit, or why a permit was not required or obtained.
TotalValue	decimal(12,2)		Total Value		The total monetary value of the accession.
Type	varchar(32)		Type	AccessionType Exchange Donation RBGV collection	The type of accession ('Donation', 'Exchange' or 'RBGV collection').
VerbatimDate	varchar(50)		Verbatim Date		Accommodates historical accessions.
YesNo1	bit(1)		Yes No1		User definable.
YesNo2	bit(1)		Yes No2		User definable.
DivisionID	int(11)	MUL
ModifiedByAgentID	int(11)	MUL
CreatedByAgentID	int(11)	MUL
AddressOfRecordID	int(11)	MUL
RepositoryAgreementID	int(11)	MUL
Integer1	int(11)		Integer1		integer1
Integer2	int(11)		Integer2		integer2
Integer3	int(11)		Integer3		integer3
Text4	text		Text4		text4
Text5	text		Text5		text5

MEL Specify schema browser

accession

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: Accession (Common)

View def.: Accession

View: AccessionCO (Common)

View def.: AccessionCO