LM_TRPLNSTS_STP(SQL Table) |
Index Back |
|---|---|
Setup table for training planSetup table for training plan around enrollment and learning request statuses |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_ITEM_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Item type to identify a training plan item. It can be of type Activity or Learning Request.
1=Class 2=Learning Request 3=Program Registration 4=Supplemental Learning |
| 2 | LM_STTS |
Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted |
| 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_FUTURE_YN | Character(1) | VARCHAR2(1) NOT NULL |
Consider for future training plan
Y/N Table Edit Default Value: N |
| 5 | LM_ACTUAL_PLAN_YN | Character(1) | VARCHAR2(1) NOT NULL |
Consider for actual training plan
Y/N Table Edit Default Value: N |
| 6 | LM_MODEL_YN | Character(1) | VARCHAR2(1) NOT NULL |
Include in Budget Model
Y/N Table Edit Default Value: N |