RF_DB_SETUP_HDR

(SQL Table)
Index Back

Dispatch Board Setup

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