EOCF_EVTYP_PLVW

(SQL View)
Index Back

event type prompt view

event type prompt view

SELECT A.EOCF_EVENT_TYPE_ID , A.LANGUAGE_CD , A.EOCF_EVTYP_NAME FROM PS_EOCF_EVTYPE_LNG A , PS_EOCF_EVENT_TYPE B WHERE A.EOCF_EVENT_TYPE_ID = B.EOCF_EVENT_TYPE_ID AND B.STATUS = 'A'

  • Related Language Record for EOCF_EVTYPSELVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCF_EVENT_TYPE_ID Number(31,0) DECIMAL(31) NOT NULL what kind of event is this
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EOCF_EVTYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action