WM_WO_TSK_G_VW(SQL View) |
Index Back |
|---|---|
Work Order Task View with GISdepends on WM_WO_TSK_VW |
| SELECT A.EMPLID , A.BUSINESS_UNIT , A.WO_ID , A.WO_TYPE , A.PRIORITY_CD , A.STATUS_CD_HDR , A.SHOP_ID , A.WO_TASK_ID , A.SEQ_NBR_5 , A.BUSINESS_UNIT_PC , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.DEPEND_TASK_ID , A.OVERLAP_PERCENT , A.WO_DURATION , A.ASSET_UP_FLG , A.ASSET_LOCATION , A.LOCATION , A.DESCR254 , A.STATUS_CD , A.STATUS_DTTM , A.REQ_START_DT , A.REQ_START_TIME , A.REQ_END_DT , A.REQ_END_TIME , A.SCHED_START_DT , A.SCHED_START_TIME , A.SCHED_END_DT , A.SCHED_END_TIME , A.ACTL_START_DT , A.ACTL_START_TIME , A.ACTL_END_DT , A.ACTL_END_TIME , A.IS_PASSIVE_PROJECT , A.PROJECT_ID , A.ACTIVITY_ID , A.SCHEDULER_CODE , A.LEAD_PERSON , A.CLOSED_DT , A.COMPLTED_DT , A.EST_COST_LBR , A.EST_COST_MAT , A.EST_COST_TLS , A.ACTL_COST_LBR , A.ACTL_COST_MAT , A.ACTL_COST_TLS , A.ASSET_DOWNTIME_HRS , A.DOWNTIME_RATE , A.RECOVER_COST_FLG , A.WARRANTY_NAME , A.VENDOR_ID , A.CNTCT_SEQ_NUM , A.CLAIM_ID , A.PROBLEM_GROUP , A.PROBLEM_CD , A.CAUSE_CD , A.RESOLUTION_CD , A.TASK_ACTION , A.SUPERVISOR , A.RES_LBR_EXIST , A.RES_TLS_EXIST , A.RES_MAT_EXIST , A.RES_PO_EXIST , A.BUSINESS_UNIT_WR , A.WR_ID , A.SRVC_GRP_ID , A.WO_APPROVAL_STATUS , A.ALERT_INDICATOR , A.ENTERED_DTTM , A.STANDING_WO_FLG , A.PM_SCHD_ID , A.WO_RESERVE_RULE , A.PRIORITY_NBR , A.WO_DESCR , A.ASSET_DESCR30 , A.HAZARDOUS_SW , A.TAG_NUMBER , A.SERIAL_ID , A.VIN , GIS.SETID , GIS.EFFDT , GIS.ADDRESS1 , GIS.ADDRESS2 , GIS.ADDRESS3 , GIS.ADDRESS4 , GIS.CITY , GIS.STATE , GIS.POSTAL , GIS.COUNTRY , GIS.COUNTRY_2CHAR , GIS.LONGITUDE , GIS.LATITUDE , A.ENTERED_BY FROM PS_WM_WO_TSK_VW A , PS_FS_GIS_TASK_VW GIS WHERE A.BUSINESS_UNIT = GIS.BUSINESS_UNIT AND A.WO_ID = GIS.WO_ID AND A.WO_TASK_ID = GIS.WO_TASK_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 4 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Work Order Type |
| 5 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Priority Code |
| 6 | STATUS_CD_HDR | Character(4) | VARCHAR2(4) NOT NULL | Header Status |
| 7 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 8 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 9 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 10 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 11 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 12 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 13 | DEPEND_TASK_ID | Number(8,0) | INTEGER NOT NULL |
Dependent Task
Prompt Table: WM_WO_TSK_DEP |
| 14 | OVERLAP_PERCENT | Number(6,2) | DECIMAL(5,2) NOT NULL | Overlap Percentage |
| 15 | WO_DURATION | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated Work Order Duration |
| 16 | ASSET_UP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Asset in Production Flag |
| 17 | ASSET_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Asset Location |
| 18 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 19 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 20 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 21 | STATUS_DTTM | DateTime(26) | TIMESTAMP | 05/13/02 EGS (CN#PL900-1): Added |
| 22 | REQ_START_DT | Date(10) | DATE | Required Start |
| 23 | REQ_START_TIME | Time(15) | TIMESTAMP | Required Start Time |
| 24 | REQ_END_DT | Date(10) | DATE | Required End |
| 25 | REQ_END_TIME | Time(15) | TIMESTAMP | Required End Time |
| 26 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 27 | SCHED_START_TIME | Time(15) | TIMESTAMP | Schedule Start Time |
| 28 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 29 | SCHED_END_TIME | Time(15) | TIMESTAMP | Schedule End Time |
| 30 | ACTL_START_DT | Date(10) | DATE | Actual Start Date |
| 31 | ACTL_START_TIME | Time(15) | TIMESTAMP | Actual Start Time |
| 32 | ACTL_END_DT | Date(10) | DATE | Actual End Date |
| 33 | ACTL_END_TIME | Time(15) | TIMESTAMP | Actual End Time |
| 34 | IS_PASSIVE_PROJECT | Character(1) | VARCHAR2(1) NOT NULL |
Passive Project Indicator
Y/N Table Edit |
| 35 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 36 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 37 | SCHEDULER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Scheduler Code |
| 38 | LEAD_PERSON | Character(30) | VARCHAR2(30) NOT NULL | Lead Person |
| 39 | CLOSED_DT | Date(10) | DATE | Date Closed |
| 40 | COMPLTED_DT | Date(10) | DATE | Completed Date |
| 41 | EST_COST_LBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Estimated Labor Cost |
| 42 | EST_COST_MAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Estimated Material Cost |
| 43 | EST_COST_TLS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Estimated Tools Cost |
| 44 | ACTL_COST_LBR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Labor Cost |
| 45 | ACTL_COST_MAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Cost |
| 46 | ACTL_COST_TLS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Tools Cost |
| 47 | ASSET_DOWNTIME_HRS | Number(32,3) | DECIMAL(31,3) NOT NULL | Asset Downtime |
| 48 | DOWNTIME_RATE | Number(32,3) | DECIMAL(31,3) NOT NULL | Downtime rate |
| 49 | RECOVER_COST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Attempt to Recover Cost flag |
| 50 | WARRANTY_NAME | Character(40) | VARCHAR2(40) NOT NULL | This field is used to store the name of the warranty. |
| 51 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 52 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 53 | CLAIM_ID | Character(15) | VARCHAR2(15) NOT NULL | Claim ID |
| 54 | PROBLEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Problem Group |
| 55 | PROBLEM_CD | Character(15) | VARCHAR2(15) NOT NULL | Problem code |
| 56 | CAUSE_CD | Character(15) | VARCHAR2(15) NOT NULL | Cause Code |
| 57 | RESOLUTION_CD | Character(15) | VARCHAR2(15) NOT NULL | Resolution code |
| 58 | 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 |
| 59 | SUPERVISOR | Character(30) | VARCHAR2(30) NOT NULL | Supervisor |
| 60 | RES_LBR_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Labor exists flag - used on WO |
| 61 | RES_TLS_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Tools exists flag - indicates if Tools exists on a WO |
| 62 | RES_MAT_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Inventory exists flag - indicates if inventory exists on WO |
| 63 | RES_PO_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Procurement exists flag - indicates if Procurement exists in WO |
| 64 | BUSINESS_UNIT_WR | Character(5) | VARCHAR2(5) NOT NULL | Work Request Business Unit |
| 65 | WR_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Request ID |
| 66 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Group |
| 67 | WO_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval |
| 68 | ALERT_INDICATOR | Character(3) | VARCHAR2(3) NOT NULL |
Note alert indicator
000=None 001=Outstanding Request 002=Reply Received |
| 69 | ENTERED_DTTM | DateTime(26) | TIMESTAMP | Entered Datetime |
| 70 | STANDING_WO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Standing Work Order indicator
N=Non-Standing Y=Standing |
| 71 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
| 72 | WO_RESERVE_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Reservation rule
1=Parts List Creation 2=Pick Plan Creation 3=Work Order Status Change 4=Batch Reserve Only |
| 73 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |
| 74 | WO_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Work Order Description |
| 75 | ASSET_DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Asset Description |
| 76 | HAZARDOUS_SW | Character(1) | VARCHAR2(1) NOT NULL | Hazardous Asset |
| 77 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 78 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 79 | VIN | Character(18) | VARCHAR2(18) NOT NULL | VIN |
| 80 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 81 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 82 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 83 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 84 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 85 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 86 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 87 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 88 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 89 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 90 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Country Code |
| 91 | LONGITUDE | Signed Number(12,7) | DECIMAL(10,7) NOT NULL | Longitude |
| 92 | LATITUDE | Signed Number(12,7) | DECIMAL(10,7) NOT NULL | Latitude |
| 93 | ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered by |