EOPM_SUPD_RLEVW

(SQL View)
 Index Back

Rule Updates Export View

automates adding or deleting roles

SELECT ROLENAME ,CLASSID ,PTIASPRPTNO ,EOPM_SELECTED ,'2' ,EOPM_STATUS_DT ,EOPM_SUPD_ACTION ,0 ,'PPLSOFT' ,%CurrentDateTimeIn ,DESCRLONG FROM PS_EOPM_SUPD_RLE

  • Related Language Record: EOPM_SUPDRLNGV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_SRCH

    2 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

    Prompt Table: PSCLASSDEFN_SRC

    3 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
    4 EOPM_SELECTED Character(1) VARCHAR2(1) NOT NULL selected

    Default Value: Y

    5 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

    6 EOPM_STATUS_DT Date(10) DATE status date of PUM security project
    7 EOPM_SUPD_ACTION Character(3) VARCHAR2(3) NOT NULL udpate action
    ADD=Add
    DEL=Delete

    Default Value: ADD

    8 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    9 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.
    10 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.
    11 DESCRLONG Long Character CLOB Long Description