LM_PRG

(SQL Table)
Index Back

Program Details

Program Details

  • Related Language Record: LM_PRG_LANG
  • Parent Record Of LM_OBJV_PRG_VW2 LM_PRG_ATCH LM_PRG_CATG LM_PRG_CERT_VW LM_PRG_EQUV_TBL LM_PRG_I LM_PRG_KWRD LM_PRG_LE LM_PRG_NOTE LM_PRG_OBJV LM_PRG_PRQ LM_PRG_PRQ_P_VW LM_PRG_REC LM_PRG_REC_I LM_PRG_REC_VW LM_PRG_REL_LVW LM_PRG_REL_VW LM_PRG_RULE LM_PRG_SCN LM_PRG_SCN_RULE LM_PRG_SCN_VW LM_PRG_SEC LM_PRG_VW LM_PRG_VW3
  • # 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 NOT NULL 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

    Default Value: 30

    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

    Prompt Table: LM_OWNERID_VW

    12 LM_COORD_ID Number(15,0) DECIMAL(15) NOT NULL Program Coordinator

    Prompt Table: LM_INSTR_SRCH

    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

    Default Value: N

    14 LM_AUTO_ASGN_OBJV Character(1) VARCHAR2(1) NOT NULL Auto Assign Objectives

    Y/N Table Edit

    Default Value: N

    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

    Prompt Table: LM_VENDORID_VW

    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

    Y/N Table Edit

    Default Value: N

    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

    Default Value: 10

    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.

    Default Value: 0

    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_WRN_DAYS Number(3,0) SMALLINT NOT NULL The recertification warning period is the number of days before re-certification expiration, in which a reminder notification is sent to the learner.
    29 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.
    30 LM_CERT_ID Number(10,0) DECIMAL(10) NOT NULL Certification ID

    Prompt Table: LM_RECERT_VW

    31 LM_TARGET_AUD Character(254) VARCHAR2(254) NOT NULL Target Audience
    32 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price
    33 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price
    34 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price
    35 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price
    36 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price
    37 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units
    38 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    39 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    40 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    41 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    42 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    43 LM_PRG_ABST Long Character CLOB Program Abstract
    44 LM_REQ_ESIGN_UPD Character(1) VARCHAR2(1) NOT NULL eSignature

    Y/N Table Edit

    Default Value: N

    45 LM_SPL_APPROVER Number(15,0) DECIMAL(15) NOT NULL Special Approver

    Prompt Table: LM_PER_NAME_VW

    46 LM_CERT_CASCD_EXPR Character(1) VARCHAR2(1) NOT NULL Cascade Expire Certification

    Y/N Table Edit

    Default Value: N

    47 LM_APRVL_REQ_EXT Character(3) VARCHAR2(3) NOT NULL Enrollment Admin Approval Required for Non-Employees
    10=None
    40=Learning Admin
    60=Payment
    48 LM_APRVL_TYPE_REQ Character(30) VARCHAR2(30) NOT NULL Specifies the approval type required to take a given course, refer to the translate values
    10=None
    20=Standard

    Default Value: NONE

    Prompt Table: LM_PRG_PRCSD_VW

    49 LM_PAR_BSE_ON_CHD Character(1) VARCHAR2(1) NOT NULL Use on Install Defaults page to set if status of parent is based on child requirements.

    Y/N Table Edit

    Default Value: N

    50 LM_PRG_AUTO_ENROLL Character(1) VARCHAR2(1) NOT NULL Program Auto Enrollment
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    51 LM_ENRL_AUTO_REG Character(1) VARCHAR2(1) NOT NULL Course Auto Registration
    N=No
    Y=Yes

    Default Value: N

    52 LM_RTI_UPD_DTTM DateTime(26) TIMESTAMP RTI Trigger Date time