CPC Reporting

Login to B2G: https://utsystem.diversitycompliance.com/

• Click on the Reporting Tab (on the left side of the screen)
• Then click Full List
• Under Contracts, click TPASS HUB Report
• Enter start/end dates (09012018 - 08312019) - Department: select UT Austin (only) - click view report.
• Lookout for projects that are not suppose to be reported under UT Austin (Austin State Hospital, New Arena, Block 164)

Export the report into Excel or PDF (document will have to be edited for reporting purposes

• In excel, separate: 00720 / 11 digit VID / Vendor Name / Obj Code / Dollar Amount / S (subcontracting) or N (non-treasury)
    00720 - each line needs to be updated to 00721
    11 digit VID - any vendor number with "No Vendor ID" needs to be replaced with 00000000000
    Vendor Name - 
    Obj Code - 4 digits either 7341 or 7256
    Dollar Amount - 
    S or N - 

Verify HUB and Non-HUB vendors

• Identify who is HUB and Non-HUB: https://mycpa.cpa.state.tx.us/tpasscmblsearch/
• Break out vendors based on object code (7256, 7341) 
    Then add all N expenditures for each object code, and add all S expenditures for each object code 
    Subtract N from S (do this for both object codes)
      Take the sum (offset) and add it with all S Non-HUB
      Add all HUB expenditures (both N and S) and divide it against the offset.
• 7256 will be added to Professional Services on the Semi-Annual / Annual Report
• 7341 will be added to Building Construction on the Semi-Annual / Annual Report

Remove CPC projects from Cognos

• Open Cognos and search Special Trade, Professional Services, and Building Construction to identify CPC projects
• Remove any projects related to 102-xxx (remember to check payments against the B2G TPASS report) both HUB and Non-HUB

Documentation

• Make notation of every addition and deletion for reference.
• Save reports in UT Box under HUB Performance Report FY "

F Drive Key

PAR reporting is the responsibility of the prime.  If prime has not input payments by deadline CPC HUB Associate should follow procedure below to input data

Per invoice, download PAR only from F Drive (file://flint/CPC/Austin)

Enter payments into B2G per PAR

Attach PAR document to each payment entered (this is for documentation)

CPC HUB Associate only enters HUB payments. 

Double-check 2^nd tier payments.  If 2^nd tier not recorded it is best practice to follow-up with HUB contact at prime firm (cc:  CPC project manager, and exec at prime firm).  If prime neglects to respond after 3 days send reminder email.  If prime neglects to respond after 7 days contact 1^st tier sub (cc:  CPC project manager, HUB contract at prime firm, and exec at prime firm)