CSH_SWEEP_DEFN (SQL Table)	Index Back
Cash Sweep Definition

CSH_SWEEP_DEFN

(SQL Table)

Cash Sweep Definition

Related Language Record: CSH_SWEEP_LANG

# 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
Default Value: P

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

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

8 AUTO_GEN_CSH_SWEEP Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) EFT Requests/Bank Transfers should be automatically generated as the result of the Cash Sweep/Concentration process.
Y/N Table Edit
Default Value: N

9 CSH_SWEEP_INIT_BY Character(1) VARCHAR2(1) NOT NULL Cash Sweep Initiated By
B=Bank
O=Organization
Default Value: O

10 CSH_SWEEP_RND_OPTN Character(1) VARCHAR2(1) NOT NULL Cash Sweep Rounding Option defines how the cash sweep/concentration amount is to be rounded.
0=None
1=Round Up
2=Round Down
3=Nearest
Default Value: 0

11 CSH_SWEEP_RND_FCTR Character(2) VARCHAR2(2) NOT NULL Cash Sweep Rounding Factor
01=1
02=10
03=100
04=1,000
05=10,000
06=100,000
07=1,000,000
08=10,000,000

12 BANK_CD Character(5) VARCHAR2(5) NOT NULL Master Bank Code
Prompt Table: BANK_CD_EXT_VW

13 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
Prompt Table: BANK_ACCT_ACTVE

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

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

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

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

18 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID
Prompt Table: WRKSHT_DEFN_VW
Set Control Field: SETID

19 POSITION_CURR_TYPE Character(1) VARCHAR2(1) NOT NULL Identifies the origin of the position currency. The currency can be a Worksheet currency or a Bank Account default currency.
1=Worksheet
2=Bank Account
Default Value: 2

20 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.
Prompt Table: RT_TYPE_TBL

21 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index
Prompt Table: RT_INDEX_FX_VW

22 ORIG_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the original creation and saving of a given transaction.

23 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

24 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

25 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

26 APPROVAL_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a given transaction is approved by an oper

27 APPROVAL_OPRID Character(30) VARCHAR2(30) NOT NULL A system generated value that reflects the operator that approved a given transaction.

28 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
Default Value: P

29 EVENT_TRACKING_ID Number(10,0) DECIMAL(10) NOT NULL The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.

#	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 Default Value: P
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description
7	CSH_SWEEP_ACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Activity Type B=Bi-Directional C=Concentration F=Funding
8	AUTO_GEN_CSH_SWEEP	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) EFT Requests/Bank Transfers should be automatically generated as the result of the Cash Sweep/Concentration process. Y/N Table Edit Default Value: N
9	CSH_SWEEP_INIT_BY	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Initiated By B=Bank O=Organization Default Value: O
10	CSH_SWEEP_RND_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Cash Sweep Rounding Option defines how the cash sweep/concentration amount is to be rounded. 0=None 1=Round Up 2=Round Down 3=Nearest Default Value: 0
11	CSH_SWEEP_RND_FCTR	Character(2)	VARCHAR2(2) NOT NULL	Cash Sweep Rounding Factor 01=1 02=10 03=100 04=1,000 05=10,000 06=100,000 07=1,000,000 08=10,000,000
12	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Master Bank Code Prompt Table: BANK_CD_EXT_VW
13	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 Prompt Table: BANK_ACCT_ACTVE
14	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
15	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
18	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID Prompt Table: WRKSHT_DEFN_VW Set Control Field: SETID
19	POSITION_CURR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies the origin of the position currency. The currency can be a Worksheet currency or a Bank Account default currency. 1=Worksheet 2=Bank Account Default Value: 2
20	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. Prompt Table: RT_TYPE_TBL
21	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index Prompt Table: RT_INDEX_FX_VW
22	ORIG_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the original creation and saving of a given transaction.
23	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
24	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
25	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
26	APPROVAL_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a given transaction is approved by an oper
27	APPROVAL_OPRID	Character(30)	VARCHAR2(30) NOT NULL	A system generated value that reflects the operator that approved a given transaction.
28	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending Default Value: P
29	EVENT_TRACKING_ID	Number(10,0)	DECIMAL(10) NOT NULL	The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.