Understanding Peg Chains

The peg chain is maintained in the IN_PEGGING table. This table links the demand transaction to the supply transaction and includes the following fields:

  • The QTY_PEGGED field, which stores the total pegged quantity between the demand and supply transactions. This quantity is in the standard unit of measure for the item.

  • The PEG_STATUS field identifies the current state of the peg chain and includes the following values:

    • Open: (10) Indicates the line has a currently active peg.

    • Completed: (20) Indicates the peg chain is finished and the pegged supply has been received.

    • Canceled: (30) Indicates that either the pegged supply or pegged demand was canceled.

  • The QTY_RECEIVED field, which stores the amount of the supply-side pegged quantity that has been received or completed. This quantity is in the standard unit of measure for the item.

  • The QTY_COMPLETE field, which stores the amount of the supply-side pegged quantity that has been putaway into PeopleSoft Inventory. This quantity is in the standard unit of measure for the item.

  • The HARD_PEG field is a yes/no field indicating a hard or soft peg.

  • The DMD_DTTM field stores the schedule date of the demand transaction.

  • The SUP_DTTM field stores the due date of the supply transaction.

  • The DMD_OPEN_QTY field stores the order quantity of the demand transaction. This quantity is in the standard unit of measure for the item.

  • The SUP_OPEN_QTY field stores the order quantity of the supply transaction. This quantity is in the standard unit of measure for the item.

  • The DEMAND_HASH and SUPPLY_HASH fields identify the transactions that are pegged. The hash field can be converted to the order keys of the demand or supply transaction using the hash tables of the associated record. The hash tables and associated records are:

    • IN_DEMAND_HASH and IN_DEMAND: Demand fulfillment record in PeopleSoft Inventory.

    • PO_HASH and PO_LINE_DISTRIB: The purchase order distribution line record in PeopleSoft Purchasing.

    • REQ_HASH and REQ_LN_DISTRIB: The requisition distribution line record in PeopleSoft Purchasing.

    • SF_OUTPUT_HASH and SF_OUTPUT_LIST: The production ID line in PeopleSoft Manufacturing.

    • WM_WO_PO_HASH and WM_WO_SCHED_PO: For items to be ordered from PeopleSoft Purchasing, the work order task IDs resource line in PeopleSoft Maintenance Management.

    • WM_WO_MAT_HASH and WM_WO_SCHED_MAT: For items to be picked from PeopleSoft Inventory, the work order task IDs resource line in PeopleSoft Maintenance Management.

If a demand or supply date is changed, the system automatically updates the peg (including canceling the peg chain for canceled orders). If the peg is a hard peg and the user changes a demand date or quantity, the associated supply order itself is automatically changed as well. Optionally, notification can be sent to the relevant users (or user roles) that a change has taken place. Notifications are sent using the Message Dashboard. The setup for the Message Dashboard determines if the notification is logged on the dashboard, sent as an email and/or sent as a worklist entry in workflow.