EOPM_SUPDDLNGV

(SQL View)
 Index Back

Details Table language export

Contains security changes by type. Keys by type: Page: menu, barname, itemname (component) CI: Name of CI (BCNAME) ADS (Tree Name) QUERY (Tree Name)

SELECT CLASSID ,EOPM_SUPD_TYPE ,EOPM_SUPD_ITEM1 ,EOPM_SUPD_ITEM2 ,PTIASPRPTNO ,LANGUAGE_CD ,DESCRLONG FROM PS_EOPM_SUPDDLNG

  • Related Language Record for EOPM_SUPD_DTLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
    2 EOPM_SUPD_TYPE Character(4) VARCHAR2(4) NOT NULL PUM Security Update Automation. Type of update to run
    ACM=Autom. Config Template
    ADS=Data Migration
    ASER=Application Services
    CI=Component Interface
    PAGE=Page
    PRCS=Process Groups
    QRY=Query
    ROLE=Role
    SES=Search Groups
    WLIB=Web Library
    WSER=Web Service
    3 EOPM_SUPD_ITEM1 Character(30) VARCHAR2(30) NOT NULL PUM Security Update Keyfield Item 1
    4 EOPM_SUPD_ITEM2 Character(30) VARCHAR2(30) NOT NULL PUM Security Update Keyfield Item 2
    5 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCRLONG Long Character CLOB Long Description