EOCF_LOG_SET_VW

(SQL View)
Index Back

SELECT X.FIELDVALUE , X.XLATLONGNAME , X.XLATSHORTNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'EOCF_DL_LOGTYPE' AND X.EFFDT = ( SELECT MAX(X2.EFFDT) FROM PSXLATITEM X2 WHERE X2.FIELDNAME = X.FIELDNAME AND X2.EFFDT <= %CurrentDateIn) AND X.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOCF_DL_LOGTYPE Character(4) VARCHAR2(4) NOT NULL Rule Engine Log Type
00=Processing Messages
0100=Term Resolution
0200=Context Generation
0300=Bind Substitution
0400=Cache Management
0500=Object Factory Processing
2 EOCF_LOG_SET_DESCR Character(30) VARCHAR2(30) NOT NULL Log Setting
3 EOCF_LOG_SET_SHORT Character(10) VARCHAR2(10) NOT NULL Log Setting