CAF_ACC_FCT_VW

(SQL View)

SELECT c.caf_config_type , c.caf_config_id , c.caf_access_lvl , c.caf_access_lvl_val , ' ' , c.caf_all_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_flg = 'Y' UNION SELECT c.caf_config_type , c.caf_config_id , c.caf_access_lvl , c.caf_access_lvl_val , f.caf_factor_id , c.caf_all_flg FROM ps_caf_acc_ctl_tbl c , ps_caf_acc_fct_tbl f WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl IN ('P','U') AND c.caf_all_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_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_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_factor_id , c.caf_all_flg FROM ps_caf_acc_ctl_tbl c , ps_caf_acc_fct_tbl f , PSROLEUSER r WHERE c.caf_enabled_flg = 'Y' AND c.caf_access_lvl = 'R' AND c.caf_all_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_FACTOR_ID Character(30) VARCHAR2(30) NOT NULL Factor ID

6 CAF_ALL_FLG Character(1) VARCHAR2(1) NOT NULL All Factors

#	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_FACTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Factor ID
6	CAF_ALL_FLG	Character(1)	VARCHAR2(1) NOT NULL	All Factors