LM_ADH_APR_VW

(SQL View)
 Index Back

Adhoc Approval View

This view is used for the Mobile Approval for Supplemental Learning

SELECT M.LM_ADHC_LRN_ID , M.LM_PRVD_BY , M.LM_SUP_BY , M.LM_CEU , M.LM_FRE_FLD_FOUR , M.LM_FRE_FLD_ONE , M.LM_FRE_FLD_THREE , M.LM_FRE_FLD_TWO , M.LM_ADHC_ID , M.LM_PERSON_ID , M.LM_PER_TRN_NM , M.LM_ADHC_LRN_STTS , M.LM_PER_TRN_DESCR , M.LM_PER_TRN_ST_DT , M.LM_PER_TRN_ED_DT , M.LM_PER_TRN_LOC , M.LM_PER_TRN_INST , M.CURRENCY_CD , M.LM_ACT_FEE , M.LM_APPR_ID , M.LM_APPROVED_ON , M.LM_REQUESTOR_ID , M.LM_ACT_REQ , M.LM_INITIATED_DT , M.LM_ENRL_DT , M.LM_DROP_DT , M.LM_COMPL_DT , M.LM_STTS_CHANGE_DT , M.LM_STD_HRS , M.LM_TRVL_HRS , M.LM_IS_APPR_LAUNCHD , M.LM_DIFELIGIBLE_FLG , M.LM_TRAINING_CLASS , M.LM_TRG_PLN_CTGY , M.LM_HRS_TRACK_STTS , M.LM_ISELIG_TRN_RPT , M.LM_FLAT_COST , M.LM_ESTIMATED_HOURS , M.LM_OBJV_ID , M.LM_HR_COMPANY , M.LM_LE_ID , M.LM_ORGANIZATION_ID , T.LM_ADHC_TYPE , D.EOAWSTEP_STATUS , D.OPRID , D.EOAWORIG_OPRID , %DatePart(D.EOAWDTTM_MODIFIED) , S.EOAWTHREAD_ID , D.EOAWDTTM_COMPLETE , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , D.EOAWDTTM_MODIFIED , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTEP_NBR FROM PS_LM_ADHC_LRN_TBL M , PS_LM_ADHC_TBL T , PS_LM_ADH_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE T.LM_ADHC_ID = M.LM_ADHC_ID AND %CurrentDateIn BETWEEN T.EFFDT AND T.LM_END_EFFDT AND M.LM_ADHC_LRN_ID = X.LM_ADHC_LRN_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE

  • Related Language Record: LM_ADH_APR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    2 LM_PRVD_BY Character(30) VARCHAR2(30) NOT NULL Provided By
    3 LM_SUP_BY Character(30) VARCHAR2(30) NOT NULL Supervised By
    4 LM_CEU Number(8,2) DECIMAL(7,2) NOT NULL Continuing Education Units
    5 LM_FRE_FLD_FOUR Character(50) VARCHAR2(50) NOT NULL Free Field Four
    6 LM_FRE_FLD_ONE Character(50) VARCHAR2(50) NOT NULL Free Field One
    7 LM_FRE_FLD_THREE Character(50) VARCHAR2(50) NOT NULL Free Field Three
    8 LM_FRE_FLD_TWO Character(50) VARCHAR2(50) NOT NULL Free Field Two
    9 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    10 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    11 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.
    12 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
    13 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.
    14 LM_PER_TRN_ST_DT Date(10) DATE Start Date of Personal Training
    15 LM_PER_TRN_ED_DT Date(10) DATE End Date of Personal Training
    16 LM_PER_TRN_LOC Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Location
    17 LM_PER_TRN_INST Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Institution
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    19 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    20 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field

    Prompt Table: %EDITTABLE

    21 LM_APPROVED_ON DateTime(26) TIMESTAMP The date on which this Enrollment is Approved
    22 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    23 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    24 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.
    25 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    26 LM_DROP_DT Date(10) DATE The date on which the Enrollment was dropped.
    27 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    28 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
    29 LM_STD_HRS Number(15,2) DECIMAL(14,2) NOT NULL Study Hours
    30 LM_TRVL_HRS Number(15,2) DECIMAL(14,2) NOT NULL Travel Hours
    31 LM_IS_APPR_LAUNCHD Character(1) VARCHAR2(1) NOT NULL This flag indicates whether approval was launched for the transaction.
    32 LM_DIFELIGIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Eligible to DIF
    33 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class
    34 LM_TRG_PLN_CTGY Character(10) VARCHAR2(10) NOT NULL Training Plan Category
    35 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
    36 LM_ISELIG_TRN_RPT Character(1) VARCHAR2(1) NOT NULL Is eligible for training plan report

    Y/N Table Edit

    Default Value: N

    37 LM_FLAT_COST Number(19,3) DECIMAL(18,3) NOT NULL Flat cost
    38 LM_ESTIMATED_HOURS Number(3,0) SMALLINT NOT NULL Estimated Hours
    39 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

    Prompt Table: LM_GLOB_OBJV_VW

    40 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.

    Prompt Table: LM_HR_COMP_TBL

    41 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Prompt Table: LM_LE_VW

    42 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Prompt Table: LM_ORG_ALL_VW

    43 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    44 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
    A=Approved
    B=Pushed back
    C=Auto Approved
    D=Denied
    E=Administrator denied
    F=Deleted
    G=Bypassed
    H=On Hold
    I=No Action Taken
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    R=No longer in role
    T=Terminated
    U=Auto approved
    X=Deleted
    Z=Pending Denial
    45 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    46 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    47 EOAWSTART_DT Date(10) DATE Start Date
    48 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
    49 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
    50 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    51 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
    A=Approved
    C=Complete
    D=Denied
    E=Pending Denial
    H=Hard Deny
    I=Initial
    N=Not Active
    P=Pending
    S=Awaiting Further Approvals
    T=Terminated
    W=Canceled
    X=Suspended/Pending Denial
    52 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    53 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    54 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    55 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    56 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path