OCD_ASSOC_VW (SQL View)	Index Back
View of Associations This is an order management dashboard view of the definition of an association.

OCD_ASSOC_VW

(SQL View)

View of Associations

This is an order management dashboard view of the definition of an association.

SELECT CAPTURE_ID , UID20 , RC_BUS_PROCESS_ID , BUS_PROC_INSTANCE , TYPE FROM PS_RO_ASSOCIATION WHERE TYPE='BP'

# 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 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

3 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.

4 BUS_PROC_INSTANCE Number(18,0) DECIMAL(18) NOT NULL Business Project Instance. This is the Business Project instance of a business project.

5 TYPE Character(4) VARCHAR2(4) NOT NULL Association Types

#	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	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
3	RC_BUS_PROCESS_ID	Character(15)	VARCHAR2(15) NOT NULL	Business Process ID used in Business Process tracking.
4	BUS_PROC_INSTANCE	Number(18,0)	DECIMAL(18) NOT NULL	Business Project Instance. This is the Business Project instance of a business project.
5	TYPE	Character(4)	VARCHAR2(4) NOT NULL	Association Types