LM_REQUESTOR_IDLM_DMTHD_TYPE_IDLM_RQ_DMTH_VW(SQL View) |
Index Back |
|---|---|
View of Deliv Meth TypeTableView of Delivery Method Table LM_DMTH_TYP_TBL |
| SELECT DISTINCT B.LM_PERSON_ID , F.LM_DMTHD_TYPE_ID , B.OPRID , F.LM_DM_LONG_NM FROM PS_LM_CI_SEC_TBL C , PS_LM_DMTHD_TBL D , PS_LM_CI_TBL E , PS_LM_PERSON_OPRID B , PS_LM_DMTH_TYP_TBL F , PS_LM_PERS_LGRP_VW H WHERE D.EFFDT BETWEEN E.EFFDT AND E.LM_END_EFFDT AND D.LM_CI_ID=C.LM_CI_ID AND C.LM_CI_ID = E.LM_CI_ID AND C.EFFDT=E.EFFDT AND D.LM_CI_ID=E.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 AND B.LM_PERSON_ID = H.LM_PERSON_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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | LM_DM_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - the long name of a Delivery Method Type |