PTIA_RUNSTATUS

(SQL Table)
Index Back

Thread Status

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIA_RUNID Number(10,0) DECIMAL(10) NOT NULL Run ID
2 PTIA_THREADID Number(10,0) DECIMAL(10) NOT NULL Thread ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 PTIA_DTTM_START DateTime(26) TIMESTAMP DateTime Stamp Start
6 PTIA_UPG_PATH Character(15) VARCHAR2(15) NOT NULL Definition of supported upgrade paths
7 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.
8 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
9 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 PTIA_UPG_GROUP_LVL Number(3,0) SMALLINT NOT NULL Group Level
12 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
13 PTIA_THREADDUR Number(19,3) DECIMAL(18,3) NOT NULL Thread Duration