HRS_AGNTMAIL_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A1.HRS_PERSON_ID ,A1.SEARCH_NAME ,A1.HRS_JOB_OPENING_ID ,A3.APP_PER_STATUS ,A1.EMAIL_LOG_FLAG ,A2.EMAIL_ADDR ,A2.LANG_CD ,A1.POSTING_TITLE ,A2.HRS_SITE_ID ,C.DESCR FROM PS_HRS_AGNT_RSLT A1 ,PS_HRS_AGNT_PROF A2 ,PS_HRS_APPLICANT_I A3 ,PS_HRS_JO_I A ,PS_HRS_JOBCODE_I C WHERE A1.HRS_PERSON_ID = A2.HRS_PERSON_ID AND A1.HRS_PERSON_ID = A3.HRS_PERSON_ID AND A1.SEARCH_NAME = A2.SEARCH_NAME AND A1.HRS_JOB_OPENING_ID = A.HRS_JOB_OPENING_ID AND A1.EMAIL_LOG_FLAG = 'N' AND A.JOBCODE = C.JOBCODE AND C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(CC1.EFFDT) FROM PS_HRS_JOBCODE_I CC1 WHERE CC1.JOBCODE = C.JOBCODE AND CC1.EFFDT <= %CurrentDateIn AND C.SETID = CC1.SETID) AND C.SETID = ( SELECT C1.SETID FROM PS_SET_CNTRL_REC C1 WHERE C1.SETCNTRLVALUE = A.BUSINESS_UNIT AND C1.RECNAME = 'JOBCODE_TBL') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | SEARCH_NAME | Character(20) | VARCHAR2(20) NOT NULL | Stored Search Name |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | 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 |
| 5 | EMAIL_LOG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Email With Log |
| 6 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 7 | LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 8 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 9 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |