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 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_AESTMTLEN Number(9,0) DECIMAL(9) NOT NULL Actions Statement Length
    PTIA_OBJ_TYPE Character(1) VARCHAR2(1) NOT NULL Defines the type of peoplecode statement that is being evaluated
    A=Application Class
    F=Funclib
    J=Java
    S=SQL Statement
    TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
    PTIA_DMLACTION Character(10) VARCHAR2(10) NOT NULL DML Action
    PTIA_LINENUM Number(6,0) INTEGER NOT NULL Line Number
    PTIA_SQLPASSDPARSE Character(1) VARCHAR2(1) NOT NULL SQL Passed Parse
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    PTIA_PARAMCLAUSE Character(254) VARCHAR2(254) NOT NULL Parameter Clause
    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