CSH_SWEEP_HDR (SQL Table)	Index Back
Cash Sweep Header

CSH_SWEEP_HDR

(SQL Table)

Cash Sweep Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 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.

3 CSH_SWEEP_TYPE Character(1) VARCHAR2(1) NOT NULL Cash Sweep Type - Physical or Notional.
N=Notional
P=Physical

4 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

6 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

7 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

8 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

9 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

12 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.

13 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

14 POS_IMPCT_REVAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the calculated monetary value for a specific position tree node; the result revalued to another currency.

15 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

16 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

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

18 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

19 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

20 CSH_SWEEP_ACT_TYPE Character(1) VARCHAR2(1) NOT NULL Cash Sweep Activity Type
B=Bi-Directional
C=Concentration
F=Funding

21 CSH_SWEEP_INIT_BY Character(1) VARCHAR2(1) NOT NULL Cash Sweep Initiated By
B=Bank
O=Organization

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

23 EFFDT Date(10) DATE Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	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.
3	CSH_SWEEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Type - Physical or Notional. N=Notional P=Physical
4	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
7	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
8	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
9	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
13	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
14	POS_IMPCT_REVAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the calculated monetary value for a specific position tree node; the result revalued to another currency.
15	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
16	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
17	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
18	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
19	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
20	CSH_SWEEP_ACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Activity Type B=Bi-Directional C=Concentration F=Funding
21	CSH_SWEEP_INIT_BY	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Initiated By B=Bank O=Organization
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
23	EFFDT	Date(10)	DATE	Effective Date