OPRIDRUN_CNTL_IDITEMNUM0010=Upg/Improve Knowledge & Comp.
0020=Provide New Technologies Info
0030=Prepare to Occupy New Vac/Pos
0040=Prevent Work Risks
0050=Increase Productivity
RUN_STPS1_MEX(SQL Table) |
Index Back |
|---|---|
STPS Reports Run ControlSTPS Reports Run Control Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | ITEMNUM |
Number(4,0) | SMALLINT NOT NULL | Item Number |
| 4 | TRAIN_PLAN_OBJ_MEX | Character(4) | VARCHAR2(4) NOT NULL |
Training Plan Object
0010=Upg/Improve Knowledge & Comp. 0020=Provide New Technologies Info 0030=Prepare to Occupy New Vac/Pos 0040=Prevent Work Risks 0050=Increase Productivity |
| 5 | COURSE | Character(6) | VARCHAR2(6) NOT NULL | Course Code |