DEAL_MTM_WK (SQL Table)	Index Back
Temp Record for TR_DEAL_MTM Used as a temporary table in the TR_DEAL_MTM Application Engine process

DEAL_MTM_WK

(SQL Table)

Temp Record for TR_DEAL_MTM

Used as a temporary table in the TR_DEAL_MTM Application Engine process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 AS_OF_DATE Date(10) DATE As of Date

4 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)

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

6 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)

7 MTM_FN_USAGE Character(2) VARCHAR2(2) NOT NULL This field specifies the specific analytic operation/function to be performed on that instrument type
00=MTM
01=Firm-wide Analysis
02=Convexity
03=Duration
04=MTM-A
05=File Export
06=Delta
07=Risk Measures
08=Sensitivity Analysis
09=Market Risk
10=Credit Risk
11=Operational Risk
12=Strategic Risk
13=Other

8 MTM_MODEL Character(10) VARCHAR2(10) NOT NULL Represents a more granular method by which to establish diverse analytics function usages for a given finan

9 DEAL_MTM Signed Number(28,3) DECIMAL(26,3) NOT NULL The Mark to Market value of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item

10 MTM_ASEF_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The FAS133 para 63 component of Fair Value included in the assessment of effectiveness

11 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

12 MTM_ASEF_VALUE_0 Signed Number(28,3) DECIMAL(26,3) NOT NULL The FAS133 para 63 component of Fair Value included in the assessment of effectiveness initial value)

13 EXISTING_POSN_FLG Character(1) VARCHAR2(1) NOT NULL Existing Position

14 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning

15 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

16 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type

17 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.

18 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	AS_OF_DATE	Date(10)	DATE	As of Date
4	BUSINESS_UNIT_TRX	Character(5)	VARCHAR2(5) NOT NULL	The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
5	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
6	MTM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The stated currency for a deal transaction's fair value (mark-to-market)
7	MTM_FN_USAGE	Character(2)	VARCHAR2(2) NOT NULL	This field specifies the specific analytic operation/function to be performed on that instrument type 00=MTM 01=Firm-wide Analysis 02=Convexity 03=Duration 04=MTM-A 05=File Export 06=Delta 07=Risk Measures 08=Sensitivity Analysis 09=Market Risk 10=Credit Risk 11=Operational Risk 12=Strategic Risk 13=Other
8	MTM_MODEL	Character(10)	VARCHAR2(10) NOT NULL	Represents a more granular method by which to establish diverse analytics function usages for a given finan
9	DEAL_MTM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The Mark to Market value of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item
10	MTM_ASEF_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The FAS133 para 63 component of Fair Value included in the assessment of effectiveness
11	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
12	MTM_ASEF_VALUE_0	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The FAS133 para 63 component of Fair Value included in the assessment of effectiveness initial value)
13	EXISTING_POSN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Existing Position
14	ERROR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Error Type ERR=Stop NON=None WAR=Warning
15	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
16	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type
17	ACCTG_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
18	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.