PTIA_ANALYSISTX

index back

PeopleSoft Field NameField TypeColumn TypeDescription
DETAIL_IDCharacter(100)VARCHAR2(100) NOT NULLDetail line identifer
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
PTIA_UPG_PATHCharacter(15)VARCHAR2(15) NOT NULLDefinition of supported upgrade paths
PTIA_DBTYPECharacter(10)VARCHAR2(10) NOT NULLDBType
PTIA_UPG_CONV_TYPECharacter(4)VARCHAR2(4) NOT NULLUpgrade Conversion Type
DDL=DDL Conversion Group
MAIN=Main Conversion Group
PRE=Pre Conversion Group
AE_STMT_TYPECharacter(1)VARCHAR2(1) NOT NULLType
C=Comments
D=Do Select
H=Do When
N=Do Until
S=Select
U=Update/Insert/Delete
W=Do While
SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL 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_INFO1Character(100)VARCHAR2(100) NOT NULLInformation1
    PTIA_INFO2Character(100)VARCHAR2(100) NOT NULLInformation2
    PTIA_INFO3Character(100)VARCHAR2(100) NOT NULLInformation3
    PTIA_INFO4Character(100)VARCHAR2(100) NOT NULLInformation4
    PTIA_INFO5Character(100)VARCHAR2(100) NOT NULLInformation5
    PTIA_CHUNKSEQNumber(3,0)SMALLINT NOT NULLChunk Sequence
    PTIA_TEXTCHUNKLong Character(14000)CLOBText Chunk
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19