APPS_SYS_ML_AET

(SQL Table)
Index Back

Upgrade driver state record

Upgrade driver state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 PTIA_UPG_PATH Character(15) VARCHAR2(15) NOT NULL Definition of supported upgrade paths
5 UPG_PI_LEVEL Character(2) VARCHAR2(2) NOT NULL PUM Image Level
6 UPG_RENAME_TYPE Character(2) VARCHAR2(2) NOT NULL Rename Type
7 UPG_GROUP_SEQ_NUM 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
9 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
10 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
11 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
12 AE_SQLROWS Number(10,0) DECIMAL(10) NOT NULL Rows affected by last SQL stmt
13 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
14 UPG_DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
15 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
16 UPG_ORIG_RECNAME Character(15) VARCHAR2(15) NOT NULL Original Record Name
17 FILEPATH1 Character(127) VARCHAR2(127) NOT NULL File Path and Name (ANZ)