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 | BUSINESS_UNIT | 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. |