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 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).
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
AE_STATE_RECNAMECharacter(18)VARCHAR2(18) NOT NULLState Record
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
TABLENAMECharacter(32)VARCHAR2(32) NOT NULL
COLUMN_NAMECharacter(30)VARCHAR2(30) NOT NULLColumn Name
PTIA_AESTMTSEQNumber(7,0)INTEGER NOT NULLActions Overall Upgrade Sequence
PTIA_DMLACTIONCharacter(10)VARCHAR2(10) NOT NULLDML Action
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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19