HRS_CURCTMPL_VW(SQL View) |
Index Back |
---|---|
Latest Recruitment TemplateLatest 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) |
# | 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 |