INSTR_TMPL_H_VW(SQL View) |
Index Back |
---|---|
Instrument Templates PromptPrompt Record for Treasury Instrument Templates |
SELECT setid ,instrument_type ,instrmnt_template ,descr60 ,notes_1000 ,counterparty ,transaction_issuer ,transact_guarantor ,treasury_portfolio ,net_cashflows ,tra_actg_treatment ,confo_valid_id ,auto_preview_sw ,confo_review_sw 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
Prompt Table: INSTR_TMPL_H_VW |
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 | 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 |
13 | 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 |
14 | 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 |