HRS_PERSON_IDHRS_RCMNT_IDHRS_JOB_OPENING_IDHRS_SCREENING_IDJOBCODELANGUAGE_CDHRS_RCM_SCR8_LN(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for HRS_RCM_SCR8_VW |
| SELECT A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_JOB_OPENING_ID ,A.HRS_SCREENING_ID ,A.JOBCODE ,B.LANGUAGE_CD ,B.NAME_DISPLAY FROM PS_HRS_SCR_RSLT A , PS_HRS_APP_NM_LNG B , PS_HRS_APPLICANT_I D WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = D.HRS_PERSON_ID AND B.NAME_TYPE = 'PRI' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_RCMNT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 3 | HRS_JOB_OPENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 4 | HRS_SCREENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
| 5 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |