PTSF_ES_DT_ERR1

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).
Prompt Table: PTSF_DEP_SBO_VW

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 PTSF_ES_DT_ERR_SEQ Number(5,0) INTEGER NOT NULL Sequence Number

4 PTSF_ES_PART_NO Number(5,0) INTEGER NOT NULL Partition Number No

5 PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name

6 PTSF_ES_DT_SELECT Character(1) VARCHAR2(1) NOT NULL Select
Default Value: N

7 PTSF_ES_SEG_NO Number(7,0) INTEGER NOT NULL Segment No

8 PTSF_ES_LREQ_TCLEN Number(9,0) DECIMAL(9) NOT NULL Total Length

9 PTSF_ES_LREQ_LEN Number(9,0) DECIMAL(9) NOT NULL Request Size

10 PTSF_ES_DT_LREQ Long Character(25000) CLOB Request

11 PTSF_ES_RES_DTTM DateTime(26) TIMESTAMP Response Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSF_SBO_NAME	Character(65)	VARCHAR2(65) NOT NULL	Search Definition (see PSPTSF_SD). Prompt Table: PTSF_DEP_SBO_VW
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	PTSF_ES_DT_ERR_SEQ	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	PTSF_ES_PART_NO	Number(5,0)	INTEGER NOT NULL	Partition Number No
5	PTSF_SRCH_ENG_INS	Character(30)	VARCHAR2(30) NOT NULL	Search Instance Name
6	PTSF_ES_DT_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Select Default Value: N
7	PTSF_ES_SEG_NO	Number(7,0)	INTEGER NOT NULL	Segment No
8	PTSF_ES_LREQ_TCLEN	Number(9,0)	DECIMAL(9) NOT NULL	Total Length
9	PTSF_ES_LREQ_LEN	Number(9,0)	DECIMAL(9) NOT NULL	Request Size
10	PTSF_ES_DT_LREQ	Long Character(25000)	CLOB	Request
11	PTSF_ES_RES_DTTM	DateTime(26)	TIMESTAMP	Response Time