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 , HRS_OFCCP_IND , HRS_IA_MAX_RSLTS , %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 |
Run Search Match
O=Optional R=Required |
| 14 | HRS_ET_SM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Add External Trainee
N=No Y=Yes |
| 15 | HRS_MULTIPLE_JOBS | Character(1) | VARCHAR2(1) NOT NULL | Multiple job or positions flag. |
| 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 |
| 27 | HRS_IA_MAX_RSLTS | Number(7,0) | INTEGER NOT NULL | Search Result Limit |
| 28 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 29 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 30 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 31 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |