Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

Field nameDescriptionData type
Number of Active ItemsCount of active HD items.  Formula: count(CASE WHEN Delete Date is null THEN Barcode else null end)  Integer
Number of ItemsCount of HD items, active and deleted. Formula: COUNT(HD Item.Barcode)Integer
Number of TraysCount of unique trays. Formula: COUNT(DISTINCT HD Item.Tray ID)Integer
Sum of RetrievalsSum of HD item retrievals, deleted and active. Formula: SUM(HD History Last.Sequence)Integer
Sum of Retrievals (Active)Sum of active HD item retrievals. Formula: SUM(CASE WHEN Delete Date is null  THEN HD History Last.Sequence else null end)Integer
Active FlagY/N field where Y indicates the item is in HD Inventory, and N indicates item has been withdrawn. Formula: CASE WHEN Delete Date is null  THEN 'Y' ELSE 'N' end Text
Accession DateDate item added to HD inventory. Format MM/DD/YYYYDate
Accession FYFiscal year in which item was accessioned.  Formula: EXTRACT( YEAR FROM TIMESTAMPADD( SQL_TSI_MONTH , +(6), Accession Date))Text
Accession YearCalendar year in which item was accessioned.  EXTRACT( YEAR  FROM Accession Date)Text
Arrival DateDate item arrived at HDText
Audit DateNot in use.Text
BarcodeHD item barcodeText
Billable StorageBillable storage feet (h x w x d)Text
CollectionHD collection codeText
Deaccessioned FYFiscal year in which item was withdrawn from HD. Formula:  EXTRACT( YEAR  FROM  TIMESTAMPADD( SQL_TSI_MONTH , +(6), Delete Date))Text
Deaccessioned YearCalendar year in which item was withdrawn from HD. Formula:  EXTRACT( YEAR  FROM Delete Date)Text
Delete DateDate withdrawn from HD. Format: MM/DD/YYYYDate
Number of RetrievalsNumber of times item has been retrieved from HD
On ShelfY/N field where Y indicates the item is on the shelf at HD, and N indicates the item has been retrieved from HD. Formula: CASE  WHEN Delete Date is null and Number of Retrievals = 0 THEN 'Y' ELSE  CASE  WHEN  Delete Date is not null then 'N' ELSE CASE  WHEN Last Refi Date is null THEN 'N' ELSE 'Y' END  END  END 
Owner CodeHD Owner code
Owner NameHD Owner name
Update DateDate when touched by system or manual process
Last BilleeMost recent transaction - Owner code billed
Last OwnerMost recent transaction - Owner code
Last Refi DateMost recent transaction - Refile work order date
Last Refi OrderMost recent transaction - Refile work order number
Last Refi TypeMost recent transaction - Refile work order type
Last Refi VerifiedMost recent transaction - Refile verified (Y/N)
Last Refi WithdrawnMost recent transaction - Refiled / withdrawn flag
Last Ret DateMost recent transaction - Retrieval work order request date
Last Ret OrderMost recent transaction - Retrieval work order number
Last Ret RequesterMost recent transaction - Retrieval requested by
Last Ret TypeMost recent transaction - Retrieval work order type
Last Ret VerifiedMost recent transaction -RET_VERIFIED
Last SequenceMost recent transaction -SEQUENCE
Last ServiceMost recent transaction -SERVICE
Last Ship DateMost recent transaction -SHIP_DATE
Last StopMost recent transaction -STOP
Last Trip

Most recent transaction -TRIP


Last ZoneMost recent transaction -.ZONE
Tray Change Date"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".CHANGE_DATE
Tray Change User"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".CHANGE_USER
Tray Container Code"LTS-LIBRARY"."".REPORTING."A2_HD_ITEM (Main Model)".CONTAINER
Tray Container Description"LTS-LIBRARY"."".REPORTING."A2_LKUP_HD_CONTAINER (Main Model)".DESCRIPTION
Tray Delete Count"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".DELETE_COUNT
Tray Delete Date"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".DELETE_DATE
Tray ID"LTS-LIBRARY"."".REPORTING."A2_HD_ITEM (Main Model)".TRAY_ID
Tray Item Count"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".ITEM_COUNT
Tray Location ID"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".LOCATION_ID
Tray Media Code"LTS-LIBRARY"."".REPORTING."A2_HD_ITEM (Main Model)".MEDIA
Tray Media Description"LTS-LIBRARY"."".REPORTING."A2_LKUP_HD_MEDIA (Main Model)".DESCRIPTION
Tray Open Date"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".OPEN_DATE
Tray Row Position"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".ROW_POSITION
Tray Row Sequence"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".ROW_SEQUENCE
Tray Shelf Date"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".SHELF_DATE
Tray Type"LTS-LIBRARY"."".REPORTING."A2_HD_TRAY (Main Model)".TYPE
Tray Type Description"LTS-LIBRARY"."".REPORTING."A2_LKUP_HD_TRAY (Main Model)".DESCRIPTION
Location Height"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".HEIGHT
Location Aisle"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".AISLE
Location Bsf"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".BSF
Location Change Date"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".CHANGE_DATE
Location Change User"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".CHANGE_USER
Location Class"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".CLASS
Location Class Description"LTS-LIBRARY"."".REPORTING."A2_LKUP_HD_STORAGE_CLASS (Main Model)".STORAGE_CLASS_DESC
Location Depth"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)"."DEPTH"
Location Face"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".FACE
Location Ladder"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".LADDER
Location Open Date"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".OPEN_DATE
Location Owner"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".OWNER
Location Partial"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".PARTIAL
Location Shelf"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".SHELF
Location Tray Count"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".TRAY_COUNT
Location Width"LTS-LIBRARY"."".REPORTING."A2_HD_LOCATION (Main Model)".WIDTH
  • No labels