PERSON_IDTI_REQUISITION_NBREFFDTDefault Value: %date
TI_JOB_INFO_VW1(SQL View) |
Index Back |
|---|---|
Taleo Job Information ViewTaleo Job Information View |
| SELECT %NumToChar(A.HRS_PERSON_ID) ,A.TI_REQUISITION_NBR , DSRD_ST_DT , A.EMPLID , B.EMPL_RCD ,A.BUSINESS_UNIT , 'Y' , A.DEPTID , A.JOBCODE , A.COMPANY , A.LOCATION ,C.ESTABID ,C.REG_REGION ,C.LABOR_AGREEMENT FROM PS_TI_JOB_INFO A ,PS_HR_REQUEST B ,PS_JOB C WHERE A.HRS_PERSON_ID=B.HRS_PERSON_ID AND B.SRC_SYSTEM='TI' AND A.EMPLID=C.EMPLID AND C.EFFDT=( SELECT MAX(D.EFFDT ) FROM PS_JOB D WHERE C.EMPLID=D.EMPLID AND C.EMPL_RCD=D.EMPL_RCD) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | POSITION_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Position Data |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 12 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 13 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 14 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |