EOCF_LOGSET_LVW

(SQL View)
 Index Back

EOCF_LOGSET_VW rel lang

Related language view for EOCF_LOGSET_VW

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

  • Related Language Record for EOCF_LOG_SET_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOCF_LOG_SET_DESCR Character(30) VARCHAR2(30) NOT NULL Log Setting
    4 EOCF_LOG_SET_SHORT Character(10) VARCHAR2(10) NOT NULL Log Setting