PTIA_STATE_AET

index back

PTIA Shared AE State Record

PTIA Shared AE State Record

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
PTIA_RUNIDNumber(10,0)DECIMAL(10) NOT NULLRun ID
PTIA_THREADIDNumber(10,0)DECIMAL(10) NOT NULLThread ID
PTIA_DEPTHNumber(15,0)DECIMAL(15) NOT NULL
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.
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
AE_SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
AE_STEPCharacter(8)VARCHAR2(8) NOT NULLName
AE_SQLROWSNumber(10,0)DECIMAL(10) NOT NULLRows affected by last SQL stmt
ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
A=Active
I=Inactive
PTIA_DTTM_STAMPDateTime(26)TIMESTAMPDateTime Stamp
FLAGCharacter(1)VARCHAR2(1) NOT NULLFlag
PTIA_GUIDCharacter(36)VARCHAR2(36) NOT NULL
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
SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
  • PTIA_COUNTERNumber(10,0)DECIMAL(10) NOT NULLPTIA Counter
    PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
    PROJECT_NAMECharacter(30)VARCHAR2(30) NOT NULLDisplays the Project names.
    PROJECTDESCRCharacter(30)VARCHAR2(30) NOT NULLProject Description
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19