LM_SRCH_PRG_VW

(SQL View)
 Index Back

Search view for Programs

This view is used on query LM_SRCH_PRG_PRNT. Also, the field LM_ELIG_ENRL_FLG is always set as 'X' as not applicable. This field is needed on the SES search for LS_LM_LEARNING.

SELECT A.LM_PRG_ID , A.EFFDT , C.XLATLONGNAME , A.LM_PRG_LONG_NM , A.LM_PRG_DESCR , A.LM_PRG_CD , A.LM_PRG_STATUS , A.LM_PRG_TYPE , A.LM_PRG_CD , A.LM_PRG_LONG_NM , A.LM_PRG_SHORT_NM , A.LM_PRG_DESCR , A.LM_CERT_ID , A.LM_ALLOW_WAIVER , A.LM_CMPL_PD_DAYS , A.LM_INT_PRICE , A.LM_EXT_PRICE , A.LM_TRNG_UT , A.CURRENCY_CD , A.LM_SRCH_COUNTRY , A.LM_SRCH_STATE , A.LM_SRCH_CITY , A.LM_SRCH_UP_EVENTS , 'X' , A.LM_ROW_MAINT_DTTM FROM PS_LM_PRG_VER_VW A , PSXLATITEM C WHERE %Sql(LM_SRCH_PRG_SQL)

  • Related Language Record: LM_SRCH_PRG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    4 LM_SRCH_TITLE Character(200) VARCHAR2(200) NOT NULL Search Title
    5 LM_SRCH_DESCR Character(254) VARCHAR2(254) NOT NULL Search Description
    6 LM_SRCH_CODE Character(30) VARCHAR2(30) NOT NULL SES Search Course or Program Code
    7 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    8 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    9 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.
    10 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    11 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    12 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    13 LM_CERT_ID Number(10,0) DECIMAL(10) NOT NULL Certification ID
    14 LM_ALLOW_WAIVER Character(1) VARCHAR2(1) NOT NULL Allow Waiver Credit is a flag to determine whether learners can get ad-hoc credit for any items in a program.
    15 LM_CMPL_PD_DAYS Number(3,0) SMALLINT NOT NULL Completion Period is the period used to determine the target completion date for the learner.
    16 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    17 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    18 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    20 LM_SRCH_COUNTRY Character(30) VARCHAR2(30) NOT NULL Country Description
    21 LM_SRCH_STATE Character(30) VARCHAR2(30) NOT NULL State Description
    22 LM_SRCH_CITY Character(30) VARCHAR2(30) NOT NULL City
    23 LM_SRCH_UP_EVENTS Character(100) VARCHAR2(100) NOT NULL Upcoming Events
    24 LM_ELIG_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Eligible for Enrollment
    N=Ineligible for Enrollment
    X=Not Applicable
    Y=Eligible For Enrollment

    Default Value: X

    25 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime