RS_WRKR_PREF_VW (SQL View)	Index Back
RM Flexible Worker Preferences Stores the preferences of the worker regarding flexible worker preference attributes.

RS_WRKR_PREF_VW

(SQL View)

RM Flexible Worker Preferences

Stores the preferences of the worker regarding flexible worker preference attributes.

SELECT A.EMPLID , A.RS_ATTRIBUTE_ID , A.RS_ATTR_VAL_ID , A.INTEREST_LEVEL FROM %Table(RS_WRKR_PREFS) A WHERE EXISTS ( SELECT 'X' FROM %Table(RS_ATTRIBUTES) AA WHERE AA.RS_ATTRIBUTE_ID = A.RS_ATTRIBUTE_ID AND AA.WORKER_PREF_FLAG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: RS_WORKER_TBL

2 RS_ATTRIBUTE_ID Character(10) VARCHAR2(10) NOT NULL This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
Prompt Table: RS_ATTR_PREF_VW

3 RS_ATTR_VAL_ID Character(10) VARCHAR2(10) NOT NULL Attribute Value ID
Prompt Table: %EDITTABLE

4 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level
Default Value: 2
Prompt Table: RS_INT_RATNG_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RS_WORKER_TBL
2	RS_ATTRIBUTE_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker. Prompt Table: RS_ATTR_PREF_VW
3	RS_ATTR_VAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Attribute Value ID Prompt Table: %EDITTABLE
4	INTEREST_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Interest Level Default Value: 2 Prompt Table: RS_INT_RATNG_VW