HRS_AGNTMAIL_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A1.HRS_PERSON_ID ,A1.SEARCH_NAME ,A1.HRS_JOB_OPENING_ID ,A1.HRS_JO_PST_SEQ ,A3.APP_PER_STATUS ,A1.EMAIL_LOG_FLAG ,A2.EMAIL_ADDR ,A2.LANG_CD ,A1.POSTING_TITLE ,A2.HRS_SITE_ID FROM PS_HRS_AGNT_RSLT A1 ,PS_HRS_AGNT_PROF A2 ,PS_HRS_APPLICANT_I A3 ,PS_HRS_JO_I A 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' |
| # | 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 | HRS_JO_PST_SEQ | Number(3,0) | SMALLINT NOT NULL | Job opening posting sequence |
| 5 | 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 |
| 6 | EMAIL_LOG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Email With Log |
| 7 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 8 | 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 |
| 9 | POSTING_TITLE | Character(200) | VARCHAR2(200) NOT NULL | Job posting title |
| 10 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |