HRS_APP_JBCRT_I(SQL View) |
Index Back |
|---|---|
Recruiting Agent profileApplicant search for Jobs Agent Profile Interface view |
| SELECT A.HRS_PERSON_ID , A.SEARCH_NAME , A.LAST_UPDATE_DATE , A.HRS_JOBAGENT_IND , A.HRS_JOBAG_TXT_IND , A.EMAIL_ADDR , A.HRS_SCH_TYPE , A.HRS_SEARCH_ID , A.DESCR100 , A.FULL_PART_TIME , A.REG_TEMP , A.SAL_RANGE_MIN_RATE , A.SAL_RANGE_MAX_RATE , A.SAL_RANGE_CURRENCY , A.SAL_RANGE_FREQ , A.HRS_POSTED_WTN , A.HRS_SORT_BY , A.HRS_ROWS_PERPAGE , A.FACETED_SRCH_IND , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_AGNT_PROF A |
| # | 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 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |
| 4 | HRS_JOBAGENT_IND | Character(1) | VARCHAR2(1) NOT NULL | Job Agent Indicator |
| 5 | HRS_JOBAG_TXT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Text me when new Jobs
Y/N Table Edit |
| 6 | EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email Address |
| 7 | HRS_SCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Type
A=Advanced B=Basic D=Database K=Keyword P=Profile Match |
| 8 | HRS_SEARCH_ID | Number(15,0) | DECIMAL(15) NOT NULL | Search Id counter |
| 9 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 10 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 11 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 12 | SAL_RANGE_MIN_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Minimum Rate |
| 13 | SAL_RANGE_MAX_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Salary Range Maximum Rate |
| 14 | SAL_RANGE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Salary Range Currency |
| 15 | SAL_RANGE_FREQ | Character(5) | VARCHAR2(5) NOT NULL | Salary Range Frequency |
| 16 | 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 |
| 17 | HRS_SORT_BY | Character(1) | VARCHAR2(1) NOT NULL |
Sort By
D=Date Posted L=Location |
| 18 | HRS_ROWS_PERPAGE | Character(3) | VARCHAR2(3) NOT NULL |
Rows Per Page
10=10 100=100 25=25 50=50 |
| 19 | FACETED_SRCH_IND | Character(1) | VARCHAR2(1) NOT NULL | Faceted search indicator |
| 20 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 21 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 22 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 23 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |