| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
HRS_SEL_ALL_JO_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
All Open Job Openings
|
| 5 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 6 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 7 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 8 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 9 |
GVT_PRIO_PLCMNT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Placement Code
|
| 10 |
HRS_G_JO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal job requisition type
I=Internal
M=Merit Promotion
O=Open Competition
|
| 11 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 12 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
|
| 13 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 14 |
GVT_PRIO_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Priority Placement Weight
|
| 15 |
GVT_RQSN_SEL_CRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
|
| 16 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 17 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_REC_I
|
| 18 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table:
HRS_RSN_REC_I
|
| 19 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
|
| 20 |
ENTRY_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Entry Source
A=Application
O=Organization
Default Value: A
|
| 21 |
ENTRY_DATE |
Date(10) |
DATE |
Date Entered
Default Value: %date
|
| 22 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
Prompt Table:
HRS_APP_CNTRACT
|
| 23 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 24 |
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
|
| 25 |
OFF_REFSRC_SUB |
Character(2) |
VARCHAR2(2) NOT NULL |
Offer Referral Subcategory
Prompt Table:
HRS_REF_SUBCAT
Set Control Field: REF_SRC_SUB_CAT
|
| 26 |
REQST_ADDTNL_INFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Additional Information
|
| 27 |
KEYWORD_MATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Keyword match
Y/N Table Edit
|
| 28 |
HRS_PRI_PLCMNT_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Priority Placement Process Sts
1=Eligible
2=Ineligible
Default Value: 1
|
| 29 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 30 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 31 |
HRS_LAST_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Recruitment ID
|
| 32 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|