PC_AM_RULE1_VW(SQL View) |
Index Back |
|---|---|
PC AM Exp: Rule viewViews 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' , C.BUSINESS_UNIT , 'NEXT' , 'I' , 'I' , C.OPRID FROM PS_PC_AM_RULE_ACT A , PS_OPR_DEF_TBL_FS C , PS_PROJ_ACTIVITY D WHERE 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)) AND %Join(COMMON_KEYS, PC_AM_RULE_ACT A, PROJ_ACTIVITY D) AND D.COSTING_ACT_SW = 'Y' |
| # | 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 | PC_AM_CAP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Enable Integration
N=No Y=Yes |
| 5 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 6 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 7 | DEFN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Definition Flag |
| 8 | PROJ_DEFN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Definition Flag |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |