OPRIDTSK_SRCH_CDCS=Crew Scheduling Workbench
LA=Labor Assignment Workbench
MI=Mobile Inspections
RP=Report
SW=Scheduler Workbench
TW=Technician Workbench
WP=Track Work Progress
TSK_SRCH_VIEWPrompt Table: WM_TSK_SRCH
TSK_SRCH_ALL_VW(SQL View) |
Index Back |
|---|---|
Task Search View |
| SELECT OPRID , TSK_SRCH_CD , TSK_SRCH_VIEW FROM PS_WM_TSK_SRCH |
| # | 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_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 |
| 3 | TSK_SRCH_VIEW |
Character(30) | VARCHAR2(30) NOT NULL |
Task Search View name
Prompt Table: WM_TSK_SRCH |