PTIA_STEPDEPEND

index back

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_CONV_TYPECharacter(4)VARCHAR2(4) NOT NULLUpgrade Conversion Type
DDL=DDL Conversion Group
MAIN=Main Conversion Group
PRE=Pre Conversion Group
PTIA_P_UPG_GROUPNumber(31,0)DECIMAL(31) NOT NULL
PTIA_P_UPGGRPLVLNumber(3,0)SMALLINT NOT NULLGroup Level
PTIA_P_SEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_P_TOPAEAPPLIDCharacter(30)VARCHAR2(30) NOT NULL
PTIA_P_TOPAESECTNCharacter(30)VARCHAR2(30) NOT NULL
PTIA_P_TOPAESTEPCharacter(8)VARCHAR2(8) NOT NULLRoot AE Step
PTIA_P_TOPAESEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_P_AEAPPLIDCharacter(12)VARCHAR2(12) NOT NULLParent Program Name
PTIA_P_AESECTIONCharacter(8)VARCHAR2(8) NOT NULLParent Section
PTIA_P_AESTEPCharacter(8)VARCHAR2(8) NOT NULLParent Step
PTIA_P_AESEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_P_AESTMTSEQNumber(7,0)INTEGER NOT NULLActions Overall Upgrade Sequence
PTIA_P_DETAILIDCharacter(100)VARCHAR2(100) NOT NULLParent Detail ID
PTIA_P_SQLNUMNumber(7,0)INTEGER NOT NULLParent SQL Number
PTIA_C_UPG_GROUPNumber(31,0)DECIMAL(31) NOT NULL
PTIA_C_UPGGRPLVLNumber(3,0)SMALLINT NOT NULLGroup Level
PTIA_C_SEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_C_TOPAEAPPLIDCharacter(30)VARCHAR2(30) NOT NULL
PTIA_C_TOPAESECTNCharacter(30)VARCHAR2(30) NOT NULL
PTIA_C_TOPAESTEPCharacter(8)VARCHAR2(8) NOT NULLRoot AE Step
PTIA_C_TOPAESEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_C_AEAPPLIDCharacter(12)VARCHAR2(12) NOT NULLChild Program Name
PTIA_C_AESECTIONCharacter(8)VARCHAR2(8) NOT NULLChild Section
PTIA_C_AESTEPCharacter(8)VARCHAR2(8) NOT NULLChild Step
PTIA_C_AESEQNUMNumber(7,0)INTEGER NOT NULL
PTIA_C_AESTMTSEQNumber(7,0)INTEGER NOT NULLActions Overall Upgrade Sequence
PTIA_C_DETAILIDCharacter(100)VARCHAR2(100) NOT NULLChild Detail ID
PTIA_C_SQLNUMNumber(7,0)INTEGER NOT NULLChild SQL Number
PTIA_TABLENAMECharacter(30)VARCHAR2(30) NOT NULL
PTIA_P_TABLEUSAGECharacter(1)VARCHAR2(1) NOT NULLTable Operation
PTIA_C_TABLEUSAGECharacter(1)VARCHAR2(1) NOT NULLTable Operation
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19