RF_DB_SETUP_HDR(SQL Table) |
Index Back |
|---|---|
Dispatch Board SetupDisplay options for the FieldService dispatch board. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RF_NONVW |
|
| 2 | TIME_INTERVAL | Character(2) | VARCHAR2(2) NOT NULL |
Unit of time to use in completion times for Business Process tracking.
10=10 Minutes 15=15 Minutes Default Value: 10 |
| 3 | NO_OF_TECHNICIANS | Number(2,0) | SMALLINT NOT NULL |
Represents the number of technicians, usually assigned to a service order.
Default Value: 10 |
| 4 | DISP_START_HOUR | Character(4) | VARCHAR2(4) NOT NULL |
This field represents the dispatch board start hour for display purposes
0000=12:00am 0100=1:00am 0200=2:00am 0300=3:00am 0400=4:00am 0500=5:00am 0600=6:00am 0700=7:00am 0800=8:00am 0900=9:00am 1000=10:00am 1100=11:00am 1200=12:00pm 1300=1:00pm 1400=2:00pm 1500=3:00pm 1600=4:00pm 1700=5:00pm 1800=6:00pm 1900=7:00pm 2000=8:00pm 2100=9:00pm 2200=10:00pm 2300=11:00pm Default Value: 0000 |
| 5 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 6 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 7 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 8 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 9 | 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. |
| 10 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
| 11 | START_HOUR | Time(15) | TIMESTAMP | Time Field to select the starting hour at which the Dispatch Board will start displaying information. |