AssetInvOwner (ver21.4.0)
This table stores the ownership details for the inventory item defined in the AssetInv table. A foreign key for AssetInvId (mapped to the id of the AssetInv table) is in place for data integrity.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| AssetInvId | 21.4.0 | NUMBER(19,0) | The primary key of AssetInv table. FK has been created which maps to ASSETINV.ID. Required. Indexed. |
| CheckinDate | 21.4.0 | DATE | Date for which check-in or return of item recorded. Null during check out and not null after return. |
| CheckoutDate | 21.4.0 | DATE | Date for which check out or assignment of item recorded. Null during check-in and not null after check out. |
| ConditionIn | 21.4.0 | NUMBER(19,0) | CodesetId of the condition of the inventory item when returned. Null during checkout and not null after check-in. Required for check-in. |
| ConditionOut | 21.4.0 | NUMBER(19,0) | CodesetId of the condition of the inventory item when assigned. Required. |
| ExtrasIn | 21.4.0 | NUMBER(1,0) | Indicate if the inventory item has extras during check-in of asset-type equipment. Valid values: 1=includes Extras, 0=no Extras. |
| ExtrasOut | 21.4.0 | NUMBER(1,0) | Indicate if the inventory item has extras during check-out of asset-type equipment. Required. Valid values: 1=includes Extras, 0=no Extras. |
| Id | 21.4.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
| Note | 21.4.0 | VARCHAR2(200 CHAR) | Note field holds checkout and check-in notes. During check-in, the notes entered during checkout will default. |
| StudentsDcid | 21.4.0 | NUMBER(19,0) | STUDENTS.DCID of the student to which the inventory item is assigned. Required. Indexed. |
| WhenCreated | 21.4.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 21.4.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 21.4.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
| WhoModifed | 21.4.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |