OCD_HOLDTIME_VW (SQL View)	Index Back
Average hold time for holds This record shows the average hold time for active holds.

OCD_HOLDTIME_VW

(SQL View)

Average hold time for holds

This record shows the average hold time for active holds.

SELECT A.HOLD_CD , A.CAPTURE_ID , A.UID20 , A.HOLD_STATUS , A.ROW_ADDED_DTTM , CASE WHEN B.USE_OVERRIDE='Y' THEN B.MAN_OVERRIDE_SEC ELSE B.AVG_SECONDS END FROM PS_RO_HOLD A , PS_OCD_AVG_HOLD B WHERE A.HOLD_CD = B.HOLD_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HOLD_CD Character(6) VARCHAR2(6) NOT NULL This field determine the hold code of an item.

2 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

3 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

4 HOLD_STATUS Character(4) VARCHAR2(4) NOT NULL Hold status that are displayed on the hold page of order capture when an order is on hold.
DENY=Override Denied
FIXE=Fixed
INPR=In Process
OPEN=Requires Action
PASS=Resolved
REMV=Override Hold

5 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

6 AVG_SECONDS Number(13,2) DECIMAL(12,2) NOT NULL Average Time in Seconds

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	This field determine the hold code of an item.
2	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
3	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
4	HOLD_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Hold status that are displayed on the hold page of order capture when an order is on hold. DENY=Override Denied FIXE=Fixed INPR=In Process OPEN=Requires Action PASS=Resolved REMV=Override Hold
5	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
6	AVG_SECONDS	Number(13,2)	DECIMAL(12,2) NOT NULL	Average Time in Seconds