HRS_PERSON_IDTI_REQUISITION_NBREFFDTDefault Value: %date
F=Female
M=Male
U=Unknown
TI_HIRE_EFFDT(SQL View) |
Index Back |
|---|---|
Applicant Effective - For HireApplicant Effective Dated Data - For Hire Integration |
| SELECT DISTINCT A.HRS_PERSON_ID , B.TI_REQUISITION_NBR ,A.DSRD_ST_DT ,' ' FROM PS_HR_REQUEST A ,PS_TI_PERS_INFO B ,PS_TI_RECRUITING C WHERE A.HRS_PERSON_ID =B.HRS_PERSON_ID AND A.HIRE_COMMENTS =B.TI_REQUISITION_NBR AND B.HRS_PERSON_ID=C.HRS_PERSON_ID AND B.TI_REQUISITION_NBR =C.TI_REQUISITION_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | TI_REQUISITION_NBR |
Character(20) | VARCHAR2(20) NOT NULL | Taleo Requisition Number |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |