LM_CI_IDLM_ACT_IDLM_ACT_AUTO2_VW(SQL View) |
Index Back |
|---|---|
Auto-Launch Activities |
| SELECT LM_CI_ID , LM_ACT_ID FROM PS_LM_ACT_AUTO_VW WHERE LM_NFRC_COMP_ORDR = 'N' AND LM_COMP_SEQ_ID = 1 AND LM_START_DT <= %CurrentDateIn AND ((LM_LAUNCHABLE_HIST = 'N') OR (LM_LAUNCHABLE_HIST = 'Y' AND ((LM_END_DT IS NOT NULL AND LM_END_DT <= %CurrentDateIn) OR LM_END_DT IS NULL)) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_CI_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 2 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |