|
SELECT setid ,instrument_type ,instrmnt_template ,descr60 ,notes_1000 ,counterparty ,transaction_issuer ,transact_guarantor ,treasury_portfolio ,net_cashflows ,tra_actg_treatment ,mtm_excl_val_type ,confo_valid_id ,auto_preview_sw ,confo_review_sw ,allow_fixed_rt_chg ,allow_rolling ,tr_repo_sw ,tr_loc_debt_flg ,tr_cp_issue_flg ,fas133_instrument ,minimum_bids FROM PS_INSTR_HEADER_TR WHERE instrmnt_template = ' '
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table:
INSTR_INST_H_VW
|
| 3 |
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
|
| 4 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 5 |
NOTES_1000 |
Long Character(1000) |
VARCHAR2(1000) |
Represents a field that allows free form text on the instrument definition panels.
|
| 6 |
COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table:
BANK_TR_CPTY_VW
|
| 7 |
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_TR_CPTY_VW
|
| 8 |
TRANSACT_GUARANTOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Entity that guarantees the credit worthiness of a financial instrument and its counterparty
Prompt Table:
BANK_TR_CPTY_VW
|
| 9 |
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
|
| 10 |
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
|
| 11 |
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
|
| 12 |
MTM_EXCL_VAL_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
A code that selects what processing and label the user wants to appear against field MTM_EXCL_VALUE on the Deal Analytics page.
1st char is either "C" display Cumulative adjustment amounts (like Amortized Cost), or "P" display Period by period adjustment amounts (FAS133 derivatives)
Next 3 chars are the LABEL_ID of one of MTM_EXCL_VALUE's labels.
CAC=Cumulative Amortized Cost
CFVA=Cumulative Fair Value
PFVA=Per Period Fair Value
|
| 13 |
CONFO_VALID_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that represents a group of deal transaction fields designated as ma
Prompt Table:
DAD_CNF_VALCOL
|
| 14 |
AUTO_PREVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the deal preview workflow feature has been enabled in the Treasur
Y/N Table Edit
Default Value: N
|
| 15 |
CONFO_REVIEW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the deal confirmation review workflow feature has been enabled
Y/N Table Edit
Default Value: N
|
| 16 |
ALLOW_FIXED_RT_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates if a deal fixed rate can be changed.
Y/N Table Edit
Default Value: N
|
| 17 |
ALLOW_ROLLING |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates if a deal can be rolled forward or swapped forward or backward.
Y/N Table Edit
|
| 18 |
TR_REPO_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch to indicate whether the Deal is a Repo or not.
Y/N Table Edit
Default Value: N
|
| 19 |
TR_LOC_DEBT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to mark instrument as being drawn on Line of Credit facility
Y/N Table Edit
Default Value: N
|
| 20 |
TR_CP_ISSUE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate that the Instrument is a Commercial Paper instrument
Y/N Table Edit
Default Value: N
|
| 21 |
FAS133_INSTRUMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
listbox to choose the FAS 133 Hedging Instrument Type:
"D" Derivative
"E" Embedded Derivative
"X" Nonderivative Foreign Currency
"H" Hedgable Item
If this field has a value, then this instrument can be used for FAS 133 hedging: D, E, X as Hedging Instruments, X, H as Hedged Items
D=Is a Derivative
E=Contains Embedded Derivative
H=Can be a Hedged Item
X=Nonderivative Foreign Currency
|
| 22 |
MINIMUM_BIDS |
Number(3,0) |
SMALLINT NOT NULL |
The minimum number of bids for a deal
|