RF_SO_LINE_PRVW(SQL View) |
Index Back |
|---|---|
Service Order Line InformationThis view returns all of the line data for a FieldService Service Order. |
| SELECT BUSINESS_UNIT , SO_ID , SO_LINE , ACTIVITY_CODE , DESCR80 , APPROVAL_REQ_FLAG , EST_SERVICE_TIME , DISPLAY_ORDER , APPROVED_FLAG , APPROVAL_OPRID , APPROVAL_DT , SOACTIVITY_STATUS , SOACT_PRIORITY , START_DT , START_TIME , END_DT , END_TIME , EST_START_DT , EST_START_TIME , EST_END_DT , EST_END_TIME , ACT_START_DATE , ACT_START_TIME , ACT_END_DATE , ACT_END_TIME , COMPLETION_DATE , TOTAL_ACT_TIME , BILLABLE_FLAG , TIME_SHEET_ID , SHEET_ID , MATERIAL_HDR , ROW_ADDED_DTTM , ROW_ADDED_OPRID , ROW_LASTMANT_DTTM , ROW_LASTMANT_OPRID , SYNCID INT , SYNCDTTM , PROVIDER_GRP_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 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 6 | APPROVAL_REQ_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field specifies whether the approval is required for the activity.
N=No Y=Yes |
| 7 | EST_SERVICE_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated time that it will take to perform a service. |
| 8 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 9 | APPROVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to determine if approval is required for this inventory item.
A=Approved P=Pending |
| 10 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 11 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 12 | 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 |
| 13 | SOACT_PRIORITY | Character(3) | VARCHAR2(3) NOT NULL |
The priority of the service order activity (a.k.a. line).
HIH=High LOW=Low NOR=Normal URG=Urgent |
| 14 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 15 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 16 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 17 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 18 | EST_START_DT | Date(10) | DATE | Estimated date that a service activity will be started. |
| 19 | EST_START_TIME | Time(15) | TIMESTAMP | Estimated time that a service activity will be started. |
| 20 | EST_END_DT | Date(10) | DATE | Estimated date that a service activity will be finished. |
| 21 | EST_END_TIME | Time(15) | TIMESTAMP | Estimated time that a service activity will be finished. |
| 22 | ACT_START_DATE | Date(10) | DATE | Actual start date recorded for a service activity. |
| 23 | ACT_START_TIME | Time(15) | TIMESTAMP | Actual start time recorded for a service activity. |
| 24 | ACT_END_DATE | Date(10) | DATE | Actual end date recorded for a service activity. |
| 25 | ACT_END_TIME | Time(15) | TIMESTAMP | Actual end time recorded for a service activity. |
| 26 | COMPLETION_DATE | Date(10) | DATE | Completion Date |
| 27 | TOTAL_ACT_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | This field is used to store the total actual time. |
| 28 | BILLABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This is used to determine of the item under consideration is billable or not.
N=No Y=Yes Y/N Table Edit |
| 29 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 30 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 31 | MATERIAL_HDR | Character(8) | VARCHAR2(8) NOT NULL | Header ID used when recording item usage on a service order. |
| 32 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 33 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 34 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 35 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 36 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 37 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 38 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table: RF_PROVIDER_GRP |