| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 4 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 5 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 6 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_REC_I
|
| 7 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table:
HRS_RSN_REC_I
|
| 8 |
HRS_STATUS_DT |
Date(10) |
DATE NOT NULL |
Recruiting Solutions Status Date field
|
| 9 |
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
|
| 10 |
GVT_RQSN_CERT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Certificate of Eligibles Nbr
|
| 11 |
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
|
| 12 |
GVT_QUALS_DET_DATE |
Date(10) |
DATE |
Qualifications Determ Date
|
| 13 |
GVT_MIN_QUAL_SCORE |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Minimum Quals Score
|
| 14 |
GVT_APPL_AP_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Augmentation Points for Applicants
|
| 15 |
GVT_APPL_VP_SCORE |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Veterans Preference Points
|
| 16 |
HRS_APP_SEL_SCORE |
Signed Number(6,1) |
DECIMAL(4,1) NOT NULL |
Selective factor points earned by an applicant.
|
| 17 |
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.
|
| 18 |
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.
|
| 19 |
GVT_RANK_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Category
1=Category 1
2=Category 2
3=Category 3
4=Category 4
|
| 20 |
GVT_RANK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Ranking Status
N=Do Not Rank
R=Rank
Default Value: N
|
| 21 |
GVT_APPL_RANK |
Number(3,0) |
SMALLINT NOT NULL |
Rank on Certificate
|
| 22 |
GVT_VET_RECR_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Recruitment Code
1=CPS
2=CP
3=XP
4=TP
5=NV
|
| 23 |
GVT_SORT_ORDER |
Number(14,10) |
DECIMAL(13,10) NOT NULL |
Sort Order Field
|
| 24 |
GVT_PRIO_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Priority Placement Weight
|
| 25 |
GVT_PRIO_PLCMNT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Placement Code
Prompt Table:
HRS_G_PR_PL_TBL
|
| 26 |
GVT_RQSN_SEL_CRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Selection Criteria
1=None
2=Must Consider
3=Must Select
|
| 27 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 28 |
GVT_DATE_APPL_RECD |
Date(10) |
DATE |
Date Application Received
Default Value: %date
|
| 29 |
GVT_DT_INFO_REQ |
Date(10) |
DATE |
Date Addl Info Requested
|
| 30 |
GVT_DT_RECON_RECD |
Date(10) |
DATE |
Date Reconsideration Received
|
| 31 |
GVT_DISP_RSN_SAVE |
Character(2) |
VARCHAR2(2) NOT NULL |
Saved Disposition Reason
|
| 32 |
GVT_DISP_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Saved Disposition
|
| 33 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 34 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 35 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 36 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 37 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|