TRCOLLFOR_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for TR_COLL_FOR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | COLLATERAL_ID | Character(12) | VARCHAR2(12) NOT NULL | Collateral ID number. auto generated but can be overridden. |
| 4 | TR_SOURCE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Type of source, to which any collateral is pledged. Could a deal or a letter of credit or anything else like cash, etc.
D=Deal ID L=Letter of Credit ID O=Other P=Portfolio ID |
| 5 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 6 | EVENT_ID | Character(20) | VARCHAR2(20) NOT NULL |
The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).
Prompt Table:
%EDITTABLE
|
| 7 | PERCENTAGE_SHARE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage of the deal that is pledged to the collateral. |
| 8 | AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 9 | MTM_ACCTG_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item |
| 10 | COLLAT_ALLOCATED | Date(10) | DATE | Date Collateral is removed from free inventory; segregated. |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 12 | COLLAT_RELEASE | Date(10) | DATE | Date Collateral is expected to be released back into free inventory; unsegregated |
| 13 | DESCR20_MIXED | Character(20) | VARCHAR2(20) NOT NULL | Description 20 characters, mixed case |
| 14 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |