HRS_ROLE_TYPE00=Recruitment Administrator
01=Recruiter
02=Recruiting User
03=Hiring Manager
04=Federal Recruiter
05=RS Approval Administrator
06=RS Technical Administrator
XLATLONGNAMEEFFDTDefault Value: %date
HRS_ROLE_SRCH_I(SQL View) |
Index Back |
|---|---|
Role Definition Search ViewRole Type Definition Search View |
| SELECT A.HRS_ROLE_TYPE , B.XLATLONGNAME , A.EFFDT FROM PS_HRS_ROLE_DEFN A , PSXLATITEM B WHERE B.FIELDNAME = 'HRS_ROLE_TYPE' AND A.HRS_ROLE_TYPE = %Substring(B.FIELDVALUE,1,2) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_ROLE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Recruiting Role Types
00=Recruitment Administrator 01=Recruiter 02=Recruiting User 03=Hiring Manager 04=Federal Recruiter 05=RS Approval Administrator 06=RS Technical Administrator |
| 2 | XLATLONGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |