|
SELECT A.HRS_PERSON_ID ,A.JOBCODE ,A.HRS_RCMNT_ID ,A.STATUS_CODE ,A.STATUS_REASON ,A.HRS_STATUS_DT ,B.HRS_JOB_OPENING_ID ,B.HRS_PROFILE_SEQ ,B.ENTRY_SOURCE ,B.ENTRY_DATE ,B.CONTRACT_NUM ,B.ESTABID ,B.OFF_REFSRC_CAT ,B.OFF_REFSRC_SUB ,B.REQST_ADDTNL_INFO ,B.KEYWORD_MATCH ,B.STATUS_CODE ,B.HRS_STATUS_DT ,B.STATUS_REASON ,%subrec(HRS_SCR_SBR,A) ,%subrec(HRS_G_RCMNT_SBR,A) ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_RCMNT_JOB A , PS_HRS_RCMNT B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_RCMNT_ID = B.HRS_RCMNT_ID
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 2 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 3 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 4 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_REC_I
|
| 5 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table:
HRS_RSN_REC_I
|
| 6 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
|
| 7 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 8 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 9 |
ENTRY_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Source
A=Application
O=Organization
Default Value: A
|
| 10 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
Default Value: %date
|
| 11 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
HRS_APP_CNTRACT
|
| 12 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 13 |
OFF_REFSRC_CAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Official Referral Source
AD=Advertisement
AG=Agency
CL=Client Referral
CO=College Recruiting
CR=College Recommendation
EE=Employee
ES=Employment Securitry Bureau
FE=Former Employee
JF=Job Fair
JP=Job Posting
OH=Open House
OT=Other Source
PI=Phone Inquiry
UK=Unknown
US=Unsolicited
WI=Walk-In
XR=Executive Referral
XS=Executive Search
|
| 14 |
OFF_REFSRC_SUB |
Character(2) |
VARCHAR2(2) NOT NULL |
Official Referral Subcategory
Prompt Table:
HRS_REF_SUBCAT
Set Control Field: REF_SRC_SUB_CAT
|
| 15 |
REQST_ADDTNL_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Additional Info
|
| 16 |
KEYWORD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Keywords Matched
Y/N Table Edit
|
| 17 |
HRS_RCMNT_STS_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment status code -- used on a view
|
| 18 |
HRS_RCMNT_STS_DT |
Date(10) |
DATE |
Recruitment Status Date
|
| 19 |
HRS_RCMNT_STS_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment Status Reason
|
| 20 |
GVT_APPL_COMP_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicant Competitive Status
0=Mark...
C=Competitive
N=Non-Competitive VRA
O=Non-Competitive Other
|
| 21 |
GVT_RQSN_CERT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Certificate of Eligibles Nbr
|
| 22 |
GVT_QUALS_DETERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Qualifications Determination Flag
B=Best Qualified
D=Does Not Meet Min Quals
N=Eligible/Not Rated
Q=Qualified
W=Well Qualified
|
| 23 |
GVT_QUALS_DET_DATE |
Date(10) |
DATE |
Qualifications Determ Date
|
| 24 |
GVT_MIN_QUAL_SCORE |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Minimum Quals Score
|
| 25 |
GVT_APPL_AP_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Augmentation Points for Applicants
|
| 26 |
GVT_APPL_VP_SCORE |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Veterans Preference Points
|
| 27 |
HRS_APP_SEL_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Selective factor points earned by an applicant.
|
| 28 |
HRS_SCR_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Screening score. Includes all points awarded to an applicant for a screening level, less veterans preference points, augmenting points, and selective factor points.
|
| 29 |
HRS_SCR_TTL_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Screening score. Includes all points awarded to an applicant for a screening level, INCLUDING veterans preference points, augmenting factor points, and selective factor points.
|
| 30 |
GVT_RANK_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Category
1=Category 1
2=Category 2
3=Category 3
4=Category 4
|
| 31 |
GVT_RANK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Status
N=Do Not Rank
R=Rank
Default Value: N
|
| 32 |
GVT_APPL_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Rank on Certificate
|
| 33 |
GVT_VET_RECR_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment Code
1=CPS
2=CP
3=XP
4=TP
5=NV
|
| 34 |
GVT_SORT_ORDER |
Number(14,10) |
DECIMAL(13,10) NOT NULL |
Sort Order Field
|
| 35 |
GVT_PRIO_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Priority Placement Weight
|
| 36 |
GVT_PRIO_PLCMNT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table:
HRS_G_PR_PL_TBL
|
| 37 |
GVT_RQSN_SEL_CRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
|
| 38 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 39 |
GVT_DATE_APPL_RECD |
Date(10) |
DATE |
Date Application Received
Default Value: %date
|
| 40 |
GVT_DT_INFO_REQ |
Date(10) |
DATE |
Date Addl Info Requested
|
| 41 |
GVT_DT_RECON_RECD |
Date(10) |
DATE |
Date Reconsideration Received
|
| 42 |
GVT_DISP_RSN_SAVE |
Character(2) |
VARCHAR2(2) NOT NULL |
Saved Disposition Reason
|
| 43 |
GVT_DISP_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Saved Disposition
|
| 44 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 45 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 46 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 47 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 48 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|