PSPTANALYSISAET

#	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).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
5	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
6	GUID	Character(36)	VARCHAR2(36) NOT NULL	Unique Identifier
7	PTTST_ANALYSISNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
8	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
9	PTTST_COMPTYPE	Character(1)	VARCHAR2(1) NOT NULL	Compare Type D=To Database F=From File
10	MENUNAME	Character(30)	VARCHAR2(30) NOT NULL	Menu Name (see PSMENUDEFN).
11	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
12	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
13	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).
14	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
15	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
16	FIELDVALUE	Character(4)	VARCHAR2(4) NOT NULL	Field Value
17	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
18	PTTST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Test Name (see PSPTTSTDEFN).
19	PTTST_CMD_ID	Number(5,0)	INTEGER NOT NULL	Scr Command ID
20	NUMROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.