HRS_CE_JO_EXT_I(SQL View) |
Index Back |
|---|---|
External Job OpeningsJob openings with postings that are available for external applicants. |
| SELECT HRS_JOB_OPENING_ID ,HRS_JO_PST_SEQ ,HRS_JO_TYPE ,POSTING_TITLE ,STATUS_CODE ,OPEN_DT ,BUSINESS_UNIT ,COMPANY ,DEPTID ,HOT_JOB ,ORIGINATOR_ID ,MANAGER_ID ,RECRUITER_ID , HRS_LOCATION_ID FROM PS_HRS_JO_ROWEXT_I |
| # | 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 |
| 2 | HRS_JO_PST_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Job opening posting sequence
Prompt Table: HRS_JO_PST_I |
| 3 | HRS_JO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Type
P=Continuous Job Opening R=Standard Requisition |
| 4 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 5 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table: HRS_STS_JO_VW |
| 6 | OPEN_DT | Date(10) | DATE | Created |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |
| 8 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 9 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 10 | HOT_JOB | Character(1) | VARCHAR2(1) NOT NULL |
Indicates which Job requisitions are classed as urgent to fill. Hot Jobs are identified during the develop requisition process and used as an indicator for both the organization and applicant.
Y/N Table Edit |
| 11 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 12 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Manager ID
Prompt Table: PERSON_NAME |
| 13 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 14 | HRS_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area |