OCD_EST_TMP (SQL Table)	Index Back
Stores time data record for storing time data for the order management dashboard.

OCD_EST_TMP

(SQL Table)

Stores time data

record for storing time data for the order management dashboard.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 START_DTTM DateTime(26) TIMESTAMP start date time

3 EST_TASK_TIME Number(15,0) DECIMAL(15) NOT NULL Estimated Time to finish the task.

4 EST_TOTAL_TIME Number(15,0) DECIMAL(15) NOT NULL This is a field for storing the estimated time to finish the order.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	START_DTTM	DateTime(26)	TIMESTAMP	start date time
3	EST_TASK_TIME	Number(15,0)	DECIMAL(15) NOT NULL	Estimated Time to finish the task.
4	EST_TOTAL_TIME	Number(15,0)	DECIMAL(15) NOT NULL	This is a field for storing the estimated time to finish the order.