OPRIDTSK_SRCH_VIEWTSK_SRCH_CDCS=Crew Scheduling Workbench
LA=Labor Assignment Workbench
MI=Mobile Inspections
RP=Report
SW=Scheduler Workbench
TW=Technician Workbench
WP=Track Work Progress
STATUS_CDWM_TSK_ST_SRCH(SQL Table) |
Index Back |
|---|---|
Work Order Task Search Status |
| # | 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 | TSK_SRCH_VIEW |
Character(30) | VARCHAR2(30) NOT NULL | Task Search View name |
| 3 | TSK_SRCH_CD |
Character(2) | VARCHAR2(2) NOT NULL |
Task Search code. The Task Search page is utilized by several components. This indicator to provide some categorization for between views stored in the WM_TSK_SRCH table.
CS=Crew Scheduling Workbench LA=Labor Assignment Workbench MI=Mobile Inspections RP=Report SW=Scheduler Workbench TW=Technician Workbench WP=Track Work Progress |
| 4 | STATUS_CD |
Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |