UPG_HRS_AT_AET

(SQL Table)
 Index Back

RS HRAT Upgrade State Rcrd

RS Applicant Tracking Upgrade State record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SPECIFIC_REFER_SRC Character(50) VARCHAR2(50) NOT NULL Specific Referral Source
3 HRS_AL_LOG_ID Number(15,0) DECIMAL(15) NOT NULL Resume Extraction Queue ID
4 HRS_SUBSOURCE_ID Number(15,0) DECIMAL(15) NOT NULL SubSource ID
5 HRS_SUBSOURCE_DESC Character(50) VARCHAR2(50) NOT NULL Subsource Description
6 REFERRAL_SOURCE Character(2) VARCHAR2(2) NOT NULL 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
7 HRS_AL_LOG_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Unique Identifier - For Log Source
8 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
9 HRS_CHKLST_ID Number(15,0) DECIMAL(15) NOT NULL Checklist ID
10 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
11 HRS_PROFILE_SEQ Number(3,0) SMALLINT NOT NULL Profile sequece
12 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
13 HRS_ANSWER_CD Character(10) VARCHAR2(10) NOT NULL Identifies an answer definition that can be associated to a question. An applicant can respond to a questionnaire made up of particular questions and answers associated to the job requisition(s) being applied for.
14 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
15 APP_DT Date(10) DATE Date an application was submitted
16 CHECKLIST_DT Date(10) DATE Checklist Date
17 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
18 HRS_RTE_ID Number(15,0) DECIMAL(15) NOT NULL Route ID
19 WC_DECISION_DTTM DateTime(26) TIMESTAMP Works Council decision date/time
20 WC_DECISION_ID Character(3) VARCHAR2(3) NOT NULL Works Council Decision
21 HRS_APP_WC_DEC_ID Number(15,0) DECIMAL(15) NOT NULL Works Council Decision ID
22 HRS_CHKLST_ITM_SEQ Number(3,0) SMALLINT NOT NULL Checklist Item Sequence
23 HRS_QSTN_ID Number(15,0) DECIMAL(15) NOT NULL Question ID
24 HRS_QSTN_SET_ID Number(15,0) DECIMAL(15) NOT NULL Question set identifier
25 HRS_QSTN_SET_CD Character(10) VARCHAR2(10) NOT NULL Question Set Code
26 HRS_RCMNT_LTR_ID Number(15,0) DECIMAL(15) NOT NULL Recruitment Letter ID
27 HRS_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
28 HRS_QSTN_CD Character(10) VARCHAR2(10) NOT NULL Question Code
29 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
30 ROUTE_DT Date(10) DATE Route Date
31 ROUTE_TO_ID Character(11) VARCHAR2(11) NOT NULL Route To ID
32 HRS_LAST_ID Number(15,0) DECIMAL(15) NOT NULL Last Recruitment ID
33 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
34 STATUS_DT Date(10) DATE Status Date
35 HRS_LAST_SEQ Number(3,0) SMALLINT NOT NULL Last Sequence Number
36 HRS_RTE_SEQ Number(3,0) SMALLINT NOT NULL Route Sequence
37 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
38 OFFER_DT Date(10) DATE Offer Date
39 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
40 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
41 COMMENT_DT Date(10) DATE Comment Date
42 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
43 HRS_HIRE_SEQ Number(10,0) DECIMAL(10) NOT NULL Hire Sequence ID
44 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.
45 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number
46 JOB_REQ_NBR1 Character(6) VARCHAR2(6) NOT NULL Job Requisition #
47 HRS_SOURCE_ID Number(15,0) DECIMAL(15) NOT NULL Source ID
48 HRS_SOURCE_NAME Character(30) VARCHAR2(30) NOT NULL Source Name
49 RESUME_NUMBER Number(7,0) INTEGER NOT NULL Resume number
50 HRS_UPG_SEQ Number(3,0) SMALLINT NOT NULL Sequence used in Upgrade
51 INTERVW_DT Date(10) DATE Interview date
52 INTERVIEWER Character(11) VARCHAR2(11) NOT NULL Interviewer
53 EVALUATION_DT Date(10) DATE Evaluation Date
54 SUBMITTED Character(1) VARCHAR2(1) NOT NULL Submitted
55 INTVW_RATING_OVER Number(2,0) SMALLINT NOT NULL Overall Rating
1=Low
2=Below Average
3=Average
4=Above Average
5=High
56 RECOMMENDATION Character(3) VARCHAR2(3) NOT NULL Recommendation
F=Hold on File
I=Interview Further
O=Make Offer
R=Reject
57 DESCRLONG Long Character CLOB Long Description
58 COURSE_START_DT Date(10) DATE Course Start Date
59 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
60 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
61 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
62 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.
63 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
64 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
65 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
66 TABLE_NAME1 Character(30) VARCHAR2(30) NOT NULL Table Name
67 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code
68 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
69 PROCESS_PREHIRE Character(1) VARCHAR2(1) NOT NULL Prehire Processing Requested
70 RESPONSE_DT Date(10) DATE Response Date
71 OFFER_REJECT_RSN Character(1) VARCHAR2(1) NOT NULL Reject Reason
B=Benefits
J=Another Job
N=Not Specified
P=Personal
S=Salary
72 AUTHORIZATION_ID Character(11) VARCHAR2(11) NOT NULL Authorization ID
73 RESPONSE_OFFER Character(1) VARCHAR2(1) NOT NULL Response to Offer
A=Accepted
N=No Response
R=Rejected
U=Under Negotiation
W=Withdrawn
74 OFFER_AMT Number(19,6) DECIMAL(18,6) NOT NULL Offer Amount
75 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
76 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
77 AUTHORIZATION_DT Date(10) DATE Date Authorized
78 PREEMPLOY_REF_NBR Character(12) VARCHAR2(12) NOT NULL Pre-employment reference number.