HRS_BIP_JOBINFO(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Job Opening Information |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_RCRT_TMPL_ID , A.REFERRAL_PGM_ID , ' ' , A.ORIGINATOR_ID , B.NAME_DISPLAY , ' ' , A.OPEN_DT , ' ' , A.STATUS_CODE , C.DESCR , A.STATUS_REASON , O.DESCR , A.STATUS_DT , ' ' , A.HRS_OPENING_LIMIT , ' ' , ' ' , A.OPENINGS_CNT , A.OPENINGS_TARGET , A.BUSINESS_UNIT , ' ' , ' ' , A.SETID_DEPT , A.DEPTID , ' ' , ' ' , A.COMPANY , ' ' , ' ' , A.DESIRED_START_DT , ' ' , A.ENCUMB_DT_INDC , ' ' , A.PROJECTED_FILL_DT , ' ' , A.AUTHORIZATION_DT , ' ' , A.ESTABID , ' ' , ' ' , A.COUNTRY , ' ' , ' ' , A.CITIZENSHIP_STATUS , ' ' , A.MIN_AGE , A.MAX_AGE , A.SEX , ' ' , A.HRS_CONTACT_ID , P.HRS_CONTACT_NAME , A.GVT_CONSIDER_AREA , ' ' , A.GVT_DRAFT_STATUS , ' ' , A.HRS_G_JO_TYPE , ' ' , A.WC_COUNCIL_ID FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_HRS_RSN_JO_VW O ON(A.STATUS_CODE = O.STATUS_CODE AND O.STATUS_AREA = '1' AND A.STATUS_REASON = O.STATUS_REASON) LEFT OUTER JOIN PS_HRS_RO_CNTCT_I P ON(A.HRS_CONTACT_ID = P.HRS_CONTACT_ID) , PS_HRS_ACT_PERS_I1 B , PS_HRS_STS_JO_VW C WHERE A.ORIGINATOR_ID = B.EMPLID AND A.STATUS_CODE = C.STATUS_CODE AND C.STATUS_AREA = '1' |
| # | 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_RCRT_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Recruitment Template ID |
| 3 | REFERRAL_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Employee referral program ID |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 5 | ORIGINATOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Originator's ID |
| 6 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 7 | HRS_BIP_ORIGNDESCR | Character(70) | VARCHAR2(70) NOT NULL | Originator ID |
| 8 | OPEN_DT | Date(10) | DATE | Created |
| 9 | HRS_OPNDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 10 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 11 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 12 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |
| 13 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 14 | STATUS_DT | Date(10) | DATE | Status Date |
| 15 | HRS_STSDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 16 | HRS_OPENING_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
Unlimited or limited number of job openings flag
L=Limited Number of Openings U=Unlimited Number of Openings |
| 17 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 18 | HRS_BIP_OPLMTDESCR | Character(40) | VARCHAR2(40) NOT NULL | Opening Limit |
| 19 | OPENINGS_CNT | Number(3,0) | SMALLINT NOT NULL | Tracks number of openings |
| 20 | OPENINGS_TARGET | Number(3,0) | SMALLINT NOT NULL | Tracks number of target openings |
| 21 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 22 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 23 | HRS_BIP_BUSDESCR | Character(40) | VARCHAR2(40) NOT NULL | Business Unit |
| 24 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 25 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 26 | DESCR_DEPT | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 27 | HRS_BIP_DEPTDESCR | Character(35) | VARCHAR2(35) NOT NULL | Department |
| 28 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 29 | DESCR6 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 30 | HRS_BIP_CMPNYDESCR | Character(40) | VARCHAR2(40) NOT NULL | Company |
| 31 | DESIRED_START_DT | Date(10) | DATE | Desired Start Date |
| 32 | HRS_DSRDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used for XMLP Print Job Opening |
| 33 | ENCUMB_DT_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Date Indicator
A=Authorization Date P=Project Fill Date |
| 34 | DESCR7 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 35 | PROJECTED_FILL_DT | Date(10) | DATE | Projected Fill Date |
| 36 | HRS_PRJFLLDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 37 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 38 | HRS_AUTHDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 39 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 40 | DESCR8 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 41 | HRS_BIP_ESTABDESCR | Character(50) | VARCHAR2(50) NOT NULL | Establishment ID |
| 42 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 43 | DESCR_COUNTRY | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 44 | HRS_BIP_CNTRYDESCR | Character(40) | VARCHAR2(40) NOT NULL | Country |
| 45 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Citizenship Status |
| 46 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Derived Descr |
| 47 | MIN_AGE | Number(3,0) | SMALLINT NOT NULL | Minimum age for employee benefits |
| 48 | MAX_AGE | Number(3,0) | SMALLINT NOT NULL | Maximum age for employee benefits |
| 49 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 50 | DESCR_4 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 51 | HRS_CONTACT_ID | Number(15,0) | DECIMAL(15) NOT NULL | Contact Id |
| 52 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 53 | GVT_CONSIDER_AREA | Character(1) | VARCHAR2(1) NOT NULL |
Area of Consideration
A=Agency E=External Government F=Federal Government N=Nationwide S=Subagency W=Worldwide |
| 54 | HRS_GVT_CONS_AREA | Character(30) | VARCHAR2(30) NOT NULL | Used in XMLP report for Job Opening |
| 55 | GVT_DRAFT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered R=Registered X=Not Applicable |
| 56 | HRS_GVT_DFT_STS | Character(30) | VARCHAR2(30) NOT NULL | Used in XMLP report for Job Opening |
| 57 | HRS_G_JO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Federal job requisition type
I=Internal M=Merit Promotion O=Open Competition |
| 58 | HRS_GJOTYP_DESC | Character(30) | VARCHAR2(30) NOT NULL | Used in XMLP report for Job Opening |
| 59 | WC_COUNCIL_ID | Character(9) | VARCHAR2(9) NOT NULL | Works Council ID |