LM_ACT_IDLM_CI_IDLM_SRCH_CIDELVW(SQL View) |
Index Back |
|---|---|
Deleted Catalog ItemsThis has all the deleted catalog items and catalog items that have been set as NOT active. Select catalog items that were previously set with inactive classes. Now, the activities that are active. Therefore, set maximum datestamp is derived to so that the catalog items that have active are selected for deletion on SES indexing. These are rows where LM_CI_ID is set but LM_ACT_ID is set to zero. |
| SELECT 0 , LM_CI_ID , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID FROM PS_LM_CI_DEL_TBL UNION SELECT 0 , LM_CI_ID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_CI_TBL WHERE %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT AND LM_CI_STATUS <> '10' UNION SELECT 0 , LM_CI_ID , MAX(LM_ROW_MAINT_DTTM) , ' ' FROM PS_LM_ACT WHERE LM_ACT_STATUS = '1' AND LM_START_DT <= %CurrentDateIn AND (LM_END_DT IS NULL OR (LM_END_DT IS NOT NULL AND LM_END_DT >= %CurrentDateIn) ) GROUP BY LM_CI_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 3 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 4 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |