LM_USUC_TRN_REQ(SQL View) |
Index Back |
|---|---|
View for Unsuccessful recordsView to contain Unsuccessful records for approval |
| SELECT A.LM_APPR_ID , A.LM_ACT_REQ , A.LM_STTS , B.LM_ACT_STATUS , A.LM_ENRLMT_ID , A.LM_PERSON_ID , A.LM_ACT_ID , A.LM_ACT_FEE , B.LM_CS_LONG_NM , ' ' , ' ' , ' ' , C.FIRST_NAME , C.LAST_NAME , '' , C.LM_JOB_TITLE , C.LM_ORG_SDESCR , %DateNull , C.LM_NAME_DISPLAY FROM PS_LM_ENRLMT A , PS_LM_ACT_CI_VW B , PS_LM_PERS_DTL_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_APPR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approver ID field |
| 2 | LM_ACT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes |
| 3 | LM_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted |
| 4 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 5 | LM_CONFIRM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Confirmation ID for Activity , Program , Adhoc |
| 6 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 7 | LM_COMMON_ID | Number(10,0) | DECIMAL(10) NOT NULL | Common Id |
| 8 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 9 | LM_COMMON_NAME | Character(254) | VARCHAR2(254) NOT NULL | Long Name - Describes the long name of an object |
| 10 | LM_COMMON_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Type |
| 11 | LM_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
Type
ACT=Activity ADH=Supplemental CER=Certification CUR=Curriculum |
| 12 | LM_PYMT_STRNG | Character(254) | VARCHAR2(254) NOT NULL | Payment String |
| 13 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 14 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 15 | LM_ERR_MSG | Long Character(2000) | VARCHAR2(2000) | Error Message |
| 16 | LM_JOB_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 17 | LM_ORG_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Organization Short Description |
| 18 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 19 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |