LM_OBJV_MASS_DT

(SQL Table)
Index Back

Mass Objective Details

Mass Objective Detail Record- Updated from the App Eng

  • Parent Record Of LM_OBJV_MASS_RQ
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    3 LM_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence number to increment for the mass req record
    4 LM_MASS_DT_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Mass Person Details Seq Nbr
    5 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    6 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    7 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
    8 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    9 LM_OBJV_ASGN_DT Date(10) DATE Objective Assign Date
    10 LM_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Fr Mass Enrollment
    ER=Error
    PE=Pending
    PO=Processed
    PR=Processing
    SU=Successful
    11 LM_OBJV_NEEDED Character(1) VARCHAR2(1) NOT NULL Objective needed.

    Y/N Table Edit

    12 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
    13 LM_PROCESSED_DT Date(10) DATE Fr Mass Enrollment _ Processed Date
    14 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    15 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    16 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    17 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    18 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments