LM_SUC_TRN_REQ

(SQL View)
Index Back

View for successfuol records

View 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