PTIA_STATE_AET

index back

PTIA Shared AE State Record

PTIA Shared AE State Record

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
PTIA_RUNID Number(10,0) DECIMAL(10) NOT NULL Run ID
PTIA_THREADID Number(10,0) DECIMAL(10) NOT NULL Thread ID
PTIA_DEPTH Number(15,0) DECIMAL(15) NOT NULL
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_GROUP Number(6,0) INTEGER NOT NULL Specifies 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.
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
AE_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
AE_SQLROWS Number(10,0) DECIMAL(10) NOT NULL Rows affected by last SQL stmt
ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
PTIA_DTTM_STAMP DateTime(26) TIMESTAMP DateTime Stamp
FLAG Character(1) VARCHAR2(1) NOT NULL Flag
PTIA_GUID Character(36) VARCHAR2(36) NOT NULL
DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
SQLID Character(30) VARCHAR2(30) NOT NULL SQL 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_COUNTER Number(10,0) DECIMAL(10) NOT NULL PTIA Counter
    PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.
    PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19