RS_WRKR_PREFS(SQL Table) |
Index Back |
---|---|
RM Flexible Worker PreferencesStores 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 |