LM_PRG_CERT_VW

(SQL View)
 Index Back

Program Recertifications View

Program Recertifications View

SELECT A.LM_PRG_ID , A.EFFDT , A.LM_END_EFFDT , A.LM_PRG_STATUS , A.LM_PRG_TYPE , A.LM_PRG_CD , A.LM_VERSION , A.LM_PRG_LONG_NM , A.LM_PRG_SHORT_NM , A.LM_PRG_DESCR , A.LM_OWNER_ID , A.LM_COORD_ID , A.LM_ALLOW_WAIVER , A.LM_AUTO_ASGN_OBJV , A.LM_EXTRNL_ID , A.LM_EXTRNL_INFO , A.LM_VENDOR_ID , A.LM_VNDR_PRG_CD , A.LM_CEU_BASED , A.LM_CEU_TOT , A.LM_CMPL_TYPE , A.LM_CMPL_PD_DAYS , A.LM_CMPL_WRN_DAYS , A.LM_EXPR_DT , A.LM_EXPR_DAYS , A.LM_GRACE_PD_DAYS , A.LM_EXPR_WRN_DAYS , A.LM_RECERT_PD_DAYS , A.LM_CERT_ID , A.LM_TARGET_AUD , %subrec(LM_PRICING_SBR, A) , A.LM_PRG_ABST FROM PS_LM_PRG A WHERE A.LM_PRG_TYPE = 'CE'

  • Related Language Record: LM_PRG_LANG

  • Parent record: LM_PRG

    • # 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_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    4 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    5 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    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_VERSION Character(30) VARCHAR2(30) NOT NULL Program Version
    8 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    9 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    10 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description
    11 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
    12 LM_COORD_ID Number(15,0) DECIMAL(15) NOT NULL Program Coordinator
    13 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.

    Y/N Table Edit

    14 LM_AUTO_ASGN_OBJV Character(1) VARCHAR2(1) NOT NULL Auto Assign Objectives
    15 LM_EXTRNL_ID Number(10,0) DECIMAL(10) NOT NULL External ID - This field comes in from an external vendor and/or user and is user defined
    16 LM_EXTRNL_INFO Character(30) VARCHAR2(30) NOT NULL External Information - This field is populated by external user/vendor and is user defined.
    17 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID
    18 LM_VNDR_PRG_CD Character(30) VARCHAR2(30) NOT NULL Vendor Program Code
    19 LM_CEU_BASED Character(1) VARCHAR2(1) NOT NULL CEU Based Completion
    20 LM_CEU_TOT Number(13,2) DECIMAL(12,2) NOT NULL Total Continuing Education Units
    21 LM_CMPL_TYPE Character(2) VARCHAR2(2) NOT NULL Completion Type is a flag that determines whether completion period is calculated from a registration date or from the date of the first item completion.
    10=Fixed
    20=Delayed
    22 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.
    23 LM_CMPL_WRN_DAYS Number(3,0) SMALLINT NOT NULL The completion warning period is the number of days in advance of the target completion date, when an email notification will be sent to warn a learner to complete the requirements before time is up.
    24 LM_EXPR_DT Date(10) DATE Certification Expiration Date is a fixed, preset date when the certification will expire.
    25 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.
    26 LM_GRACE_PD_DAYS Number(3,0) SMALLINT NOT NULL This is the number of days after expiration, that the actual expiration takes effect.
    27 LM_EXPR_WRN_DAYS Number(3,0) SMALLINT NOT NULL The expiration warning period is the number of days before certification or before re-certification expiration, in which a reminder notification is sent to the learner.
    28 LM_RECERT_PD_DAYS Number(5,0) INTEGER NOT NULL The re-certification period is the number of days after certification actually expires, within which the learner must complete the official re-certification path/program to reinstate certification status.
    29 LM_CERT_ID Number(10,0) DECIMAL(10) NOT NULL Certification ID
    30 LM_TARGET_AUD Character(254) VARCHAR2(254) NOT NULL Target Audience
    31 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    32 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    33 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    34 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price
    35 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price
    36 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units
    37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    38 LM_PRG_ABST Long Character CLOB Program Abstract