LM_SUC_TRN_REQ(SQL View) |
Index Back |
---|---|
View for successfuol recordsView to contain Successful aproved records |
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 , ' ' , ' ' , ' ' , %DateNull , C.FIRST_NAME , C.LAST_NAME , 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_PRG_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Program Reg Status
CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning |
5 | LM_ADHC_LRN_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Adhoc Learning Status
COMP=Completed DECL=Denied DROP=Dropped INPO=In-Progress PEAP=Pending Approval PLAN=Planned |
6 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
7 | LM_CONFIRM_ID | Number(10,0) | DECIMAL(10) NOT NULL | Confirmation ID for Activity , Program , Adhoc |
8 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
9 | LM_COMMON_ID | Number(10,0) | DECIMAL(10) NOT NULL | Common Id |
10 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
11 | LM_COMMON_NAME | Character(254) | VARCHAR2(254) NOT NULL | Long Name - Describes the long name of an object |
12 | LM_COMMON_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Type |
13 | LM_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
Type
ACT=Activity ADH=Supplemental CER=Certification CUR=Curriculum |
14 | LM_PYMT_STRNG | Character(254) | VARCHAR2(254) NOT NULL | Payment String |
15 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
16 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
17 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
18 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |