LM_ADHC_APRVL_INT10=None
20=Standard
50=Learner Selected
LM_ADHC_IDLM_PERSON_IDLM_ADHCSETID_VW(SQL View) |
Index Back |
|---|---|
Get SETID for adhocGet SETID and approval process definition for adhoc learning |
| SELECT C.LM_ADHC_APRVL_INT , C.LM_ADHC_ID , B.LM_PERSON_ID , A.EOAWDEFN_ID FROM PS_LM_LE_SETID_MAP A , PS_LM_PERSON_ATTRB B , PS_LM_ADHC_TBL C WHERE A.LM_LE_ID = B.LM_LE_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ADHC_APRVL_INT |
Character(30) | VARCHAR2(30) NOT NULL |
Adhoc internal approval types
10=None 20=Standard 50=Learner Selected |
| 2 | LM_ADHC_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Id |
| 3 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 4 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |