TRX_LOCDEBTA_VW (SQL View)	Index Back
All Line of Credit Debt View of all Line of Credit Debt that was issued on Line of Credit facilities

TRX_LOCDEBTA_VW

(SQL View)

All Line of Credit Debt

View of all Line of Credit Debt that was issued on Line of Credit facilities

SELECT DISTINCT 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.TRANSACT_CURRENCY , C.TRANSACTION_RATE , C.INT_BASIS , C.SETTLEMENT_DT , C.MATURITY_DT , C.INT_CALCULATION FROM PS_INSTR_HEADER_TR A , PS_TRX_HEADER_TR B , PS_TRX_DETAIL_TR C , PS_SET_CNTRL_REC D WHERE A.TR_LOC_DEBT_FLG = 'Y' AND B.DEAL_STATUS IN ('03', '04', '07', '09', '05') AND B.INSTRUMENT_TYPE = A.INSTRUMENT_TYPE AND B.INSTRMNT_TEMPLATE = A.INSTRMNT_TEMPLATE AND D.SETCNTRLVALUE = B.BUSINESS_UNIT AND D.REC_GROUP_ID = 'TR_01' AND D.RECNAME = 'INSTR_HEADER_TR' AND D.SETID = A.SETID 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 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal

10 TRANSACTION_RATE Number(16,8) DECIMAL(15,8) NOT NULL The applicable interest rate for a given deal transaction.

11 INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual

12 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.

13 MATURITY_DT Date(10) DATE The maturity date for a deal transaction.

14 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	TRANSACT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"The nominal
10	TRANSACTION_RATE	Number(16,8)	DECIMAL(15,8) NOT NULL	The applicable interest rate for a given deal transaction.
11	INT_BASIS	Character(2)	VARCHAR2(2) NOT NULL	Day Count Basis 30=30/360 3E=30E/360 A0=Actual/360 A5=Actual/365 AA=Actual/Actual
12	SETTLEMENT_DT	Date(10)	DATE	The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
13	MATURITY_DT	Date(10)	DATE	The maturity date for a deal transaction.
14	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