TRX_COMPAPRF_VW(SQL View) |
Index Back |
|---|---|
Commercial Paper Fixd/FloatingView of Commercial Paper (CP) Principal balances for CP Deals issued on interest bearing basis. |
| SELECT A.SETID , A.INSTRUMENT_TYPE , B.BUSINESS_UNIT , B.TREAS_HEADER_ID , A.TR_CP_ISSUE_FLG , B.DEAL_STATUS , B.FCLTY_ID , C.TRANSACTION_AMT , C.MATURITY_DT , C.INT_CALCULATION , D.PERIOD_END_DT , D.PERIOD_START_DT , PRINCIPAL_BALANCE FROM PS_INSTR_HEADER_TR A , PS_TRX_HEADER_TR B , PS_TRX_DETAIL_TR C , PS_TRX_POSITION_TR D WHERE A.TR_CP_ISSUE_FLG = 'Y' AND C.INT_CALCULATION = 'AR' AND B.DEAL_STATUS IN ('03', '04', '07', '09') AND B.INSTRUMENT_TYPE = A.INSTRUMENT_TYPE AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.TREAS_HEADER_ID = B.TREAS_HEADER_ID AND D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.TR_SOURCE_ID = C.TREAS_HEADER_ID |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | TREAS_HEADER_ID |
Character(12) | VARCHAR2(12) NOT NULL | The unique key identifier for a given deal transaction. |
| 5 | 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 |
| 6 | DEAL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation 02=Sample 03=Open 04=Matured 05=Deactivated 06=Rejected 07=Sold / Bought back 08=Forecasted 09=Partially Sold/Bought Back |
| 7 | FCLTY_ID | Character(12) | VARCHAR2(12) NOT NULL | A unique key identifier that represents a given counterparty facility. |
| 8 | TRANSACTION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal or actual deal transaction amount. |
| 9 | MATURITY_DT | Date(10) | DATE | The maturity date for a deal transaction. |
| 10 | INT_CALCULATION | Character(2) | VARCHAR2(2) NOT NULL |
Interest calculation method for financial instruments.
AR=Interest Bearing CD=Canadian Discount DS=Straight Discount DY=Discount to Yield |
| 11 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 12 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 13 | PRINCIPAL_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The notional principal balance of a given deal transaction at commencement. |