CA_MYCON_FAV (SQL Table)	Index Back
My Contracts Favorites Temp table to store favorites information during CA_MYCON_AE processing

CA_MYCON_FAV

(SQL Table)

My Contracts Favorites

Temp table to store favorites information during CA_MYCON_AE processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

3 FAVORITE Character(1) VARCHAR2(1) NOT NULL To be used on my contracts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	FAVORITE	Character(1)	VARCHAR2(1) NOT NULL	To be used on my contracts