LM_ACT_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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

    Prompt Table: LM_ML_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_RNW_REQ Character(1) VARCHAR2(1) NOT NULL Renewal Needed
    N=No
    Y=Yes

    Default Value: N

    10 LM_RENEWAL_TYPE Character(1) VARCHAR2(1) NOT NULL Renewal Type
    D=Renewal Threshold Date
    P=Renewal Period

    Default Value: P

    11 LM_RNW_PD_DAYS Number(3,0) SMALLINT NOT NULL Renewal period
    12 LM_RENW_DATE Date(10) DATE Renewal date
    13 LM_DUE_DT_MTHD Character(2) VARCHAR2(2) NOT NULL Due date method
    DT=Date
    LP=Learning Period

    Default Value: LP

    14 LM_MAN_LRN_PD Number(3,0) SMALLINT NOT NULL Mandatory Learning Period
    15 LM_DUE_DATE Date(10) DATE Due Date