MTM_STRUC_PARM (SQL Table)	Index Back
Mtm Structure Detail Table

MTM_STRUC_PARM

(SQL Table)

Mtm Structure Detail Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MTM_STRUCT Character(20) VARCHAR2(20) NOT NULL A unique key identifier value that represents a complex data object (rows and columns) intended to contain mult
Prompt Table: MTM_STRUCHDR_VW

2 MTM_STRUC_SEQ Number(3,0) SMALLINT NOT NULL A sequential value utilized to identify the number of rows contained in an analytics parameter structure matr

3 MTM_FLD_NM Character(20) VARCHAR2(20) NOT NULL A database field name utilized in describing a matrix component of a user defined analytics input data structu

4 MTM_DATA_TYPE Character(2) VARCHAR2(2) NOT NULL The underlying database field datatype for those fields utilized in the Treasury risk module.
00=Number
01=Character
02=Date
03=Structure
Prompt Table: MTM_STRUC_XL_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MTM_STRUCT	Character(20)	VARCHAR2(20) NOT NULL	A unique key identifier value that represents a complex data object (rows and columns) intended to contain mult Prompt Table: MTM_STRUCHDR_VW
2	MTM_STRUC_SEQ	Number(3,0)	SMALLINT NOT NULL	A sequential value utilized to identify the number of rows contained in an analytics parameter structure matr
3	MTM_FLD_NM	Character(20)	VARCHAR2(20) NOT NULL	A database field name utilized in describing a matrix component of a user defined analytics input data structu
4	MTM_DATA_TYPE	Character(2)	VARCHAR2(2) NOT NULL	The underlying database field datatype for those fields utilized in the Treasury risk module. 00=Number 01=Character 02=Date 03=Structure Prompt Table: MTM_STRUC_XL_VW