| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_VENDOR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Integration Vendor ID
|
| 2 |
HRS_VERSION |
Number(15,0) |
DECIMAL(15) NOT NULL |
used as version for numerous integration objects
|
| 3 |
LM_LELW_OPT_LBL_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (1)
|
| 4 |
LM_LELW_OPT_LBL_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (2)
|
| 5 |
LM_LELW_OPT_LBL_3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (3)
|
| 6 |
LM_LELW_OPT_LBL_4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (4)
|
| 7 |
LM_LELW_OPT_LBL_5 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (5)
|
| 8 |
LM_LELW_OPT_LBL_6 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label 6
|
| 9 |
LM_LELW_OPT_LBL_7 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (7)
|
| 10 |
LM_LELW_OPT_LBL_8 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (8)
|
| 11 |
LM_LELW_OPT_LBL_9 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label 9
|
| 12 |
LM_LELW_OPT_LBL_10 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label 10
|
| 13 |
LM_LELW_OPT_LBL_11 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (11)
|
| 14 |
LM_LELW_OPT_LBL_12 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (12)
|
| 15 |
LM_LELW_OPT_LBL_13 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (13)
|
| 16 |
LM_LELW_OPT_LBL_14 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (14)
|
| 17 |
LM_LELW_OPT_LBL_15 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (15)
|
| 18 |
LM_LELW_OPT_LBL_16 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (16)
|
| 19 |
LM_LELW_OPT_LBL_17 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label 17
|
| 20 |
LM_LELW_OPT_LBL_18 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (18)
|
| 21 |
LM_LELW_OPT_LBL_19 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (19)
|
| 22 |
LM_LELW_OPT_LBL_20 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (20)
|
| 23 |
LM_LELW_OPT_LBL_21 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (21)
|
| 24 |
LM_LELW_OPT_LBL_22 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (22)
|
| 25 |
LM_LELW_OPT_LBL_23 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (23)
|
| 26 |
LM_LELW_OPT_LBL_24 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (24)
|
| 27 |
LM_LELW_OPT_LBL_25 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (25)
|
| 28 |
LM_LELW_OPT_LBL_26 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (26)
|
| 29 |
LM_LELW_OPT_LBL_27 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (27)
|
| 30 |
LM_LELW_OPT_LBL_28 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (28)
|
| 31 |
LM_LELW_OPT_LBL_29 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (29)
|
| 32 |
LM_LELW_OPT_LBL_30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Options Label (30)
|
| 33 |
LM_LELW_OPT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (1)
Y/N Table Edit
|
| 34 |
LM_LELW_OPT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (2)
Y/N Table Edit
|
| 35 |
LM_LELW_OPT_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (3)
Y/N Table Edit
|
| 36 |
LM_LELW_OPT_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (4)
Y/N Table Edit
|
| 37 |
LM_LELW_OPT_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (5)
Y/N Table Edit
|
| 38 |
LM_LELW_OPT_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (6)
Y/N Table Edit
|
| 39 |
LM_LELW_OPT_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (7)
Y/N Table Edit
|
| 40 |
LM_LELW_OPT_8 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (8)
Y/N Table Edit
|
| 41 |
LM_LELW_OPT_9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Label (9)
Y/N Table Edit
|
| 42 |
LM_LELW_OPT_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Label (10)
Y/N Table Edit
|
| 43 |
LM_LELW_OPT_11 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (11)
Y/N Table Edit
|
| 44 |
LM_LELW_OPT_12 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (12)
Y/N Table Edit
|
| 45 |
LM_LELW_OPT_13 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (13)
Y/N Table Edit
|
| 46 |
LM_LELW_OPT_14 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (14)
Y/N Table Edit
|
| 47 |
LM_LELW_OPT_15 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (15)
Y/N Table Edit
|
| 48 |
LM_LELW_OPT_16 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (16)
Y/N Table Edit
|
| 49 |
LM_LELW_OPT_17 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (17)
Y/N Table Edit
|
| 50 |
LM_LELW_OPT_18 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (18)
Y/N Table Edit
|
| 51 |
LM_LELW_OPT_19 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (19)
Y/N Table Edit
|
| 52 |
LM_LELW_OPT_20 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (20)
Y/N Table Edit
|
| 53 |
LM_LELW_OPT_21 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (21)
Y/N Table Edit
|
| 54 |
LM_LELW_OPT_22 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (22)
Y/N Table Edit
|
| 55 |
LM_LELW_OPT_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (23)
Y/N Table Edit
|
| 56 |
LM_LELW_OPT_24 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (24)
Y/N Table Edit
|
| 57 |
LM_LELW_OPT_25 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (25)
Y/N Table Edit
|
| 58 |
LM_LELW_OPT_26 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (26)
Y/N Table Edit
|
| 59 |
LM_LELW_OPT_27 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (27)
Y/N Table Edit
|
| 60 |
LM_LELW_OPT_28 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (28)
Y/N Table Edit
|
| 61 |
LM_LELW_OPT_29 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (29)
Y/N Table Edit
|
| 62 |
LM_LELW_OPT_30 |
Character(1) |
VARCHAR2(1) NOT NULL |
Options Default (30)
Y/N Table Edit
|
| 63 |
LM_LELW_ACTIVE_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE
Y/N Table Edit
Default Value: N
|
| 64 |
LM_LELW_ACTIVE_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (2)
Y/N Table Edit
Default Value: N
|
| 65 |
LM_LELW_ACTIVE_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (3)
Y/N Table Edit
Default Value: N
|
| 66 |
LM_LELW_ACTIVE_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (4)
Y/N Table Edit
Default Value: N
|
| 67 |
LM_LELW_ACTIVE_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (5)
Y/N Table Edit
Default Value: N
|
| 68 |
LM_LELW_ACTIVE_6 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (6)
Y/N Table Edit
Default Value: N
|
| 69 |
LM_LELW_ACTIVE_7 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (7)
Y/N Table Edit
Default Value: N
|
| 70 |
LM_LELW_ACTIVE_8 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (8)
Y/N Table Edit
Default Value: N
|
| 71 |
LM_LELW_ACTIVE_9 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (9)
Y/N Table Edit
Default Value: N
|
| 72 |
LM_LELW_ACTIVE_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (10)
Y/N Table Edit
Default Value: N
|
| 73 |
LM_LELW_ACTIVE_11 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (11)
Y/N Table Edit
Default Value: N
|
| 74 |
LM_LELW_ACTIVE_12 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (12)
Y/N Table Edit
Default Value: N
|
| 75 |
LM_LELW_ACTIVE_13 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (13)
Y/N Table Edit
Default Value: N
|
| 76 |
LM_LELW_ACTIVE_14 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (14)
Y/N Table Edit
Default Value: N
|
| 77 |
LM_LELW_ACTIVE_15 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (15)
Y/N Table Edit
Default Value: N
|
| 78 |
LM_LELW_ACTIVE_16 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (16)
Y/N Table Edit
Default Value: N
|
| 79 |
LM_LELW_ACTIVE_17 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (17)
Y/N Table Edit
Default Value: N
|
| 80 |
LM_LELW_ACTIVE_18 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (18)
Y/N Table Edit
Default Value: N
|
| 81 |
LM_LELW_ACTIVE_19 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (19)
Y/N Table Edit
Default Value: N
|
| 82 |
LM_LELW_ACTIVE_20 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (20)
Y/N Table Edit
Default Value: N
|
| 83 |
LM_LELW_ACTIVE_21 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (21)
Y/N Table Edit
Default Value: N
|
| 84 |
LM_LELW_ACTIVE_22 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (22)
Y/N Table Edit
Default Value: N
|
| 85 |
LM_LELW_ACTIVE_23 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (23)
Y/N Table Edit
Default Value: N
|
| 86 |
LM_LELW_ACTIVE_24 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (24)
Y/N Table Edit
Default Value: N
|
| 87 |
LM_LELW_ACTIVE_25 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (25)
Y/N Table Edit
Default Value: N
|
| 88 |
LM_LELW_ACTIVE_26 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (26)
Y/N Table Edit
Default Value: N
|
| 89 |
LM_LELW_ACTIVE_27 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (27)
Y/N Table Edit
Default Value: N
|
| 90 |
LM_LELW_ACTIVE_28 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (28)
Y/N Table Edit
Default Value: N
|
| 91 |
LM_LELW_ACTIVE_29 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (29)
Y/N Table Edit
Default Value: N
|
| 92 |
LM_LELW_ACTIVE_30 |
Character(1) |
VARCHAR2(1) NOT NULL |
OPTION ACTIVE (30)
Y/N Table Edit
Default Value: N
|
| 93 |
LM_LELW_SSTR_LBL_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Short String Label (1)
|
| 94 |
LM_LELW_SSTR_LBL_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Short String Label (2)
|
| 95 |
LM_LELW_SSTR_LBL_3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Short String Label (3)
|
| 96 |
LM_LELW_SSTR_ACT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Short String Active 1
Y/N Table Edit
Default Value: N
|
| 97 |
LM_LELW_SSTR_ACT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Short String Active 2
Y/N Table Edit
Default Value: N
|
| 98 |
LM_LELW_SSTR_ACT_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Short String Active 3
Y/N Table Edit
Default Value: N
|
| 99 |
LM_LELW_NBR_LBL_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Number Label (1)
|
| 100 |
LM_LELW_NBR_LBL_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Number Label 2
|
| 101 |
LM_LELW_NBR_ACT_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Number Active 1
Y/N Table Edit
Default Value: N
|
| 102 |
LM_LELW_NBR_ACT_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Number Active 2
Y/N Table Edit
Default Value: N
|
| 103 |
LM_LELW_LSTR_LBL_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Long String Label
|
| 104 |
LM_LELW_LSTR_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Long String Active
Y/N Table Edit
Default Value: N
|
| 105 |
LM_LELW_REAL_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Real Time
Y/N Table Edit
|
| 106 |
LM_BUILDURLLOCAL |
Character(1) |
VARCHAR2(1) NOT NULL |
LM_BUILDURLLOCAL
Y/N Table Edit
|
| 107 |
LM_LELW_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Status
10=Active
20=Inactive
Default Value: 20
|
| 108 |
LM_LELW_ADMIN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Admin User ID
|
| 109 |
LM_LELW_ADMIN_PWD |
Character(30) |
VARCHAR2(30) NOT NULL |
Admin Password
|
| 110 |
LM_LELW_SITE_KEY |
Character(50) |
VARCHAR2(50) NOT NULL |
Site Key
|
| 111 |
LM_LELW_VI_ROUTE |
Character(254) |
VARCHAR2(254) NOT NULL |
Vendor Route URL
|
| 112 |
LM_LELW_VI_NAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Vendor Internal Name
|
| 113 |
LM_COLLAB |
Character(1) |
VARCHAR2(1) NOT NULL |
LM_COLLAB
Y/N Table Edit
|
| 114 |
LM_LELW_ENROLL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll Learner's Flag
Y/N Table Edit
|