HRS_RCMNT_HST

(SQL Table)
 Index Back

Recruitment Tracking

The Recruitment Tracking manages an applicant's progress through recruiting.

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    5 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
    6 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    7 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_REC_I

    8 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_RSN_REC_I

    9 HRS_STATUS_DT Date(10) DATE Recruiting Solutions Status Date field
    10 ENTRY_SOURCE Character(1) VARCHAR2(1) NOT NULL Entry Source
    A=Application
    O=Organization

    Default Value: A

    11 HRS_SUBMIT_SOURCE Character(1) VARCHAR2(1) NOT NULL field used to identify where this application was submitted from: C- Candidate Gateway, T- TAM
    C=Candidate Gateway
    T=TAM
    12 HRS_APP_INTEREST Character(1) VARCHAR2(1) NOT NULL Applicant Interest
    1=Low
    2=Medium
    3=High
    13 ENTRY_DATE Date(10) DATE Date Entered

    Default Value: %date

    14 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

    Prompt Table: HRS_APP_CNTRACT

    15 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    16 OFF_REFSRC_CAT Character(2) VARCHAR2(2) NOT NULL Official Referral Source
    AD=Advertisement
    AG=Agency
    CL=Client Referral
    CO=College Recruiting
    CR=College Recommendation
    EE=Employee
    ES=Employment Securitry Bureau
    FE=Former Employee
    JF=Job Fair
    JP=Job Posting
    OH=Open House
    OT=Other Source
    PI=Phone Inquiry
    UK=Unknown
    US=Unsolicited
    WI=Walk-In
    XR=Executive Referral
    XS=Executive Search
    17 OFF_REFSRC_SUB Character(2) VARCHAR2(2) NOT NULL Offer Referral Subcategory

    Prompt Table: HRS_REF_SUBCAT
    Set Control Field: REF_SRC_SUB_CAT

    18 REQST_ADDTNL_INFO Character(1) VARCHAR2(1) NOT NULL Request Additional Information
    19 KEYWORD_MATCH Character(1) VARCHAR2(1) NOT NULL Keyword match

    Y/N Table Edit

    20 HRS_JO_NTF_DELETED Character(1) VARCHAR2(1) NOT NULL Job Offer Notification Deletion Indicator
    21 EODI_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Transaction ID
    22 HRS_LOGICAL_DELETE Character(1) VARCHAR2(1) NOT NULL Indicates row has been logically deleted.
    23 HRS_WITHDRAWN_DTTM DateTime(26) TIMESTAMP Date time stamp when the candidate's application was withdrawn.
    24 GVT_APPL_COMP_STS Character(1) VARCHAR2(1) NOT NULL Applicant Competitive Status
    0=Mark...
    C=Competitive
    N=Non-Competitive VRA
    O=Non-Competitive Other
    25 GVT_RQSN_CERT_NBR Character(10) VARCHAR2(10) NOT NULL Certificate of Eligibles Nbr
    26 GVT_QUALS_DETERM Character(1) VARCHAR2(1) NOT NULL Qualifications Determination Flag
    B=Best Qualified
    D=Does Not Meet Min Quals
    N=Eligible/Not Rated
    Q=Qualified
    W=Well Qualified
    27 GVT_QUALS_DET_DATE Date(10) DATE Qualifications Determ Date
    28 GVT_MIN_QUAL_SCORE Number(5,1) DECIMAL(4,1) NOT NULL Minimum Quals Score
    29 GVT_APPL_AP_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Augmentation Points for Applicants
    30 GVT_APPL_VP_SCORE Signed Number(3,0) DECIMAL(2) NOT NULL Veterans Preference Points
    31 HRS_APP_SEL_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Selective factor points earned by an applicant.
    32 HRS_SCR_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Screening score. Includes all points awarded to an applicant for a screening level, less veterans preference points, augmenting points, and selective factor points.
    33 HRS_SCR_TTL_SCORE Signed Number(6,1) DECIMAL(4,1) NOT NULL Screening score. Includes all points awarded to an applicant for a screening level, INCLUDING veterans preference points, augmenting factor points, and selective factor points.
    34 GVT_RANK_CATEGORY Character(1) VARCHAR2(1) NOT NULL Ranking Category
    1=Category 1
    2=Category 2
    3=Category 3
    4=Category 4
    35 GVT_RANK_STATUS Character(1) VARCHAR2(1) NOT NULL Ranking Status
    N=Do Not Rank
    R=Rank

    Default Value: N

    36 GVT_APPL_RANK Number(3,0) SMALLINT NOT NULL Rank on Certificate
    37 GVT_VET_RECR_CODE Character(3) VARCHAR2(3) NOT NULL Recruitment Code
    1=CPS
    2=CP
    3=XP
    4=TP
    5=NV
    38 GVT_SORT_ORDER Number(14,10) DECIMAL(13,10) NOT NULL Sort Order Field
    39 GVT_PRIO_WEIGHT Number(3,0) SMALLINT NOT NULL Priority Placement Weight
    40 GVT_PRIO_PLCMNT_CD Character(3) VARCHAR2(3) NOT NULL Priority Placement Code

    Prompt Table: HRS_G_PR_PL_TBL

    41 GVT_RQSN_SEL_CRITE Character(1) VARCHAR2(1) NOT NULL Job Opening Selection Criteria
    1=None
    2=Must Consider
    3=Must Select
    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
    46 HRS_TRG_UPD_DTTM DateTime(26) TIMESTAMP Search Index Updated DateTime