| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LM_LRQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
New field for ELM 9.0, stores unique identifier for a single learning request.
|
| 2 |
LM_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field to store title of an object
|
| 3 |
LM_LRQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
New Field. Uppercase. Stores current status of learning request.
1=Requested
2=Inactive
3=Offered
|
| 4 |
LM_STTS_CHANGE_DT |
Date(10) |
DATE |
Status Chage Date
|
| 5 |
LM_REQUESTOR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Requestor
|
| 6 |
LM_ACT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Activity ID
|
| 7 |
LM_CI_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
|
| 8 |
LM_CATG_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Category ID - System generated number used to uniquely identify a Category.
|
| 9 |
LM_LRQ_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Method field in learning request o know if learner prefers self-paced or scheduled learning.
1=No Preference
2=Online
3=Classroom
4=Live Webcast
Default Value: 1
|
| 10 |
LM_LRQ_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
New Field. Mixed case. Stores description of requested learning (as entered by requestor).
|
| 11 |
LM_FROM_DT |
Date(10) |
DATE |
From Date
|
| 12 |
LM_TO_DT |
Date(10) |
DATE |
To Date
|
| 13 |
LM_LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 14 |
LM_INSTR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Instructor ID
|
| 15 |
LM_FCLTY_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Facility ID
|
| 16 |
LM_LRQ_PRTY |
Character(1) |
VARCHAR2(1) NOT NULL |
New Field. Uppercase. Stores learning request priority, as entered by the requestor.
Valid values:
???1???: Required for job
???2???: Required to complete objective
???3???: Career goal
???4???: Voluntary
1=Required for job
2=Required to complete objective
3=Career Goal
4=Voluntary
5=No Preference
Default Value: 5
|
| 17 |
LM_LRQ_COMMENTS |
Long Character |
CLOB |
New Field. Allows free-text entry of comments related to a request.
|
| 18 |
LM_SEAT_REQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Seat Request
|
| 19 |
LM_SEAT_AVL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Seat Request
|
| 20 |
LM_AUTO_ENROLL_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
New field. Yes no Flag.
Y/N Table Edit
|
| 21 |
LM_GEN_FLD1 |
Character(30) |
VARCHAR2(30) NOT NULL |
New field. Storage for generic field data.
|
| 22 |
LM_GEN_FLD2 |
Character(30) |
VARCHAR2(30) NOT NULL |
New field. Storage for generic field data.
|
| 23 |
LM_GEN_FLD3 |
Character(30) |
VARCHAR2(30) NOT NULL |
New field. Storage for generic field data.
|
| 24 |
LM_GEN_FLD4 |
Character(30) |
VARCHAR2(30) NOT NULL |
New field. Storage for generic field data.
|
| 25 |
LM_GEN_FLD5 |
Character(30) |
VARCHAR2(30) NOT NULL |
New field. Storage for generic field data.
|
| 26 |
LM_LE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
|
| 27 |
LM_HR_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
HR's Company ID brought over during synchronization.
|
| 28 |
LM_ORGANIZATION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Organization ID
|
| 29 |
LM_FLAT_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Flat cost
|
| 30 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 31 |
LM_OBJV_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Objective ID. System Generated ID Number associated with each Objective.
|
| 32 |
LM_ISELIG_TRN_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Is eligible for training plan report
Y/N Table Edit
Default Value: N
|
| 33 |
LM_MONDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Monday
|
| 34 |
LM_TUESDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuesday
|
| 35 |
LM_WEDNESDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Wednesday
|
| 36 |
LM_THURSDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Thursday
|
| 37 |
LM_FRIDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Friday
|
| 38 |
LM_SATURDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Saturday
|
| 39 |
LM_SUNDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sunday
|
| 40 |
LM_CLASS_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Class timings
1. No Preference
2. Morning
3. Afternoon
4. Evening
1=No Preference
2=Morning
3=Afternoon
4=Evening
Default Value: 1
|
| 41 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 42 |
LM_ESTIMATED_HOURS |
Number(3,0) |
SMALLINT NOT NULL |
Estimated Hours
|
| 43 |
LM_CREATED_DT |
Date(10) |
DATE |
Creation Date
|
| 44 |
LM_ACT_DIF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DIF Enrollment
Default Value: N
|
| 45 |
LM_TRAINING_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Training Class
|
| 46 |
LM_TRG_PLN_CTGY |
Character(10) |
VARCHAR2(10) NOT NULL |
Training Plan Category
|
| 47 |
LM_HRS_TRACK_STTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Hour Tracking Status
1=Pending Review from ELM Admin.
2=Approved by ELM Administrator
3=Pending Review from Payroll
4=Cancelled
5=Publish Error
6=Rejected by Payroll Admin
7=Finalized
|
| 48 |
LM_ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
Datetime Added
|
| 49 |
LM_ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Added By
|
| 50 |
LM_ROW_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
Row Maintainted DateTime
|
| 51 |
LM_ROW_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Maintained Oprid
|
| 52 |
LM_LRN_DECL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for declined Learning requests
Y/N Table Edit
Default Value: N
|