|
SELECT BUSINESS_UNIT , TREAS_HEADER_ID , TREAS_MAST_ROLL_ID , TREAS_MIRROR_BU , TREAS_MIRROR_ID , TREAS_MIRROR_CPTY , INSTRUMENT_TYPE , INSTRMNT_TEMPLATE , TRANSACTION_DT , COUNTERPARTY_SETID , COUNTERPARTY , DEAL_FAMILY_TYPE , DESCR150_MIXED , TRANSACTION_ISSUER , TRANSACT_GUARANTOR , TRANSACTION_BROKER , DEALER_OPRID , ORIG_OPRID , ORIG_DTTM , TREASURY_PORTFOLIO , CPTY_DEALER , CPTY_REFERENCE , NET_CASHFLOWS , TRA_ACTG_TREATMENT , TR_COLL_LVL_MIN , TR_SUB_REPO , TR_COLL_LVL_MAX , TR_SUB_LIMIT , TR_REPO_PRICE , MTM_CURRENCY , MTM_VALUE_OVRD_SW , - MTM_ACCTG_VALUE_0 , - MTM_ACCTG_VALUE , - MTM_EXCL_VALUE , - MTM_DEAL_VALUE , DEAL_STATUS , LAST_MAINT_DTTM , LAST_MAINT_OPRID , EXCL_FROM_POSITION , LIMIT_RESERVED , FCLTY_ID , TRD_TRADE_ID , TRADE_TYPE , START_DT , START_DISCOUNT_AMT , SECURITY_ID , TRP_BUSINESS_UNIT , POOL_ID , CR_RATING_TYPE , CR_RATING_VALUE FROM PS_TRX_HEADER_TR
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_TRD_NONVW
|
| 2 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Default Value: NEXT
Prompt Table:
TRX_HEADER_TR
|
| 3 |
TREAS_MAST_ROLL_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
This fields contains the first deal id in a series of deals that are related for deal rolling forward.
|
| 4 |
TREAS_MIRROR_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit of the deal that is the opposite clearing deal of the current deal.
|
| 5 |
TREAS_MIRROR_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The deal ID of the deal the is the offset for this deal.
|
| 6 |
TREAS_MIRROR_CPTY |
Character(5) |
VARCHAR2(5) NOT NULL |
The counterparty in a mirror clearing deal.
|
| 7 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table:
INSTR_INST_H_VW
|
| 8 |
INSTRMNT_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier associated with an instrument that describes a separate template version of a pre
Prompt Table:
INSTR_TMPL_H_VW
|
| 9 |
TRANSACTION_DT |
Date(10) |
DATE |
Transaction date (often used as trade date)
|
| 10 |
COUNTERPARTY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given dealing counterparty.
|
| 11 |
COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table:
BANK_TR_CPTY_VW
|
| 12 |
DEAL_FAMILY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
When deals are linked together, a code is set to identify the nature of the linkage. (EG btb = back to back)
BTB=Back to Back
COPY=Other Purpose Deal Copy
MIR=Standard Mirror
MIRR=Other Purpose Deal Mirror
PART=Partial Sell/Buyback
RLFX=FX Swap Forward / Backward
RLPH=One Period Physical Rollover
SUB=Internal or Subsidiary
|
| 13 |
DESCR150_MIXED |
Character(150) |
VARCHAR2(150) NOT NULL |
Description
|
| 14 |
TRANSACTION_ISSUER |
Character(5) |
VARCHAR2(5) NOT NULL |
The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre
Prompt Table:
BANK_ISSUER_VW
|
| 15 |
TRANSACT_GUARANTOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Entity that guarantees the credit worthiness of a financial instrument and its counterparty
Prompt Table:
BANK_GURANTR_VW
|
| 16 |
TRANSACTION_BROKER |
Character(5) |
VARCHAR2(5) NOT NULL |
"The deal transaction intermediary
Prompt Table:
BANK_BROKER_VW
|
| 17 |
DEALER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table:
OPRID_VW
|
| 18 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
OPRID_VW
|
| 19 |
ORIG_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the original creation and saving of a given transaction.
|
| 20 |
TREASURY_PORTFOLIO |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier for a position portfolio that may be associated with a given deal transaction.
Prompt Table:
TRX_PORTFLIO_TR
|
| 21 |
CPTY_DEALER |
Character(10) |
VARCHAR2(10) NOT NULL |
The assigned external dealer or trader associated with a given dealing counterparty.
|
| 22 |
CPTY_REFERENCE |
Character(15) |
VARCHAR2(15) NOT NULL |
A reference identifier associated with a dealing counterparty transaction.
|
| 23 |
NET_CASHFLOWS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate that the inbound and outbound cashflows for a given financi
Y/N Table Edit
|
| 24 |
TRA_ACTG_TREATMENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Treasury Deal Accounting Treatment.
Edit Translates on this field to alter the Accounting Treatments available.
(Not quite a control table, but as good as it gets!)
01=Held to Maturity
02=Available for Sale
03=Trading
04=Other
05=Loans and Receivables
|
| 25 |
TR_COLL_LVL_MIN |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Amount of Collateral that agreed upon to be pledged for a repo.
|
| 26 |
TR_SUB_REPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch to allow substitution of collateral.
L=Substitution with Limits
N=No Substitution
W=Unlimited Substitution
Default Value: N
|
| 27 |
TR_COLL_LVL_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Amount of Collateral that agreed upon to be pledged for a repo.
|
| 28 |
TR_SUB_LIMIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Limit of substitution amount.
|
| 29 |
TR_REPO_PRICE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
The repurchase price of the instrument.
|
| 30 |
MTM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 31 |
MTM_VALUE_OVRD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the returned output value from an analytics function may be
Y/N Table Edit
Default Value: N
|
| 32 |
MTM_ACCTG_VALUE_0 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction
|
| 33 |
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
|
| 34 |
MTM_EXCL_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
(Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item.
Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item.
NOTE: ONLY Label IDs 3 characters or less can be used as user-chosen labels on the Define Intruments / Analytics page (if added as XLATs to field MTM_EXCL_VAL_TYPE + C/P prefix)
|
| 35 |
MTM_DEAL_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
"A deal transaction's mark-to-market
|
| 36 |
DEAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
Default Value: 01
|
| 37 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 38 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
Prompt Table:
OPRID_VW
|
| 39 |
EXCL_FROM_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate that a given deal transaction is not to be included in a subse
N=Include in Position
Y=Exclude From Position
Y/N Table Edit
Default Value: N
|
| 40 |
LIMIT_RESERVED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal workfield that indicates whether a portion of a given treasury position's available exposu
N=UnReserved
Y=Limit Reserved
Y/N Table Edit
Default Value: N
|
| 41 |
FCLTY_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A unique key identifier that represents a given counterparty facility.
Prompt Table:
FCLTY_DFN
|
| 42 |
TRD_TRADE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Trade ID
Prompt Table:
TRD_HEADER_VW
|
| 43 |
TRADE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trade Type
C=Close
O=Open
|
| 44 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 45 |
START_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Internal field utilized to determine the appropriate accrual accounting amount for a giv
|
| 46 |
SECURITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
A reference identifier for a given deal transaction.
Prompt Table:
TRX_SEC_HDR
|
| 47 |
TRP_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Pool Business Unit
Prompt Table:
SP_TRPBU_NONVW
|
| 48 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table:
TRP_PL_ACT_VW1
|
| 49 |
CR_RATING_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
The market credit agency associated wth a given group of credit ratings.
I=IBCA
M=Moody's
S=Standard && Poors
Prompt Table:
%EDITTABLE5
|
| 50 |
CR_RATING_VALUE |
Number(3,0) |
SMALLINT NOT NULL |
User defined rating values utilized to assign priorities to a given set of credit ratings.
Prompt Table:
%EDITTABLE6
|