CAF_ACC_ACT_VW

(SQL View)
 Index Back

SELECT c.caf_config_type , c.caf_config_id , c.caf_access_lvl , c.caf_access_lvl_val , ' ' , c.caf_all_action_flg FROM PS_CAF_ACC_CTL_TBL c WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl IN ('P','U') AND c.caf_all_action_flg = 'Y' UNION SELECT c.caf_config_type , c.caf_config_id , c.caf_access_lvl , c.caf_access_lvl_val , f.caf_action_id , c.caf_all_action_flg FROM PS_CAF_ACC_CTL_TBL c , ps_caf_acc_act_tbl f WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl IN ('P','U') AND c.caf_all_action_flg <> 'Y' AND f.caf_config_type = c.caf_config_type AND f.caf_config_id = c.caf_config_id AND f.caf_access_lvl = c.caf_access_lvl AND f.caf_access_lvl_val = c.caf_access_lvl_val UNION SELECT c.caf_config_type , c.caf_config_id , 'U' , r.roleuser , ' ' , c.caf_all_action_flg FROM PS_CAF_ACC_CTL_TBL c , psroleuser r WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl = 'R' AND c.caf_all_action_flg = 'Y' AND c.caf_access_lvl_val = r.rolename UNION SELECT c.caf_config_type , c.caf_config_id ,'U' , r.roleuser , f.caf_action_id , c.caf_all_action_flg FROM PS_CAF_ACC_CTL_TBL c , ps_caf_acc_act_tbl f , psroleuser r WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl = 'R' AND c.caf_all_action_flg <> 'Y' AND f.caf_config_type = c.caf_config_type AND f.caf_config_id = c.caf_config_id AND f.caf_access_lvl = c.caf_access_lvl AND f.caf_access_lvl_val = c.caf_access_lvl_val AND c.caf_access_lvl_val = r.rolename

  • Parent record: CAF_ACC_CTL_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAF_CONFIG_TYPE Character(4) VARCHAR2(4) NOT NULL Analysis Type
    RTBL=Real Time Bottom Line
    SYS=System
    USER=User Defined

    Default Value: USER

    2 CAF_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Analysis ID
    3 CAF_ACCESS_LVL Character(1) VARCHAR2(1) NOT NULL Access Level
    P=Public
    R=Role
    U=User
    4 CAF_ACCESS_LVL_VAL Character(30) VARCHAR2(30) NOT NULL Access Level Value
    5 CAF_ACTION_ID Character(30) VARCHAR2(30) NOT NULL Action ID
    6 CAF_ALL_ACTION_FLG Character(1) VARCHAR2(1) NOT NULL All Actions

    Y/N Table Edit

    Default Value: N