PTIA_DTLIDSQLS

index back

Upgrade Statements

This table contains statements that affect PeopleSoft data in the upgrade process. This is analyzed data from the PTIA_ANALYSIS table. This is a child table of PTIA_ANALYSIS. Fields: DETAIL_ID >> Uniquely identifies what appengine action the code came from. PTIA_SQLNUM >> Counter of the statements found in PTIA_ANALYSIS.STMT_TEXT. PTIA_AESTMTLEN >> Length of PTIA_DTLIDSQLS.STMT_TEXT. PTIA_OBJ_TYPE >> SQL (S), JAVA (J), FUNCLIB (F), APP_CLASS (A), and PEOPLECODE (P) TABLE_NAME >> The main table that is being used. If more than one table is used this field will be left blank. PTIA_DMLACTION >> The main sql action that the statement is executing. PTIA_LINENUM >> Line number from PTIA_ANALYSIS.STMT_TEXT where the statement was found. PTIA_VALIDSQL >> Indicates if the statement was parsed with no errors. DESCR254 >> Reason why sql is invalid. PTIA_PARAMCLAUSE >> Parameters that the statement uses. PTIA_INFO1 >> Just carried over from PTIA_ANALYSIS PTIA_INFO2 >> Just carried over from PTIA_ANALYSIS PTIA_INFO3 >> Just carried over from PTIA_ANALYSIS PTIA_INFO4 >> Just carried over from PTIA_ANALYSIS PTIA_INFO5 >> Just carried over from PTIA_ANALYSIS STMT_TEXT >> The statement that could affect PeopleSoft data.

  • Parent record: PTIA_ANALYSIS
  • 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_AESTMTLENNumber(9,0)DECIMAL(9) NOT NULLActions Statement Length
    PTIA_OBJ_TYPECharacter(1)VARCHAR2(1) NOT NULLDefines the type of peoplecode statement that is being evaluated
    A=Application Class
    F=Funclib
    J=Java
    S=SQL Statement
    TABLE_NAMECharacter(30)VARCHAR2(30) NOT NULLTable Name
    PTIA_DMLACTIONCharacter(10)VARCHAR2(10) NOT NULLDML Action
    PTIA_LINENUMNumber(6,0)INTEGER NOT NULLLine Number
    PTIA_SQLPASSDPARSECharacter(1)VARCHAR2(1) NOT NULLSQL Passed Parse
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    PTIA_PARAMCLAUSECharacter(254)VARCHAR2(254) NOT NULLParameter Clause
    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