| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LM_TU_POOL_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Training Unit Pool No. Unique key for Training Unit Pool Record.
|
| 2 |
LM_POOL_ITEM_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Training Unit Pool Item No is a unique key for Training unit Pool Item Record.
|
| 3 |
LM_NO_OF_TUS |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
No of Training Units available/used.
|
| 4 |
LM_BALANCE_TUS |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
No of Training Units available.
|
| 5 |
LM_ITM_START_DT |
Date(10) |
DATE |
TU Pool Item Start Date.
|
| 6 |
LM_ITM_END_DT |
Date(10) |
DATE |
TU Pool Item End Date
|
| 7 |
LM_AMT_PAID |
Number(23,3) |
DECIMAL(22,3) NOT NULL |
Amount Paid so far towards the Enrollment Fee
|
| 8 |
LM_TUPL_ITM_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N value if a TU pool has been used
|