TRX_LOCUNDM2_VW (SQL View)	Index Back
Line of Credit Maturity Amount View of Line of Credit (LOC) principal payments for LOC Deals issued on interest bearing basis and subsequently de-activated.

TRX_LOCUNDM2_VW

(SQL View)

Line of Credit Maturity Amount

View of Line of Credit (LOC) principal payments for LOC Deals issued on interest bearing basis and subsequently de-activated.

SELECT D.BUSINESS_UNIT , D.TR_SOURCE_CD , D.TR_SOURCE_ID , F.AS_OF_DATE FROM PS_TRX_DETAIL_TR C , PS_TRX_POSITION_TR D , PS_TRX_UNDO_DL_LST F WHERE D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.TR_SOURCE_ID = C.TREAS_HEADER_ID AND F.BUSINESS_UNIT = D.BUSINESS_UNIT AND F.TREAS_HEADER_ID = D.TR_SOURCE_ID AND F.AS_OF_DATE = D.PERIOD_END_DT AND F.AS_OF_DATE <= C.MATURITY_DT UNION SELECT D.BUSINESS_UNIT , D.TR_SOURCE_CD , D.TR_SOURCE_ID , C.MATURITY_DT FROM PS_TRX_DETAIL_TR C , PS_TRX_POSITION_TR D , PS_TRX_UNDO_DL_LST F WHERE D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.TR_SOURCE_ID = C.TREAS_HEADER_ID AND F.BUSINESS_UNIT = D.BUSINESS_UNIT AND F.TREAS_HEADER_ID = D.TR_SOURCE_ID AND D.PERIOD_END_DT = C.MATURITY_DT AND F.AS_OF_DATE > C.MATURITY_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers

3 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

4 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers
3	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
4	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.