repositoryagreement

Table info.

Title Repository Agreement
Description Repository Agreement

Fields

Name Type Required Index Hidden On form Title Pick list Description
RepositoryAgreementID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last edited.
Version int(11) Version version
DateReceived date RA date The date the repository agreement was signed.
EndDate date End Date endDate
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
Remarks text Comments Any additional comments relating to the repository agreement.
RepositoryAgreementNumber varchar(60) MUL RA Number repositoryAgreementNumber
StartDate date MUL Date received Date specimens were received
Status varchar(32) Status AccessionStatus
  • Complete
  • Open
 status
Text1 varchar(255) Quantity The number of specimens received
Text2 varchar(255) File name The file name for the electronic data for the specimens in the consignment
Text3 varchar(255) Taxa included Taxa included in the donation
YesNo1 bit(1) Data uploaded Indicates if data provided for the donation has been uploaded
YesNo2 bit(1) Yes No2 User definable
DivisionID int(11) MUL
ModifiedByAgentID int(11) MUL
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
AddressOfRecordID int(11) MUL

Indexes

Name Fields Unique Nullable
FKA5A38A00384B3622 AgentID
FKA5A38A005327F942 ModifiedByAgentID
FKA5A38A007699B003 CreatedByAgentID
FKA5A38A0097C961D8 DivisionID
FKA5A38A00DC8B4810 AddressOfRecordID
PRIMARY RepositoryAgreementID
RefWrkNumberIDX RepositoryAgreementNumber
RefWrkStartDate StartDate

One-to-many relationships

Name Field Related table Related field
FK81EF38243EBC6278 RepositoryAgreementID accession RepositoryAgreementID
FK2DC981613EBC6278 RepositoryAgreementID accessionagent RepositoryAgreementID
FK4F2602D53EBC6278 RepositoryAgreementID accessionauthorization RepositoryAgreementID
FK93663233EBC6278 RepositoryAgreementID repositoryagreementattachment RepositoryAgreementID

Many-to-one relationships

Name Field Related table Related field
FKA5A38A00384B3622 AgentID agent AgentID
FKA5A38A005327F942 ModifiedByAgentID agent AgentID
FKA5A38A007699B003 CreatedByAgentID agent AgentID
FKA5A38A0097C961D8 DivisionID division UserGroupScopeId
FKA5A38A00DC8B4810 AddressOfRecordID addressofrecord AddressOfRecordID

View: RepositoryAgreement (Common)

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

View def.: RepositoryAgreement

<viewdef type="form"
      name="RepositoryAgreement"
      class="edu.ku.brc.specify.datamodel.RepositoryAgreement"
      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,150px,5px,100px,2px,151px,5px,110px,2px,200px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,168px,5px,105px,2px,168px,5px,135px,2px,210px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,201px,5px,110px,2px,200px,5px,140px,2px,235px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g,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="repositoryAgreementNumber" uitype="text"/> 
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="status" uitype="combobox" picklist="AccessionStatus"/>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="originator" uitype="querycbx" initialize="name=Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="endDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="dateReceived" uitype="formattedtext" uifieldformatter="Date"/>
        </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" id="8" viewname="AgreementAgent" name="repositoryAgreementAgents" colspan="13"/>
        </row>
        <row>
            <cell type="subview" id="9" viewname="AgreementAuthorization" name="repositoryAgreementAuthorizations" colspan="13"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="13"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="repositoryAgreementAttachments" colspan="13" initialize="addsearch=true;btn=true;icon=RepositoryAgreementAttachment;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" colspan="3"/>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
        </row>
        <!--<row>
            <cell type="subview" id="6" name="addressOfRecord" viewname="AddressOfRecord" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="n1"/>
            <cell type="field" id="n1" name="number1" uitype="text"/>
            <cell type="label" labelfor="n2"/>
            <cell type="field" id="n2" name="number2" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t1"/>
            <cell type="field" id="t1" name="text1" uitype="text"/>
            <cell type="label" labelfor="t2"/>
            <cell type="field" id="t2" name="text2" uitype="text"/>
            <cell type="label" labelfor="t3"/>
            <cell type="field" id="t3" name="text3" uitype="text"/>
        </row>
        <row>
            <cell type="field" id="20" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="20" name="yesNo2" uitype="checkbox" initialize="editable=true"/>
        </row>
        <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true" uifieldformatter="Agent"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>