EMPLIDY/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
RS_ATTR_SEL_VW(SQL View) |
Index Back |
|---|---|
Emp Attribute OptionsThis view displays Employee options for Search in Staffing Workbench. Only selected attributes are considered to retrieve Search results. |
| SELECT EMPLID ,SELECT_CMP ,SELECT_DEG ,SELECT_LIC ,SELECT_LNG ,SELECT_MEM FROM PS_RS_WORKER_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SELECT_CMP | Character(1) | VARCHAR2(1) NOT NULL |
Include Competency for Search
Y/N Table Edit Default Value: Y |
| 3 | SELECT_DEG | Character(1) | VARCHAR2(1) NOT NULL |
Include Education for Search
Y/N Table Edit Default Value: Y |
| 4 | SELECT_LIC | Character(1) | VARCHAR2(1) NOT NULL |
Include Licenses for Search
Y/N Table Edit Default Value: Y |
| 5 | SELECT_LNG | Character(1) | VARCHAR2(1) NOT NULL |
Include Languages for Search
Y/N Table Edit Default Value: Y |
| 6 | SELECT_MEM | Character(1) | VARCHAR2(1) NOT NULL |
Include Memberships for Search
Y/N Table Edit Default Value: Y |