PTIA_DTLIDSQLSR

index back

Resolved Upgrade Statements

This table contains resolved statements that affect PeopleSoft data in the upgrade process. This is a child table of PTIA_DTLIDSQLS. Fields: DETAIL_ID >> Uniquely identifies what appengine action the code came from. PTIA_SQLNUM >> Counter of the statements found in PTIA_ANALYSIS.STMT_TEXT. STMT_TEXT >> The resolved statement that could affect PeopleSoft data.

PeopleSoft Field Name Field Type Column Type Description
PTIA_GUID Character(36) VARCHAR2(36) NOT NULL  
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
PTIA_SQLNUM Number(3,0) SMALLINT NOT NULL SQL Number
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