B2G Data for HUB Report

Login to B2G: https://utexas.gob2g.com/

Click on the Reporting Tab (on the left side of the screen)
Then click Full List
Under Contracts, click TPASS HUB Report
Lookout for projects that are not suppose to be reported under UT Austin (Austin State Hospital, New Arena, Block 164, P3s)

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

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

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, 7343)
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
7343 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 "

PAR reporting is the responsibility of the prime.

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)