RF_UTIL_WRK_TBL (SQL Table)	Index Back
Utilization Work Hours Table Used when running the Utilization Smart View, when determining work hours for the technician.

RF_UTIL_WRK_TBL

(SQL Table)

Utilization Work Hours Table

Used when running the Utilization Smart View, when determining work hours for the technician.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 UUID_RAW Character(36) VARCHAR2(36) NOT NULL Universal Unique Identifier - can be used as an identifier when processing a batch of data.

2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

3 TOTAL_HOURS Signed Number(13,2) DECIMAL(11,2) NOT NULL This field is used to store the Total Hours.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	UUID_RAW	Character(36)	VARCHAR2(36) NOT NULL	Universal Unique Identifier - can be used as an identifier when processing a batch of data.
2	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
3	TOTAL_HOURS	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	This field is used to store the Total Hours.