loan

Table info.

Title Loan
Description Loan

Fields

Name Type Required Index Hidden On form Title Pick list Description
LoanID 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
CurrentDueDate date MUL Current due date Date the loan is due to be returned
DateClosed date Loan closed The date that the loan is completed
DateReceived date Acknowledged The date the receipt of the loan was acknowledged by the borrowing institution (as indicated on the yellow loan form)
IsClosed bit(1) Closed Indicates that the loan is closed
IsFinancialResponsibility bit(1) Extension granted Indicates that an extension was granted
LoanDate date MUL Date requested The date the loan was requested
LoanNumber varchar(50) MUL Loan number The number assigned to the loan
Number1 float(20,10) Quantity on loan The number of specimens currently on loan
Number2 float(20,10) Number2 User definable.
OriginalDueDate date Original due date The date the loan was originally due to be returned
OverdueNotiSetDate date
PurposeOfLoan varchar(64) Project LoanProject
  • Flora of Australia Project
 The project that the loan was requested for
ReceivedComments varchar(255) Received comments Comments on the state of the loan upon receipt at the borrowing institution (i.e. any general comments recorded on the yellow loan acknowledgement form). Comments about particular specimens should be listed in the Loan preparations form.
Remarks text Returned comments A general description of the condition of the loan upon return. Any comments about the condition of a particular specimen should be listed in the Loan return preparations table.
SpecialConditions text Conditions Any special conditions of loan (e.g. destructive sampling permitted, photography permitted)
SrcGeography varchar(500) Loan status LoanStatus
  • Awaiting acknowledgement
  • Complete
  • Current
  • Not serviced
  • Written off
  • Under consideration
  • Approved
 The status of the loan
SrcTaxonomy varchar(500) Transfer loan no. The number of the loan that all or part of the loan was transferred to
Text1 text Description A description of the loan, and any other comments. Enter two pipe symbols (||) to separate the original loan description from comments that are added later
Text2 text Loan notice LoanNotice
  • Acknowledgement request
  • Extension
  • Overdue
  • Recall
  • Reminder
 The type of loan notice that was most recently sent
YesNo1 bit(1) Destructive sampling permitted Indicates that destructive sampling has been permitted
YesNo2 bit(1) Quarantined Indicates that all or part of the loan was quarantined
DisciplineID int(11) MUL
DivisionID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
AddressOfRecordID int(11) MUL
Contents text Contents contents
Integer1 int(11) Integer1 integer1
Integer2 int(11) Integer2 integer2
Integer3 int(11) Integer3 integer3

Indexes

Name Fields Unique Nullable
CurrentDueDateIDX CurrentDueDate
FK32C4F04CE675DE DisciplineID
FK32C4F05327F942 ModifiedByAgentID
FK32C4F07699B003 CreatedByAgentID
FK32C4F097C961D8 DivisionID
FK32C4F0DC8B4810 AddressOfRecordID
LoanDateIDX LoanDate
LoanNumberIDX LoanNumber
PRIMARY LoanID

One-to-many relationships

Name Field Related table Related field
FK63FA1415A16D4F1E LoanID loanagent LoanID
FK23ECB213A16D4F1E LoanID loanattachment LoanID
FK374DEBA7A16D4F1E LoanID loanpreparation LoanID
FKE139719AA16D4F1E LoanID shipment LoanID

Many-to-one relationships

Name Field Related table Related field
FK32C4F04CE675DE DisciplineID discipline UserGroupScopeId
FK32C4F05327F942 ModifiedByAgentID agent AgentID
FK32C4F07699B003 CreatedByAgentID agent AgentID
FK32C4F097C961D8 DivisionID division UserGroupScopeId
FK32C4F0DC8B4810 AddressOfRecordID addressofrecord AddressOfRecordID