HRS_RCRT_TMPL(SQL Table) |
Index Back |
|---|---|
Recruitment TemplateRecruitment template |
| # | 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
Prompt Table: HRS_JO_TMPL |
| 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
Prompt Table: HRS_JO_PST_TMPL |
| 11 | HRS_SCR_TMPL_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Screening template ID
Prompt Table: HRS_SCR_TMPL |
| 12 | 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 |
| 13 | 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 |
| 14 | HRS_FLXTGRP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Flexible Template Group ID.
Prompt Table: HRS_FLXTGRP_VW |
| 15 | 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 |
| 16 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 17 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 18 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 19 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |