HRS_INST_I

(SQL View)
 Index Back

eRecruit Installation Table

eRecruit Installation Table

SELECT INST.ER_PRF_ACTV_DAYS , INST.APPLY_ONLINE_URL , INST.LAST_REFTRK_ID , INST.HRS_TMPL_SEGMENT , INST.HRS_REQ_DFLT_TMPL , INST.HRS_PST_DFLT_TMPL , INST.URL_ID , INST.AGENT_RESULTS_URL , INST.HRS_REQ_APRV , INST.HRS_POST_APRV , INST.HRS_OFF_APRV , INST.HRS_MAX_AGENTS , INST.HRS_SM_RUN , INST.HRS_ET_SM_RUN , INST.HRS_MULTIPLE_JOBS , INST.HRS_LATEST_JO_DAYS , INST.INTVW_EVAL_TMPL , INST.HRS_SITE_ID , '040' , ' ' , '030' , ' ' , INST.HRS_WC_APRV , INST.HRS_INTJOB_ERP , INST.HRS_DUPE_MRG_INACT , INST.HRS_DUP_MRG_STSRSN , INST.HRS_OFCCP_IND , INST.HRS_IA_MAX_RSLTS , INST.HRS_CALENDAR_INTGR , INST.HRS_EVAL_EDIT , INST.HRS_JPM_INTGRN , INST.HRS_JPM_PER_INTGRN , INST.HRS_RANDOM_QSTN , INST.HRS_RANDOM_ANS , INST.HRS_MAX_POST_NOTIF , INST.HRS_ONLN_OFR , INST.HRS_ONLN_OFR_DAYS , INST.HRS_INTEREST_DISP , INST.HRS_REQ_REJECT_RSN , INST.HRS_MAX_RSLT_MYAP , INST.HRS_MAX_RSLT_MYJO , %subrec(HRS_AUDIT_SBR, INST) FROM PS_HRSINSTALLATION INST

# 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
25 HRS_DUPE_MRG_INACT Character(3) VARCHAR2(3) NOT NULL Duplicate Merge Inactive State

Prompt Table: HRS_STS_CLS_VW

26 HRS_DUP_MRG_STSRSN Character(3) VARCHAR2(3) NOT NULL Status Reason For Duplicates

Prompt Table: HRS_DMRSN_APP_I

27 HRS_OFCCP_IND Character(1) VARCHAR2(1) NOT NULL OFCCP Compliance
N=No
Y=Yes
28 HRS_IA_MAX_RSLTS Number(7,0) INTEGER NOT NULL Search Result Limit
29 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

30 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

31 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

32 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

33 HRS_RANDOM_QSTN Character(1) VARCHAR2(1) NOT NULL Determines if Questions will be randomize
N=No
Y=Yes

Default Value: N

34 HRS_RANDOM_ANS Character(1) VARCHAR2(1) NOT NULL Determine if Answers to questions will be randomize
N=No
Y=Yes

Default Value: N

35 HRS_MAX_POST_NOTIF Number(3,0) SMALLINT NOT NULL Determine the maximum number of job postings
36 HRS_ONLN_OFR Character(1) VARCHAR2(1) NOT NULL Determines if Online Offers will be made available
N=No
Y=Yes

Default Value: N

37 HRS_ONLN_OFR_DAYS Number(3,0) SMALLINT NOT NULL Determine the number of days Online Offer valid
38 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
39 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
40 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.
41 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.
42 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
43 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
44 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
45 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id