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 NameField TypeColumn TypeDescription
PTIA_GUIDCharacter(36)VARCHAR2(36) NOT NULL 
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
PTIA_SQLNUMNumber(3,0)SMALLINT NOT NULLSQL Number
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