MTM_FLXP_XL_LNG(SQL View) |
Index Back |
---|---|
MTM Filexp XLAT LNG VWThis view displays all the function usage values for the filexport one('05'). |
SELECT %Substring(A.FIELDVALUE,1,2) , C.LANGUAGE_CD , C.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG C WHERE A.FIELDNAME = 'MTM_FN_USAGE' AND A.FIELDVALUE IN ('05') AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn) AND A.FIELDNAME = C.FIELDNAME AND A.FIELDVALUE = C.FIELDVALUE AND A.EFFDT = C.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |