TI_JOB_INFO_VW

(SQL View)
 Index Back

SELECT %NumToChar(A.HRS_PERSON_ID) , A.TI_REQUISITION_NBR , DSRD_ST_DT , A.EMPLID , B.EMPL_RCD , ' ' , ' ' ,A.BUSINESS_UNIT , A.DEPTID , A.JOBCODE , ' ' , 0 , ' ' , ' ' , 0 , A.COMPANY , A.LOCATION ,' ' ,' ' ,' ' FROM PS_TI_JOB_INFO A ,PS_HR_REQUEST B WHERE A.HRS_PERSON_ID=B.HRS_PERSON_ID AND B.SRC_SYSTEM='TI'

# 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 ACTION Character(3) VARCHAR2(3) NOT NULL Action
7 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
10 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
12 ORG_INSTANCE_ERN Number(3,0) SMALLINT NOT NULL Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
13 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
14 JOB_OPENING_NAME Character(200) VARCHAR2(200) NOT NULL Job Posting Title
15 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
18 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
19 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
20 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement