BUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
COLLATERAL_IDPrompt Table: TR_COLLATERAL
Prompt Table: CURRENCY_CD_TBL
CUST=Customer
EURO=Euro Brokers
OTHR=Other
US=Treasury
Prompt Table: BANK_TR_CPTY_VW
TR_COLL_SRCH_VW(SQL View) |
Index Back |
|---|---|
Collateral Details.Details of any collateral. |
| SELECT BUSINESS_UNIT , COLLATERAL_ID , COLL_REFERENCE_ID , MTM_ACCTG_VALUE , MTM_CURRENCY , ASOF_DATE , COLLATERAL_HELD_BY , COUNTERPARTY FROM PS_TR_COLLATERAL |
| # | 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 | COLL_REFERENCE_ID | Character(30) | VARCHAR2(30) NOT NULL | Reference Number of the Collateral. |
| 4 | 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 |
| 5 | 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 |
| 6 | ASOF_DATE | Date(10) | DATE | As Of Date |
| 7 | COLLATERAL_HELD_BY | Character(4) | VARCHAR2(4) NOT NULL |
Treasury Collateral Held By
CUST=Customer EURO=Euro Brokers OTHR=Other US=Treasury |
| 8 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |