MPHUBEL (TXTBLS) Update and Maintenance
Access DEFINE. (QWS3270)
After signing in:
Type in txtbls in the following screen.
COMMAND E1
NAME MPHUBEL
KEY [current fiscal years ex 2019-2020] + [Procurement Category code ex. BC]
Key example: 2019-2020BC (fiscal year, building construction)
Next Screen:
Type "A" (for Add) in the area before the prompt "Please enter action (A, C, or D) and record number.
C = change
D = delete (do not use unless you create a duplicate
Next Screen:
Enter information as follows, use the MPHUBEL Updates Worksheet to assist with entering data.
USE ALL CAPS!
Fiscal Year 20XX-20XX
Procure Ctgy (Letter code - BC, CDY, HCOTB, NR, OS, PS, or STC)
HUB Type (Letter Code - AIF, AIM, ASF, ASM, BLF, BLM, HIF, HIM, NON, WHF, DVM)
Cty V Grp Elig (Yes or No - Y/N)
Press enter once you add the above data.
Next Screen:
New row appears in the next screen.
Key has changed. Remove suffix (HUB Type) to continue.
To continue adding and to save time with entering data, use the A command along with the number of the last row you added to copy the row and replace with new data.
For example:
Use A1 command.
Change the data in the applicable fields (normally the HUB Type and Ctgy V Grp Elig.
Once all updates have been applied, please double check that all information is correctly added to each table.
Use the following Updates Table to create rows.