UPG_DP_SCM_AET (SQL Table)	Index Back
DP Upg State Rec

UPG_DP_SCM_AET

(SQL Table)

DP Upg State Rec

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

3 UPG_RELEASE Character(4) VARCHAR2(4) NOT NULL Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release

4 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

5 EFFDT Date(10) DATE Effective Date

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

8 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1

9 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application

10 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

11 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name

12 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name

13 RECCOUNT Number(5,0) INTEGER NOT NULL Records Retrieved

14 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
3	UPG_RELEASE	Character(4)	VARCHAR2(4) NOT NULL	Upgrade Application Release 751=7.51 Release 752=7.52 Release 753=7.53 Release 801=8 SP1 Release 803=8 SP3 Release 840=8.40 Release 841=8.40 SP1 880=8.80 Release
4	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
5	EFFDT	Date(10)	DATE	Effective Date
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
8	COUNTER1	Number(16,2)	DECIMAL(15,2) NOT NULL	Counter 1
9	AE_APPL_ID	Character(8)	VARCHAR2(8) NOT NULL	Application
10	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
11	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
12	STEP_NAME	Character(40)	VARCHAR2(40) NOT NULL	Step Name
13	RECCOUNT	Number(5,0)	INTEGER NOT NULL	Records Retrieved
14	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.