TR_CSWP_AET

#	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	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	CSH_SWEEP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a Cash Sweep/Concentratoin structure. The identifier is manually entered by the user and not automatically generated by the system.
7	CSH_SWEEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Type - Physical or Notional. N=Notional P=Physical
8	AS_OF_DATE	Date(10)	DATE	As of Date
9	VALUE_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Value Date Option C=Current Date S=Specify Date
10	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
11	TRANSACT_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Transaction Date Option C=Current Date S=Specify Date
12	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
13	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
14	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success
15	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
16	SYSTEM_DATE	Date(10)	DATE	System Date
17	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
19	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
20	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
21	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
22	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
23	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
24	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
25	MESSAGE_PARM4	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 4
26	MESSAGE_PARM5	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 5
27	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
28	FIRST_PASS_SW	Character(1)	VARCHAR2(1) NOT NULL	First Pass Switch
29	SQLROWS_TAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
30	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
31	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
32	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
33	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
34	CURRENCY_CD_ACCT	Character(3)	VARCHAR2(3) NOT NULL	The default currency defined for an external bank account.
35	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
36	POS_IMPCT_ORIG	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result
37	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
38	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name