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_JCP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Job Creation Process ID used by Recruiting Solutions
Prompt Table: HRS_JCP_VW |
| 10 | HRS_RP_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Used as the Recruitment Processing ID.
Prompt Table: HRS_RP_VW |
| 11 | HRS_REQ_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening: Requisitions Approval Flag
Y/N Table Edit Default Value: Y |
| 12 | HRS_POST_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening: Posting Approval Flag
Y/N Table Edit Default Value: N |
| 13 | HRS_OFF_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Offer Approval Flag
Default Value: Y |
| 14 | HRS_MAX_AGENTS | Number(3,0) | SMALLINT NOT NULL | Maximum number of job agents allowable |
| 15 | HRS_SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Solutions Installation page - Verify Employee ID indicator for use in Manage Hire process.
O=Optional R=Required Default Value: O |
| 16 | HRS_ET_SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Solutions Installation page - Verify POI indicator for use in Manage Hire process.
N=No Y=Yes Default Value: N |
| 17 | HRS_MULTIPLE_JOBS | Character(1) | VARCHAR2(1) NOT NULL |
Multiple job or positions flag.
N=No Y=Yes Default Value: N |
| 18 | HRS_LATEST_JO_DAYS | Number(3,0) | SMALLINT NOT NULL | Show Jobs Posted Time Frame |
| 19 | HRS_PREREG_TERMS | Character(1) | VARCHAR2(1) NOT NULL |
Preregistration terms and cond
Y/N Table Edit Default Value: N |
| 20 | HRS_SM_ADD_APP | Character(1) | VARCHAR2(1) NOT NULL | Search Match - Add Applicant |
| 21 | HRS_SM_OIF | Character(1) | VARCHAR2(1) NOT NULL | Search Match - OIF |
| 22 | INTVW_EVAL_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Interview Evaluation Template
Prompt Table: HRS_INT_EVL_DFN |
| 23 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL |
Site ID
Prompt Table: HRS_SITE_ID_PT |
| 24 | HRS_WC_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Works Council Approval field, used on RS Installation record
Default Value: N |
| 25 | HRS_INTJOB_ERP | Character(1) | VARCHAR2(1) NOT NULL |
Allow Internal Jobs for ERP
Y/N Table Edit |
| 26 | HRS_DUPE_MRG_INACT | Character(3) | VARCHAR2(3) NOT NULL |
Duplicate Merge Inactive State
Prompt Table: HRS_STS_CLS_VW |
| 27 | HRS_DUP_MRG_STSRSN | Character(3) | VARCHAR2(3) NOT NULL |
Status Reason For Duplicates
Prompt Table: HRS_DMRSN_APP_I |
| 28 | 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 |
| 29 | HRS_IA_MAX_RSLTS | Number(7,0) | INTEGER NOT NULL |
Search Result Limit
Default Value: 10000 |
| 30 | HRS_OFCCP_IND | Character(1) | VARCHAR2(1) NOT NULL |
OFCCP Compliance
N=No Y=Yes Default Value: N |
| 31 | HRS_CALENDAR_INTGR | Character(1) | VARCHAR2(1) NOT NULL |
Determine if Integration with Calendar Systems will occur
F=Full Integration N=No Integration P=Partial Integration Default Value: N |
| 32 | HRS_EVAL_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
Determine if Evaluation will be available for edit (administrators only)
N=No Y=Yes Default Value: N |
| 33 | HRS_JPM_INTGRN | Character(1) | VARCHAR2(1) NOT NULL |
Checkbox on Recruiting Installation table to allow TAM integration with JPM. When set to 'Y' this field will allow JPM Non-person and/or Person Profile data to be included in a TAM Job Opening.
N=No Y=Yes Default Value: Y |
| 34 | HRS_JPM_PER_INTGRN | Character(1) | VARCHAR2(1) NOT NULL |
Determines if JPM Person Profile is allowed in TAM
N=No Y=Yes Default Value: Y |
| 35 | HRS_RANDOM_QSTN | Character(1) | VARCHAR2(1) NOT NULL |
Determines if Questions will be randomize
N=No Y=Yes Default Value: N |
| 36 | HRS_RANDOM_ANS | Character(1) | VARCHAR2(1) NOT NULL |
Determine if Answers to questions will be randomize
N=No Y=Yes Default Value: N |
| 37 | HRS_MAX_POST_NOTIF | Number(3,0) | SMALLINT NOT NULL |
Determine the maximum number of job postings
Default Value: 20 |
| 38 | HRS_ONLN_OFR | Character(1) | VARCHAR2(1) NOT NULL |
Determines if Online Offers will be made available
N=No Y=Yes Default Value: N |
| 39 | HRS_ONLN_OFR_DAYS | Number(3,0) | SMALLINT NOT NULL | Determine the number of days Online Offer valid |
| 40 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 41 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 42 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 43 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |
| 44 | HRS_SHO_LATEST_JOB | Character(1) | VARCHAR2(1) NOT NULL |
Show Latest Jobs grid in RS setting
N=No Y=Yes Default Value: Y |
| 45 | HRS_MAX_JOB_RSLTS | Number(5,0) | INTEGER NOT NULL |
Maximum number of jobs to display in Candidate Gateway
Default Value: 500 |
| 46 | HRS_EMAIL_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Email is required setting for Candidate Gateway
N=No Y=Yes Default Value: Y |
| 47 | HRS_INTEREST_DISP | Character(1) | VARCHAR2(1) NOT NULL |
This installation option indicates whether the Interest rating widget is displayed on Job 360 and Application pages.
N=No Y=Yes Default Value: N |
| 48 | HRS_REQ_REJECT_RSN | Character(1) | VARCHAR2(1) NOT NULL |
This installation option indicates whether the Recruiter must select a Reason when rejecting an Applicant for a particular job opening.
N=No Y=Yes Default Value: N |
| 49 | HRS_MAX_RSLT_MYAP | Number(3,0) | SMALLINT NOT NULL |
This field is used to limit the number of rows returned in the My Applicants pagelet.
Default Value: 300 |
| 50 | HRS_MAX_RSLT_MYJO | Number(3,0) | SMALLINT NOT NULL |
This field is used to limit the number of rows returned in the My Job Openings pagelet.
Default Value: 300 |
| 51 | HRS_JOBCAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag is used to active or disable the Job Categoriation feature
N=No Y=Yes Default Value: Y |
| 52 | HRS_BROWSE_JO_STAT | Character(3) | VARCHAR2(3) NOT NULL |
Default job opening status for Browse Job Opening page
Prompt Table: HRS_STS_JO_I |
| 53 | HRS_VISIBLE | Character(1) | VARCHAR2(1) NOT NULL |
Field visibility flag for Flex Processes
N=No Y=Yes Default Value: Y |
| 54 | HRS_ONLINE_LIMIT | Number(5,0) | INTEGER NOT NULL | This fields stores threshold beyond which group actions are processed by a batch process. |
| 55 | HRS_GRP_ACT_LMT | Number(5,0) | INTEGER NOT NULL |
This stores the limit on selection of rows for taking group actions.
Default Value: 100 |
| 56 | HRS_ADDR_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
address required
N=No Y=Yes Default Value: N |
| 57 | HRS_DISP_ADDRESS | Character(1) | VARCHAR2(1) NOT NULL |
address required
N=No Y=Yes Default Value: N |
| 58 | HRS_PHONE_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
phone required indicator
N=No Y=Yes Default Value: N |
| 59 | HRS_PRNT_NO_SEP | Character(1) | VARCHAR2(1) NOT NULL |
Print no separator pages in attachments
Y/N Table Edit Default Value: N |
| 60 | HRS_MAX_RSLT_MGJO | Number(7,0) | INTEGER NOT NULL | Field placed on Recruiting Installtion table. This field is used to configure the number of applicants displayed in Manage Job Opening component. |
| 61 | HRS_DFLT_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
Field to define the default phase the funnel display on Manage Job Opening to show when the user enters manage Job Opening.
Default value to display is ALL.
0=0 - All 1=1 - Applied 2=2 - Reviewed 3=3 - Screen 4=4 - Route 5=5 - Interview 6=6 - Offer 7=7 - Hire 8=8 - Hold 9=9 - Reject Default Value: 0 |
| 62 | HRS_MAX_LIST_MEM | Number(5,0) | INTEGER NOT NULL | Maximum Applicants in List |
| 63 | HRS_ASSOCIATION_CD | Character(1) | VARCHAR2(1) NOT NULL |
Job opening association codes
A=Applied jobs G=Created by Me H=Primary Hiring Manager M=Hiring Manager N=Not applied Jobs P=Primary Recruiter R=Recruiter T=Team Member Prompt Table: HRS_ASSO_CD_VW |
| 64 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table: HRS_STS_JO_VW1 |
| 65 | HRS_STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Applicant Status
Prompt Table: HRS_STS_APP_VW1 |
| 66 | APP_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |
| 67 | HRS_RTE_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
RTE Display
N=No Y=Yes Default Value: N |
| 68 | HRS_SUP_REVIEW_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Review Confirmation
N=No Y=Yes Default Value: N |
| 69 | HRS_SUP_REJECT_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Reject Confirmation
N=No Y=Yes Default Value: N |