EP_MISSION_LANG

(SQL View)
 Index Back

Mission Statement - Rel Lang

Mission Statement related language record is used to store the related language for the EP_MISSION_TBL record.

SELECT JPM_CAT_ITEM_ID ,EFFDT ,LANGUAGE_CD ,%Substring(JPM_DESCR90,1,60) ,JPM_TEXT1325_1 FROM PS_JPM_CAT_ITM_LNG WHERE JPM_CAT_TYPE = 'MISSION'

  • Related Language Record for EP_MISSION_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
    5 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance