PTIA_SECLISTTMP

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTIA_UPG_PATHCharacter(15)VARCHAR2(15) NOT NULLDefinition of supported upgrade paths
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).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
EFFDTDate(10)DATEEffective Date

Default: %date

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19