LM_LRNOBJ_HSTVW(SQL View) |
Index Back |
|---|---|
Learner ObjectivesLearner Objectives table. |
| SELECT PSARCH_ID , PSARCH_BATCHNUM , LM_LRNR_OBJV_ID , LM_ENRLMT_ID , LM_PERSON_ID , LM_OBJV_ID , LM_ACT_ID , LM_CI_ID , LM_PRG_REG_ID , LM_ADHC_LRN_ID , LM_PRG_ID , LM_ADHC_ID , LM_OBJV_STATUS , LM_OBJV_STAT_DTTM , LM_OBJV_ASGN_DT , LM_OBJV_NEEDED , LM_EXT_SRC_CD , LM_EXT_CD , LM_EXT_MSG_TYPE , LM_OBJV_ASSIGN_CD , LM_TARGET_CMPL_DT , LM_SUB_SOURCE , LM_REQUESTOR_ID , LM_REVIEW_RATING , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_LRNROBJV_HST |
| # | 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_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 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_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 |