BUSINESS_UNITSO_IDSO_LINEPrompt Table: RF_ACT_CODE_VW3
CAN=Canceled
CLO=Closed
COM=Completed
OAC=Accepted
OER=En Route
OHA=Hold Assignment
OHC=Hold Customer
OHP=Hold Part
OOS=On Site
OPA=Assigned
ORJ=Rejected
Default Value: OHA
RF_SO_LINE_VW(SQL View) |
Index Back |
|---|---|
Service Order Line InfoThis table stores all of the line data for a FieldService Service Order. |
| SELECT BUSINESS_UNIT , SO_ID , SO_LINE , ACTIVITY_CODE , EST_SERVICE_TIME , DISPLAY_ORDER , SOACTIVITY_STATUS , START_DT , START_TIME , END_DT , END_TIME , MATERIAL_HDR , SHEET_ID , TIME_SHEET_ID FROM PS_RF_SO_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Stores the Service Order line number. |
| 4 | ACTIVITY_CODE | Character(8) | VARCHAR2(8) NOT NULL |
Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
Prompt Table: RF_ACT_CODE_VW3 |
| 5 | EST_SERVICE_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated time that it will take to perform a service. |
| 6 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 7 | SOACTIVITY_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Service Order Activity (line) Status.
CAN=Canceled CLO=Closed COM=Completed OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected Default Value: OHA |
| 8 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 9 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 10 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 11 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 12 | MATERIAL_HDR | Character(8) | VARCHAR2(8) NOT NULL | Header ID used when recording item usage on a service order. |
| 13 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 14 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |