EOPM_SUPD_DTLVW

(SQL View)
 Index Back

PUM Secrty Upd - Export View

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 ,PROJECTNAME ,EOPM_SELECTED ,'2' ,EOPM_STATUS_DT ,ACTION_ADD ,ACTION_UPDT_DISP ,ACTION_UPDTDISPALL ,ACTION_CORRECTION ,EOPM_SUPD_ACTION ,EOPM_SUPD_LOADED ,0 ,'PPLSOFT' ,%CurrentDateTimeIn ,DESCRLONG FROM PS_EOPM_SUPD_DTL

  • Related Language Record: EOPM_SUPDDLNGV

    • # 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).

    Prompt Table: PSCLASSDEFN_SRC

    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

    Prompt Table: %EDITTABLE

    4 EOPM_SUPD_ITEM2 Character(30) VARCHAR2(30) NOT NULL PUM Security Update Keyfield Item 2

    Prompt Table: %EDITTABLE2

    5 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
    6 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    7 EOPM_SELECTED Character(1) VARCHAR2(1) NOT NULL selected

    Default Value: Y

    8 EOPM_STATUS Character(1) VARCHAR2(1) NOT NULL set status of PUM security project
    1=New
    2=Imported
    3=Changed
    4=Processing
    5=Applied
    6=Error
    7=Tested

    Default Value: 1

    9 EOPM_STATUS_DT Date(10) DATE status date of PUM security project
    10 ACTION_ADD Character(1) VARCHAR2(1) NOT NULL Add
    0=No Add
    1=Add

    Default Value: 0

    11 ACTION_UPDT_DISP Character(1) VARCHAR2(1) NOT NULL Update/Display
    0=No Update Display
    2=Update Display

    Default Value: 0

    12 ACTION_UPDTDISPALL Character(1) VARCHAR2(1) NOT NULL Update/Display All
    0=No Display All
    4=Update Display All

    Default Value: 0

    13 ACTION_CORRECTION Character(1) VARCHAR2(1) NOT NULL Correction
    0=No Correction
    8=Correction

    Default Value: 0

    14 EOPM_SUPD_ACTION Character(3) VARCHAR2(3) NOT NULL udpate action
    ADD=Add
    DEL=Delete

    Default Value: ADD

    15 EOPM_SUPD_LOADED Character(1) VARCHAR2(1) NOT NULL items are loaded.

    Default Value: N

    16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    19 DESCRLONG Long Character CLOB Long Description