HRS_JOB_OPENING_IDP=Continuous Job Opening
R=Standard Requisition
HRS_JOBOPEN_VW3(SQL View) |
Index Back |
|---|---|
JOB OPEN HEADER VIEWFluid Approval - Job opening |
| SELECT DISTINCT J.HRS_JOB_OPENING_ID , J.HRS_PRM_PST_TITLE , J.HRS_JO_TYPE , ' ' , J.HRS_PRM_POSITION , ' ' , J.BUSINESS_UNIT , BU.DESCR , J.HRS_PRM_JOBCODE , ' ' , J.JOB_FAMILY , ' ' , J.COMPANY , ' ' , J.SETID_DEPT , J.HRS_PRM_LOC_AREA , ' ' , J.DEPTID , ' ' , ' ' , ' ' , J.OPEN_DT , %Sql(HR_HT_EMAIL_DATE,J.OPEN_DT) , J.DESIRED_START_DT , %Sql(HR_HT_EMAIL_DATE,J.DESIRED_START_DT) , J.OPENINGS_TARGET , ' ' , ' ' , ' ' , CASE J.BUSINESS_UNIT WHEN ' ' THEN ' ' ELSE BU.DESCR %Concat ' - ' %Concat J.BUSINESS_UNIT END , ' ' , ' ' , 'X' FROM PS_HRS_JOB_OPENING J , PS_BUS_UNIT_TBL_HR BU WHERE BU.BUSINESS_UNIT = J.BUSINESS_UNIT |
| # | 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 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 3 | HRS_JO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Type
P=Continuous Job Opening R=Standard Requisition |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 5 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 6 | DESCR6 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 11 | JOB_FAMILY | Character(6) | VARCHAR2(6) NOT NULL | Job Family |
| 12 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 13 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 14 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 15 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 16 | HRS_LOCATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Recruiting location area |
| 17 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 18 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 19 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 20 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 21 | NAME_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 22 | OPEN_DT | Date(10) | DATE | Created |
| 23 | DESCR25 | Character(25) | VARCHAR2(25) NOT NULL | Short description |
| 24 | DESIRED_START_DT | Date(10) | DATE | Desired Start Date |
| 25 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description |
| 26 | OPENINGS_TARGET | Number(3,0) | SMALLINT NOT NULL | Tracks number of target openings |
| 27 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 28 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 29 | DESCR45 | Character(45) | VARCHAR2(45) NOT NULL | Description |
| 30 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 31 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 32 | DESCR50_HR1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 33 | DESCR_COMMENTS_HIS | Long Character | CLOB | This field is used in a complex query that shows many descr fields. |