HRSINSTALLATION(SQL Table) |
Index Back |
|---|---|
eRecruit Installation TableeRecruit Installation Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ER_PRF_ACTV_DAYS | Number(3,0) | SMALLINT NOT NULL | Days Job Search Agent Active |
| 2 | APPLY_ONLINE_URL | Character(30) | VARCHAR2(30) NOT NULL |
Apply On-Line URL
Prompt Table: HRS_APLYONLN_VW |
| 3 | LAST_REFTRK_ID | Number(9,0) | DECIMAL(9) NOT NULL | Last Referral Track Id |
| 4 | HRS_TMPL_SEGMENT | Character(2) | VARCHAR2(2) NOT NULL |
Segmenting type for recruiting template
10=Business Unit 20=Company 30=Department 40=Job Profile 50=Job Family 60=Job Code 70=Salary Grade |
| 5 | HRS_REQ_DFLT_TMPL | Number(15,0) | DECIMAL(15) NOT NULL |
Default job opening requisition template
Prompt Table: HRS_RCRT_TMPL |
| 6 | HRS_PST_DFLT_TMPL | Number(15,0) | DECIMAL(15) NOT NULL |
Default job opening requisition template
Prompt Table: HRS_RCRT_TMPL |
| 7 | URL_ID | Character(30) | VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
Prompt Table: PSURLDEFN |
| 8 | AGENT_RESULTS_URL | Character(30) | VARCHAR2(30) NOT NULL |
Job Search Agent Results URL
Prompt Table: HRS_APLYONLN_VW |
| 9 | HRS_REQ_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening: Requisitions Approval Flag
Y/N Table Edit Default Value: Y |
| 10 | HRS_POST_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening: Posting Approval Flag
Y/N Table Edit Default Value: N |
| 11 | HRS_OFF_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Offer Approval Flag
Default Value: Y |
| 12 | HRS_MAX_AGENTS | Number(3,0) | SMALLINT NOT NULL | Maximum number of job agents allowable |
| 13 | HRS_SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Run Search Match
O=Optional R=Required Default Value: O |
| 14 | HRS_ET_SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Add External Trainee
N=No Y=Yes Default Value: N |
| 15 | HRS_MULTIPLE_JOBS | Character(1) | VARCHAR2(1) NOT NULL |
Multiple job or positions flag.
Y/N Table Edit Default Value: N |
| 16 | HRS_LATEST_JO_DAYS | Number(3,0) | SMALLINT NOT NULL | Show Jobs Posted Time Frame |
| 17 | HRS_PREREG_TERMS | Character(1) | VARCHAR2(1) NOT NULL |
Preregistration terms and cond
Y/N Table Edit Default Value: N |
| 18 | HRS_SM_ADD_APP | Character(1) | VARCHAR2(1) NOT NULL | Search Match - Add Applicant |
| 19 | HRS_SM_OIF | Character(1) | VARCHAR2(1) NOT NULL | Search Match - OIF |
| 20 | INTVW_EVAL_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Interview Evaluation Template
Prompt Table: HRS_INT_EVL_DFN |
| 21 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Site ID
Prompt Table: HRS_SITE_ID_PT |
| 22 | HRS_WC_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Works Council Approval field, used on RS Installation record
Default Value: N |
| 23 | HRS_INTJOB_ERP | Character(1) | VARCHAR2(1) NOT NULL |
Allow Internal Jobs for ERP
Y/N Table Edit |
| 24 | HRS_DUPE_MRG_INACT | Character(3) | VARCHAR2(3) NOT NULL |
Duplicate Merge Inactive State
Prompt Table: HRS_STS_CLS_VW |
| 25 | HRS_SCREENING_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Screening ID
Prompt Table: HRS_ONL_SCRN_VW |
| 26 | HRS_NOTIFY_APP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicator as to whether an Applicant will be notified on rejection
Y/N Table Edit Default Value: N |
| 27 | HRS_IA_MAX_RSLTS | Number(7,0) | INTEGER NOT NULL |
Search Result Limit
Default Value: 10000 |
| 28 | HRS_OFCCP_IND | Character(1) | VARCHAR2(1) NOT NULL |
OFCCP Compliance
Y/N Table Edit Default Value: N |
| 29 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 30 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 31 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 32 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |