LM_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 | Character(30) | VARCHAR2(30) NOT NULL |
Adhoc internal approval types
10=None 20=Standard 50=Learner Selected |
|
2 | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Id | |
3 | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID | |
4 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |