RS_WRKR_PREFS

(SQL Table)
Index Back

RM Flexible Worker Preferences

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

# 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