RS_SRCH_TEST

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 WEIGHTED_FIT_SCORE Signed Number(7,4) DECIMAL(5,4) NOT NULL A numeric value from -1 to 1 representing the weighted fit of a worker to a service order line for a single factor. The values from 0 to 1 represent the percentage fit relative to all factors being considered. The value is derived by multiplying the percentage score (from 0 to 1) for a single factor by the weight percent of that factor. Thus, the maximum possible score is dependent upon how many factors are being considered and how much weight has been assigned to each. A value of -1 indicates that some required criteria specified on the service order line and relevant to the factor in question is not met by the worker.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	WEIGHTED_FIT_SCORE	Signed Number(7,4)	DECIMAL(5,4) NOT NULL	A numeric value from -1 to 1 representing the weighted fit of a worker to a service order line for a single factor. The values from 0 to 1 represent the percentage fit relative to all factors being considered. The value is derived by multiplying the percentage score (from 0 to 1) for a single factor by the weight percent of that factor. Thus, the maximum possible score is dependent upon how many factors are being considered and how much weight has been assigned to each. A value of -1 indicates that some required criteria specified on the service order line and relevant to the factor in question is not met by the worker.