PTIA_DTLIDBINDS

index back

Upgrade Binds

This table contains bind variables that are used in the upgrade process. This is analyzed data from the PTIA_ANALYSIS table. Fields: DETAIL_ID >> Uniquely identifies what appengine action the code came from. PTIA_SQLNUM >> Counter of the statements found in PTIA_ANALYSIS.STMT_TEXT. AE_STATE_RECNAME >> AE State record used to hold values. FIELDNAME >> AE State record field used to hold values. PTIA_AESTMTSEQ >> Just carried over from PTIA_ANALYSIS TABLENAME >> Table name where the ae state field was populated from. COLUMN_NAME >> Field name where the ae state field was populated from. PTIA_DMLACTION >> The main sql action that the statement is executing. 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

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).
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
AE_STATE_RECNAME Character(18) VARCHAR2(18) NOT NULL State Record
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
TABLENAME Character(32) VARCHAR2(32) NOT NULL
COLUMN_NAME Character(30) VARCHAR2(30) NOT NULL Column Name
PTIA_AESTMTSEQ Number(7,0) INTEGER NOT NULL Actions Overall Upgrade Sequence
PTIA_DMLACTION Character(10) VARCHAR2(10) NOT NULL DML Action
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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19