RSF_SUSERPER_VW

(SQL View)
Index Back

Sales User Add Person View

Add mode sales user person prompt view...............

SELECT P.PERSON_ID , B.BO_NAME , P.TITLE , P.EMPLID FROM PS_RD_PERSON P , PS_BO_NAME B WHERE P.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

  • Related Language Record: RSF_SUSERPERLVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Default Value: NEXT

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID