| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 2 |
SEARCH_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Stored Search Name
|
| 3 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 4 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 5 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 6 |
HRS_JOBAGENT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Agent Indicator
Y/N Table Edit
|
| 7 |
HRS_JOBAG_TXT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Text me when new Jobs
Y/N Table Edit
|
| 8 |
HRS_SEARCH_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Search Id counter
|
| 9 |
HRS_SCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Type
A=Advanced
B=Basic
D=Database
K=Keyword
P=Profile Match
|
| 10 |
HRS_ROWS_PERPAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Rows Per Page
10=10
100=100
25=25
50=50
|
| 11 |
HRS_SORT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort By
D=Date Posted
L=Location
|
| 12 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 13 |
HRS_POSTED_WTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Time period
A=Anytime
M=Last Month
Q=Last Three Months
W=Last Week
Y=Last Year
|
| 14 |
SAL_RANGE_MIN_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Salary Range Minimum Rate
|
| 15 |
SAL_RANGE_MAX_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Salary Range Maximum Rate
|
| 16 |
SAL_RANGE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Range Currency
|
| 17 |
SAL_RANGE_FREQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Range Frequency
|
| 18 |
SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating
|
| 19 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 20 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 21 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 22 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 23 |
HRS_SITE_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Site ID
|
| 24 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 25 |
HRS_RECR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Recruiter
|
| 26 |
HRS_MGR_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Hiring Manager
|
| 27 |
FACETED_SRCH_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Faceted search indicator
Default Value: N
|
| 28 |
HRS_SORT_ORDER_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sort Order
A=Ascending
D=Descending
|
| 29 |
HRS_SORT_RSLTS_BY |
Character(2) |
VARCHAR2(2) NOT NULL |
sort by dropdown field for job search page search results scroll area
01=Job Title
02=Job ID
03=Department
04=Location
06=Job Family
07=Job Function
08=Business Unit
09=Posted Date
10=Hot Jobs
11=Favorites
12=Profile Score
|
| 30 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 31 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 32 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 33 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|