Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

MPHUBEL (TXTBLS) Update and Maintenance

Access Log into 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]

Step 1: Get into the TXTBLS screen by typing TXTBLS and enter. 

Step 2: Enter the following:

  • Command: E1
  • Name: MPHUBEL
  • Key: [Current fiscal year][Procurement Category Code] 

Key example: 2019-2020BC (fiscal year, building construction)

Image RemovedImage Added

Next ScreenStep 3:

  • 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

Image Removed



Next ScreenStep 4:

Enter information as follows, use Use the MPHUBEL Updates Worksheet to assist with entering data.

USE ALL CAPS!

Fiscal Year . Enter the following:

  • 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.

Image Removed

Next Screen:

New row appears in the next screen.

Key has changed. Remove suffix (HUB Type) to continue.

Image Removed

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:

Image Removed

Use A1 command.

Change the data in the applicable fields (normally the HUB Type and Ctgy V Grp Elig.

Image RemovedExample: 


  • Press "Enter" to add the data.

Step 4:



Once all updates have been applied, please double check that all information is correctly added to each table.

...