HRS_ACT_RCTR_LN(SQL View) |
Index Back |
---|---|
Related Language RecordRelated Language Record for HRS_ACT_RCTR_I |
SELECT DISTINCT A.EMPLID ,A.LANGUAGE_CD ,A.NAME_DISPLAY FROM PS_HRS_PERSON_NM_L A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECRUITER_ID | Character(11) | VARCHAR2(11) NOT NULL |
Recruiter ID
Prompt Table: HRS_ACT_PERS_I |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |