| # |
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 |
TI_USERNAME |
Character(254) |
VARCHAR2(254) NOT NULL |
User Name
|
| 4 |
TI_CANDIDATE_LANG |
Character(3) |
VARCHAR2(3) NOT NULL |
Taleo- Candidate Language
|
| 5 |
TI_CANDIDATE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Taleo-Internal Candidate Indicator
|
| 6 |
TI_EEO_CAT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Taleo-EEO Category
|
| 7 |
TI_CAN_EEO_ORG |
Number(10,0) |
DECIMAL(10) NOT NULL |
Taleo-Canada EEO Aboriginal
|
| 8 |
TI_CAN_EEO_DIS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Taleo - Canada EEO Disability
|
| 9 |
TI_CAN_EEO_GEN |
Number(10,0) |
DECIMAL(10) NOT NULL |
Taleo- Canada EEO Gender Identifier
|
| 10 |
TI_CAN_EEO_VIS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Taleo-Canada EEO Visible Minority
|
| 11 |
TI_USA_EEO2_GEN |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Gender
|
| 12 |
TI_USA_EEO2_ETH |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Ethnicity
|
| 13 |
TI_USA_EEO2_RACE |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Race
|
| 14 |
TI_USA_EEO2_VET |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Veteran
|
| 15 |
TI_USA_EEO2_SDV |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Special Disabled Veteran
|
| 16 |
TI_USA_EEO2_DISVET |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Disabled Veteran
|
| 17 |
TI_USA_EEO2_DISPER |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Disabled Person
|
| 18 |
TI_USA_EEO2_MEDVET |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Medal Veteran
|
| 19 |
TI_USA_EEO2_OTPVET |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Other Protected Veteran
|
| 20 |
TI_USA_EEO2_RSPVET |
Character(150) |
VARCHAR2(150) NOT NULL |
Taleo USA EEO2 Recently Separated Veteran
|
| 21 |
TI_RECRUITER_FSTNM |
Character(254) |
VARCHAR2(254) NOT NULL |
Taleo Recruiter First Name
|
| 22 |
TI_RECRUITER_LSTNM |
Character(254) |
VARCHAR2(254) NOT NULL |
Taleo Recruiter Last Name
|
| 23 |
TI_OFFER_ACT_STDT |
Date(10) |
DATE |
Taleo-Offer Actual Start Date
|
| 24 |
TI_OFFER_RELOC_AMT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Taleo-Offer Relocation Amount
|
| 25 |
TI_OFFER_SIGN_BNS |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Taleo offer Sign on bonus
|
| 26 |
TI_OFFER_CURRENCY |
Character(10) |
VARCHAR2(10) NOT NULL |
Taleo-Offer Currency
|
| 27 |
TI_OFFER_ANAL_SAL |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Taleo Offer Annual Salary
|
| 28 |
TI_OFFER_PAY_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Taleo-Offer Pay Basis
|
| 29 |
TI_OFF_PAY_BAS_DSC |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Pay Basis Description
|
| 30 |
TI_OFF_SAL_PAY_BAS |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Taleo-Offer Salary Pay Basis
|
| 31 |
TI_OFFER_RELOC_PKG |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo offer Reloc pkg
|
| 32 |
TI_OFF_ANAL_BONUS |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Annual Bonus
|
| 33 |
TI_OFF_CAR_ALVENCE |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Car Allowance
|
| 34 |
TI_OFFER_COMM |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Commission
|
| 35 |
TI_OFFER_COMM_PKG |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Commission Package
|
| 36 |
TI_OFFER_STOCK |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo offer Stock
|
| 37 |
TI_OFF_STOCK_PKG |
Character(50) |
VARCHAR2(50) NOT NULL |
Taleo-Offer Stock Package
|
| 38 |
TI_REQ_TITLE |
Character(254) |
VARCHAR2(254) NOT NULL |
Taleo Requisition Title
|
| 39 |
TI_DVM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Taleo-DVM Identifier
|
| 40 |
TI_PERS_JOB_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
TI_PERS_JOB_FLAG
|