TR_COLL_VW(SQL View) |
Index Back |
|---|---|
Collateral Details.Details of any collateral. |
| SELECT A.BUSINESS_UNIT ,A.COLLATERAL_ID ,B.TR_SOURCE_TYPE ,B.SOURCE_BUS_UNIT ,B.EVENT_ID ,A.COLL_REFERENCE_ID ,A.CURRENCY_CD ,A.MTM_CURRENCY ,A.ASOF_DATE ,A.COLLATERAL_HELD_BY ,A.COUNTERPARTY ,B.AMOUNT_BSE ,B.PERCENTAGE_SHARE ,A.MTM_ACCTG_VALUE ,A.SECURITY_ID FROM PS_TR_COLLATERAL A , PS_TR_COLL_FOR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COLLATERAL_ID = B.COLLATERAL_ID AND B.TR_SOURCE_TYPE = 'D' AND B.EVENT_ID IN ( SELECT C.TREAS_HEADER_ID FROM PS_TRX_DETAIL_TR C WHERE C.BUSINESS_UNIT = B.SOURCE_BUS_UNIT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | COLLATERAL_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Collateral ID number. auto generated but can be overridden.
Prompt Table: TR_COLLATERAL |
| 3 | 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 |
| 4 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 5 | 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 |
| 6 | COLL_REFERENCE_ID | Character(30) | VARCHAR2(30) NOT NULL | Reference Number of the Collateral. |
| 7 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | MTM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
Prompt Table: CURRENCY_CD_TBL |
| 9 | ASOF_DATE | Date(10) | DATE | As Of Date |
| 10 | COLLATERAL_HELD_BY | Character(4) | VARCHAR2(4) NOT NULL |
Treasury Collateral Held By
CUST=Customer EURO=Euro Brokers OTHR=Other US=Treasury |
| 11 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |
| 12 | AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 13 | PERCENTAGE_SHARE | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage of the deal that is pledged to the collateral. |
| 14 | 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 |
| 15 | SECURITY_ID | Character(10) | VARCHAR2(10) NOT NULL |
A reference identifier for a given deal transaction.
Prompt Table: TRX_SEC_HDR |