TRCOLLFOR_TEO3

(SQL Table)
Index Back

CCU TEO temp table

CCU 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
Set Control Field: BUSINESS_UNIT

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