WM_CSRCH_SORT(SQL Table) |
Index Back |
|---|---|
Crew Search Sort viewCrew Search Sort table saves the sort criteria for crew scheduling and labor assignment searches. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | TSK_SRCH_VIEW |
Character(30) | VARCHAR2(30) NOT NULL |
Task Search View name
Prompt Table: %EDITTABLE |
| 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 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | WM_SORT_BY_FIELD |
Character(2) | VARCHAR2(2) NOT NULL | Sort By |
| 6 | ASC_DESC_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Ascending or Descending
A=Ascending D=Descending |