AP_MTCH_OBJ_DTL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MATCH_OBJECT Character(10) VARCHAR2(10) NOT NULL Match Object

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW3

4 SUMMARY_DETAIL Character(1) VARCHAR2(1) NOT NULL Summary/Detail
D=Detail
S=Summary

5 DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

6 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MATCH_OBJECT	Character(10)	VARCHAR2(10) NOT NULL	Match Object
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFN_VW3
4	SUMMARY_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Summary/Detail D=Detail S=Summary
5	DTL_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Structure Detail Record name
6	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)