HRS_RCRT_TMPL_IDPrompt Table: HRS_RES_TMPL
Prompt Table: HRS_REF_PGM
Prompt Table: HRS_INT_EVL_DFN
C=Job Code
F=Job Family
N=Not Used
P=Position
S=Salary Grade
Default Value: N
HRS_RCRTTMPL_VW(SQL View) |
Index Back |
|---|---|
Recruitment Template InterfaceRecruiting template interface view |
| SELECT A.HRS_RCRT_TMPL_ID , 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 FROM PS_HRS_RCRT_TMPL A WHERE %EffdtCheck(HRS_RCRT_TMPL B, A, %CURRENTDATEIN) AND A.EFF_STATUS = 'A' |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | HRS_RES_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Resume Template ID
Prompt Table: HRS_RES_TMPL |
| 5 | HRS_JO_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Template ID |
| 6 | ERP_TMPL | Character(12) | VARCHAR2(12) NOT NULL |
Employee Referral Program
Prompt Table: HRS_REF_PGM |
| 7 | INTVW_EVAL_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Interview Evaluation Template
Prompt Table: HRS_INT_EVL_DFN |
| 8 | HRS_PST_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job opening posting template id |
| 9 | HRS_SCR_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL | Screening template ID |
| 10 | 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 |