PTIA_ANALYSISTX

index back

PeopleSoft Field Name Field Type Column Type Description
DETAIL_ID Character(100) VARCHAR2(100) NOT NULL Detail line identifer
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
PTIA_UPG_PATH Character(15) VARCHAR2(15) NOT NULL Definition of supported upgrade paths
PTIA_DBTYPE Character(10) VARCHAR2(10) NOT NULL DBType
PTIA_UPG_CONV_TYPE Character(4) VARCHAR2(4) NOT NULL Upgrade Conversion Type
DDL=DDL Conversion Group
MAIN=Main Conversion Group
PRE=Pre Conversion Group
AE_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Type
C=Comments
D=Do Select
H=Do When
N=Do Until
S=Select
U=Update/Insert/Delete
W=Do While
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)
  • PTIA_INFO1 Character(100) VARCHAR2(100) NOT NULL Information1
    PTIA_INFO2 Character(100) VARCHAR2(100) NOT NULL Information2
    PTIA_INFO3 Character(100) VARCHAR2(100) NOT NULL Information3
    PTIA_INFO4 Character(100) VARCHAR2(100) NOT NULL Information4
    PTIA_INFO5 Character(100) VARCHAR2(100) NOT NULL Information5
    PTIA_CHUNKSEQ Number(3,0) SMALLINT NOT NULL Chunk Sequence
    PTIA_TEXTCHUNK Long Character(14000) CLOB Text Chunk
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19