TRX_CPINTA_VW(SQL View) |
Index Back |
---|---|
Daily Interest for CP dealsUsed to calculate total interest using from and to dates for commercial paper that have issued on a CP facility. Total interest used in calculating estimated cost of funds of CP issued |
SELECT A.SETID , B.FCLTY_ID , D.TRX_YEAR_NUM , D.TRX_DAY_OF_YR_NUM , D.CALENDAR_DATE , D.CALENDAR_DATE , C.POSITION_CURRENCY , %Round((%DecDiv(%DecMult(PERIOD_INT_ACCRUAL,(%DateDiff(PD_INT_START_DT, CALENDAR_DATE) + 1)), %DateDiff(PD_INT_START_DT, PERIOD_END_DT) ) - %DecDiv(%DecMult(PERIOD_INT_ACCRUAL, %DateDiff(PD_INT_START_DT, CALENDAR_DATE) ), %DateDiff( PD_INT_START_DT, PERIOD_END_DT))),3) , %Round((%DecDiv(%DecMult(DISCOUNT_AMT,(%DateDiff(PD_INT_START_DT, CALENDAR_DATE) + 1)), %DateDiff(PD_INT_START_DT, PERIOD_END_DT) ) - %DecDiv(%DecMult(DISCOUNT_AMT, %DateDiff(PD_INT_START_DT, CALENDAR_DATE) ), %DateDiff( PD_INT_START_DT, PERIOD_END_DT))),3) ,C.BUSINESS_UNIT ,C.TR_SOURCE_ID FROM PS_INSTR_HEADER_TR A , PS_TRX_HEADER_TR B , PS_TRX_POSITION_TR C , PS_POS_DAYS_TBL D WHERE A.TR_CP_ISSUE_FLG = 'Y' AND B.INSTRUMENT_TYPE = A.INSTRUMENT_TYPE AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.TR_SOURCE_ID = B.TREAS_HEADER_ID AND C.TR_SOURCE_CD='D' AND D.CALENDAR_DATE >= C.PERIOD_START_DT AND D.CALENDAR_DATE < C.PERIOD_END_DT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | FCLTY_ID | Character(12) | VARCHAR2(12) NOT NULL | A unique key identifier that represents a given counterparty facility. |
3 | TRX_YEAR_NUM | Number(4,0) | SMALLINT NOT NULL | Year in numeric form |
4 | TRX_PERIOD_NUM | Number(3,0) | SMALLINT NOT NULL | Period |
5 | FROM_DATE | Date(10) | DATE | From Date |
6 | TO_DATE | Date(10) | DATE | To Date |
7 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
8 | ACCRUED_INT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The periodic amount of accrued interest for a given deal transaction. |
9 | BOND_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount for Straightline Bond |
10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
11 | TR_SOURCE_ID | Character(12) | VARCHAR2(12) NOT NULL | An internal work field that represents a unique identifier for records depicting a given treasury po |