HRS_RCRT_TMPL_I

(SQL View)
 Index Back

Recruitment Template Interface

Recruiting template interface view

SELECT A.HRS_RCRT_TMPL_ID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.HRS_RES_TMPL_ID , A.HRS_JO_TMPL_ID , A.ERP_TMPL , A.INTVW_EVAL_TMPL , A.HRS_PST_TMPL_ID , A.HRS_SCR_TMPL_ID , A.HRS_JOBPROFILE_SRC , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_RCRT_TMPL A

  • Related Language Record: HRS_RCTMPL_LN_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_RCRT_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Template ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 HRS_RES_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Resume Template ID

    Prompt Table: HRS_RES_TMPL

    7 HRS_JO_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Template ID
    8 ERP_TMPL Character(12) VARCHAR2(12) NOT NULL Employee Referral Program

    Prompt Table: HRS_REF_PGM

    9 INTVW_EVAL_TMPL Character(15) VARCHAR2(15) NOT NULL Interview Evaluation Template

    Prompt Table: HRS_INT_EVL_DFN

    10 HRS_PST_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job opening posting template id
    11 HRS_SCR_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Screening template ID
    12 HRS_JOBPROFILE_SRC Character(1) VARCHAR2(1) NOT NULL Determines if the job profile is used and where the it comes from
    C=Job Code
    F=Job Family
    N=Not Used
    P=Position
    S=Salary Grade

    Default Value: N

    13 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id