LM_PRG_ML

(SQL Table)
 Index Back

Mandatory Learning table

Mandatory Learning table

  • Parent record: LM_ACT

    • # 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 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

    Prompt Table: LM_ML_PRG_LG_VW

    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_ML_NAME_VW

    4 LM_ML_SEL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
    G=Learner Group
    L=Learner

    Default Value: G

    5 LM_HST_CRD_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow historical credit

    Y/N Table Edit

    6 LM_HISTCREDIT_TYPE Character(1) VARCHAR2(1) NOT NULL Historical Credit Type
    D=Credit Threshold Date
    P=Historical Credit Period

    Default Value: P

    7 LM_HIST_CRD_PRD Number(3,0) SMALLINT NOT NULL Historical credit period days
    8 LM_HIST_DATE Date(10) DATE Historical Date
    9 LM_DUE_DT_MTHD Character(2) VARCHAR2(2) NOT NULL Due date method
    DT=Date
    LP=Learning Period

    Default Value: LP

    10 LM_MAN_LRN_PD Number(3,0) SMALLINT NOT NULL Mandatory Learning Period
    11 LM_DUE_DATE Date(10) DATE Due Date
    12 CUB_STARTMONTH Character(2) VARCHAR2(2) NOT NULL Month
    1=01 - January
    10=10 - October
    11=11 - November
    12=12 - December
    2=02 - February
    3=03 - March
    4=04 - April
    5=05 - May
    6=06 - June
    7=07 - July
    8=08 - August
    9=09 - September
    13 CUB_BEGINDAY Character(2) VARCHAR2(2) NOT NULL Day