| # |
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_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 4 |
HRS_RCRT_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Template ID
Prompt Table:
HRS_RCRTTMPL_VW
|
| 5 |
HRS_JO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Opening Type
P=Continuous Job Opening
R=Standard Requisition
|
| 6 |
REFERRAL_PGM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Employee referral program ID
Prompt Table:
HRS_REF_PGM
|
| 7 |
ORIGINATOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Originator's ID
Prompt Table:
HRS_PERSON_NM_I
|
| 8 |
MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager ID
Prompt Table:
HRS_PERSON_NM_I
|
| 9 |
RECRUITER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Recruiter ID
Prompt Table:
HRS_PERSON_NM_I
|
| 10 |
GVT_SEL_OFFICIAL |
Character(11) |
VARCHAR2(11) NOT NULL |
Selecting Official
Prompt Table:
HRS_PERSON_NM_I
|
| 11 |
OPEN_DT |
Date(10) |
DATE |
Created
Default Value: %date
|
| 12 |
CLOSE_DT |
Date(10) |
DATE |
Date Closed
|
| 13 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
Prompt Table:
HRS_STS_JO_I
|
| 14 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
Prompt Table:
HRS_RSN_JO_I
|
| 15 |
STATUS_DT |
Date(10) |
DATE NOT NULL |
Status Date
Default Value: %date
|
| 16 |
HRS_OPENING_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Unlimited or limited number of job openings flag
L=Limited Number of Openings
U=Unlimited Number of Openings
Default Value: L
|
| 17 |
OPENINGS_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Tracks number of openings
|
| 18 |
OPENINGS_TARGET |
Number(3,0) |
SMALLINT NOT NULL |
Tracks number of target openings
Default Value: 1
|
| 19 |
HOT_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which Job requisitions are classed as urgent to fill. Hot Jobs are identified during the develop requisition process and used as an indicator for both the organization and applicant.
Y/N Table Edit
Default Value: N
|
| 20 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
HRS_BS_UNT_HR_I
|
| 21 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 22 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
HRS_DEPT_I
|
| 23 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
HRS_COMPANY_I
|
| 24 |
HRS_PRM_JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
HRS_JOBCODE_I
|
| 25 |
HRS_PRM_POSITION |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
HRS_POS_DTA_C_I
|
| 26 |
HRS_PRM_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
HRS_LOCATION_I
|
| 27 |
HRS_PRM_LOC_AREA |
Number(15,0) |
DECIMAL(15) NOT NULL |
Primary recruiting location area
Prompt Table:
HRS_LOCATION
|
| 28 |
HRS_PRM_PST_TITLE |
Character(200) |
VARCHAR2(200) NOT NULL |
Job posting title
|
| 29 |
DESIRED_START_DT |
Date(10) |
DATE |
Desired Start Date
|
| 30 |
WC_COUNCIL_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
Works Council ID
Prompt Table:
HRS_WC_CNCL_I
|
| 31 |
ENCUMB_DT_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Encumbrance Date Indicator
A=Authorization Date
P=Project Fill Date
|
| 32 |
PROJECTED_FILL_DT |
Date(10) |
DATE |
Projected Fill Date
|
| 33 |
AUTHORIZATION_DT |
Date(10) |
DATE |
Date Authorized
|
| 34 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 35 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 36 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table:
HRS_CTZN_STS_I
|
| 37 |
MIN_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Monimum age used for Benefits process.
|
| 38 |
MAX_AGE |
Number(3,0) |
SMALLINT NOT NULL |
Max age used for Benefits process
|
| 39 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 40 |
HRS_CONTACT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Contact ID
Prompt Table:
HRS_CONTACT
|
| 41 |
GVT_CONSIDER_AREA |
Character(1) |
VARCHAR2(1) NOT NULL |
Area of Consideration
A=Agency
E=External Government
F=Federal Government
N=Nationwide
S=Subagency
W=Worldwide
|
| 42 |
GVT_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
N=Not Yet Registered
R=Registered
X=Not Applicable
|
| 43 |
HRS_G_JO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal job requisition type
I=Internal
M=Merit Promotion
O=Open Competition
|
| 44 |
HRS_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Added DateTime
|
| 45 |
HRS_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added Operator Id
|
| 46 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 47 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|
| 48 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|