RSF_CUST_ACC_VW

(SQL View)
 Index Back

Account Access Profile


SELECT CUST_ACCESS_ID , STATUS , DESCR , AACC_ALL_CUST , AACC_PLAN_ADMIN , AACC_TEAM_ADMIN FROM PS_RSF_CUST_ACCESS WHERE STATUS = 'A'

  • Related Language Record: RSF_CST_ACC_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUST_ACCESS_ID Character(15) VARCHAR2(15) NOT NULL Account Access Profiles
    2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 AACC_ALL_CUST Character(1) VARCHAR2(1) NOT NULL View All Accounts

    Y/N Table Edit

    Default Value: N

    5 AACC_PLAN_ADMIN Character(1) VARCHAR2(1) NOT NULL Administer Account Plans

    Y/N Table Edit

    Default Value: N

    6 AACC_TEAM_ADMIN Character(1) VARCHAR2(1) NOT NULL Administer Account Teams

    Y/N Table Edit

    Default Value: N