|
SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_PROFILE_SEQ , A.HRS_JOB_OPENING_ID , A.STATUS_CODE , A.STATUS_REASON , A.HRS_STATUS_DT , A.ENTRY_SOURCE , A.ENTRY_DATE , A.HRS_SUBMIT_SOURCE , A.CONTRACT_NUM , A.ESTABID , A.OFF_REFSRC_CAT , A.OFF_REFSRC_SUB , A.REQST_ADDTNL_INFO , A.KEYWORD_MATCH , A.HRS_JO_NTF_DELETED , A.EODI_TRANS_ID ,a.hrs_app_interest , A.HRS_LOGICAL_DELETE , A.HRS_WITHDRAWN_DTTM , %subrec(HRS_SCR_SBR,A) , %subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_RCMNT 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_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 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.
Prompt Table:
HRS_RSN_REC_I
|
| 7 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
Default Value: %date
|
| 8 |
ENTRY_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Source
A=Application
O=Organization
Default Value: A
|
| 9 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
Default Value: %date
|
| 10 |
HRS_SUBMIT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
field used to identify where this application was submitted from: C- Candidate Gateway, T- TAM
C=Candidate Gateway
T=TAM
|
| 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 |
Offer 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 Information
|
| 16 |
KEYWORD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Keyword match
Y/N Table Edit
|
| 17 |
HRS_JO_NTF_DELETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Offer Notification Deletion Indicator
Default Value: N
|
| 18 |
EODI_TRANS_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Transaction ID
|
| 19 |
HRS_APP_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicant Interest
1=Low
2=Medium
3=High
|
| 20 |
HRS_LOGICAL_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates row has been logically deleted.
Y/N Table Edit
Default Value: N
|
| 21 |
HRS_WITHDRAWN_DTTM |
DateTime(26) |
TIMESTAMP |
Date time stamp when the candidate's application was withdrawn.
|
| 22 |
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
|
| 23 |
GVT_RQSN_CERT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Certificate of Eligibles Nbr
|
| 24 |
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
|
| 25 |
GVT_QUALS_DET_DATE |
Date(10) |
DATE |
Qualifications Determ Date
|
| 26 |
GVT_MIN_QUAL_SCORE |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Minimum Quals Score
|
| 27 |
GVT_APPL_AP_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Augmentation Points for Applicants
|
| 28 |
GVT_APPL_VP_SCORE |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Veterans Preference Points
|
| 29 |
HRS_APP_SEL_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Selective factor points earned by an applicant.
|
| 30 |
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.
|
| 31 |
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.
|
| 32 |
GVT_RANK_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Category
1=Category 1
2=Category 2
3=Category 3
4=Category 4
|
| 33 |
GVT_RANK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Status
N=Do Not Rank
R=Rank
Default Value: N
|
| 34 |
GVT_APPL_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Rank on Certificate
|
| 35 |
GVT_VET_RECR_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment Code
1=CPS
2=CP
3=XP
4=TP
5=NV
|
| 36 |
GVT_SORT_ORDER |
Number(14,10) |
DECIMAL(13,10) NOT NULL |
Sort Order Field
|
| 37 |
GVT_PRIO_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Priority Placement Weight
|
| 38 |
GVT_PRIO_PLCMNT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table:
HRS_G_PR_PL_TBL
|
| 39 |
GVT_RQSN_SEL_CRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
|
| 40 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 41 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 42 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 43 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|