AE_REQUEST

#	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
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
4	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: O
5	AE_PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now Default Value: N
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
7	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler Default Value: N
8	GOTO_PROCESS_STAT	Character(1)	VARCHAR2(1) NOT NULL	Go To Process Status
9	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
10	AE_PRODUCT	Character(2)	VARCHAR2(2) NOT NULL	Product AE=PS/AE AM=PS/AM AP=PS/AP AR=PS/AR BI=PS/BI EO=PS/EO EX=PS/EX FS=PS/FS GL=PS/GL HR=PS/HR IN=PS/IN OM=PS/OM PC=PS/PC PO=PS/PO TR=PS/TR
11	AE_APPL_ID	Character(8)	VARCHAR2(8) NOT NULL	Application Prompt Table: AE_APPL_TBL