HRS_AGNT_PROF(SQL Table) |
Index Back |
|---|---|
Recruiting Agent profileApplicant search for Jobs Agent Profile |
| # | 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_SEARCH_ID | Number(15,0) | DECIMAL(15) NOT NULL | Search Id counter |
| 8 | HRS_SCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Type
A=Advanced B=Basic D=Database |
| 9 | HRS_ROWS_PERPAGE | Character(3) | VARCHAR2(3) NOT NULL |
Rows Per Page
10=10 100=100 25=25 50=50 |
| 10 | HRS_SORT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Sort By
D=Date Posted L=Location |
| 11 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 12 | 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 |
| 13 | SAL_RANGE_MIN_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Minimum Rate |
| 14 | SAL_RANGE_MAX_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Maximum Rate |
| 15 | SAL_RANGE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Salary Range Currency |
| 16 | SAL_RANGE_FREQ | Character(5) | VARCHAR2(5) NOT NULL | Salary Range Frequency |
| 17 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 18 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 19 | HRS_SITE_ID | Number(15,0) | DECIMAL(15) NOT NULL | Site ID |
| 20 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 21 | HRS_RECR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Recruiter |
| 22 | HRS_MGR_NAME | Character(50) | VARCHAR2(50) NOT NULL | Hiring Manager |
| 23 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 24 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 25 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 26 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |