OCD_ESTTIME_TMP

#	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.
5	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
7	RO_PROCESS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Field decribes the order process type like resume service, suspend service. It has translate values. ACT=Activate CHA=Change Service Attribute CHG=Change Service CNCL=Cancel Service DIS=Disconnect Service EDCH=Change End Date NEW=New Service PAC=PAC Code Request PORT=Port In Request RDCH=Change Resume Date RES=Resume Service RNW=Renew Service SNC=Suspend/Change Service SURE=Suspend / Resume Service SUS=Suspend Service
8	CAPTURE_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Capture Type QUO=Quote SO=Order
9	RC_BUS_PROCESS_ID	Character(15)	VARCHAR2(15) NOT NULL	Business Process ID used in Business Process tracking.
10	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
11	ACTIVITY_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Activity Instance
12	RC_TASK_ID	Character(15)	VARCHAR2(15) NOT NULL	Task ID used for Business Process tracking.