HRS_INST(SQL View) |
Index Back |
|---|---|
eRecruit Installation TableeRecruit Installation Table |
| SELECT A.ER_PRF_ACTV_DAYS , A.APPLY_ONLINE_URL , A.LAST_REFTRK_ID , A.HRS_TMPL_SEGMENT , A.HRS_REQ_DFLT_TMPL , A.HRS_PST_DFLT_TMPL , A.URL_ID , A.AGENT_RESULTS_URL , A.HRS_REQ_APRV , A.HRS_POST_APRV , A.HRS_OFF_APRV , A.HRS_MAX_AGENTS , A.HRS_SM_RUN , A.HRS_ET_SM_RUN , A.HRS_MULTIPLE_JOBS , A.HRS_LATEST_JO_DAYS , A.INTVW_EVAL_TMPL , A.HRS_SITE_ID , '040' , ' ' , '030' , ' ' , A.HRS_WC_APRV , A.HRS_INTJOB_ERP , A.HRS_DUPE_MRG_INACT , A.HRS_OFCCP_IND , A.HRS_IA_MAX_RSLTS , A.HRS_ONLN_OFR , A.HRS_ONLN_OFR_DAYS , A.HRS_CALENDAR_INTGR , A.HRS_EVAL_EDIT , A.HRS_MAX_POST_NOTIF , A.HRS_INTEREST_DISP , A.HRS_REQ_REJECT_RSN , A.HRS_MAX_JOB_RSLTS , A.HRS_MAX_RSLT_MYAP , A.HRS_MAX_RSLT_MYJO , A.HRS_JOBCAT_FLG , A.HRS_ASSOCIATION_CD , A.HRS_STATUS_CODE , A.STATUS_CODE , A.APP_PER_STATUS , A.HRS_RTE_DISPLAY , A.HRS_SUP_REVIEW_MSG , A.HRS_SUP_REJECT_MSG , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRSINSTALLATION A |
| # | 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 |
| 6 | HRS_PST_DFLT_TMPL | Number(15,0) | DECIMAL(15) NOT NULL | Default job opening requisition template |
| 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
Default Value: Y |
| 10 | HRS_POST_APRV | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening: Posting Approval Flag
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 |
Recruiting Solutions Installation page - Verify Employee ID indicator for use in Manage Hire process.
O=Optional R=Required |
| 14 | 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 |
| 15 | HRS_MULTIPLE_JOBS | Character(1) | VARCHAR2(1) NOT NULL |
Multiple job or positions flag.
N=No Y=Yes |
| 16 | HRS_LATEST_JO_DAYS | Number(3,0) | SMALLINT NOT NULL | Show Jobs Posted Time Frame |
| 17 | INTVW_EVAL_TMPL | Character(15) | VARCHAR2(15) NOT NULL | Interview Evaluation Template |
| 18 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 19 | HRS_SC_QUEUED | Character(3) | VARCHAR2(3) NOT NULL | Queued Status Code |
| 20 | HRS_SC_QUEUED_RSN | Character(3) | VARCHAR2(3) NOT NULL | Queued Status Reason |
| 21 | HRS_SC_REJECT | Character(3) | VARCHAR2(3) NOT NULL | Rejected Status |
| 22 | HRS_SC_REJECT_RSN | Character(3) | VARCHAR2(3) NOT NULL | Rejected Status Reason |
| 23 | HRS_WC_APRV | Character(1) | VARCHAR2(1) NOT NULL | Works Council Approval field, used on RS Installation record |
| 24 | HRS_INTJOB_ERP | Character(1) | VARCHAR2(1) NOT NULL |
Allow Internal Jobs for ERP
Y/N Table Edit |
| 25 | HRS_DUPE_MRG_INACT | Character(3) | VARCHAR2(3) NOT NULL |
Duplicate Merge Inactive State
Prompt Table: HRS_STS_CLS_VW |
| 26 | HRS_OFCCP_IND | Character(1) | VARCHAR2(1) NOT NULL |
OFCCP Compliance
N=No Y=Yes |
| 27 | HRS_IA_MAX_RSLTS | Number(7,0) | INTEGER NOT NULL | Search Result Limit |
| 28 | HRS_ONLN_OFR | Character(1) | VARCHAR2(1) NOT NULL |
Determines if Online Offers will be made available
N=No Y=Yes |
| 29 | HRS_ONLN_OFR_DAYS | Number(3,0) | SMALLINT NOT NULL | Determine the number of days Online Offer valid |
| 30 | 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 |
| 31 | HRS_EVAL_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
Determine if Evaluation will be available for edit (administrators only)
N=No Y=Yes |
| 32 | HRS_MAX_POST_NOTIF | Number(3,0) | SMALLINT NOT NULL | Determine the maximum number of job postings |
| 33 | 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 |
| 34 | 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 |
| 35 | HRS_MAX_JOB_RSLTS | Number(5,0) | INTEGER NOT NULL | Maximum number of jobs to display in Candidate Gateway |
| 36 | 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. |
| 37 | 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. |
| 38 | HRS_JOBCAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag is used to active or disable the Job Categoriation feature
N=No Y=Yes |
| 39 | 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 |
| 40 | HRS_STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Applicant Status |
| 41 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 42 | 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 |
| 43 | HRS_RTE_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
RTE Display
N=No Y=Yes |
| 44 | HRS_SUP_REVIEW_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Review Confirmation
N=No Y=Yes |
| 45 | HRS_SUP_REJECT_MSG | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Reject Confirmation
N=No Y=Yes |
| 46 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 47 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 48 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 49 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |