| Title | Loan Preparation |
|---|---|
| Description | Loan Preparation |
| Name | Type | Required | Index | Hidden | On form | Title | Pick list | Description |
|---|---|---|---|---|---|---|---|---|
| LoanPreparationID | int(11) | PRI | ||||||
| TimestampCreated | datetime | Created | The timestamp the record was created. | |||||
| TimestampModified | datetime | Last edited | The timestamp the record was last modified. | |||||
| Version | int(11) | Version | version | |||||
| DescriptionOfMaterial | text | Status | LoanPrepStatus
|
The status of the preparation, if it has not been returned, but has been resolved (transferred, lost, destroyed or written off) | ||||
| InComments | text | Incoming comments | MEL comments about preparations when they are returned from loan, e.g. damage to specimen, sampling undertaken | |||||
| IsResolved | bit(1) | Is resolved | To indicate that a preparation is resolved (returned, destroyed, lost etc.) | |||||
| OutComments | text | Outgoing comments | MEL comments about preparations when they are sent on loan, e.g. condition of specimen, permission for destructive sampling | |||||
| Quantity | int(11) | Quantity | The total number of specimens loaned (necessary for lots). | |||||
| QuantityResolved | int(11) | Quantity resolved | Number of specimens returned, deaccessioned or otherwise accounted for (necessary for lots) | |||||
| QuantityReturned | int(11) | Quantity returned | Number of specimens returned (necessary for lots) | |||||
| ReceivedComments | text | Borrower's comments | Any comments that the borrower has made about the preparation | |||||
| ModifiedByAgentID | int(11) | MUL | ||||||
| PreparationID | int(11) | MUL | ||||||
| LoanID | int(11) | MUL | ||||||
| CreatedByAgentID | int(11) | MUL | ||||||
| DisciplineID | int(11) | MUL |
| Name | Fields | Unique | Nullable |
|---|---|---|---|
| FK374DEBA718627F06 | PreparationID | ||
| FK374DEBA74CE675DE | DisciplineID | ||
| FK374DEBA75327F942 | ModifiedByAgentID | ||
| FK374DEBA77699B003 | CreatedByAgentID | ||
| FK374DEBA7A16D4F1E | LoanID | ||
| LoanPrepDspMemIDX | DisciplineID | ||
| PRIMARY | LoanPreparationID |
| Name | Field | Related table | Related field |
|---|---|---|---|
| FK36328477CD552686 | LoanPreparationID | loanreturnpreparation | LoanPreparationID |
| Name | Field | Related table | Related field |
|---|---|---|---|
| FK374DEBA718627F06 | PreparationID | preparation | PreparationID |
| FK374DEBA74CE675DE | DisciplineID | discipline | UserGroupScopeId |
| FK374DEBA75327F942 | ModifiedByAgentID | agent | AgentID |
| FK374DEBA77699B003 | CreatedByAgentID | agent | AgentID |
| FK374DEBA7A16D4F1E | LoanID | loan | LoanID |