INSTR_HEADER_TR(SQL Table) |
Index Back |
---|---|
Instruments & TemplatesBoth Instruments (instrmnt_template = ' ') and Instrument Templates (instrmnt_template != ' ') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
|
2 | Character(10) | VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table: INSTR_INST_H_VW |
|
3 | 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 |
|
4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
5 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |
6 | 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 |
7 | 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 |
8 | 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 |
9 | 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 Default Value: Y |
10 | MINIMUM_BIDS | Number(3,0) | SMALLINT NOT NULL | The minimum number of bids for a deal |
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 Default Value: PFVA |
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 | OB_CONFO_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate that the automated outbound confirmation feature has been enabled in
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 Default Value: N |
18 | 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 |
19 | 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 |
20 | 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 |
21 | NOTES_1000 | Long Character(1000) | VARCHAR2(1000) | Represents a field that allows free form text on the instrument definition panels. |
22 | RSK_VAR_EXP_SQL | Character(30) | VARCHAR2(30) NOT NULL |
SQLID used to obtain data for VaR export.
Prompt Table: SQLID_VW |
23 | 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 |
24 | 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 |