|
SELECT RCM.HRS_PERSON_ID , RCM.HRS_RCMNT_ID , RCM.HRS_PROFILE_SEQ , RCM.HRS_JOB_OPENING_ID , RCM.STATUS_CODE , RCM.STATUS_REASON , RCM.HRS_STATUS_DT , RCM.HRS_APP_INTEREST , APP.APP_PER_STATUS , APP.STATUS_CODE , APP.POI_TYPE , APP.HRS_APP_PREF_CONT , PRN.REG_REGION , PRN.HRS_DESCR , EML.EMAIL_ADDR , %subrec(PHONE_SBR, PHN) , JOB.STATUS_CODE , JOB.HRS_JO_TYPE , JOB.RECRUITER_ID , JOB.MANAGER_ID , JOB.BUSINESS_UNIT , JOB.SETID_DEPT , JOB.DEPTID , JOB.COMPANY , JOB.HRS_PRM_JOBCODE , JOB.HRS_PRM_POSITION , JOB.HRS_PRM_LOCATION , JOB.HRS_PRM_LOC_AREA , JOB.HRS_PRM_PST_TITLE , JOB.JOB_FAMILY , JOB.OPEN_DT , JOB.HOT_JOB , JOB.ORIGINATOR_ID , APPL.HRS_SUBMITTED_BY , APPL.HRS_SUBMITTED_DTTM , APPL.HRS_RESUME_ID , APPL.HRS_AL_LOG_ID , APPL.HRS_PAGE_LAYOUT_ID , APPL.APPLIC_PURGE_DT , APPL.HIGHEST_EDUC_LVL , %subrec(HRS_PERSFED_SBR, APPL) , APPL.LANG_CD , APPL.YEARS_OF_EXP , APPL.HRS_REPORT_DEFN_ID , APPL.HRS_REPORT_TMPL_ID , APPL.LETTER_PRINTED_DT , APPL.TRAVELLING , APPL.RELOCATE , APPL.UNION_CD , APPL.DESIRED_HOURS , APPL.MIN_RATE , APPL.CURRENCY_CD , APPL.PAY_FREQ_ABBRV , APPL.DESIRED_START_DT , APPL.DESIRED_FULL_PART , APPL.DESIRED_REG_TEMP , APPL.DESIRED_SHIFT , APPL.MON , APPL.TUES , APPL.WED , APPL.THURS , APPL.FRI , APPL.SAT , APPL.SUN , APPL.HRS_DES_LOC1 , APPL.HRS_DES_LOC2 , APPL.HRS_TRAVEL_PERCENT , APPL.PREV_EMPL_BY_COMPY , APPL.PREV_TERM_DT , APPL.GEOG_PREFER , APPL.HRS_HR_EFFDT FROM PS_HRS_APPLICANT APP LEFT OUTER JOIN PS_HRS_GEND_PRN_VW PRN ON (APP.REG_REGION = PRN.REG_REGION AND APP.PRONOUN = PRN.PRONOUN ) , PS_HRS_RCMNT RCM LEFT OUTER JOIN PS_HRS_JOB_OPENING JOB ON JOB.HRS_JOB_OPENING_ID = RCM.HRS_JOB_OPENING_ID LEFT OUTER JOIN PS_HRS_APP_EMAIL EML ON (EML.HRS_PERSON_ID = RCM.HRS_PERSON_ID AND EML.PREF_EMAIL_FLAG = 'Y') LEFT OUTER JOIN PS_HRS_APP_PHONE PHN ON (PHN.HRS_PERSON_ID = RCM.HRS_PERSON_ID AND PHN.PREF_PHONE_FLAG = 'Y') , PS_HRS_APP_PROFILE APPL WHERE RCM.HRS_PERSON_ID = APP.HRS_PERSON_ID AND APPL.HRS_PERSON_ID = APP.HRS_PERSON_ID AND APPL.HRS_PROFILE_SEQ = RCM.HRS_PROFILE_SEQ
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
Prompt Table:
HRS_APPLICANT_I
|
| 2 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
Prompt Table:
HRS_RCMNT_I
|
| 3 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
Prompt Table:
HRS_APP_PROF_I
|
| 4 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table:
HRS_JO_OPEN_I
|
| 5 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_REC_I
|
| 6 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
|
| 7 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
|
| 8 |
HRS_APP_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicant Interest
1=Low
2=Medium
3=High
|
| 9 |
APP_PER_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant
E=Employee
N=Non-Employee
Default Value: A
|
| 10 |
HRS_STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Applicant Status
Prompt Table:
HRS_STS_APP_I
|
| 11 |
POI_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines the Transactional usage of POIs in HRMS.
|
| 12 |
HRS_APP_PREF_CONT |
Character(1) |
VARCHAR2(1) NOT NULL |
Preferred Method of Contact
E=Email
M=Mail
N=Not Specified
P=Phone
|
| 13 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 14 |
HRS_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 15 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 16 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 17 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 18 |
JOB_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Job Status
Prompt Table:
HRS_STS_JO_I
|
| 19 |
HRS_JO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Type
P=Continuous Job Opening
R=Standard Requisition
|
| 20 |
RECRUITER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Recruiter ID
|
| 21 |
MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager ID
|
| 22 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 23 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 24 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
HRS_DEPT_I
|
| 25 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
HRS_COMPANY_I
|
| 26 |
HRS_PRM_JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary Job Code of Job Opening.
Prompt Table:
%EDITTABLE
|
| 27 |
HRS_PRM_POSITION |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
%EDITTABLE2
|
| 28 |
HRS_PRM_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Primary Recruiting Location of Job Opening,
Prompt Table:
HRS_LOCATN_I
|
| 29 |
HRS_PRM_LOC_AREA |
Number(15,0) |
DECIMAL(15) NOT NULL |
Primary recruiting location area
Prompt Table:
HRS_RECR_LOC_I
|
| 30 |
HRS_PRM_PST_TITLE |
Character(200) |
VARCHAR2(200) NOT NULL |
Job posting title
|
| 31 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 32 |
OPEN_DT |
Date(10) |
DATE |
Created
|
| 33 |
HOT_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which Job requisitions are classed as urgent to fill. Hot Jobs are identified during the develop requisition process and used as an indicator for both the organization and applicant.
N=No
Y=Yes
|
| 34 |
ORIGINATOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Originator's ID
|
| 35 |
HRS_SUBMITTED_BY |
Character(15) |
VARCHAR2(15) NOT NULL |
submitted by
|
| 36 |
HRS_SUBMITTED_DTTM |
DateTime(26) |
TIMESTAMP |
Submitted Date Time
Default Value: %Datetime
|
| 37 |
HRS_RESUME_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume id
Prompt Table:
HRS_APP_RES
|
| 38 |
HRS_AL_LOG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Resume Extraction Queue ID
|
| 39 |
HRS_PAGE_LAYOUT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Page Layout ID
Prompt Table:
HRS_PL_STATE
|
| 40 |
APPLIC_PURGE_DT |
Date(10) |
DATE |
Store date by which applicant records are to be deleted as part of the applicant purge process
|
| 41 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
Default Value: A
|
| 42 |
GVT_CRED_MIL_SVCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Creditable Military Service
|
| 43 |
GVT_MILITARY_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
GVT_MILITARY_COMP
A=Air Force
C=Coast Guard
M=Marines
N=Navy
R=Army
|
| 44 |
GVT_MIL_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Military Grade
E1=E1
E2=E2
E3=E3
E4=E4
E5=E5
E6=E6
E7=E7
E8=E8
E9=E9
O1=O1
O10=O10
O2=O2
O3=O3
O4=O4
O5=O5
O6=O6
O7=O7
O8=O8
O9=O9
W1=W1
W2=W2
W3=W3
W4=W4
|
| 45 |
GVT_MIL_RESRVE_CAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reserve Category
A=IMA - Air Force
B=IMA - Army
C=IMA - Coast Guard
D=IMA - Marines
E=IMA - Navy
F=Selected Reserve - Air Force
G=Selected Reserve - Army
H=Selected Reserve - Coast Guard
I=Selected Reserve - Marine Corp
J=Selected Reserves - Navy
K=Air National Guard
L=Army National Guard
M=IRR - Air Force
N=IRR - Army
O=IRR - Coast Guard
P=IRR - Marine Corps
Q=IRR - Navy
S=Standby Reserve - Air Force
T=Standby Reserve - Army
U=Standby Reserve - Coast Guard
V=Standby Reserve - Marine Corps
W=Standby Reserve - Navy
X=Navy Reserve - Merchant Marine
Y=Draft Eligible
Z=Not Applicable
|
| 46 |
GVT_MIL_SEP_RET |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Separation Status
R=Retired
S=Separated
Z=Not Applicable
|
| 47 |
GVT_MIL_SVCE_END |
Date(10) |
DATE |
Military Service End Date
|
| 48 |
GVT_MIL_SVCE_START |
Date(10) |
DATE |
Military Service Start Date
|
| 49 |
GVT_MIL_VERIFY |
Character(1) |
VARCHAR2(1) NOT NULL |
Military Service Verified
Y/N Table Edit
|
| 50 |
GVT_PAR_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Personnel Action Reqst #
|
| 51 |
GVT_UNIF_SVC_CTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Military Pay Center
Y/N Table Edit
|
| 52 |
GVT_VET_PREF_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference
Default Value: 1
Prompt Table:
HRS_G_VTPRF_TBL
|
| 53 |
GVT_VET_PREF_RIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterans Preference RIF
Y/N Table Edit
Default Value: N
|
| 54 |
GVT_CHANGE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Flag
|
| 55 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 56 |
GVT_YR_ATTAINED |
Date(10) |
DATE |
Year Attained
|
| 57 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 58 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Default Value: N
Prompt Table:
GVT_HANDICP_TBL
|
| 59 |
GVT_DISABILITY_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Disability Code
Default Value: 05
Prompt Table:
GVT_HANDICP_TBL
|
| 60 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
%SAL_GRD_PRMPT1
|
| 61 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Default Value: 0000
Prompt Table:
SAL_PLAN_TBL
|
| 62 |
GVT_CURR_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 63 |
GVT_CURR_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 64 |
GVT_HIGH_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 65 |
GVT_HIGH_GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Highest Grade
Prompt Table:
%SAL_GRD_PRMPT3
|
| 66 |
GVT_PREV_AGCY_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Agency Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 67 |
GVT_PREV_FED_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Federal Employee
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 68 |
GVT_SEP_INCENTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separation Incentive
B=Buyout/VSIP
E=Early Retirement
O=Other Incentive
|
| 69 |
GVT_SEP_INCENT_DT |
Date(10) |
DATE |
Separation Incentive Date
|
| 70 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 71 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
Prompt Table:
GVT_PAY_PLAN
|
| 72 |
BARG_UNIT |
Character(4) |
VARCHAR2(4) NOT NULL |
Bargaining Unit
1=Bargaining Unit 1
2=Bargaining Unit 2
|
| 73 |
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
Prompt Table:
HRS_LNG_CD_VW
|
| 74 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
Default Value: 0
|
| 75 |
HRS_REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The Fusion Publisher Report Definition ID used by Recruiting
|
| 76 |
HRS_REPORT_TMPL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
The Fusion publisher Report template ID used by RS.
Prompt Table:
HRS_XP_APPTMP_V
|
| 77 |
LETTER_PRINTED_DT |
Date(10) |
DATE |
Date letter was printed
|
| 78 |
TRAVELLING |
Character(1) |
VARCHAR2(1) NOT NULL |
Willing to Travel
N=No
Y=Yes
Default Value: N
|
| 79 |
RELOCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Willing to Relocate
N=No
Y=Yes
Default Value: N
|
| 80 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
|
| 81 |
DESIRED_HOURS |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Desired Hours Per Week
|
| 82 |
MIN_RATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Minimum Acceptable Pay Rate
|
| 83 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
HRS_CURRENCY_VW
|
| 84 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 85 |
DESIRED_START_DT |
Date(10) |
DATE |
Desired Start Date
|
| 86 |
DESIRED_FULL_PART |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part-Time
E=Either
F=Full-Time
P=Part-Time
Default Value: E
|
| 87 |
DESIRED_REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
E=Either
R=Regular
T=Temporary
Default Value: E
|
| 88 |
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
Default Value: A
|
| 89 |
MON |
Character(1) |
VARCHAR2(1) NOT NULL |
Monday
Default Value: Y
|
| 90 |
TUES |
Character(1) |
VARCHAR2(1) NOT NULL |
Tuesday
Default Value: Y
|
| 91 |
WED |
Character(1) |
VARCHAR2(1) NOT NULL |
Wednesday
Default Value: Y
|
| 92 |
THURS |
Character(1) |
VARCHAR2(1) NOT NULL |
Thursday
Default Value: Y
|
| 93 |
FRI |
Character(1) |
VARCHAR2(1) NOT NULL |
Friday
Default Value: Y
|
| 94 |
SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Saturday
|
| 95 |
SUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Sunday
|
| 96 |
HRS_DES_LOC1 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Desired Location 1
|
| 97 |
HRS_DES_LOC2 |
Number(15,0) |
DECIMAL(15) NOT NULL |
Desired Location 2
Prompt Table:
HRS_RECR_LOC_I2
|
| 98 |
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
Default Value: 0
|
| 99 |
PREV_EMPL_BY_COMPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Previously Employed by Company
N=No
Y=Yes
Default Value: N
|
| 100 |
PREV_TERM_DT |
Date(10) |
DATE |
Previous Termination Date
|
| 101 |
GEOG_PREFER |
Long Character |
CLOB |
Geographic Preference
|
| 102 |
HRS_HR_EFFDT |
Date(10) |
DATE |
HR Record EFFDT
|