LM_LRNROBJV_HST

(SQL Table)
Index Back

Learner Objectives

Learner Objectives table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 LM_LRNR_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Learner Objective ID. System Generated ID Number associated with each Learner Objective.
4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
5 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
6 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
7 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
8 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
9 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
10 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
11 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
12 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
13 LM_OBJV_STATUS Character(2) VARCHAR2(2) NOT NULL Learner Objective status.
10=Needed
20=Planned
30=In-Progress
40=Met
14 LM_OBJV_STAT_DTTM DateTime(26) TIMESTAMP Learner Objective status datetime.
15 LM_OBJV_ASGN_DT Date(10) DATE Objective Assign Date
16 LM_OBJV_NEEDED Character(1) VARCHAR2(1) NOT NULL Objective needed.

Y/N Table Edit

Default Value: N

17 LM_EXT_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code
18 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code
19 LM_EXT_MSG_TYPE Character(1) VARCHAR2(1) NOT NULL External Message Type - full or incremental.
1=Full Sync
5=Incremental Sync
20 LM_OBJV_ASSIGN_CD Character(3) VARCHAR2(3) NOT NULL Internal assignment of Objectives
ADH=Adhoc Assigned
CAT=Catalogue Assigned
EXT=External System
HPC=HR Person Comp Assigned
HRS=HR Assigned
JOB=Job Objectives Assigned
MAS=Mass Assigned
MGR=Manager Assigned
POS=Position Objectives Assigned
PRG=Program Assigned
SLF=Self Assigned
21 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.
22 LM_SUB_SOURCE Character(30) VARCHAR2(30) NOT NULL External objective code
23 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
24 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS
25 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
26 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
27 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
28 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid