PTUPG_STATE_AET

index back

Upgrade driver state record

Upgrade driver 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
PTUPG_PATH Character(4) VARCHAR2(4) NOT NULL Definition of supported upgrade paths
7084=PeopleTools 7.0x to 8.4x
7584=PeopleTools 7.5x to 8.4x
8184=PeopleTools 8.1x to 8.4x
8484=PeopleTools 8.4x to 8.4x
PTUPG_GROUP_SEQNUM 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.
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
PTUPG_DTTMSTAMP DateTime(26) TIMESTAMP DateTime Stamp
PTUPG_FLAG Character(1) VARCHAR2(1) NOT NULL Flag
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
PTUPG_NULL_DATE Date(10) DATE Null Work Date
PTUPG_NULL_DTTM DateTime(26) TIMESTAMP Null Work Date Time
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19