deaccession

Table info.

Title Deaccession
Description Deaccession

Fields

Name Type Required Index Hidden On form Title Pick list Description
DeaccessionID 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
DeaccessionDate date MUL Deaccession Date deaccessionDate
DeaccessionNumber varchar(50) MUL Deaccession Number Name institution assigns to the deaccession
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
Remarks text Remarks Additional Comments
Text1 text Text1 User definable
Text2 text Text2 User definable
Type varchar(64) Type Description of the Type of deaccession; i.e. Gift, disposal, lost
YesNo1 bit(1) Yes No1 User definable
YesNo2 bit(1) Yes No2 User definable
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AccessionID int(11) MUL

Indexes

Name Fields Unique Nullable
DeaccessionDateIDX DeaccessionDate
DeaccessionNumberIDX DeaccessionNumber
FKC3EACC33925EE20 AccessionID
FKC3EACC35327F942 ModifiedByAgentID
FKC3EACC37699B003 CreatedByAgentID
PRIMARY DeaccessionID

One-to-many relationships

Name Field Related table Related field
FKBE551822BE26B05E DeaccessionID deaccessionagent DeaccessionID
FK6A06F1F4BE26B05E DeaccessionID deaccessionpreparation DeaccessionID

Many-to-one relationships

Name Field Related table Related field
FKC3EACC33925EE20 AccessionID accession AccessionID
FKC3EACC35327F942 ModifiedByAgentID agent AgentID
FKC3EACC37699B003 CreatedByAgentID agent AgentID

View: Deaccession (Common)

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

View def.: Deaccession

<viewdef type="form"
      name="Deaccession"
      class="edu.ku.brc.specify.datamodel.Deaccession"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The Deaccession form.]]></desc>
    <enableRules/>
 
    <columnDef>p,2px,p,80px,p,2px,p,40px,p,2px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="deaccessionNumber" uitype="formattedtext" uifieldformatter="DeaccessionNumber"/>                                  
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="deaccessionDate" uitype="formattedtext" uifieldformatter="Date" default="today"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="accession" uitype="querycbx" initialize="name=AccessionCO;title=Accession;newbtn=false;editbtn=false"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="type" uitype="combobox" picklist="DeaccessionType"/>
        </row>
        <row>
            <cell type="iconview" viewname="DeaccessionAgent" id="8" name="deaccessionAgents" desc="Agents" colspan="12"/>
        </row> 
        <!--   <row>
            <cell type="subview" viewname="DeaccessionPreparation" id="4" name="deaccessionPreparations" colspan="12"/>
            </row> --> 
        <row>
            <cell type="separator" label="" colspan="12"/>
        </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" colspan="2"/>
        </row>
    </rows>
</viewdef>