TR_DEAL_FLUID_V(SQL View) |
Index Back |
|---|---|
Deal View Fluid ApprovalTreasury Deal view for Fluid Approval Framework - Page Composer |
| SELECT DISTINCT A.BUSINESS_UNIT , A.TREAS_HEADER_ID , A.INSTRUMENT_TYPE , A.INSTRMNT_TEMPLATE , A.TRANSACTION_DT , A.COUNTERPARTY , A.DESCR150_MIXED , A.TRA_ACTG_TREATMENT , A.TREASURY_PORTFOLIO , %Abs(A.MTM_ACCTG_VALUE_0) , A.MTM_CURRENCY , CPT.DESCR , A.TRANSACTION_DT , CASE WHEN ATT.TREAS_HEADER_ID = ' ' THEN 'N' ELSE 'Y' END , X.ORIGINATORID , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , X.EOAWDTTM_MODIFIED ,'2' , A.CPTY_DEALER , A.CPTY_REFERENCE , A.DEAL_CONF_STATUS , A.FCLTY_ID , A.SECURITY_ID , A.TRP_BUSINESS_UNIT , A.POOL_ID , A.TRANSACTION_ISSUER , A.TRANSACT_GUARANTOR , A.TRANSACTION_BROKER , A.DEALER_OPRID , ' ' , ' ' , ' ' , ' ' 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 WHERE A.BUSINESS_UNIT = X.BUSINESS_UNIT AND A.TREAS_HEADER_ID = X.TREAS_HEADER_ID AND A.COUNTERPARTY_SETID = CPT.SETID AND A.COUNTERPARTY = CPT.COUNTERPARTY |
| # | 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 | INSTRMNT_TEMPLATE | Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier associated with an instrument that describes a separate template version of a pre |
| 5 | TRANSACTION_DT | Date(10) | DATE | Transaction date (often used as trade date) |
| 6 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL | Represents a treasury dealing counterpart. |
| 7 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 8 | 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 |
| 9 | 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. |
| 10 | 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 |
| 11 | MTM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The stated currency for a deal transaction's fair value (mark-to-market) |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | ENTERED_DT | Date(10) | DATE | Entered on |
| 14 | ATTACHMENT_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
Attachments Exist
N=N Y=Y |
| 15 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 16 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 17 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial |
| 18 | EOAWDTTM_MODIFIED | DateTime(26) | TIMESTAMP | Datetime modified |
| 19 | PRIORITY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Priority Flag
1=High 2=Medium 3=Low |
| 20 | CPTY_DEALER | Character(10) | VARCHAR2(10) NOT NULL | The assigned external dealer or trader associated with a given dealing counterparty. |
| 21 | CPTY_REFERENCE | Character(15) | VARCHAR2(15) NOT NULL | A reference identifier associated with a dealing counterparty transaction. |
| 22 | DEAL_CONF_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Reflects the confirmation status of a given deal transaction at any particular point in time.
01=Pending 02=Confirmed 03=Invalid |
| 23 | FCLTY_ID | Character(12) | VARCHAR2(12) NOT NULL | A unique key identifier that represents a given counterparty facility. |
| 24 | SECURITY_ID | Character(10) | VARCHAR2(10) NOT NULL | A reference identifier for a given deal transaction. |
| 25 | TRP_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Pool Business Unit |
| 26 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 27 | TRANSACTION_ISSUER | Character(5) | VARCHAR2(5) NOT NULL | The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre |
| 28 | TRANSACT_GUARANTOR | Character(5) | VARCHAR2(5) NOT NULL | Entity that guarantees the credit worthiness of a financial instrument and its counterparty |
| 29 | TRANSACTION_BROKER | Character(5) | VARCHAR2(5) NOT NULL | "The deal transaction intermediary |
| 30 | DEALER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that originally created and saved a given deal tran |
| 31 | BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business unit description. |
| 32 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 33 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 34 | OPRID_TR | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |