HRS_JO_JOBCD_I

(SQL View)
 Index Back

Job opening job codes intfc

Job opening job codes interface

SELECT A.HRS_JOB_OPENING_ID , A.JOBCODE , A.HRS_JO_RQMT_SEQ , B.DESCR , A.HRS_JO_PRM_JCD_FLG , 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 , A.GVT_TYPE_OF_APPT , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_RQMT A , PS_HRS_JOBCODE_I3 B , PS_SET_CNTRL_REC C , PS_HRS_JO_I D WHERE A.HRS_JOB_OPENING_ID = D.HRS_JOB_OPENING_ID AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.RECNAME = 'HRS_JOBCODE_I' AND A.JOBCODE = B.JOBCODE AND B.SETID = C.SETID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_HRS_JOBCODE_I E WHERE B.JOBCODE = E.JOBCODE AND B.SETID = E.SETID AND B.EFFDT <= %DateIn('9999-09-09'))

  • Related Language Record: HRS_JO_JC_LN_I

  • 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

    Prompt Table: HRS_JO_I

    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HRS_JOBCODE_I

    3 HRS_JO_RQMT_SEQ Number(3,0) SMALLINT NOT NULL Job opening requirement sequence
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 HRS_JO_PRM_JCD_FLG Character(1) VARCHAR2(1) NOT NULL Primary job code for job opening

    Y/N Table Edit

    Default Value: N

    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=1
    2=2
    3=3
    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: SAL_PLAN_TBL

    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: SAL_STEP_FRM_VW

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

    Prompt Table: SAL_STEP_TO_VW

    34 HRS_TRAVEL_PERCENT Character(1) VARCHAR2(1) NOT NULL Travel percent
    0=None
    1=<= 25%
    2=26 - 50 %
    3=51 - 75 %
    4=76 - 100 %
    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 field
    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 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)
    43 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    44 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    45 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    46 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id