TR_CSWP_DFN_AET(SQL Table) |
Index Back |
|---|---|
Cash Sweep defn state recThe following state record is used in the Cash Sweep Process (TR_CSH_SWEEP). This state record contains the fields from the CSH_SWEEP_DEFN record. |
| # | 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 | 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. |
| 4 | CSH_SWEEP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cash Sweep Type - Physical or Notional.
N=Notional P=Physical |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 8 | CSH_SWEEP_ACT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Cash Sweep Activity Type
B=Bi-Directional C=Concentration F=Funding |
| 9 | 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. |
| 10 | CSH_SWEEP_INIT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Cash Sweep Initiated By
B=Bank O=Organization |
| 11 | 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 |
| 12 | 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 |
| 13 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 14 | 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 |
| 15 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 16 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 19 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL | Cash Flows Worksheet ID |
| 20 | 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 |
| 21 | 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. |
| 22 | RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Rate index |
| 23 | ORIG_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the original creation and saving of a given transaction. |
| 24 | ORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 25 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 26 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 27 | APPROVAL_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a given transaction is approved by an oper |
| 28 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 29 | 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 |
| 30 | 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. |
| 31 | SETID1 | Character(5) | VARCHAR2(5) NOT NULL | SetID Value |
| 32 | SETID2 | Character(5) | VARCHAR2(5) NOT NULL | 2nd SetId |
| 33 | EFFDT_MAX | Date(10) | DATE | 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_effdt_from. |
| 34 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 35 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Exist |
| 36 | CALC_DT | Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 37 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 38 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 39 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 40 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 41 | 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 |
| 42 | 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. |
| 43 | WRK_RND_FACTOR | Number(16,7) | DECIMAL(15,7) NOT NULL | Rounding Factor for rounding up and rounding down. |
| 44 | WRK_RND_ADJUST | Number(19,15) | DECIMAL(18,15) NOT NULL | Rounding Adjustment for rounding up and rounding down. |
| 45 | WRK_RND_OPERATOR | Character(3) | VARCHAR2(3) NOT NULL | Rounding Operator for rounding up + and rounding down -. |
| 46 | CSWP_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cash Sweep Process Status
C=Successfully Completed E=Completed With Errors W=Completed With Warnings X=No Success |