Procurement Card User Hierarchy Information

The Procurement Card Hierarchy Information (PRCUHI) table is used to assign hierarchy levels to coordinators and administrators. The PRCUHI table stores hierarchy level information for users with coordinator or admin roles in the PCard system.

When records are saved to the Hierarchy Levels (HIERLVL) table, a record is also inserted to the PRCUHI table. Users are also able to directly access PRCUHI via a hyperlink displayed at the bottom of the HIERLVL page or can access HIERLVL via a hyperlink displayed at the bottom of the PRCUHI page. Records can be added directly to the PRCUHI table to assign hierarchy levels via hierarchy level pick fields.
 
The PRCUHI table has a grid/scalar format. The scalar includes the same fields as displayed on the Hierarchy Levels page described in the section above. Some additional comments regarding the fields:

  • The Hierarchy Level fields are used for security. When a user navigates to the PRCUU or PRCUT table, the system utilizes that user’s Hierarchy Level fields from the PRCUHI table (can be multiple records) and searches for the records with matching Hierarchy Levels combinations. Therefore, the query that is run on the table filters out records based on the level that the user is assigned.

  • Active – The Active check box indicates whether this record is active.

  • Pin – The Pin field displays the pin number of the user with the bank. This is a system generated User ID + 4 digit sequential number.

Each section of the PRCUHI features a grid/scalar format with the following fields:

  • Level Code – Required field for Level 1 through Level 7. This is a 5-character numeric field to identify the organization hierarchy.

  • Level 1 to 7 Description – A required field that allows users to enter detailed descriptions for each hierarchy level. 

  • Status – A required field that allows the Administrator to set the status of each hierarchy level.  

    • Requested – Identifies records that have been added but not yet reviewed.

    • Accepted – Indicates when a record has been reviewed and approved. 

    • Rejected – Indicates that a record has been reviewed and rejected.

  • Active – This check box can only be set by Administrators.

  • User ID – A required pick field linked to the User Information (SCUSER) table from the Advantage Administration application. 

  • Request Type – A required field that allows users to enter detailed descriptions for each PRCUHI.

    • New Addition – Identifies newly added records.

    • Modification – Identifies modified records.

    • Deactivation – Indicates records that need to be deactivated.

  • Reviewed - This check can be manually populated by the user once the HIERLVL record has been reviewed. 

  • Site ID – A required pick field linked to the Procurement Location (PLOC) table.