LM_OBJV_MASS_RQ (SQL Table)	Index Back
Mass Assignment

LM_OBJV_MASS_RQ

(SQL Table)

Mass Assignment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence number to increment for the mass req record

2 LM_MASS_RQST_NAME Character(50) VARCHAR2(50) NOT NULL Used for Mass Enrollments - Requestor Name

3 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

4 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

5 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS

6 LM_OBJV_ASGN_DT Date(10) DATE Objective Assign Date

7 LM_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Fr Mass Enrollment
ER=Error
PE=Pending
PO=Processed
PR=Processing
SU=Successful

8 LM_PROCESSED_DT Date(10) DATE Fr Mass Enrollment _ Processed Date

9 LM_MASS_ENRL_DESCR Character(254) VARCHAR2(254) NOT NULL Fr Mass Enrollment

10 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

11 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

12 LM_JOBCODE_ID Number(15,0) DECIMAL(15) NOT NULL JobCode ID

13 LM_POSITION_NBR Character(15) VARCHAR2(15) NOT NULL Position Number

14 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

15 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

16 LM_HIRE_DT_FRM Date(10) DATE Hire Date from

17 LM_HIRE_DT_THR Date(10) DATE Hire Date Through

18 LM_ORG_TYPE_RPT Character(4) VARCHAR2(4) NOT NULL Organization Type
ALL=All
CUST=Customer
DEPT=Department

19 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

20 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

21 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

22 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

24 LM_OBJV_NEEDED Character(1) VARCHAR2(1) NOT NULL Objective needed.
Y/N Table Edit

25 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence number to increment for the mass req record
2	LM_MASS_RQST_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used for Mass Enrollments - Requestor Name
3	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
4	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
5	LM_REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	REview points for Rating models from HRMS
6	LM_OBJV_ASGN_DT	Date(10)	DATE	Objective Assign Date
7	LM_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Fr Mass Enrollment ER=Error PE=Pending PO=Processed PR=Processing SU=Successful
8	LM_PROCESSED_DT	Date(10)	DATE	Fr Mass Enrollment _ Processed Date
9	LM_MASS_ENRL_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Fr Mass Enrollment
10	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
11	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
12	LM_JOBCODE_ID	Number(15,0)	DECIMAL(15) NOT NULL	JobCode ID
13	LM_POSITION_NBR	Character(15)	VARCHAR2(15) NOT NULL	Position Number
14	LM_ORGANIZATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Organization ID
15	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
16	LM_HIRE_DT_FRM	Date(10)	DATE	Hire Date from
17	LM_HIRE_DT_THR	Date(10)	DATE	Hire Date Through
18	LM_ORG_TYPE_RPT	Character(4)	VARCHAR2(4) NOT NULL	Organization Type ALL=All CUST=Customer DEPT=Department
19	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
20	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
21	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
22	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
23	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
24	LM_OBJV_NEEDED	Character(1)	VARCHAR2(1) NOT NULL	Objective needed. Y/N Table Edit
25	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.