RF_DISPBRD_ASGN(SQL Table) |
Index Back |
|---|---|
Dispatch Board Assigned SOThis record is used to display Assigned Service Order Steps in the grid on the Dispatch Board. |
| # | 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 | SELECT_CHKBOX | Character(1) | VARCHAR2(1) NOT NULL |
This is used in action for enabling the actions
N=No Y=Yes |
| 4 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table: RF_PROVGRP_VW2 |
| 5 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RF_GRP_MEM_VW |
| 6 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 7 | SO_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
The priority of the service order.
H=High L=Low N=Normal U=Urgent |
| 8 | SO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to store the Service Order Header Status.
C=Complete D=Closed O=Open X=Canceled |
| 9 | REGION_ID | Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 10 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 11 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 12 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 13 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 14 | CHAR_DATETIME | Character(20) | VARCHAR2(20) NOT NULL | This field is used to show the Date and Time in character format on the Dispatch Board. |
| 15 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 16 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 17 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 18 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 19 | 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. |
| 20 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |