HRS_JORQMT_P_VW

(SQL View)
 Index Back

Job Opening Standard Rqmts Int

Job opening standard requirements interface

SELECT A.HRS_JOB_OPENING_ID , A.HRS_JO_RQMT_SEQ , A.JOBCODE , A.HRS_JO_PRM_JCD_FLG , A.GVT_NUM_APPS_CONS , A.GVT_RQSN_CERT_NBR , A.GVT_RQSN_CERT_SRC , A.GVT_RQSN_CERT_STS , A.DT_DUE , A.DT_ISSUED , A.DT_RECVD , A.DT_REQUESTED , A.DT_RETURNED , A.GVT_DT_EXTENDED , A.GVT_DT_RET_FRM_SO , A.GVT_DT_SENT_TO_SO , A.REG_REGION , A.FULL_PART_TIME , A.REG_TEMP , A.BEGIN_DT , A.END_DT , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.SHIFT , A.HRS_JO_MIN_RT , A.HRS_JO_MAX_RT , A.PAY_FREQ_ABBRV , A.CURRENCY_CD , A.SAL_ADMIN_PLAN , A.GRADE_FROM , A.GRADE_TO , A.STEP_FROM , A.STEP_TO , 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 , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_RQMT A WHERE A.HRS_JO_PRM_JCD_FLG = 'Y'

  • Parent record: HRS_JO_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

    Default Value: 0

    Prompt Table: HRS_JO_I

    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

    Prompt Table: HRS_JOBCODE_I

    4 HRS_JO_PRM_JCD_FLG Character(1) VARCHAR2(1) NOT NULL Primary job code for job opening
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    5 GVT_NUM_APPS_CONS Number(2,0) SMALLINT NOT NULL Nbr of Applicants to Consider
    6 GVT_RQSN_CERT_NBR Character(10) VARCHAR2(10) NOT NULL Certificate of Eligibles Nbr
    7 GVT_RQSN_CERT_SRC Character(1) VARCHAR2(1) NOT NULL Certificate Source
    I=Generated Internally
    O=Requested from OPM
    8 GVT_RQSN_CERT_STS Character(1) VARCHAR2(1) NOT NULL Certificate Status
    C=Cancelled
    F=Forwarded by Selecting Off
    I=Issued/Received
    M=Pending Min Qual Determination
    P=Pending Ratings
    R=Requested
    S=Re-Issued
    T=Returned by Selecting Official
    U=Returned to Issuer
    W=Waiting Applicants
    9 DT_DUE Date(10) DATE Due Date
    10 DT_ISSUED Date(10) DATE Issue Date
    11 DT_RECVD Date(10) DATE Date Received
    12 DT_REQUESTED Date(10) DATE Date of Request
    13 DT_RETURNED Date(10) DATE Date Returned
    14 GVT_DT_EXTENDED Date(10) DATE Extension Date
    15 GVT_DT_RET_FRM_SO Date(10) DATE Date Returned from SO
    16 GVT_DT_SENT_TO_SO Date(10) DATE Date Sent to SO
    17 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    18 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    19 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: R

    20 BEGIN_DT Date(10) DATE Begin Date
    21 END_DT Date(10) DATE end date
    22 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    23 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Prompt Table: HRS_FREQUENCY_I

    24 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating
    25 HRS_JO_MIN_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening minimum rate
    26 HRS_JO_MAX_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening maximum rate
    27 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
    A=Annual
    B=Bi-weeky
    H=Hour
    M=Month
    Y=Year
    28 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: HRS_CURRENCY_VW

    29 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: HRS_SAL_PLAN_I

    30 GRADE_FROM Character(3) VARCHAR2(3) NOT NULL From Grade

    Prompt Table: HRS_SAL_GRADE_I

    31 GRADE_TO Character(3) VARCHAR2(3) NOT NULL To Grade

    Prompt Table: HRS_SAL_GRADE_I

    32 STEP_FROM Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: HRS_SAL_STEP_I

    33 STEP_TO Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: HRS_SAL_STEP_I

    34 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
    35 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
    36 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
    37 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
    38 GVT_NTE_DATE Date(10) DATE Not To Exceed Date
    39 GVT_NTE_DAYS Number(4,0) SMALLINT NOT NULL Not-to-Exceed Days
    40 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
    41 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
    42 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    43 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    44 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    45 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id