Information Management - reportWORQS Documentation

Documentation

reportWORQS is the CPFM reporting support center. Cognos reports, SQL queries, and FAMIS canned reports provide users access to database data. Over 60 FAMIS related Cognos reports exist, and SQL queries are written as needed to extract data not included in report results. Cognos reports can be run on demand, scheduled, or emailed to users, and new reports can be requested using the CPFM report request form.

Jump directly to:

Reports Dictionary
Additional Resources
Frequently Asked Questions (FAQs)
Support Request

Reports Dictionary

[ Rep Dict | Add Resc | FAQs | Supp Req | Top of Page ]

Capital Projects

CP Cost Per Square Foot - Example report
Full details
Description: Report details cost per square foot values included estimate and actual values.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: CP status, Est Comp Date, CP Number, Site, Building, CP description, coll/dept, proj manager, const method, project type, square feet, curr applicable charges, est cost/sf, actual cost/sq
CP Project Review - One Line Per Project - Example report
Full details
Description: One line per project based on UT Materialized Views.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: Pg, Cp Nbr, Title, Coll/Dept, CPr, APr, RCd, Proj Mgr, Cp Type, Site, Bldg, Status, Method, Open Dt, Status Dt, EstCmp, Estimate, Funded, Actuals, Commttd, Ttl Oblg, Avail Bal
Business Owner: PMCS
Capital Project Dashboard - Example report
Full details
Description: One page summary per project based on UT Materialized Views.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: Pg, Cp Nbr, Title, Coll/Dept, CPr, APr, RCd, Proj Mgr, Cp Type, Site, Bldg, Status, Method, Open Dt, Status Dt, EstCmp, Estimate, Funded, Actuals, Commttd, Ttl Oblg, Avail Bal
Additional Resources: PMCS Project Dashboard Explanation, Adequately Funded Calculation, On Schedule Calculation
CP Accounting Status with Balance - Example report
Full details
Description: This report lists all Accounting status CPs and their corresponding accounts, pending transactions, and balances.
Report Columns: Acct Segment1, GB1, DEFINE Pend Trans, Proof Pend Trans, Balance, CP Number, CP desc, project manager, project accountant, Status Enter Date
Report Location: Project Reconciliation
CP Quick List by Days in ACCOUNTING - Example report
Full details
Description: This report lists all CPs in Accounting Status sorted by the number of days in Accounting status.
Report Columns: CP Number, Title (CP Description), College/Dept, CP Type, Project Mgr, Project Accountant, CP Status, Site, Bldg, Status Entr date, Days in Accounting, Open date, Estimate, Funded, Actuals, Committed, Ttl Oblg (Obligated), Available Bal, Acct Segment1, Misc. Encumberances, AQ Free Balance, AQ Expend
Report Location: Project Reconciliation
CP Quick List by Days in ACCTG_PM - Example report
Full details
Description: This report lists all CPs in Accounting_PM status sorted by the number of days in that status. Costs are current as of the previous business day.
Report Columns: CP Number, Title (CP Description), College/Dept, CP Type, Project Mgr, Project Accountant, CP Status, Site, Bldg, Status Entr Date, Days in Accounting, Open Date, Estimate, Funded, Actuals, Committed, Ttl Oblg (Obligated), Available Bal, Acct Segment1, Misc. Encumberances, AQ Free Balance, AQ Expend
Report Location: Project Reconciliation
CP Quick List by Days in CLOSED - Example report
Full details
Description: This report lists all CPs in Closed Status sorted by the number of days in that status. Based off the materialized view for costs, sorted by the number of days in Closed status.
Report Columns: CP Nbr, Title (CP Description), College/Dept, Cp Type, Project Mgr, Project Accountant, Site, Bldg, Status Entr Date, Close User, Open Date, Estimate, Funded, actuals, Committed, Ttl Oblg (Total Obligated), Aval Bal, Acct Segment1, Misc. Encumberances, AQ Free Bal, AQ Expend
Report Location: Project Reconciliation
Capital Project List by PM - Example report
Full details
Description: This report shows all capital projects and corresponding accounts with balances for the selected project manager.
Report Prompts: The user will be prompted to select a project manager from a list.
Report Columns: Cp Number, Cp Status, Cp Description, Acct Segment1, %, GB1, Define Pend Trans, Proof Pend Trans, CP Balance
Report Location: Project Reconciliation
Complete List of Capital Projects - Example report
Full details
Description: This report is a complete unfiltered list of all Capital Projects in FAMIS, ordered by CP number.
Report Columns: CP Number, Description, CP Status, Open Date, Cp Type, College/Dept, Project Accountant, Project Manager, and AcctSegment1
Report Location: Project Reconciliation
WO Detail Acct Seg1 - Example report
Full details
Description: The WO Detail Acct Seg1 report lists all work orders and any pending transactions against them for the account entered in the prompt.
Report Prompts: The user will be required to input an account number.
Report Columns: Acct Segment1, GB1, Define Pend Trans, Proof Pend Trans, WO Number, WO Description, %, WO Status, WO Assinged To, CP Number, Project Manager, Project Accountant
Report Location: Project Reconciliation
CP Projects by Age with Prompt - Example report
Full details
Description: This report provides a count of Capital Projects, grouped by Age. Users can drill through the report to the One Line Per or CP Dashbord report.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: CP Age Group, status, number of CPs
Report Location: Project Management > Stats
CP Projects by Dean-VP with Prompt - Example report
Full details
Description: Report totals CP amounts by Dean and VP.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: VP, Coll/Dept, Count of CPs, totals for estimate, funded, actuals, committed, allocated, total obligated and available balance.
Report Location: Project Management > Stats
Project Load by Position with Crew Prompt - Example report
Full details
Description: This report shows the Project Load by Crew, Position Title, and Employee Name. The total number of projects managed by employee and the total number where the employee is a team member are displayed. The total dollar amounts are also included.
Report Prompts: The user will be prompted to provide crew value(s).
Report Columns: Pm Title, Pm User Id, CP Status, As_PM, AS_TEAM, Total Pm Cp, Total Planned, Fund Amount, Avg Planned Amount, Avg Fund Amount
Report Location: Project Management
Project Manager Comments - Example report
Full details
Description: This report is very similar to the CP One Line Per Project report, with the exception that it includes the Project Manager Comments.
Report Prompts: This report is filtered by the Standard Prompt values.
Report Columns: Project Mgr, A&E Pr, CP Nbr, CP Title, Site, PrRv, Design Manager Comments, Status, Method, Open Dt, Est Cmpl, Estimate, Funded, Avail Bal
Report Location: Project Management

DHFS

HF Parent Child WO Report - Example report
Full details
Description: DHFS Parent Work Order and Children summary lists children Work Orders w Labor & Material costs.
Report Prompts: Parent WO Nbr
Report Columns: wo number, description, site, building, start date, WO status, close date, labor, material, total
Report Location: Work Order & Equipment
Business Owner: DHFS
North Dorms - Work Orders - Example report
Full details
Description: Lists WO details for DHFS north zone work orders.
Report Prompts: account number, enter date range
Report Columns: Building, Abbr, Wo Number, Description, Maint Type, Crew, Requestor, Enter Date, Enter User, Close Date, Status, Billing, Hours, Labor, Material
Report Location: Work Order & Equipment
Business Owner: DHFS
South Dorms - Work Orders - Example report
Full details
Description: Lists WO details for DHFS south zone work orders.
Report Prompts: account number, enter date range
Report Columns: Building, Abbr, Wo Number, Description, Maint Type, Crew, Requestor, Enter Date, Enter User, Close Date, Status, Billing, Hours, Labor, Material
Report Location: Work Order & Equipment
Business Owner: DHFS
UTHFP Work Order - Example report
Full details
Description: A list of DHFS work orders scheduled within a prompted date range. This report is sorted by building abbreviation and maintenance type.
Report Prompts: maint type, building, date range
Report Columns: WO number, description, building, maint type, sched date, close date, labor, material, total
Report Location: Work Order & Equipment
Business Owner: DHFS
HF WH Material Ctlg List - Example report
Full details
Description: List materials catalog entries for DHFS selected warehouse.
Report Prompts: warehouse
Report Columns: part description, part number, price, on hand, unit of measurement
Report Location: Purchasing & Inventory > Warehouse Inventory
Business Owner: DHFS
HF-IR Audit by Warehouse - Example report
Full details
Description: This audit report shows the changes made in the barcode application for the Issue or Return to be processed in FAMIS.
Report Prompts: Audit Date, Warehouse, Audit field
Report Columns: Warehouse, Clerk ID, Technician ID, Work Order ID, Batch Type, Audit Date, Audit Field, From Value, To Value
Report Location: Purchasing & Inventory > Warehouse Inventory
Business Owner: DHFS
HF-Issues & Returns Deleted Report by WH - Example report
Full details
Description: This report shows the detail or batch deletion. Housing and Food uses this report to audit the accuracy of the technicians entering PDA information. Reasons for deletion include: incorrect part number, part should have been taken from bench stock, etc. and are listed on the report.
Report Prompts: Date Deleted, Warehouse, Reason Deleted
Report Columns: Warehouse, Date Deleted, Work Order number, Part number, Technician ID, Quantity, UOM, Reason Deleted, Comment Deleted
Report Location: Purchasing & Inventory > Warehouse Inventory
Business Owner: DHFS
HF WH Bin Labels - Example report
Full details
Description: This Avery label formatted report, three across and nine down, lists the Housing and Food bin labels for the warehouse selected .
Report Prompts: The user will be promted to select a Warehouse.
Report Columns: Part number, description, commodity, category, unit of measure
Report Location: Purchasing & Inventory
Business Owner: DHFS
HF WH Inv Net Adjustments - Example report
Full details
Description: This report produces the Housing and Food net inventory count adjustments for the selected warehouse for a date range.
Report Prompts: The user will be promted to select a Warehouse.
Report Columns: Page, Line, Bin, Commodity Description, Count, UM, Short Description, Part #
Report Location: Purchasing & Inventory
Business Owner: DHFS
HF WH Inventory Count Sheets - Example report
Full details
Description: Lists inventory count sheets for the selected warehouse.
Report Prompts: warehouse
Report Columns: Page, line, bin, commodity description, count, unit of measurement, short description, part number
Report Location: Purchasing & Inventory
Business Owner: DHFS
HF-MSH Detail WO ChargesUpd - Example report
Full details
Description: Details work order charges for married student housing for a selected date range.
Report Prompts: Process date range
Report Columns: maint type, site, building, wo Number, description, labor, material, other charges
Report Location: IDT Reports & Charges
Business Owner: DHFS
HF-MSH Summary WO ChargesUpd - Example report
Full details
Description: Details married student housing WO charges by maintenance type.
Report Prompts: Date range
Report Columns: maint type, site, building, labor, material, other charges, total charges
Report Location: IDT Reports & Charges
Business Owner: DHFS
HF-UTM Detail WO ChargesuUpd - Example report
Full details
Description: Details DHFS main campus work order charges.
Report Prompts: Date range
Report Columns: maint type, site, building, wo Number, description, labor, material, other charges
Report Location: IDT Reports & Charges
Business Owner: DHFS
HF-UTM Summary ChargesUpd - Example report
Full details
Description: Details DHFS main campus WO charges by maint type.
Report Prompts: Date range
Report Columns: maint type, site, building, labor, material, other charges, total charges
Report Location: IDT Reports & Charges
Business Owner: DHFS
HFMisc - Example report
Full details
Description: Details DHFS miscellaneous charges.
Report Location: IDT Reports & Charges
Business Owner: DHFS

Financials

Form Letter Bill - Example report
Full details
Description: This report produces the letters that are sent to clients after each billing cycle, otherwise known as the Letter Bill process. They are sent with their associated Work Order cost report.
GLErrors report - Example report
Full details
Description: Lists the records that cannot bill due to errors. An error number and description are listed so users can easily fix the issues.
Report Prompts: Site, Extract Date, and UT_DTN_MODE
Report Columns: Site, Error Number, Error Description, CP#, EQ#, WO Number, Parent WO, Amount, WO Total, Institutional Charge, Error Code Total, Credit Acct Segment1, Credit Acct Segment2, Debit Acct Segment1, Debit Acct Segment2, JC Type, Trans Date, Extract Date
Hold Billing Report - Example report
Full details
Description: The Cognos 8 Hold Billing report lists all active and inactive Capital Projects with Work Orders where the account number is set to Hold Billing.
Report Columns: Site, CP Number, CP Description, CP Status, Project Manager, Project Accountant, WO Number, WO Description, WO Status, WO Total, WO Close Date
Schedule: The report runs on the third day of each month and is emailed to those in the distribution list.
Invoice Exception Report - Example report
Full details
Description: This report shows Invoices that need attention. Matched, unmatched, and suspended invoices are returned based on prompt selections.
Report Prompts: PO Type, PO Status, Invoice Number, Invoice Status, Invoice Enter Date
Report Columns: PO Number, PO Status, Purchase Type, Invoice, Voucher No, Invoice Status, Inv Enter User, Inv Enter date
Letter Bill - Example report
Full details
Description: This report lists work orders charged to a 'Letter Bill' account. Site, WO#, requestor, WO close date, and total are listed. It is sorted by site, descending WO close date.
Report Columns: Site, WO Number, WO Status, Description, Start Date, WO CLose Date, Total, Tracking1
Schedule: This report is scheduled to run every 2 weeks on a Wednesday. The output is emailed to specific people in Facilities Services/Business Services.
No Charge Work Orders w/Reimbursable Costs - Example report
Full details
Description: This is the renamed Cognos 7 WO No Charge with Real Costs All report. This report contains all work orders flagged as 'No Charge' but they have reimbursable/real charges posted against them.
Report Columns: Site, CP Number, CP Status, Project Manager, WO Number, WO Status, Description, Sched Date, Close Date, No Charge Material, No Charge Misc Cost, No Charge Adjustment, No Charge POs
Schedule: This report runs every Monday and is emailed to those on distribution list.
Non CP Hold Billing Report - Example report
Full details
Description: This report shows active and inactive work orders with account number equal to 'Hold Billing'. (Account Number = AcctSegment1 field)
Report Columns: WO Number, Description, WO Total, Crew, WO Close Date, WO Status, WO Type
Schedule: This report runs automatically on the third day of each month and is emailed to those on the distribution list.
WO Active Actuals w Bad Acct - Example report
Full details
Description: This report lists Work orders with billable charges and inactive or otherwise 'bad' account numbers.
Report Columns: Site, CP Number, CP Status, Project Manager, WO Number, WO Status, Start Date, Description, Acct Segment1, Account Valid error, Verified Invoice, Proofed Labor, Proofed Material, Proofed Misc Cost, Billed Invoice, Billed Labor, Billed Material, Billed Misc Cost
Schedule: This report runs every Monday morning and is emailed to those on the distribution list.
WO Active Actuals w No Acct - Example report
Full details
Description: This report lists active work orders that are charged "Actuals" but are missing the account number and/or object code. Sorted by CP number (if present) then Work Order Number.
Report Columns: Site, CP Number, CP Status, Proj mgr, proj acct, WO number, WO status, start date
Schedule: This report is scheduled to run every Monday. The output is emailed to specific people in Facilities Services/Business Services.
WO Active Letter Bill - Example report
Full details
Description: This report lists Letter Bill work orders with active status. It is sorted by site then start date.
Report Columns: Site, WO number, WO status, WO description, start date and total
Schedule: This report is scheduled to run on the 1st day of each month. The output is emailed to specific people in Facilities Services/Business Services.
WO Closed Letter Bill No Tracking - Example report
Full details
Description: Lists Letter Bill work orders that have not had a form letter bill sent and no payment has been received. Sorted by site then work order close date.
Report Columns: Site, WO number, WO status, WO description, start date, total charges, and tracking1
Schedule: This report is scheduled to run on the 1st day of each month. The output is emailed to specific people in Facilities Services/Business Services.
WO Closed Letter Bill Paid - Example report
Full details
Description: Lists all Letter Bill work orders with payment received. Sorted by site then work order close date.
Report Columns: Site, WO Number, WO Status, Description, Start date, Wo CLose Date, Total, Tracking1
Schedule: This report is scheduled to run on the 1st day of each month. The output is emailed to specific people in Facilities Services/Business Services.
WO Closed Letter Bill Sent - Example report
Full details
Description: Lists Letter Bill work orders that have had a form letter bill sent and no payment received. Sorted by site then work order close date
Report Columns: Site, WO Number, WO Status, Description, Start date, Wo CLose Date, Total, Tracking1
Schedule: This report is scheduled to run on the 1st day of each month. The output is emailed to specific people in Facilities Services/Business Services.

Purchasing & Inventory

Custodial Material Issues Report - Example report
Full details
Description: Details materials issued for specified craft(s) over a specified date range.
Report Prompts: Craft, date range
Report Columns: Craft, CP Number, WO number, crew, transaction date, part number, part desc, price, UM, quantity, and amount
Bin Labels Bin Range - Example report
Full details
Description: Creates Bin labels for a prompted Warehouse and Bin range. Uses short description.
Report Prompts: warehouse, value range
Report Location: Warehouse Inventory
Bin Labels Bin Range long - Example report
Full details
Description: Creates Bin labels for a prompted Warehouse and a specific list of parts. Uses long description.
Report Prompts: warehouse, value range
Report Location: Warehouse Inventory
Bin Labels Spfc Parts - Example report
Full details
Description: Creates Bin labels for a prompted Warehouse and a specific list of parts. Uses short description.
Report Prompts: warehouse, part numbers 1-9
Report Location: Warehouse Inventory
Cycle Counting Report - Example report
Full details
Description: Lists active parts with quantities on hand for inventory counting.
Report Prompts: warehouse
Report Columns: part number, short description, bin, status, price, UM, quantity on hand
Report Location: Warehouse Inventory
WH Inv Adjustments - Example report
Full details
Description: Lists inventory adjustments for a prompted warehouse and date range.
Report Prompts: date range, warehouse
Report Columns: Bin, Part number, description, init inventory, on hand, qty change, adjustment comments, adjustment date, adjustment entered by
Report Location: Warehouse Inventory
WH Inv Stock Items Rpt - Example report
Full details
Description: Summary of part type counts and inventory values by warehouse and part status.
Report Columns: warehouse, description, status, part count, total inventory value
Report Location: Warehouse Inventory
WH Inventory Work Sheets - Example report
Full details
Description: Creates inventory count sheets for a prompted warehouse and bin range that has been extracted for inventory.
Report Prompts: warehouse
Report Columns: entry page, entry line, bin, part number, units, count, old inventory number, description
Report Location: Warehouse Inventory
WH Obsolete In Stock Items - Example report
Full details
Description: Lists parts still in stock with "Obsolete" status for a prompted warehouse.
Report Prompts: warehouse
Report Columns: Bin, status, part number, category, description, quantity, unit of measure, unit price, value
Report Location: Warehouse Inventory
WH Status Items - Example report
Full details
Description: Lists items of a prompted Part Status for a prompted Warehouse.
Report Prompts: warehouse, part status
Report Columns: Bin, status, part number, category, description, quantity, unit of measure, unit price, value
Report Location: Warehouse Inventory
PO Import Summary - Example report
Full details
Description: Summary list of Req #, PO # and totals either deleted or imported to FAMIS from the UT_PO_IMPORT table for a prompted date range. Highlights deleted POs.
Report Prompts: date range, warehouse
Report Columns: req number, PO number, FAMIS load date, vendor no, orig total amt, deleted, total to FAMIS
Report Location: PO Load
Schedule: Report runs every Thursday night.
POs Loaded to FAMIS - Example report
Full details
Description: Lists Req #, PO # and items imported to FAMIS from the UT_PO_IMPORT table for a prompted date range. Highlights discrepancies.
Report Prompts: date range, warehouse
Report Columns: req number, PO number, vendor number, date loaded, part description, part number, quantity, UM, unit price, ext amount, load/del data deleted?
Report Location: PO Load
Schedule: Report runs every Tuesday night.
VE3 Error Report - Example report
Full details
Description: This is a scheduled, daily report that shows VE3 load error records that result from the DEFINE to FAMIS PO, POCO, and PO Line item import.
Report Columns: define doc ID, creator, PO number, amt, vendor number, vendor site code, WO number, CP number, change order flag, POCO change amount, CO description, preq line number, date loaded, reason
Report Location: PO Load
Schedule: This report runs at 4pm each weekday and is emailed to those on the report matilto: list.
VP1 Error Report - Example report
Full details
Description: This report lists all of the DEFINE VP1 records that were not imported into FAMIS as Invoices.
Report Columns: creator, PO number, WO number, PO line number, define invoice line amt, DEFINE orig price/item, DEFINE qty billed, DEFINE document ID, vendor number, date loaded from DEFINE, reason
Report Location: PO Load
Schedule: This report runs at 4pm each weekday
VP2 Error Report - Example report
Full details
Description: This report lists all of the DEFINE VP2 records that were not imported into FAMIS as Invoices.
Report Columns: creator, PO number, WO number, PO line number, invoice, DEFINE invoice amt, DEFINE document ID, DEFINE doc summary, vendor number, date loaded from DEFINE, reason
Report Location: PO Load
Schedule: This report runs at 4pm each weekday and is emailed to those on the report matilto: list.
VT5 Error Report - Example report
Full details
Description: The VT5 exception report includes all appropriate VT5 records for a two week period that were not imported successfully into FAMIS as Miscellaneous Costs.
Report Columns: process date, DEFINE doc ID, WO number, WO acct, amount, comments, cost type, WO budget code, reason
Report Location: PO Load
Schedule: It is scheduled to run every two weeks (run date -14) on Mondays at 8pm and a csv version is sent to the users on the mailto: list. It can also be run on demand if necessary.

Work Orders

Active Work Orders with Building Prompt - Example report
Full details
Description: This report shows Active Work Orders for building(s) sorted by Enter Date.
Report Prompts: Site, Building
Report Columns: SR number, WO number, CP number, building, maint type, WO status, enter date, prim crew, debit acct, requestor, description, total costs for: labor, material, contract, misc cost & IDT's, and total cost
Inactive Work Orders with Building Prompt - Example report
Full details
Description: This report shows Inactive Work Orders for buildings sorted by Enter Date and Close Date.
Report Prompts: Site, Building, Enter Date Range
Report Columns: SR number, WO number, CP number, building, maint type, WO status, enter date, prim crew, debit acct, requestor, description, total costs for: labor, material, contract, misc cost & IDT's, and total cost
Primary and Secondary Crew Schedule Report with Prompts - Example report
Full details
Description: This report allows users to a select any combination of available prompt information and see corresponding primary and secondary WO records. The prompts and report columns are listed below and are included on the Cognos report description.
Report Prompts: Primary/Secondary Crew, Maintenance Type, Crew Status, Priority, WO Schedule Date (date work order is created from SR), WO Start Date, WO Due Date
Report Columns: WO #, SR #, Description, Maint Type, Bldg Abbr, Primary Crew, Primary Crew Status, WO Priority, SR Enter Date, WO Schedule Date, WO Start Date, WO Due Date, WO Close Date, Secondary Crew, Secondary Crew Status, Secondary Completion Date, Labor Hours
Work Order Report with Prompts - Example report
Full details
Description: This report details work orders by Crew, Priority, Maint Type, Site, Building, WO Status, SR Enter Date, WO Schedule Date, or WO Close Date
Report Prompts: Prim crew, WO status, maint type, site, building, priority, SR enter date range, WO schedule date range, WO close date range
Report Columns: Crew, WO number, Description, WO status, WO Maintenance Type, Site, Building, Room, SR Enter Date, Due Date, Priority, WO schedule date, WO close date, CP number, Parent WO number, enter user, Assigned To Name, Requestor, days active, proofed materials, billed materials, inst materials, proofed labor, billed labor, inst labor, proofed misc costs, billed misc costs, inst misc costs, proofed invoice amts, billed invoice amts, inst invoice amts, total charges
Material Report - Example report
Full details
Description: Displays crew warehouse purchases.
Report Prompts: Crew number, begin date, end date
Report Columns: crew, WO number, description, part number part description, issue no, issue date, issued to, quantity, unit price, amount
Report Location: Facilities Maintenance
PM Work Orders Entered - Example report
Full details
Description:
Report Prompts: Site, date range
Report Location: Facilities Maintenance

Additional Resources * indicates that PDF opens in a new window.

[ Rep Dict | Add Resc | FAQs | Supp Req | Top of Page ]

Saving Cognos 8 Reports to MyFolders * - Report Views for Individual Users
Scheduling and Emailing Cognos 8 Reports * - Using Personal Report Views in MyFolders
Cognos 8 Toolbar *

Frequently Asked Questions (FAQs) * indicates that PDF opens in a new window.

[ Rep Dict | Add Resc | FAQs | Supp Req | Top of Page ]

General

What are the types of FAMIS reports available?
How can I request FAMIS report support?
How do I request a new Cognos report?
Where can I learn more about Information Quest (IQ)?

Access

Who should I contact for FAMIS report access in Cognos?

reportWORQS Support Request Form

[ Rep Dict | Add Resc | FAQs | Supp Req | Top of Page ]

What are the types of FAMIS reports available?

You have access to three types of reports.
1. Canned FAMIS reports are available in the FAMIS application. These reports run in PDF format only and are available in your FAMIS menu.
2. SQL ad-hoc reports are available from your department’s Data Analyst or the Information Management staff. These are comma separated value (.csv) reports written from SQL queries.
3. Cognos reports are available on the iqweb server. https://iq-web.austin.utexas.edu/cognos8 There are over 60 published reports, so please use the report dictionary to find the report that suits your needs.

Back to FAQs

How can I request FAMIS report support?

Use the above support request form.

Back to FAQs

How do I request a new Cognos report?

Email worqs@austin.utexas.edu to request a new report..

Back to FAQs

Where can I learn more about Information Quest (IQ)?

Visit the IQ Website for more information on resources and training.

Back to FAQs

Who should I contact for FAMIS report access in Cognos?

Send an email to worqs@austin.utexas.edu and include your EID and reason for needing access.