EOPM_SUPD_ITM

(SQL Table)
 Index Back

PUM SCRTY UPD Items

Pum Automated Security Update. Contains items to update and their settings

  • Parent record: EOPM_SUPD_DTL

    • # 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 EOPM_SUPD_ITEM3 Character(70) VARCHAR2(70) NOT NULL PUM Security Update Keyfield Item 3

    Prompt Table: %EDITTABLE3

    7 ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    8 SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
    9 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    10 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
    C=C
    N=N
    Y=Y
    11 DISPLAY_ONLY Character(1) VARCHAR2(1) NOT NULL Display Only
    N=No
    Y=Yes
    12 EOPM_SUPD_ACTION Character(3) VARCHAR2(3) NOT NULL udpate action
    ADD=Add
    DEL=Delete

    Default Value: ADD

    13 ACCESSIBLE Character(1) VARCHAR2(1) NOT NULL Accessible
    14 BCMETHODACCESS Character(4) VARCHAR2(4) NOT NULL BC Method Access
    FULL=Full Access
    NO=No Access
    15 READ_ADS_AGRP Character(1) VARCHAR2(1) NOT NULL Read
    16 WRITE_ADS_AGRP Character(1) VARCHAR2(1) NOT NULL Write
    17 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).