TRX_AF_SRCH_VW

(SQL View)
 Index Back

Deal cross reference record.

Cross refrence table for treasury deal approval using approval framework..

SELECT DISTINCT A.BUSINESS_UNIT ,A.TREAS_HEADER_ID , A.INSTRUMENT_TYPE ,A.TRANSACTION_DT , A.COUNTERPARTY ,A.TRA_ACTG_TREATMENT ,A.TREASURY_PORTFOLIO ,A.MTM_ACCTG_VALUE_0 ,A.MTM_CURRENCY ,CPT.DESCR , U.OPRID ,X.ORIGINATORID , %DatePart(U.DTTM_CREATED) , A.TRANSACTION_DT , CASE WHEN ATT.TREAS_HEADER_ID = ' ' THEN 'N' ELSE 'Y' END FROM PS_TRX_HEADER_TR A , PS_TRX_AF_XREF X LEFT OUTER JOIN PS_TRX_AF_ATTACH ATT ON ATT.BUSINESS_UNIT=X.BUSINESS_UNIT AND ATT.TREAS_HEADER_ID =X.TREAS_HEADER_ID ,PS_BANK_TR_CPTY_VW CPT , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE A.BUSINESS_UNIT=X.BUSINESS_UNIT AND A.TREAS_HEADER_ID =X.TREAS_HEADER_ID AND A.COUNTERPARTY=CPT.COUNTERPARTY AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND U.EOAWSTEP_STATUS ='P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_TRD_NONVW

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

Prompt Table: TRX_HEADER_TR

3 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
4 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)
5 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
6 TRA_ACTG_TREATMENT Character(2) VARCHAR2(2) NOT NULL Treasury Deal Accounting Treatment. Edit Translates on this field to alter the Accounting Treatments available. (Not quite a control table, but as good as it gets!)
01=Held to Maturity
02=Available for Sale
03=Trading
04=Other
05=Loans and Receivables
7 TREASURY_PORTFOLIO Character(15) VARCHAR2(15) NOT NULL A unique key identifier for a position portfolio that may be associated with a given deal transaction.
8 MTM_ACCTG_VALUE_0 Signed Number(28,3) DECIMAL(26,3) NOT NULL The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction
9 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
12 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
13 EOAWSTART_DT Date(10) DATE Start Date
14 ENTERED_DT Date(10) DATE Entered on
15 ATTACHMENT_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments Exist
N=N
Y=Y