HRS_JO_BASE_VW(SQL View) |
Index Back |
|---|---|
Ext and Int Job OpeningsJob openings with postings that are available for external and internal applicants. |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_PST_SEQ , A.HRS_JO_PST_TYPE , A.HRS_SOURCE_ID , A.STATUS_CODE , A.POSTING_TITLE , A.BUSINESS_UNIT ,A.SETID_DEPT , A.DEPTID ,A.DEPT_DESCR ,A.HRS_JOB_FAMILY , A.JOB_FAMILY , A.JOB_FUNCTION ,A.HRS_MGR_NAME , A.RECRUITER_NAME , A.COUNTRY , A.COUNTRY_DESCR , A.STATE , A.STATE_DESCR , A.CITY ,A.LOCATION ,A.LOCATION_DESCR , A.HRS_JO_MIN_RT , A.HRS_JO_MAX_RT , A.PAY_FREQ_ABBRV , A.CURRENCY_CD ,A.OPEN_DT ,A.DESCR30 ,A.HRS_JO_PST_CLS_DT ,A.HRS_JO_PST_RVW_DT ,A.LASTUPDDTTM ,B.HRS_PRM_LOC_AREA ,E.DESCR FROM PS_HRS_JPST_TBL A LEFT OUTER JOIN PS_HRS_JOB_OPENING B ON B.HRS_JOB_OPENING_ID=A.HRS_JOB_OPENING_ID LEFT OUTER JOIN PS_SET_CNTRL_GROUP D ON B.BUSINESS_UNIT = %Substring(D.SETCNTRLVALUE,1,5) AND D.REC_GROUP_ID = 'RS_LOC' LEFT OUTER JOIN PS_HRS_LOCATION E ON D.SETID = E.SETID AND B.HRS_PRM_LOC_AREA = E.HRS_LOCATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table: HRS_JO_I |
| 2 | HRS_JO_PST_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Job opening posting sequence
Prompt Table: HRS_JO_PST_I |
| 3 | HRS_JO_PST_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Posting Type
C=Contingent Workforce E=External Posting I=Internal Posting L=Labor Office R=Recruitment |
| 4 | HRS_SOURCE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Source ID |
| 5 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table: HRS_STS_JO_VW |
| 6 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: HRS_BS_UNT_HR_I |
| 8 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 10 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description |
| 11 | HRS_JOB_FAMILY | Character(30) | VARCHAR2(30) NOT NULL | Job family description |
| 12 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 13 | JOB_FUNCTION | Character(3) | VARCHAR2(3) NOT NULL | Job Function |
| 14 | HRS_MGR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Hiring Manager |
| 15 | RECRUITER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter Name |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 17 | COUNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 18 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 19 | STATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 20 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 21 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 22 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location Description |
| 23 | HRS_JO_MIN_RT | Number(22,6) | DECIMAL(21,6) NOT NULL | Job opening minimum rate |
| 24 | HRS_JO_MAX_RT | Number(22,6) | DECIMAL(21,6) NOT NULL | Job opening maximum rate |
| 25 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year |
| 26 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 27 | OPEN_DT | Date(10) | DATE | Created |
| 28 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 29 | HRS_JO_PST_CLS_DT | Date(10) | DATE | Job opening post close date |
| 30 | HRS_JO_PST_RVW_DT | Date(10) | DATE | Job opening posting next review date |
| 31 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 32 | HRS_PRM_LOC_AREA | Number(15,0) | DECIMAL(15) NOT NULL | Primary recruiting location area |
| 33 | HRS_RECR_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Job opening recruiting location |