TRX_LOCDEBTD_VW (SQL View)	Index Back
Line of Credit Debt Discount View of Line of Credit Debt that was issued on discount basis

TRX_LOCDEBTD_VW

(SQL View)

Line of Credit Debt Discount

View of Line of Credit Debt that was issued on discount basis

SELECT A.SETID , A.INSTRUMENT_TYPE , B.BUSINESS_UNIT , B.TREAS_HEADER_ID , A.TR_LOC_DEBT_FLG , B.DEAL_STATUS , B.FCLTY_ID , C.TRANSACTION_AMT , C.MATURITY_DT , C.INT_CALCULATION FROM PS_INSTR_HEADER_TR A , PS_TRX_HEADER_TR B , PS_TRX_DETAIL_TR C WHERE A.TR_LOC_DEBT_FLG = 'Y' AND A.INSTRMNT_TEMPLATE = ' ' AND B.DEAL_STATUS IN ('03', '04', '07', '09') AND (C.INT_CALCULATION = 'DS' OR C.INT_CALCULATION = 'DY') AND B.INSTRUMENT_TYPE = A.INSTRUMENT_TYPE AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.TREAS_HEADER_ID = B.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_LOC_DEBT_FLG Character(1) VARCHAR2(1) NOT NULL Flag to mark instrument as being drawn on Line of Credit facility

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

#	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_LOC_DEBT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Flag to mark instrument as being drawn on Line of Credit facility
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