LM_OBJV_MASS_DT(SQL Table) |
Index Back |
---|---|
Mass Objective DetailsMass Objective Detail Record- Updated from the App Eng |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
3 | Number(10,0) | DECIMAL(10) NOT NULL | Sequence number to increment for the mass req record | |
4 | 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 |