REPORT DESCRIPTIONS 1. HARDWARE INVENTORY FILE (IHVENT) 2. SOFTWARE INVENTORY FILE (ISVENT) (THE FOLLOWING REPORTS ARE FOUND IN ALL OF THE ABOVE FILES...) 1) Listing By System Number Paper: 8 1/2 X 11" Long Fields Printed: System Number, Product Name, Serial Number, Vendor, Purchase Date, Purchase Cost, Current Value, Department Code, Category Sorted By: System Number Records Selected: Specified System Number or All Records 2) Listing By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, System Number, Serial Number, Vendor, Purchase Date, Purchase Cost, Current Value, Department Code, Category Sorted By: Product Name, then System Number Records Selected: Specified Product Name or All Records 3) Listing --- Leased Items Paper: 8 1/2 X 11" Long Fields Printed: System Number, Product Name, Serial Number, Vendor, Purchase Date, Purchase Cost, Current Value, Department Code, Category Sorted By: System Number Records Selected: Specified System Number All Leased Equipment 4) Listing By Manufacturer Paper: 8 1/2 X 11" Long Fields Printed: Manufacturer, System Number, Product Name, Serial Number, Vendor, Purchase Date, Purchase Cost, Current Value, Department Code, Category Sorted By: Manufacturer, then Product Name Records Selected: Specified Manufacturer or All Records 5) Listing By Vendor Paper: 8 1/2 X 11" Long Fields Printed: Vendor, System Number, Product Name, Serial Number, Purchase Date, Purchase Cost, Current Value, Department Code, Category Sorted By: Vendor, Then Product Name Records Selected: Specified Vendor or All Records 6) Listing By Purchase Date Paper: 8 1/2 X 11" Long Fields Printed: Purchase Date, System Number, Product Name, Serial Number, Vendor, Purchase Cost, Current Value, Department Code, Category Sorted By: Purchase Date, then Product Name Records Selected: Range of Purchase Dates or All Records 7) Listing By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, System Number, Product Name, Serial Number, Vendor, Purchase Date, Purchase Cost, Current Value, Category Sorted By: Department Code, then System Number, then Product Name Records Selected: Specified Department Code or All Records 8) Listing By Maintenance Company Paper: 8 1/2 X 11" Long Fields Printed: Maintenance Company, System Number, Product Name, Serial Number, Vendor, Start Date, Expiration Date, Maintenance Fee, Pay Period Sorted By: Maintenance Company, then System Number, then Product Name Records Selected: Specified Maintenance Company or All Records 8) Listing By Expiration Date Paper: 8 1/2 X 11" Long Fields Printed: Expiration Date, Maintenance Company, System Number, Product Name, Serial Number, Maintenance Fee, Pay Period Sorted By: Expiration Date, the Maintenance Company, then Product Name Records Selected: Range of Expiration Dates or All Records 9) Depreciation Summary Paper: 8 1/2 X 11" Long Fields Printed: System Number, Product Name, Department Code, Budget Number, Fixed Asset Number, Purchase Cost, Depreciation Percent, Depreciation Months, Depreciation Amount, Monthly Depreciation, Months Taken, Depreciation Taken, Current Value Sorted By: System Number Records Selected: Specified System Number or All Records 3. COMPUTER DEPRECIATION JOURNAL FILE (DHVENT & DZVENT) 1) Depreciation Listing By Date Paper: 8 1/2 X 11" Long Fields Printed: Date, Year Charged, Month Charged, System Number, Serial Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Sorted By: Date Records Selected: Range of Dates or All Records 2) Depreciation Listing By Month Charged Paper: 8 1/2 X 11" Long Fields Printed: Year Charged, Month Charged, Date, System Number, Serial Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Sorted By: Year Charged, then Month Charged, then System Number Records Selected: Range of Months or All Records 3) Depreciation Listing By System Number Paper: 8 1/2 X 11" Long Fields Printed: System Number, Date, Year Charged, Month Charged, Serial Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Sorted By: System Number, then Date Records Selected: Specified System Number or All Records 4) Depreciation Listing By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, Date, Year Charged, Month Charged, System Number, Serial Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Sorted By: Product Name, then Date Records Selected: Specified Product Name or All Records 5) Depreciation Listing By Serial Number Paper: 8 1/2 X 11" Long Fields Printed: Serial Number, Date, Year Charged, Month Charged, System Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Sorted By: Serial Number, then Date Records Selected: Specified Serial Number or All Records 6) Depreciation Listing By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Date, Year Charged, Month Charged, System Number, Serial Number, Budget Code, Fixed Asset Number, Entry Amount Sorted By: Department Code, then Date Records Selected: Specified Department Code or All Records 7) Depreciation Listing By Budget Code Paper: 8 1/2 X 11" Long Fields Printed: Budget Code, Date, Year Charged, Month Charged, System Number, Serial Number, Department Code, Fixed Asset Number, Entry Amount Sorted By: Budget Code, then Date Records Selected: Specified Budget Code or All Records 8) Depreciation Listing By Fixed Asset Number Paper: 8 1/2 X 11" Long Fields Printed: Fixed Asset Number, Date, Year Charged, Month Charged, System Number, Serial Number, Department Code, Budget Code, Entry Amount Sorted By: Fixed Asset Number, then Date Records Selected: Specified Fixed Asset Number or All Records 4. APPLICATIONS FILE (APPLIC) (THE FOLLOWING REPORTS ARE FOUND IN ALL OF THE ABOVE FILES...) 1) Application Listing By Title Paper: 8 1/2 X 11" Long Fields Printed: Application Title, File Date, System Number, Used By, Package/Language, Department Code, Hours, Cost Sorted By: Application Title Records Selected: Specified Application Title or All Records 2) Application Listing By File Date Paper: 8 1/2 X 11" Long Fields Printed: File Date, Application Title, System Number, Used By, Package/Language, Department Code, Hours, Cost Sorted By: File Date, then Application Title Records Selected: Range of File Dates or All Records 3) Application Listing By System Number Paper: 8 1/2 X 11" Long Fields Printed: System Number, Application Title, File Date, Used By, Package/Language, Department Code, Hours, Cost Sorted By: System Number, then Application Title Records Selected: Specified System Number or All Records 4) Application Listing By Developer Paper: 8 1/2 X 11" Long Fields Printed: Developer, Application Title, File Date, System Number, Used By, Package/Language, Department Code, Hours, Cost Sorted By: Developer, then Application Title Records Selected: Specified Developer or All Records 5) Application Listing By Package/Language Paper: 8 1/2 X 11" Long Fields Printed: Package/Language, Application Title, File Date, System Number, Used By, Department Code, Hours, Cost Sorted By: Package/Language, then Application Title Records Selected: Specified Package/Language or All Records 6) Application Listing By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Application Title, File Date, System Number, Used By, Package/Language, Hours, Cost Sorted By: Department Code, then Application Title Records Selected: Specified Department Code or All Records 7) Application Listing By Category Paper: 8 1/2 X 11" Long Fields Printed: Category, Application Title, File Date, System Number, Used By, Package/Language, Department Code, Hours, Cost Sorted By: Category, then Application Title Records Selected: Specified Category or All Records 8) Incomplete Application Listing By Title Paper: 8 1/2 X 11" Long Fields Printed: Application Title, File Date, System Number, Developed By, Package/Language,Department Code, Completion Stage, Completion Date Sorted By: Application Title Records Selected: Incomplete Applications 9) Incomplete Application Listing By Completion Date Paper: 8 1/2 X 11" Long Fields Printed: Completion Date, Application Title, File Date, System Number, Developed By, Package/Language, Department Completion Stage Sorted By: Completion Date, then Application Title Records Selected: Range of Completion Dates or All Incomplete Applications 5. MAINTENANCE FILE (MAINT) 1) Maintenance Listing By Date Paper: 8 1/2 X 11" Long Fields Printed: Date, Scheduled/Unscheduled, System Number, Product Name, Serial Number, Department Code, Description, Downtime, Cost Sorted By: Date Records Selected: Range of Dates or All Records 2) Maintenance Listing By System Number Paper: 8 1/2 X 11" Long Fields Printed: System Number, Date, Scheduled/Unscheduled, Product Name, Serial Number, Department Code, Description, Downtime, Cost Sorted By: System Number, then Date Records Selected: Specified System Number or All Records 3) Maintenance Listing By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Date, Scheduled/Unscheduled, System Number, Product Name, Serial Number, Description, Downtime, Cost Sorted By: Department Code, then Date Records Selected: Specified Department Code or All Records 4) Maintenance Listing By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, Date, Scheduled/Unscheduled, System Number, Serial Number, Department Code, Description, Downtime, Cost Sorted By: Product Name, then Date Records Selected: Specified Product Name or All Records 5) Scheduled Maintenance Listing Paper: 8 1/2 X 11" Long Fields Printed: Date, System Number, Product Name, Serial Number, Department Code, Description, Downtime, Cost Sorted By: Date Records Selected: Range of Dates Where SCH_UNSCH = "S" or All Records Where SCH_UNSCH = "S" 6-1) MTBF Listing By System Number Paper: 8 1/2 X 11" Long Fields Printed: System Number, Average Downtime, Average Cost, MTBF (Mean Time Between Failure -- In Days) Sorted By: System Number Records Selected: Specified System Number or All Records 6-2) MTBF Listing By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Average Downtime, Average Cost, MTBF (Mean Time Between Failure -- In Days) Sorted By: Department Code Records Selected: Specified Department Code or All Records 6-3) MTBF Listing By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, Average Downtime, Average Cost, MTBF (Mean Time Between Failure -- In Days) Sorted By: Product Name Records Selected: Specified Product Name or All Records 6-4) MTBF Listing By Manufacturer Paper: 8 1/2 X 11" Long Fields Printed: Manufacturer, Average Downtime, Average Cost, MTBF (Mean Time Between Failure -- In Days) Sorted By: Manufacturer Records Selected: Specified Manufacturer or All Records 6. PRODUCT REQUESTS FILE (PRODREQ) 1) Product Requests By Request Number Paper: 8 1/2 X 11" Long Fields Printed: Request Number, Request Date, Requestor, Department Code, Product Name, Manufacturer, Cost, Filled?, Priority Sorted By: Request Number Records Selected: Range of Request Numbers or All Records 2) Product Requests By Request Date Paper: 8 1/2 X 11" Long Fields Printed: Request Date, Request Number, Requestor, Department Code, Product Name, Manufacturer, Cost, Filled?, Priority Sorted By: Request Date, then Request Number Records Selected: Range of Request Dates or All Records 3) Unfilled Product Requests By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Request Number, Request Date, Requestor, Product Name, Manufacturer, Cost, Filled?, Priority Sorted By: Department Code, Then Request Number Records Selected: Specified Department Code or All Records 4) Unfilled Product Requests By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, Request Number, Request Date, Requestor, Department Code, Manufacturer, Cost, Filled?, Priority Sorted By: Product Name, Then Request Number Records Selected: Specified Product Name or All Records 5) Unfilled Product Requests By Vendor Paper: 8 1/2 X 11" Long Fields Printed: Vendor, Product Name, Request Number, Request Date, Requestor, Department Code, Manufacturer, Cost, Filled?, Priority Sorted By: Vendor, Then Product Name, Then Request Number Records Selected: Specified Vendor or All Records 6) Unfilled Product Requests By Priority Paper: 8 1/2 X 11" Long Fields Printed: Priority, Product Name, Request Number, Request Date, Requestor, Department Code, Manufacturer, Cost, Filled? Sorted By: Category, Then Product Name, Then Request Number Records Selected: Specified Priority or All Records 7) Unfilled Product Requests By P.O. Number Paper: 8 1/2 X 11" Long Fields Printed: Purchase Order Number, Product Name, Request Number, Request Date, Requestor, Department Code, Manufacturer, Cost, Filled?, Priority Sorted By: P.O. Number, Then Product Name Records Selected: Range of P.O. Numbers or All Records 8) Purchase Order Summary Paper: 8 1/2 X 11" Long Fields Printed: Purchase Order Number, Vendor, Product Name, Department Code, Request Number, Request Date, Requestor, Manufacturer, Cost, Filled?, Priority Sorted By: Product Name Records Selected: Specified P.O. Number 9) Order Processing Summary Paper: 8 1/2 X 11" Long Fields Printed: Date Filled, Request Number, Request Date, Processing Days, Department Code, Product Name, Vendor, Cost, Priority Sorted By: Date Filled, Then Request Number Records Selected: Range of Fill Dates or All Records 7. DESIGN REQUESTS FILE (DESREQ) 1) Design Requests By Request Number Paper: 8 1/2 X 11" Long Fields Printed: Request Number, Request Date, Requestor, Department Code, Application Name, Priority, Estimated Hours, Estimated Cost, Assigned? Sorted By: Request Number Records Selected: Range of Request Numbers or All Records 2) Design Requests By Request Date Paper: 8 1/2 X 11" Long Fields Printed: Request Date, Request Number, Requestor, Department Code, Application Name, Priority, Estimated Hours, Estimated Cost, Assigned? Sorted By: Request Date, Then Request Number Records Selected: Range of Request Dates or All Records 3) Design Requests By Department Code Paper: 8 1/2 X 11" Long Fields Printed: Department Code, Request Number, Request Date, Requestor, Application Name, Priority, Estimated Hours, Estimated Cost, Assigned? Sorted By: department Code, then Request Number Records Selected: Specified Department Code or All Records 4) Design Requests By Priority Paper: 8 1/2 X 11" Long Fields Printed: Priority, Request Number, Request Date, Requestor, Department Code, Application Name, Estimated Hours, Estimated Cost, Assigned? Sorted By: Priority, Request Number Records Selected: Specified Priority or All Records 5) Design Requests By Developer Paper: 8 1/2 X 11" Long Fields Printed: Developer, Request Number, Request Date, Requestor, Department Code, Application Name, Priority, Estimated Hours, Estimated Cost, Assigned? Sorted By: Developer, Then Request Number Records Selected: Specified Developer or All Records 6) Design Requests By Category Paper: 8 1/2 X 11" Long Fields Printed: Category, Request Number, Request Date, Requestor, Department Code, Application Name, Priority, Estimated Hours, Estimated Cost, Assigned? Sorted By: Category, Then Request Number Records Selected: Specified Category or All Records 7) Design Request Processing Summary Paper: 8 1/2 X 11" Long Fields Printed: Assignment Date, Request Number, Request Date, Backlog Days, Department Code, Application Name, Priority, Developer Sorted By: Assignment Date, Then Request Number Records Selected: Range of Assignment Dates or All Records 8. HARDWARE PRODUCT REVIEWS FILE (RHVPROD) 9. SOFTWARE PRODUCT REVIEWS FILE (RHVPROD) (THE FOLLOWING REPORTS ARE FOUND IN ALL OF THE ABOVE FILES...) 1) Review Listing By Product Name Paper: 8 1/2 X 11" Long Fields Printed: Product Name, Manufacturer, Cost, Date Reviewed, Reviewer, Department Code, Summary Sorted By: Product Name Records Selected: Specified Product Name or All Records 2) Review Listing By Manufacturer Paper: 8 1/2 X 11" Long Fields Printed: Manufacturer, Product Name, Cost, Date Reviewed, Reviewer, Department Code, Summary Sorted By: Manufacturerm Then Product Name Records Selected: Specified Manufacturer or All Records 3) Review Listing By Review Date Paper: 8 1/2 X 11" Long Fields Printed: Review Date, Product Name, Manufacturer, Cost, Reviewer, Department Code, Summary Sorted By: Date Reviewed, Then Product Name Records Selected: Range of Review Dates or All Records 4) Review Listing By Category Paper: 8 1/2 X 11" Long Fields Printed: Category, Product Name, Manufacturer, Cost, Date Reviewed, Reviewer, Department Code, Summary Sorted By: Category, Then Product Name Records Selected: Specified Category or All Records 10. SUMMARY REPORTS 1) Computer Department Summary Paper: 8 1/2 X 11" Long Fields Printed: Microcomputer Hardware, Software, and Applications Records Selected: Specified Department Code 2) Computer System Number Summary Paper: 8 1/2 X 11" Long Fields Printed: Microcomputer Hardware, Software, and Applications Records Selected: Specified System Number 3) Departmental Depreciation Summary Paper: 8 1/2 X 11" Long Fields Printed: Date, Year Charged, Month Charged, System Number, Serial Number, Department Code, Budget Code, Fixed Asset Number, Entry Amount Totals Records Selected: Specified Department Code 4-1) Computer Hardware Labels Paper: One Across Labels Fields Printed: System Number, Department Code, Product Name, Fixed Asset Number, Serial Number Sorted By: System Number, Then Product Name Records Selected: Range of Purchase Dates or All Microcomputer Hardware 4-2) Computer Software Labels Paper: One Across Labels Fields Printed: System Number, Department Code, Product Name, Fixed Asset Number, Serial Number Sorted By: System Number, Then Product Name Records Selected: Range of Purchase Dates or All Microcomputer Software