PSPMTRANSCURR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PM_INSTANCE_ID	Number(20,0)	DECIMAL(20) NOT NULL	Instance Identifier
2	PM_INSTANCE_SEQ	Number(5,0)	INTEGER NOT NULL	Instance sequence number
3	PM_TRANS_DEFN_SET	Number(5,0)	INTEGER NOT NULL	Performance monitor transaction definition set number.
4	PM_TRANS_DEFN_ID	Number(5,0)	INTEGER NOT NULL	Performance Monitor Transaction Definition Identifier.
5	PM_AGENTID	Number(10,0)	DECIMAL(10) NOT NULL	Performance Monitor Agent Identifier.
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	PM_PERF_TRACE	Character(128)	VARCHAR2(128) NOT NULL	Performance Trace Name
8	PM_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action 0=0-Start 1=1-Update 2=2-Stop 3=3-Atomic 4=4-Unknown
9	PM_TRANS_DELETED	Character(1)	VARCHAR2(1) NOT NULL	PMU Deleted
10	PM_CONTEXT_VALUE1	Character(254)	VARCHAR2(254) NOT NULL	Context 1
11	PM_CONTEXT_VALUE2	Character(254)	VARCHAR2(254) NOT NULL	Context 2
12	PM_CONTEXT_VALUE3	Character(254)	VARCHAR2(254) NOT NULL	Context 3
13	PM_CONTEXTID_1	Number(5,0)	INTEGER NOT NULL	Context Identifier 1
14	PM_CONTEXTID_2	Number(5,0)	INTEGER NOT NULL	Context Identifier 2
15	PM_CONTEXTID_3	Number(5,0)	INTEGER NOT NULL	Context Identifier 3
16	PM_AGENT_STRT_DTTM	DateTime(26)	TIMESTAMP	Agent Start Date/Time
17	PM_AGENT_LAST_DTTM	DateTime(26)	TIMESTAMP	Agent Last Update Date/Time
18	PM_MON_STRT_DTTM	DateTime(26)	TIMESTAMP	Monitor Received Date/Time
19	PM_MON_LAST_DTTM	DateTime(26)	TIMESTAMP	Monitor Last Update Date/Time
20	PM_TIMEOUT_DTTM	DateTime(26)	TIMESTAMP	Timeout datetime
21	PM_PARENT_INST_ID	Number(20,0)	DECIMAL(20) NOT NULL	Parent Instance Identifier
22	PM_TOP_INST_ID	Number(20,0)	DECIMAL(20) NOT NULL	Top Instance Identifier
23	PM_PROCESS_ID	Number(8,0)	INTEGER NOT NULL	Process ID
24	PM_METRIC_VALUE1	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 1
25	PM_METRIC_VALUE2	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 2
26	PM_METRIC_VALUE3	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 3
27	PM_METRIC_VALUE4	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 4
28	PM_METRIC_VALUE5	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 5
29	PM_METRIC_VALUE6	Signed Number(30,4)	DECIMAL(28,4) NOT NULL	Metric Value 6
30	PM_METRIC_VALUE7	Character(128)	VARCHAR2(128) NOT NULL	Metric Value 7
31	PM_ADDTNL_DESCR	Long Character	CLOB	Additional Description