HRS_BIP_JSTF_VW(SQL View) |
Index Back |
|---|---|
Used in XMLP report for Job OXMLP report Print Job Opening Staffing Information |
| SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.JOBCODE , A.HRS_JO_PRM_JCD_FLG , ' ' , A.BEGIN_DT , ' ' , A.END_DT , ' ' , A.REG_REGION , B.DESCR50 , A.FULL_PART_TIME , ' ' , A.REG_TEMP , ' ' , A.STD_HOURS , A.STD_HRS_FREQUENCY , ' ' , A.SHIFT , ' ' , A.HRS_TRAVEL_PERCENT , ' ' , A.MANAGER_LEVEL , ' ' , A.FLSA_STATUS , ' ' , A.GVT_SUMMER_APPT , ' ' , A.GVT_NTE_DATE , ' ' , A.GVT_NTE_DAYS , A.GVT_LEO_POSITION , ' ' , A.GVT_POSN_SENS_CD , ' ' , A.GVT_TYPE_OF_APPT , ' ' FROM PS_HRS_JO_RQMT A LEFT OUTER JOIN PS_REG_REGION_TBL B ON (A.REG_REGION = B.REG_REGION) |
| # | 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_RQMT_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening requirement sequence |
| 3 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 4 | HRS_JO_PRM_JCD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Primary job code for job opening
N=No Y=Yes |
| 5 | FLAG | Character(1) | VARCHAR2(1) NOT NULL | Flag |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | HRS_BGNDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used for XMLP Print Job Opening |
| 8 | END_DT | Date(10) | DATE | end date |
| 9 | HRS_ENDDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used for XMLP Print Job Opening |
| 10 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 12 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 14 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 15 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 16 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 17 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |
| 18 | DESCR50_1 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 19 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating |
| 20 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 21 | HRS_TRAVEL_PERCENT | Character(1) | VARCHAR2(1) NOT NULL |
Travel percent
0=Never or rarely 1=Up to 25% of the time 2=Up to 50% of the time 3=Up to 75% of the time 4=Up to 100% of the time |
| 22 | DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | Descr 3 |
| 23 | MANAGER_LEVEL | Character(2) | VARCHAR2(2) NOT NULL |
Manager Level
0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager |
| 24 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 25 | FLSA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FLSA Status
A=Administrative C=Computer Employee E=Executive H=Highly Compensated Employees M=Management N=Nonexempt O=Outside Salesperson P=Professional V=Nonexempt Alt Overtime X=No FLSA Required |
| 26 | DESCR4 | Character(30) | VARCHAR2(30) NOT NULL | Descr 4 |
| 27 | GVT_SUMMER_APPT | Character(1) | VARCHAR2(1) NOT NULL |
Summer Appointment
C=Cooperative Education F=Federal Internship Program N=Not Student Opportunity S=Summer Employment T=Student Temporary Educ Program V=Volunteer Service W=University Work Study |
| 28 | DESCR5 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 29 | GVT_NTE_DATE | Date(10) | DATE | Not To Exceed Date |
| 30 | HRS_NTEDT_STR | Character(15) | VARCHAR2(15) NOT NULL | Used in XMLP report for Job Opening |
| 31 | GVT_NTE_DAYS | Number(4,0) | SMALLINT NOT NULL | Not-to-Exceed Days |
| 32 | GVT_LEO_POSITION | Character(1) | VARCHAR2(1) NOT NULL |
LEO/Fire Position
5=5USC 5305 LEO C=D.C. Police Forces F=Fire Fighter N=Not Applicable P=Primary FEPCA S=Secondary FEPCA |
| 33 | DESCR6 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 34 | GVT_POSN_SENS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Sensitivity Code
1=Non Sensitive 2=Non-Critical, Sensitive 3=Critical Sensitive 4=Special Sensitive |
| 35 | DESCR7 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |
| 36 | GVT_TYPE_OF_APPT | Character(2) | VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm) 15=Career-Conditional (Comp Perm) 20=Nonpermanent (Comp NonPerm) 30=Schedule A (Except Svc Perm) 32=Schedule B (Except Svc Perm) 34=Schedule C (Except Svc Perm) 36=Executive (Except Svc Perm) 38=Other (Except Svc Perm) 40=Schedule A (Except NonPerm) 42=Schedule B (Except NonPerm) 44=Schedule C (Except NonPerm) 46=Executive (Except NonPerm) 48=Other (Except NonPerm) 50=Career (Senior Exec Perm) 55=Noncareer (Senior Exec Perm) 60=Limited Term (Senior Exec NPrm 65=Limited Emergency (SES NPerm) |
| 37 | DESCR8 | Character(30) | VARCHAR2(30) NOT NULL | This field is used in a complex query that shows many descr fields. |