SPR_DM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
3	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
4	PERSON_ID2	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
5	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
6	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_BI_NONVW
7	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
8	SPB_DURATION_DT	Date(10)	DATE	Duration Start Date
9	SPF_CURRENT_DATE	Character(1)	VARCHAR2(1) NOT NULL	Current Month 1=Yes 2=No Y/N Table Edit Default Value: N
10	SPF_REPORT_MONTHS	Signed Number(4,0)	DECIMAL(3) NOT NULL	# of Reporting Months
11	DATE_FROM	Date(10)	DATE	Date From
12	DATE_TO	Date(10)	DATE	Date To
13	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
14	OPRID_TO_RPT	Character(30)	VARCHAR2(30) NOT NULL	User ID To Report Prompt Table: SPR_ANALYZ_SRCH
15	SPR_ALL_USER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Run for all SPro Users 1=Yes 2=No N=No Y=Yes
16	DURATION_MONTH	Number(3,0)	SMALLINT NOT NULL	Length of Stay Duration in Months Default Value: 6
17	ASOF_DATE	Date(10)	DATE	As Of Date
18	LEAVE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Leave Period used to calculate Start Date of Length of Stay Analysis Default Value: 2
19	WO_CONID	Character(15)	VARCHAR2(15) NOT NULL	Service Provider's ID assigned on work order
20	NEW_START_DATE	Date(10)	DATE	Start Date