WM_RPT_SRCH_VW

(SQL View)
 Index Back

Task Search view


SELECT OPRID ,TSK_SRCH_VIEW ,TSK_SRCH_CD ,EMPLID ,BUSINESS_UNIT ,WO_ID ,WO_TASK_ID ,BUSINESS_UNIT_WR ,WR_ID ,WO_TYPE ,TASK_ACTION ,ACTL_START_DT ,ACTL_END_DT ,ACTL_SRCH_CD ,ACTL_DT_CD ,SCHED_START_DT ,SCHED_END_DT ,SCHED_SRCH_CD ,SCHED_DT_CD ,REQ_START_DT ,REQ_END_DT ,REQ_SRCH_CD ,REQ_DT_CD ,LOCATION ,LOCATION_IN_LIST ,ENTERED_DT_FROM ,ENTERED_DT_TO ,SHOP_ID ,ENTERED_BY ,BUSINESS_UNIT_PC ,PROJECT_ID ,ACTIVITY_ID ,BUSINESS_UNIT_AM ,ASSET_ID ,TAG_NUMBER ,SERIAL_ID ,PROBLEM_GROUP ,PROBLEM_CD ,CAUSE_CD ,RESOLUTION_CD ,SRVC_GRP_ID ,WO_APPROVAL_STATUS ,BASIS_DT_CD ,STANDING_WO_FLG ,PM_SCHD_ID ,PM_SRCH_CD ,AREA_ID ,ASSET_LOCATION ,ASSET_TYPE ,ASSET_SUBTYPE ,MFG_ID ,MODEL ,CRAFT_ID ,CREW_BU ,CREW_SHOP ,CREW_ID ,CREW_FLG ,MAINT_TYPE ,TOOLS_REQ_FLG ,TOOLS_ASSET_TYPE ,TOOLS_ASSET_SUBTYP ,SCHEDULING_STATUS ,SCHED_PERIOD ,PERIOD_START_DT ,SRCH_OPR_1 ,SRCH_OPR_2 ,SRCH_OPR_3 ,SRCH_OPR_4 ,LAST_VIEW_SW ,PUBLIC_SW ,VIEW_MODE ,ASSET_CRITICALITY ,WM_CUR_EMPLID_SW ,TASK_DESCR ,ASSET_DESCR ,UNASSIGNED FROM PS_WM_TSK_SRCH WHERE TSK_SRCH_CD = 'RP'

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
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

Default Value: RP

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: WM_ELGBL_WRKR

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

6 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: WM_WO_HDR

7 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Prompt Table: WM_WO_TSK

8 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

9 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID

Prompt Table: WM_WOE_WRPMT_VW

10 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

11 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change
12 ACTL_START_DT Date(10) DATE Actual Start Date
13 ACTL_END_DT Date(10) DATE Actual End Date
14 ACTL_SRCH_CD Character(2) VARCHAR2(2) NOT NULL Task Search Date Start or End indicator.
1=Actual Start
2=Actual End

Default Value: 1

15 ACTL_DT_CD Character(1) VARCHAR2(1) NOT NULL Actual date
1=Exists
2=Not Exists
3=Today
4=Date Range

Default Value: 4

16 SCHED_START_DT Date(10) DATE Scheduled Start Date
17 SCHED_END_DT Date(10) DATE Scheduled End Date
18 SCHED_SRCH_CD Character(2) VARCHAR2(2) NOT NULL Task Search Date Start or End indicator.
1=Scheduled Start
2=Scheduled End

Default Value: 1

19 SCHED_DT_CD Character(1) VARCHAR2(1) NOT NULL Schedule date
1=Exists
2=Not Exists
3=Today
4=Date Range

Default Value: 4

20 REQ_START_DT Date(10) DATE Required Start
21 REQ_END_DT Date(10) DATE Required End
22 REQ_SRCH_CD Character(2) VARCHAR2(2) NOT NULL Task Search Date Start or End indicator.
1=Required Start
2=Required End

Default Value: 1

23 REQ_DT_CD Character(1) VARCHAR2(1) NOT NULL Required date
1=Exists
2=Not Exists
3=Today
4=Date Range

Default Value: 4

24 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

25 LOCATION_IN_LIST Character(254) VARCHAR2(254) NOT NULL Location In List
26 ENTERED_DT_FROM Date(10) DATE Field used in Voucher Maintenance Search component
27 ENTERED_DT_TO Date(10) DATE Field used in Voucher Maintenance Search component
28 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_HDR

29 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

Prompt Table: WM_OPR_NAME_VW

30 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

31 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
32 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
33 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

34 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_WOE_AMPMT_VW

35 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
36 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
37 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_GROUP

38 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

Prompt Table: WM_PCR_PROB_VW

39 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

Prompt Table: WM_PCR_CAUSE_VW

40 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

Prompt Table: WM_PCR_RES_VW

41 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Prompt Table: WM_SRVC_GRP

42 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
43 BASIS_DT_CD Character(2) VARCHAR2(2) NOT NULL Track WO progress Basis Date indicator.
1=Scheduled Start date
2=Scheduled End date
3=Scheduled Start or End

Default Value: 2

44 STANDING_WO_FLG Character(1) VARCHAR2(1) NOT NULL Standing Work Order indicator
N=Non-Standing
Y=Standing
45 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

Prompt Table: WM_TSKSRC_PM_VW

46 PM_SRCH_CD Character(1) VARCHAR2(1) NOT NULL PM Search Code
1=PM Work Orders only
2=Non-PM Work Orders only
3=PM Schedule ID

Default Value: 3

47 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: WM_AREA_PMT_VW
Set Control Field: BUSINESS_UNIT_AM

48 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT_AM

49 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
50 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE
Set Control Field: BUSINESS_UNIT_AM

51 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER
Set Control Field: BUSINESS_UNIT_AM

52 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: MFG_MODEL
Set Control Field: BUSINESS_UNIT_AM

53 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

Prompt Table: RS_CRAFT_DETAIL

54 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit

Prompt Table: WM_CREW_DEFN

55 CREW_SHOP Character(10) VARCHAR2(10) NOT NULL Crew Shop ID

Prompt Table: WM_CREW_PMT_VW

56 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

Prompt Table: WM_CREW_PMT2_VW

57 CREW_FLG Character(1) VARCHAR2(1) NOT NULL View Tasks without Crew

Y/N Table Edit

Default Value: N

58 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT_AM

59 TOOLS_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Tool Required

Y/N Table Edit

Default Value: N

60 TOOLS_ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Tools Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Furniture
080=Facility
100=Intangible
999=Other
61 TOOLS_ASSET_SUBTYP Character(15) VARCHAR2(15) NOT NULL Tools Asset Subtype

Prompt Table: WM_TLS_SUBTY_VW
Set Control Field: BUSINESS_UNIT_AM

62 SCHEDULING_STATUS Character(1) VARCHAR2(1) NOT NULL Scheduling Status
1=Unscheduled
2=Scheduled
3=Carryover Work
4=Review Entire Crew Schedule
63 SCHED_PERIOD Character(1) VARCHAR2(1) NOT NULL Schedule Period
1=Previous Period
2=Current Period
3=Next Period
4=Following Period
5=Specific Period
64 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
65 SRCH_OPR_1 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals

Default Value: =

66 SRCH_OPR_2 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals

Default Value: =

67 SRCH_OPR_3 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals

Default Value: =

68 SRCH_OPR_4 Character(2) VARCHAR2(2) NOT NULL Field search operator
<=Less than
<==Less than or equals
==Equals
>=Greater than
>==Greater than or equals
69 LAST_VIEW_SW Character(1) VARCHAR2(1) NOT NULL Last View used flag.

Y/N Table Edit

Default Value: N

70 PUBLIC_SW Character(1) VARCHAR2(1) NOT NULL Public

Y/N Table Edit

Default Value: N

71 VIEW_MODE Character(1) VARCHAR2(1) NOT NULL View Mode
1=Crew Scheduled
2=Non-Crew Scheduled

Default Value: 1

72 ASSET_CRITICALITY Character(2) VARCHAR2(2) NOT NULL Asset Criticality
73 WM_CUR_EMPLID_SW Character(1) VARCHAR2(1) NOT NULL Assigned to current Technician
74 TASK_DESCR Character(254) VARCHAR2(254) NOT NULL Task Description
75 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description
76 UNASSIGNED Character(1) VARCHAR2(1) NOT NULL Field used to indicate an unassigned pool
N=No
Y=Yes

Default Value: N