accessionagent

Table info.

Title Accession Agent
Description Accession Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
AccessionAgentID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
Remarks text Remarks Additional Comments.
Role varchar(50) MUL Role AccessionRole
  • Reviewer
  • Collector
  • Receiver
  • Permit holder
 The role of the agent in the accession. Note that 'Collector' and 'Permit holder' can be used for Accession records, and 'Collector', 'Receiver' and 'Reviewer' can be used for Repostiroy agreement records.
RepositoryAgreementID int(11) MUL
ModifiedByAgentID int(11) MUL
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
AccessionID int(11) MUL

Indexes

Name Fields Unique Nullable
FK2DC98161384B3622 AgentID
FK2DC981613925EE20 AccessionID
FK2DC981613EBC6278 RepositoryAgreementID
FK2DC981615327F942 ModifiedByAgentID
FK2DC981617699B003 CreatedByAgentID
PRIMARY AccessionAgentID
Role Role, AgentID, AccessionID

Many-to-one relationships

Name Field Related table Related field
FK2DC98161384B3622 AgentID agent AgentID
FK2DC981613925EE20 AccessionID accession AccessionID
FK2DC981613EBC6278 RepositoryAgreementID repositoryagreement RepositoryAgreementID
FK2DC981615327F942 ModifiedByAgentID agent AgentID
FK2DC981617699B003 CreatedByAgentID agent AgentID

View: AccessionAgent (Common)

<view name="AccessionAgent"
      objtitle="Accession
      Agent"
      class="edu.ku.brc.specify.datamodel.AccessionAgent"
      busrules="edu.ku.brc.specify.datamodel.busrules.AccessionAgentBusRules">
    <desc><![CDATA[Subform within the Accession form.]]></desc>
    <altviews>
        <altview name="AccessionAgent View" viewdef="AccessionAgent" mode="view"/>
        <altview name="AccessionAgent Edit" viewdef="AccessionAgent" mode="edit" default="true"/>
        <altview name="AccessionAgent Table View" viewdef="AccessionAgent Table" mode="view"/>
        <altview name="AccessionAgent Table Edit" viewdef="AccessionAgent Table" mode="edit"/>
    </altviews>
</view>

View def.: AccessionAgent

<viewdef type="form"
      name="AccessionAgent"
      class="edu.ku.brc.specify.datamodel.AccessionAgent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The Accession form.]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,210px,5px,110px,2px,155px,243px,p:g</columnDef>
    <columnDef os="lnx">135px,2px,230px,5px,98px,2px,155px,290px,p:g</columnDef>
    <columnDef os="mac">130px,2px,215px,5px,153px,2px,189px,336px,p:g</columnDef>
    <columnDef os="exp">p,2px,p,5px,85px,2px,p:g(2),p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="agent" uitype="querycbx" initialize="name=Agent;title=Agent"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="role" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="remarks" uitype="textareabrief" rows="2" colspan="6"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>
 

View: AgreementAgent (Common)

<view name="AgreementAgent"
      objtitle="Agreement
      Agent"
      class="edu.ku.brc.specify.datamodel.AccessionAgent">
    <desc><![CDATA[Subform within the Accession form.]]></desc>
    <altviews>
        <altview name="AgreementAgent View" viewdef="AgreementAgent" mode="view"/>
        <altview name="AgreementAgent Edit" viewdef="AgreementAgent" mode="edit" default="true"/>
    </altviews>
</view>

View def.: AgreementAgent

<viewdef type="form"
      name="AgreementAgent"
      class="edu.ku.brc.specify.datamodel.AccessionAgent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The RA agent]]></desc>
    <enableRules/>
 
    <columnDef>105px,2px,205px,5px,43px,2px,151px,329px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,210px,5px,63px,2px,166px,354px,p:g</columnDef>
    <columnDef os="mac">130px,2px,275px,5px,71px,2px,215px,332px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px:g,p,2px,p:g(2),p:g(6)</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="agent" uitype="querycbx" initialize="name=Agent;title=Agent"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="role" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="remarks" uitype="textareabrief" rows="2" colspan="6"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>