| # |
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_SCREENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening ID
|
| 5 |
HRS_JO_SCR_SUMM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
JO Screening Summary ID
|
| 6 |
HRS_ANSWER_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Answer ID
|
| 7 |
HRS_QUES_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Question Type
D=Date
M=Multiple Choice
N=Numeric
O=Open Ended
S=Single Choice
|
| 8 |
HRS_JO_SCR_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job opening screening sequence
|
| 9 |
HRS_DATE_VAL |
Date(10) |
DATE |
Date Value
|
| 10 |
HRS_JO_RQMT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job opening requirement sequence
|
| 11 |
HRS_NUM_VAL |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Date Value
|
| 12 |
HRS_SEARCH_ALL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Search all option. Used on the job opening screening run control record to determine if the process is being run in search all mode.
|
| 13 |
HRS_FEDERAL_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Federal flag determines if the current operator is a federal user.
|
| 14 |
HRS_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Required
|
| 15 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 16 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 17 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 18 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 19 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 20 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 21 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 22 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_REC_I
|
| 23 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table:
HRS_RSN_REC_I
|
| 24 |
HRS_STATUS_DT |
Date(10) |
DATE |
Recruiting Solutions Status Date field
|
| 25 |
MESSAGE_TEXT |
Character(100) |
VARCHAR2(100) NOT NULL |
Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
|
| 26 |
HRS_SCR_GEN_SCORE |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Tracks the applicant score of general requirements during job opening screening.
|
| 27 |
REQ_SCR_EDEX_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Education/Experience Score
|
| 28 |
REQ_SCR_COMP_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Competencies Score
|
| 29 |
REQ_SCR_ACMP_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Accomplishments Score
|
| 30 |
REQ_SCR_KEY_SCORE |
Number(3,0) |
SMALLINT NOT NULL |
Keyword Score
|
| 31 |
REQ_SCR_QUES_SCORE |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Questions Score
|
| 32 |
HRS_SCR_GEN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Stores the count of general requirements for the applicant during job opening screening.
|
| 33 |
REQ_SCR_EDEX_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Education/Experience Count
|
| 34 |
REQ_SCR_COMP_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Competencies Count
|
| 35 |
REQ_SCR_ACMP_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Accomplishment Count
|
| 36 |
REQ_SCR_KEY_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Keyword Count
|
| 37 |
REQ_SCR_QUES_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Questions Count
|
| 38 |
HRS_SCR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Screening Status
1=Passed
2=Failed
|
| 39 |
HRS_SCR_STS_RSN |
Character(254) |
VARCHAR2(254) NOT NULL |
Screening Status Reason
|
| 40 |
HRS_SCR_RSL_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Screening Result Sequence
|
| 41 |
POINTS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Points
|
| 42 |
HRS_JO_SCR_AUGMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Augmentation factor
|
| 43 |
HRS_JO_SCR_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Selective factor
|
| 44 |
HRS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 45 |
HRS_LAST_SCR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Screening ID
|
| 46 |
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
|
| 47 |
GVT_RQSN_CERT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Certificate of Eligibles Nbr
|
| 48 |
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
|
| 49 |
GVT_QUALS_DET_DATE |
Date(10) |
DATE |
Qualifications Determ Date
|
| 50 |
GVT_MIN_QUAL_SCORE |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Minimum Quals Score
|
| 51 |
GVT_APPL_AP_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Augmentation Points for Applicants
|
| 52 |
GVT_APPL_VP_SCORE |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Veterans Preference Points
|
| 53 |
HRS_APP_SEL_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Selective factor points earned by an applicant.
|
| 54 |
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.
|
| 55 |
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.
|
| 56 |
GVT_RANK_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Category
1=Category 1
2=Category 2
3=Category 3
4=Category 4
|
| 57 |
GVT_RANK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Status
N=Do Not Rank
R=Rank
Default Value: N
|
| 58 |
GVT_APPL_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Rank on Certificate
|
| 59 |
GVT_VET_RECR_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment Code
1=CPS
2=CP
3=XP
4=TP
5=NV
|
| 60 |
GVT_SORT_ORDER |
Number(14,10) |
DECIMAL(13,10) NOT NULL |
Sort Order Field
|
| 61 |
GVT_PRIO_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Priority Placement Weight
|
| 62 |
GVT_PRIO_PLCMNT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table:
HRS_G_PR_PL_TBL
|
| 63 |
GVT_RQSN_SEL_CRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
|
| 64 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 65 |
GVT_DATE_APPL_RECD |
Date(10) |
DATE |
Date Application Received
Default Value: %date
|
| 66 |
GVT_DT_INFO_REQ |
Date(10) |
DATE |
Date Addl Info Requested
|
| 67 |
GVT_DT_RECON_RECD |
Date(10) |
DATE |
Date Reconsideration Received
|
| 68 |
GVT_DISP_RSN_SAVE |
Character(2) |
VARCHAR2(2) NOT NULL |
Saved Disposition Reason
|
| 69 |
GVT_DISP_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Saved Disposition
|
| 70 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 71 |
GVT_VET_RECR_PTS |
Number(2,0) |
SMALLINT NOT NULL |
Recruitment Points
|
| 72 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 73 |
HRS_DAYS |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Days
|
| 74 |
HRS_QSTN_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Question ID
|
| 75 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 76 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 77 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 78 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|
| 79 |
HRS_JO_SCR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Screening Requirement Required
Y/N Table Edit
Default Value: N
|