LM_LC_ROST_VW

(SQL View)
 Index Back

Learning Comp Roster View

Learning Component Roster View

SELECT A.LM_ENRLMT_ID , A.LM_LC_ID , D.LM_ACT_ID , B.LM_PERSON_ID , B.FIRST_NAME_SRCH , B.LAST_NAME_SRCH , B.LM_HR_EMPLID , D.LM_ENRL_DT , D.LM_COMPL_DT , D.LM_STTS , B.LM_ACTIVE , B.FIRST_NAME , B.LAST_NAME , B.LM_ORGANIZATION_ID , B.LM_ORG_DESCR , B.LM_ORG_SDESCR , B.LM_ORG_TYPE , B.LM_MANAGER_ID , B.LM_MGR_FIRST_NAME , B.LM_MGR_LAST_NAME , B.LM_JOB_TITLE , B.LM_HIRE_DT , C.LM_LC_LONG_NM , C.LM_LC_TYPE_LONG , C.LM_REQD_FLAG , C.LM_PASS_REQD , A.LM_PASS_VAL_ID , A.LM_LC_COMP_STTS , A.LM_ATT_VAL_ID , A.LM_GRADE_VAL_ID , A.LM_SCORE , C.LM_BAS_LC_TYPE , C.LM_PASS_PCT , C.LM_CMPLNCE , C.LM_COMP_SEQ_ID , C.LM_LAUNCH_URL , B.LM_NAME_DISPLAY ,%subrec(LM_ENLC_FRA_SBR,A) FROM PS_LM_ENR_LC_TBL A , PS_LM_PERS_DTL_VW B , PS_LM_LC_ROUTE_VW C , PS_LM_ENRLMT D WHERE A.LM_ENRLMT_ID = D.LM_ENRLMT_ID AND D.LM_PERSON_ID = B.LM_PERSON_ID AND A.LM_LC_ID = C.LM_LC_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_ACT_ID = D.LM_ACT_ID AND D.LM_STTS IN ('COMP', 'ENRL', 'INCO', 'INPO')

  • Related Language Record: LM_LC_ROST_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
    3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    7 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
    8 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    9 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    10 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
    11 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active
    12 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    13 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    14 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    15 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    16 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    17 LM_ORG_TYPE Character(15) VARCHAR2(15) NOT NULL Organization Type
    18 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    19 LM_MGR_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Manager First Name
    20 LM_MGR_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Manager Last Name
    21 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    22 LM_HIRE_DT Date(10) DATE Hire Date
    23 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
    24 LM_LC_TYPE_LONG Character(200) VARCHAR2(200) NOT NULL Learning Component Type Long Name
    25 LM_REQD_FLAG Character(1) VARCHAR2(1) NOT NULL Learning Component required? - Blended Learning
    26 LM_PASS_REQD Character(1) VARCHAR2(1) NOT NULL Passing Required
    27 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID

    Prompt Table: LM_PASS_SCH_VAL

    28 LM_LC_COMP_STTS Character(4) VARCHAR2(4) NOT NULL Learning Component - Completion Status
    CANC=Dropped
    COMP=Completed
    INCO=Not Completed
    INPO=In-Progress
    NOAT=Not Attempted
    29 LM_ATT_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely

    Prompt Table: LM_ATT_ALL_VW

    30 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.

    Prompt Table: LM_GRD_SCH_VW

    31 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
    32 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
    10=Web-based
    20=Sessions
    30=Webcast
    40=Assignment
    50=Test
    60=Survey
    33 LM_PASS_PCT Number(3,0) SMALLINT NOT NULL this is to store the passing% to be used for compliant courses
    34 LM_CMPLNCE Character(3) VARCHAR2(3) NOT NULL Compliance - This field is used to comply with the Scorm and AICC regulations.
    10=None
    20=AICC-API
    30=AICC-HACP
    40=SCORM11
    50=SCORM12
    60=SCORM2004
    35 LM_COMP_SEQ_ID Number(3,0) SMALLINT NOT NULL Learning Component sequence - Blended Learning
    36 LM_LAUNCH_URL Long Character(2000) VARCHAR2(2000) URL or File path - Holds the URL or File Path name for an activity.
    37 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    38 LM_HRS_TRACK_STTS Character(1) VARCHAR2(1) NOT NULL Hour Tracking Status
    1=Pending Review from ELM Admin.
    2=Approved by ELM Administrator
    3=Pending Review from Payroll
    4=Cancelled
    5=Publish Error
    6=Rejected by Payroll Admin
    7=Finalized

    Default Value: 1

    39 LM_CST_TRACK_STTS Character(1) VARCHAR2(1) NOT NULL Student Cost Status
    1=Ready to Sent to HR/TA
    2=Sent to HR/TA successfully
    3=Canceled
    4=Publish Error
    5=Processed by HR/TA
    6=Processed by HR/TA with Errors
    9=New

    Default Value: 9