HRS_CURCTMPL_VW

(SQL View)
Index Back

Latest Recruitment Template

Latest eff dated row for Recruitment templates

SELECT HRS_RCRT_TMPL_ID , EFF_STATUS , DESCR , DESCRSHORT ,HRS_RES_TMPL_ID , HRS_JO_TMPL_ID , ERP_TMPL , INTVW_EVAL_TMPL , HRS_PST_TMPL_ID , HRS_SCR_TMPL_ID , HRS_JO_REQ_FLG , HRS_JO_PST_FLG , HRS_JOBPROFILE_SRC FROM PS_HRS_RCRT_TMPL A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_HRS_RCRT_TMPL A1 WHERE A1.HRS_RCRT_TMPL_ID = A.HRS_RCRT_TMPL_ID)

  • Related Language Record: HRS_CRTMPL_LNVW
  • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Prompt Table: HRS_RES_TMPL

    6 HRS_JO_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Template ID

    Prompt Table: HRS_JO_TMPL

    7 ERP_TMPL Character(12) VARCHAR2(12) NOT NULL ERP Template

    Prompt Table: HRS_REF_PGM

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

    Prompt Table: HRS_INT_EVL_DFN

    9 HRS_PST_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Job opening posting template id

    Prompt Table: HRS_JO_PST_TMPL

    10 HRS_SCR_TMPL_ID Number(15,0) DECIMAL(15) NOT NULL Screening template ID

    Prompt Table: HRS_SCR_TMPL

    11 HRS_JO_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine that this is to be used for requisitions.

    Y/N Table Edit

    Default Value: Y

    12 HRS_JO_PST_FLG Character(1) VARCHAR2(1) NOT NULL Flag to determine that this is to be used for a job opening of posting only type.

    Y/N Table Edit

    Default Value: Y

    13 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