HRS_APP_PREF_VW(SQL View) |
Index Back |
|---|---|
Applicant PreferencesApplicant Preferences |
| SELECT A.HRS_PERSON_ID ,A.HRS_PROFILE_SEQ ,A.BUSINESS_UNIT ,A.DESIRED_START_DT ,A.DESIRED_REG_TEMP ,A.DESIRED_FULL_PART ,A.RELOCATE ,A.TRAVELLING ,A.HRS_TRAVEL_PERCENT ,A.MON ,A.TUES ,A.WED ,A.THURS ,A.FRI ,A.SAT ,A.SUN ,A.MIN_RATE ,A.CURRENCY_CD ,A.PAY_FREQ_ABBRV ,A.DESIRED_SHIFT ,A.DESIRED_HOURS ,A.HRS_DES_LOC1 ,A.HRS_DES_LOC2 ,A.GEOG_PREFER FROM PS_HRS_APP_PROFILE 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 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | DESIRED_START_DT | Date(10) | DATE | Desired Start Date |
| 5 | DESIRED_REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
E=Either R=Regular T=Temporary |
| 6 | DESIRED_FULL_PART | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part-Time
E=Either F=Full-Time P=Part-Time |
| 7 | RELOCATE | Character(1) | VARCHAR2(1) NOT NULL |
Willing to Relocate
N=No Y=Yes |
| 8 | TRAVELLING | Character(1) | VARCHAR2(1) NOT NULL |
Willing to Travel
N=No Y=Yes |
| 9 | HRS_TRAVEL_PERCENT | Character(1) | VARCHAR2(1) NOT NULL |
Travel percent
0=Never or rarely 1=Up to 25% of the time 2=Up to 50% of the time 3=Up to 75% of the time 4=Up to 100% of the time |
| 10 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Monday
Y/N Table Edit |
| 11 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Tuesday
Y/N Table Edit |
| 12 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Wednesday
Y/N Table Edit |
| 13 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Thursday
Y/N Table Edit |
| 14 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Friday
Y/N Table Edit |
| 15 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Saturday
Y/N Table Edit |
| 16 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Sunday
Y/N Table Edit |
| 17 | MIN_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Minimum Acceptable Pay Rate |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 19 | PAY_FREQ_ABBRV | Character(1) | VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual B=Bi-weeky H=Hour M=Month Y=Year |
| 20 | DESIRED_SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Desired Shift
1=1 2=2 3=3 A=Any C=Compressed N=Not Applicable R=Rotating |
| 21 | DESIRED_HOURS | Number(4,1) | DECIMAL(3,1) NOT NULL | Desired Hours Per Week |
| 22 | HRS_DES_LOC1 | Number(15,0) | DECIMAL(15) NOT NULL |
Desired Location 1
Prompt Table: HRS_RECR_LOC_I2 |
| 23 | HRS_DES_LOC2 | Number(15,0) | DECIMAL(15) NOT NULL |
Desired Location 2
Prompt Table: HRS_RECR_LOC_I |
| 24 | GEOG_PREFER | Long Character | CLOB | Geographic Preference |