HRS_JOPST_JRQMT

(SQL View)
 Index Back

Job Opening Requirements

Job Opening Requirements: full-time/part-time, regular, shift

SELECT B.HRS_JOB_OPENING_ID , CASE WHEN B.FULL_PART_TIME <> ' ' THEN B.FULL_PART_TIME ELSE 'N' END , CASE WHEN B.REG_TEMP <> ' ' THEN B.REG_TEMP ELSE 'N' END , CASE WHEN B.SHIFT <> ' ' THEN B.SHIFT ELSE 'N' END , B.FULL_PART_TIME , B.REG_TEMP , B.SHIFT FROM PS_HRS_JO_RQMT B

# 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 FULLPART_SRCH_FCT Character(1) VARCHAR2(1) NOT NULL Used for translating to SES search facet values
D=On Demand
F=Full-Time
N=No Value
P=Part-Time
3 REG_TEMP_SRCH_FCT Character(1) VARCHAR2(1) NOT NULL Used for translating to SES search facet values
N=No Value
R=Regular
T=Temporary
4 SHIFT_SRCH_FCT Character(1) VARCHAR2(1) NOT NULL Used for translating to SES search facet values
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=No Value
R=Rotating
5 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
6 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
7 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating