PTIA_STEPDEPEND

index back

PeopleSoft Field Name Field Type Column Type Description
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_P_UPG_GROUP Number(31,0) DECIMAL(31) NOT NULL
PTIA_P_UPGGRPLVL Number(3,0) SMALLINT NOT NULL Group Level
PTIA_P_SEQNUM Number(7,0) INTEGER NOT NULL
PTIA_P_TOPAEAPPLID Character(30) VARCHAR2(30) NOT NULL
PTIA_P_TOPAESECTN Character(30) VARCHAR2(30) NOT NULL
PTIA_P_TOPAESTEP Character(8) VARCHAR2(8) NOT NULL Root AE Step
PTIA_P_TOPAESEQNUM Number(7,0) INTEGER NOT NULL
PTIA_P_AEAPPLID Character(12) VARCHAR2(12) NOT NULL Parent Program Name
PTIA_P_AESECTION Character(8) VARCHAR2(8) NOT NULL Parent Section
PTIA_P_AESTEP Character(8) VARCHAR2(8) NOT NULL Parent Step
PTIA_P_AESEQNUM Number(7,0) INTEGER NOT NULL
PTIA_P_AESTMTSEQ Number(7,0) INTEGER NOT NULL Actions Overall Upgrade Sequence
PTIA_P_DETAILID Character(100) VARCHAR2(100) NOT NULL Parent Detail ID
PTIA_P_SQLNUM Number(7,0) INTEGER NOT NULL Parent SQL Number
PTIA_C_UPG_GROUP Number(31,0) DECIMAL(31) NOT NULL
PTIA_C_UPGGRPLVL Number(3,0) SMALLINT NOT NULL Group Level
PTIA_C_SEQNUM Number(7,0) INTEGER NOT NULL
PTIA_C_TOPAEAPPLID Character(30) VARCHAR2(30) NOT NULL
PTIA_C_TOPAESECTN Character(30) VARCHAR2(30) NOT NULL
PTIA_C_TOPAESTEP Character(8) VARCHAR2(8) NOT NULL Root AE Step
PTIA_C_TOPAESEQNUM Number(7,0) INTEGER NOT NULL
PTIA_C_AEAPPLID Character(12) VARCHAR2(12) NOT NULL Child Program Name
PTIA_C_AESECTION Character(8) VARCHAR2(8) NOT NULL Child Section
PTIA_C_AESTEP Character(8) VARCHAR2(8) NOT NULL Child Step
PTIA_C_AESEQNUM Number(7,0) INTEGER NOT NULL
PTIA_C_AESTMTSEQ Number(7,0) INTEGER NOT NULL Actions Overall Upgrade Sequence
PTIA_C_DETAILID Character(100) VARCHAR2(100) NOT NULL Child Detail ID
PTIA_C_SQLNUM Number(7,0) INTEGER NOT NULL Child SQL Number
PTIA_TABLENAME Character(30) VARCHAR2(30) NOT NULL
PTIA_P_TABLEUSAGE Character(1) VARCHAR2(1) NOT NULL Table Operation
PTIA_C_TABLEUSAGE Character(1) VARCHAR2(1) NOT NULL Table Operation
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19