LM_PRG_APR_VW

(SQL View)
 Index Back

Program Approval View

This view is used for the Mobile Approval for Programs

SELECT X.LM_PRG_REG_ID , P.LM_CERT_CASCD_EXPR , P.LM_COORD_ID , M.LM_PERSON_ID , P.LM_PRG_ABST , P.LM_PRG_CD , P.LM_PRG_ID , P.EFFDT , P.LM_EXPR_DAYS , P.LM_EXPR_DT , P.LM_PRG_DESCR , P.LM_PRG_TYPE , P.LM_PRG_LONG_NM , D.EOAWSTEP_STATUS , D.OPRID , D.EOAWORIG_OPRID , %DatePart(D.EOAWDTTM_MODIFIED) , S.EOAWTHREAD_ID , D.EOAWDTTM_COMPLETE , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , X.EOAWDTTM_MODIFIED , S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTEP_NBR FROM PS_LM_PRG_REG M , PS_LM_PRG_VW P , PS_LM_REG_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_PRG_ID = P.LM_PRG_ID AND M.LM_PRG_REG_ID = X.LM_PRG_REG_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_PRG_APR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    2 LM_CERT_CASCD_EXPR Character(1) VARCHAR2(1) NOT NULL Cascade Expire Certification
    3 LM_COORD_ID Number(15,0) DECIMAL(15) NOT NULL Program Coordinator
    4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    5 LM_PRG_ABST Long Character CLOB Program Abstract
    6 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
    7 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    8 LM_EFFDT Date(10) DATE Effective Date
    9 LM_EXPR_DAYS Number(5,0) INTEGER NOT NULL This is a validity period used for notifying the learner. This is what is shown to the learner as the number of days that the Certificate is valid for.
    10 LM_EXPR_DT Date(10) DATE Certification Expiration Date is a fixed, preset date when the certification will expire.
    11 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    12 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum

    Default Value: CE

    13 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    14 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
    15 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    16 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    17 EOAWSTART_DT Date(10) DATE Start Date
    18 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
    19 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
    20 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    21 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
    22 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    23 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    24 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    25 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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