RF_SO_LINE_HST(SQL Table) |
Index Back |
|---|---|
Service Order Line InformationThis table stores all of the line data for a Service Order. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | SO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Order ID |
| 5 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Stores the Service Order line number. |
| 6 | 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 |
| 7 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 8 | APPROVAL_REQ_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field specifies whether the approval is required for the activity.
N=No Y=Yes |
| 9 | EST_SERVICE_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated time that it will take to perform a service. |
| 10 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 11 | 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 |
| 12 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 13 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 14 | 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 |
| 15 | 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 |
| 16 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 17 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 18 | END_DT | Date(10) | DATE | This field stores the end date values. |
| 19 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 20 | EST_START_DT | Date(10) | DATE | Estimated date that a service activity will be started. |
| 21 | EST_START_TIME | Time(15) | TIMESTAMP | Estimated time that a service activity will be started. |
| 22 | EST_END_DT | Date(10) | DATE | Estimated date that a service activity will be finished. |
| 23 | EST_END_TIME | Time(15) | TIMESTAMP | Estimated time that a service activity will be finished. |
| 24 | ACT_START_DATE | Date(10) | DATE | Actual start date recorded for a service activity. |
| 25 | ACT_START_TIME | Time(15) | TIMESTAMP | Actual start time recorded for a service activity. |
| 26 | ACT_END_DATE | Date(10) | DATE | Actual end date recorded for a service activity. |
| 27 | ACT_END_TIME | Time(15) | TIMESTAMP | Actual end time recorded for a service activity. |
| 28 | COMPLETION_DATE | Date(10) | DATE | Completion Date |
| 29 | TOTAL_ACT_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | This field is used to store the total actual time. |
| 30 | 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 |
| 31 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 32 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 33 | MATERIAL_HDR | Character(8) | VARCHAR2(8) NOT NULL | Header ID used when recording item usage on a service order. |
| 34 | LINE_OID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Line Object ID |
| 35 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 36 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 37 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 38 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 39 | 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. |
| 40 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 41 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table: RF_PROVIDER_GRP |