LM_MGR_ADH_VW2

(SQL View)
 Index Back

Manager Adhoc Learning View

Manager Adhoc Learning View

SELECT A.LM_PERSON_ID , A.LM_ADHC_LRN_ID , C.FIRST_NAME , C.LAST_NAME , A.LM_ADHC_TYPE , A.LM_ADHC_LRN_STTS , A.LM_COMPL_DT , A.LM_REQUESTOR_ID , A.LM_PER_TRN_DESCR , A.LM_PER_TRN_NM , A.LM_PER_TRN_ST_DT , A.LM_PER_TRN_ED_DT , A.LM_ENRL_DT , C.LM_NAME_DISPLAY , A.LM_ADHC_ID , A.LM_ACT_REQ , A.LM_INITIATED_DT , A.LM_DROP_DT , A.LM_STTS_CHANGE_DT FROM PS_LM_ADHC_PER_VW A , PS_LM_PERS_DTL_VW C WHERE A.LM_PERSON_ID = C.LM_PERSON_ID

  • Related Language Record: LM_MGR_ADH_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    5 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    6 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
    7 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    8 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    9 LM_PER_TRN_DESCR Character(254) VARCHAR2(254) NOT NULL Personal Training Comments. This field is used in case of Adhoc training. This field will carry the comments on the Course / Catalog Item training the person took.
    10 LM_PER_TRN_NM Character(254) VARCHAR2(254) NOT NULL Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.
    11 LM_PER_TRN_ST_DT Date(10) DATE Start Date of Personal Training
    12 LM_PER_TRN_ED_DT Date(10) DATE End Date of Personal Training
    13 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    14 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    15 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    16 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    17 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.
    18 LM_DROP_DT Date(10) DATE The date on which the Enrollment was dropped.
    19 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date