LM_ROW_MAINT_OPRIDLM_OPR_PER_VW(SQL View) |
Index Back |
|---|---|
Row Maintain OPRID PersonContains the Person ID for every LM_ROW_MAINT_OPRID |
| SELECT A.OPRID , C.LM_PERSON_ID FROM PS_LM_PERSON_OPRID A , PS_LM_CURR_JOB_VW C WHERE C.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND C.LM_ACTIVE = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ROW_MAINT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |
| 2 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |