LM_MGR_ADHC_VW

(SQL View)
 Index Back

Manager Adhoc Learning View

Manager Adhoc Learning View

SELECT B.OPRID , B.LM_MANAGER_ID , 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_MGR_SRCH_VW B , PS_LM_PERS_DTL_VW C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND C.LM_ACTIVE='Y'

  • Related Language Record: LM_MGR_ADHC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    7 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    8 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
    9 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    10 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    11 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.
    12 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.
    13 LM_PER_TRN_ST_DT Date(10) DATE Start Date of Personal Training
    14 LM_PER_TRN_ED_DT Date(10) DATE End Date of Personal Training
    15 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    16 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    17 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    18 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

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