UPG_TR_AET (SQL Table)	Index Back
Work record for Treasury Upg. Work record required for temporary storage of data during treasury upgrade.

UPG_TR_AET

(SQL Table)

Work record for Treasury Upg.

Work record required for temporary storage of data during treasury upgrade.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge

5 SQL_ROW_COUNT Number(8,0) INTEGER NOT NULL Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.

6 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

7 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.

8 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

9 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

10 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

11 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

12 SEL_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Cash Forecast Selection SQL statement.

13 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

14 DATE_INCREMENT Signed Number(5,0) DECIMAL(4) NOT NULL An internal work field utilized for storing the number of adjustment days to be applied to a given node date during

15 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a

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

17 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

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

19 EVENT_SEQ Number(10,0) DECIMAL(10) NOT NULL Event Sequence

20 MARKET_DT Date(10) DATE User Defined Date Field

21 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

22 MTM_VENDOR_NM Character(20) VARCHAR2(20) NOT NULL 3rd party analytics vendor used for valuation and analytics.

23 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

24 LENGTH_MAX Number(5,0) INTEGER NOT NULL Maximum Length

25 EXIST Character(1) VARCHAR2(1) NOT NULL Exist

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
5	SQL_ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
6	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
7	SECURITY_ID	Character(10)	VARCHAR2(10) NOT NULL	A reference identifier for a given deal transaction.
8	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
9	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
10	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
11	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
12	SEL_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Cash Forecast Selection SQL statement.
13	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
14	DATE_INCREMENT	Signed Number(5,0)	DECIMAL(4) NOT NULL	An internal work field utilized for storing the number of adjustment days to be applied to a given node date during
15	FIELD_VALUE_NBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An accounting template field designated to support the substitution of desired monetary amounts during a
16	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
17	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
18	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
19	EVENT_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Event Sequence
20	MARKET_DT	Date(10)	DATE	User Defined Date Field
21	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
22	MTM_VENDOR_NM	Character(20)	VARCHAR2(20) NOT NULL	3rd party analytics vendor used for valuation and analytics.
23	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
24	LENGTH_MAX	Number(5,0)	INTEGER NOT NULL	Maximum Length
25	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist