LM_REQUESTOR_IDLM_DMTHD_TYPE_IDLM_RQ_DMTH_2VW(SQL View) |
Index Back |
|---|---|
View of Deliv Meth TypeTableView of Delivery Method Table LM_DMTH_TYP_TBL |
| SELECT DISTINCT H.LM_PERSON_ID , F.LM_DMTHD_TYPE_ID , F.LM_DM_LONG_NM FROM PS_LM_CI_SEC_TBL C , PS_LM_DMTHD_TBL D , PS_LM_DMTH_TYP_TBL F , PS_LM_PERS_LGRP_VW H WHERE C.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_LM_CI_SEC_TBL X WHERE X.LM_CI_ID = C.LM_CI_ID AND X.EFFDT <= %CurrentDateIn) AND D.LM_CI_ID = C.LM_CI_ID AND D.LM_CI_ID = C.LM_CI_ID AND F.LM_DMTHD_TYPE_ID = D.LM_DMTHD_TYPE_ID AND C.LM_LRNR_GROUP_ID = H.LM_LRNR_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_REQUESTOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Requestor |
| 2 | LM_DMTHD_TYPE_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
| 3 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |