AUC_PLN_PREF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN_SRCH
2	AUC_PLAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Sourcing Planning ID Prompt Table: AUC_PLN_DSCR_VW
3	AUC_PLAN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Sourcing Plan Status AP=Approved CA=Cancelled CO=Completed EX=Executing IN=Inactive NE=New PE=Pending Approval PO=Posted
4	PLAN_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Plan Owner Prompt Table: AUC_EMPL_SRCH
5	AUC_PLN_SORT_BY	Character(1)	VARCHAR2(1) NOT NULL	Plan sorting order I=Plan Id O=Current Owner S=Plan Status T=Plan Name
6	SORT_ORDER	Character(1)	VARCHAR2(1) NOT NULL	Sort Order A=Ascending D=Descending Default Value: A
7	FROM_BEGIN_DT	Date(10)	DATE	Journal Generator date range date.
8	TO_BEGIN_DT	Date(10)	DATE	Journal Generator date range date.
9	FROM_END_DT	Date(10)	DATE	Journal Generator date range date.
10	TO_END_DT	Date(10)	DATE	Journal Generator date range date.
11	PRIMARY_CATEGORY	Character(18)	VARCHAR2(18) NOT NULL	Primary Plan Category Prompt Table: AUC_PLN_CAT_VW
12	AUC_MY_EVENTS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Only show Events I created Y/N Table Edit