LM_MASS_OBJ_AET (SQL Table)	Index Back
Mass assignment State Record Mass assignment of Objectives State Record for APP ENG LM_MASS_OBJV

LM_MASS_OBJ_AET

(SQL Table)

Mass assignment State Record

Mass assignment of Objectives State Record for APP ENG LM_MASS_OBJV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

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

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

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

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

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

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

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

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

13 LM_HIRE_DT_FRM Date(10) DATE Hire Date from

14 LM_HIRE_DT_THR Date(10) DATE Hire Date Through

15 LM_COUNT Number(10,0) DECIMAL(10) NOT NULL Field to keep track of the count of id fields

16 LM_COUNT1 Number(10,0) DECIMAL(10) NOT NULL Field to keep track of the count of id fields

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

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

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

20 LM_OBJV_ASGN_DT Date(10) DATE Objective Assign Date

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

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

23 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	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	LM_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence number to increment for the mass req record
5	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
6	LM_MASS_ENRL_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Fr Mass Enrollment
7	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
8	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
9	LM_JOBCODE_ID	Number(15,0)	DECIMAL(15) NOT NULL	JobCode ID
10	LM_POSITION_NBR	Character(15)	VARCHAR2(15) NOT NULL	Position Number
11	LM_ORGANIZATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Organization ID
12	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
13	LM_HIRE_DT_FRM	Date(10)	DATE	Hire Date from
14	LM_HIRE_DT_THR	Date(10)	DATE	Hire Date Through
15	LM_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Field to keep track of the count of id fields
16	LM_COUNT1	Number(10,0)	DECIMAL(10) NOT NULL	Field to keep track of the count of id fields
17	LM_ORG_TYPE_RPT	Character(4)	VARCHAR2(4) NOT NULL	Organization Type ALL=All CUST=Customer DEPT=Department
18	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
19	LM_REVIEW_RATING	Character(1)	VARCHAR2(1) NOT NULL	REview points for Rating models from HRMS
20	LM_OBJV_ASGN_DT	Date(10)	DATE	Objective Assign Date
21	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
22	LM_OBJV_NEEDED	Character(1)	VARCHAR2(1) NOT NULL	Objective needed. Y/N Table Edit
23	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.