SECURITY_IDPrompt Table: TRX_SEC_HDR
MTM_VENDOR_NMPrompt Table: MTM_PRODNM_TBL
RT_TYPEPrompt Table: RT_TYPE_TBL
MARKET_DTEFFSEQTRX_SEC_MKTVAL(SQL Table) |
Index Back |
|---|---|
Treasury Security Market ValueTreasury Security Market Value |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SECURITY_ID |
Character(10) | VARCHAR2(10) NOT NULL |
A reference identifier for a given deal transaction.
Prompt Table: TRX_SEC_HDR |
| 2 | MTM_VENDOR_NM |
Character(20) | VARCHAR2(20) NOT NULL |
3rd party analytics vendor used for valuation and analytics.
Prompt Table: MTM_PRODNM_TBL |
| 3 | RT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 4 | MARKET_DT |
Date(10) | DATE NOT NULL | User Defined Date Field |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | MKT_PRICE | Number(14,8) | DECIMAL(13,8) NOT NULL | Market Price |
| 7 | PURCH_INTEREST | Number(14,8) | DECIMAL(13,8) NOT NULL | Purchase Interest |
| 8 | ORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 9 | ORIG_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the original creation and saving of a given transaction. |
| 10 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 11 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |