PTIA_ANALYSIS

index back

  • Parent record of PTIA_DTLIDSQLS
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTIA_UPG_PATHCharacter(15)VARCHAR2(15) NOT NULLDefinition of supported upgrade paths
    PTIA_DBTYPECharacter(10)VARCHAR2(10) NOT NULLDBType
    PTIA_UPG_GROUPNumber(6,0)INTEGER NOT NULLSpecifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
    PTIA_UPG_GROUP_LVLNumber(3,0)SMALLINT NOT NULLGroup Level
    PTIA_UPG_CONV_TYPECharacter(4)VARCHAR2(4) NOT NULLUpgrade Conversion Type
    DDL=DDL Conversion Group
    MAIN=Main Conversion Group
    PRE=Pre Conversion Group
    SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
    PTIA_TOPAEAPPLIDCharacter(30)VARCHAR2(30) NOT NULL
    PTIA_TOPAESECTNCharacter(30)VARCHAR2(30) NOT NULL
    PTIA_TOPAESTEPCharacter(8)VARCHAR2(8) NOT NULLName
    PTIA_TOPAESEQNUMNumber(3,0)SMALLINT NOT NULL
    PTIA_AELEVELNumber(3,0)SMALLINT NOT NULLAE Call Section Level
    AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
    AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
    AE_STEPCharacter(8)VARCHAR2(8) NOT NULLName
    AE_SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
    MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
    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
    AE_DO_SECTIONCharacter(8)VARCHAR2(8) NOT NULLDo Section
    AE_DO_APPL_IDCharacter(12)VARCHAR2(12) NOT NULLDo Application
    AE_DYNAMIC_DOCharacter(1)VARCHAR2(1) NOT NULLDynamic DO
    STEP_DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription field for salary step
    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
    PTIA_STMTTYPENUMNumber(9,0)DECIMAL(9) NOT NULLNumerical Representation of Statement Type. Used for Ordering Actions within Steps
    PTIA_AESTMTSEQNumber(7,0)INTEGER NOT NULLActions Overall Upgrade Sequence
    AE_REUSE_STMTCharacter(1)VARCHAR2(1) NOT NULLRe-Use Statement
    N=Normal
    S=Save Stmt
    Y=Use Binds
    AE_DO_SELECT_TYPECharacter(1)VARCHAR2(1) NOT NULLType of Do Select
    F=Select and Fetch
    R=Re-Select
    DETAIL_IDCharacter(100)VARCHAR2(100) NOT NULLDetail line identifer
    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
    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_STMTDESCRCharacter(30)VARCHAR2(30) NOT NULLAction Statement Description
    PTIA_HASPARENTSCharacter(1)VARCHAR2(1) NOT NULL
    PTIA_HASCHILDRENCharacter(1)VARCHAR2(1) NOT NULL
    PTIA_HASWHERECharacter(1)VARCHAR2(1) NOT NULL
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19