TRX_SEC_VW(SQL View) |
Index Back |
|---|---|
Treasury Security Header TableThis table has generic date, number and character fields that can be used by customers based on their requirements. |
| SELECT SECURITY_ID ,TR_SECURITY_TYPE ,CUSIP_ID ,STATUS ,SETTLEMENT_DT ,INTEREST_START_DT ,INTEREST_END_DT ,PERIOD_START_DT ,PERIOD_END_DT ,DESCR150_MIXED ,ISSUER_CD ,ISSUE_DT ,MATURITY_DT ,EST_MATURITY_DT ,ISSUE_AMT ,TRANSACTION_RATE ,REPEAT_INTERVAL ,CR_RATING ,MIN_AMT ,ORIG_AMOUNT ,ASSET_LIABILITY ,CURRENCY_CD ,EVENT_TRACKING_ID ,ORIG_OPRID ,ORIG_DTTM ,LAST_MAINT_DTTM ,LAST_MAINT_OPRID FROM PS_TRX_SEC_HDR WHERE STATUS = 'A' |
| # | 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.
Default Value: NEXT Prompt Table: TRX_SEC_HDR |
| 2 | TR_SECURITY_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Security type - defines the agency that issued the security.
CUSIP, ISIN, ISID, etc are examples of Security type.
01=CUSIP 02=CINS 03=EPIC 04=ISID 05=ISIN 06=QUICK 07=RIC 08=SEDOL 09=SICOVAM 10=Valoren Default Value: 01 |
| 3 | CUSIP_ID | Character(10) | VARCHAR2(10) NOT NULL | CUSIP ID - Used on Security |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 5 | SETTLEMENT_DT | Date(10) | DATE | The settlement date for a given cash -based transaction, or the start date for a Treasury Deal. |
| 6 | INTEREST_START_DT | Date(10) | DATE | The coupon period start date for a given deal transaction. |
| 7 | INTEREST_END_DT | Date(10) | DATE | The coupon period start date for a given deal transaction. |
| 8 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 9 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 10 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 11 | ISSUER_CD | Character(5) | VARCHAR2(5) NOT NULL |
The paper issuer associated with a given bank/counterparty.
Prompt Table: BANK_ISSUER_VW |
| 12 | ISSUE_DT | Date(10) | DATE NOT NULL | Issue Dt |
| 13 | MATURITY_DT | Date(10) | DATE | The maturity date for a deal transaction. |
| 14 | EST_MATURITY_DT | Date(10) | DATE | The estimated maturity date for a security or deal transaction |
| 15 | ISSUE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Issue Amount of a Security |
| 16 | TRANSACTION_RATE | Number(16,8) | DECIMAL(15,8) NOT NULL | The applicable interest rate for a given deal transaction. |
| 17 | REPEAT_INTERVAL | Character(3) | VARCHAR2(3) NOT NULL |
Represents the form of repeating interval (days or months between each Interest payment date)
D01=Daily D07=Weekly D28=Every 28 Days D35=Every 35 Days D49=Every 49 Days M01=Monthly M03=Quarterly M06=Semi-Annual M12=Annual M99=At Maturity |
| 18 | CR_RATING | Character(5) | VARCHAR2(5) NOT NULL | The market credit rating associated wth a given bank/counterparty. |
| 19 | MIN_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Minimum Amount |
| 20 | ORIG_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Outstanding Issue Size |
| 21 | ASSET_LIABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Whether the deal transaction leg represents an asset or a liability
A=Asset L=Liability Default Value: A |
| 22 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 23 | EVENT_TRACKING_ID | Number(10,0) | DECIMAL(10) NOT NULL | The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID. |
| 24 | ORIG_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 25 | ORIG_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the original creation and saving of a given transaction. |
| 26 | LAST_MAINT_DTTM | DateTime(26) | TIMESTAMP | A system generated value that reflects the date and time a transaction was last modified |
| 27 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |