PTIA_DATACONV

index back

Data Conversion App Engines

Used for dynamic section call of all the AE sections used in the Upgrade Data Conversion.

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
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).

Prompt Table: UPG_AEAPPL_VW

AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection

Prompt Table: PTIA_AESECTS_VW

ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
A=Active
I=Inactive
PTIA_RUNDURATIONNumber(19,3)DECIMAL(18,3) NOT NULLRun Duration
PTIA_RUNSTATUSFLAGCharacter(1)VARCHAR2(1) NOT NULL
PTIA_GUIDCharacter(36)VARCHAR2(36) NOT NULL
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19