SCP_REG_USER_VW

(SQL View)
 Index Back

Registration links User View


SELECT B.OPRID , A.DISPLAY_ORDER , A.SCP_CONTENT_ID , A.SCP_REG_LINK_TYPE , A.SCP_SUMMARY , A.SCP_DETAIL , A.SCP_GRP_LINK_LBL , A.PORTAL_NAME , A.PORTAL_OBJNAME , A.SUP_OB_TEMPLATE_ID , A.PSIMAGEVER , A.SCP_ICON FROM PS_SCP_REG_VW A , PS_SCP_CONGRPUS_VW B WHERE B.SCP_SECURITY_GROUP = A.SCP_SECURITY_GROUP ORDER BY A.DISPLAY_ORDER

  • Related Language Record: SCP_REGUSER_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 DISPLAY_ORDER Number(3,0) SMALLINT NOT NULL Display order for ordering items in a list - web style
    3 SCP_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Content ID
    4 SCP_REG_LINK_TYPE Character(1) VARCHAR2(1) NOT NULL Registration Link Type: S - Supplier; B - Bidder; U - User;
    B=Bidder
    S=Supplier
    U=User
    5 SCP_SUMMARY Character(254) VARCHAR2(254) NOT NULL Content Summary
    6 SCP_DETAIL Long Character CLOB Content Detail
    7 SCP_GRP_LINK_LBL Character(30) VARCHAR2(30) NOT NULL Group Link Label
    8 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    9 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    10 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

    Prompt Table: SUP_OB_TMPL_RS

    11 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
    12 SCP_ICON Image / Attachment CLOB Registration Links Icon