LM_ACT_IDLM_SRCHSESDT_VW(SQL View) |
Index Back |
|---|---|
Search:First Session dateSearch: First session date for all applicable acticities are selected using this view |
| SELECT LM_ACT_ID , MIN(LM_SES_DT) FROM PS_LM_SES GROUP BY LM_ACT_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_SES_DT | Date(10) | DATE | Session Date |