PC_AM_RULE3_VW

(SQL View)
 Index Back

PC AM Exp: Rule view

Views all activity level rules that do not yet have a row in the "relate" table.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , 'N' , 'Y' , 'N' FROM PS_PC_AM_RULE_ACT A , PS_PROJ_ACTIVITY C WHERE A.PC_AM_CAP_SW = 'Y' AND %Join(COMMON_KEYS, PC_AM_RULE_ACT A, PROJ_ACTIVITY C) AND C.COSTING_ACT_SW = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_PC_AM_PROJ_DEFN B WHERE %Join(COMMON_KEYS, PC_AM_RULE_ACT A, PC_AM_PROJ_DEFN B))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 INCLUDE_ACT_SW Character(1) VARCHAR2(1) NOT NULL Include this Activity
N=No
Y=Yes
5 PC_AM_CAP_SW Character(1) VARCHAR2(1) NOT NULL Enable Integration
N=No
Y=Yes
6 PROJ_DEFN_FLAG Character(1) VARCHAR2(1) NOT NULL Project Definition Flag