| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
CHARGE_DT |
Date(10) |
DATE |
Charge Date
|
| 4 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 5 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 6 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 7 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 8 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 9 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 10 |
APP_VISIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates which sections of a job requisition's posting description are visible to internal applicants. An entire posting description is made up of 5 possible sections, the Organizational Marketing Statement, Responsibilities, Qualifications, Closing and Departmental Statement
B=Internal and External
E=External Only
I=Internal Only
|
| 11 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 12 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 13 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 14 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 15 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 16 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 17 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 18 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 19 |
FED |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Functionality
|
| 20 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 21 |
GVT_RECR_DESCR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Description ID
|
| 22 |
GVT_VA_TEMPLATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Posting Template ID
|
| 23 |
HRS_CONTACT_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Code
|
| 24 |
HRS_END_TM |
Time(15) |
TIMESTAMP |
Recruiting Solutions End Time field
|
| 25 |
HRS_EVAL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Evaluation ID
|
| 26 |
HRS_INT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Interview ID
|
| 27 |
HRS_INT_LTR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Interview Letter ID
|
| 28 |
HRS_INT_EVL_RTG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Interview Rating
|
| 29 |
HRS_INT_EVL_CTG_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Interview Category ID
|
| 30 |
HRS_INTERVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Interviewer
|
| 31 |
HRS_INT_DT |
Date(10) |
DATE |
Interview date
|
| 32 |
HRS_INTVW_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interview Level
|
| 33 |
HRS_JO_DESCR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Description ID
|
| 34 |
HRS_JO_DESCR_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Job posting description type
|
| 35 |
HRS_JO_RQMT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job opening requirement sequence
|
| 36 |
HRS_JO_PST_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job opening posting sequence
|
| 37 |
HRS_JO_SCR_SUMM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
JO Screening Summary ID
|
| 38 |
HRS_JOB_DESCR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Description ID
|
| 39 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 40 |
HRS_PST_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job opening posting template id
|
| 41 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 42 |
HRS_RCMNT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
App Tracking Recruitment ID
|
| 43 |
HRS_RCM_INT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Interview ID
|
| 44 |
HRS_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 45 |
HRS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 46 |
HRS_START_TM |
Time(15) |
TIMESTAMP |
Recruiting Solutions Start Time
|
| 47 |
HRS_STTS_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
|
| 48 |
HRS_STTS_DT |
Date(10) |
DATE |
Status Date
|
| 49 |
HRS_STTS_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
|
| 50 |
HRS_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Submitted
|
| 51 |
INTVW_CATEGORY |
Number(2,0) |
SMALLINT NOT NULL |
Interview Category
|
| 52 |
INTVW_COMMENTS_1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Comments 1
|
| 53 |
INTVW_EVAL_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Evaluation ID
|
| 54 |
INTVW_LOCATION |
Character(254) |
VARCHAR2(254) NOT NULL |
Interview Location
|
| 55 |
INTVW_RATING |
Number(2,0) |
SMALLINT NOT NULL |
Interview Rating
|
| 56 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 57 |
JOB_REQ_NBR |
Character(6) |
VARCHAR2(6) NOT NULL |
Job requisition number
|
| 58 |
JOB_REQN_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Requisition Template ID
|
| 59 |
JOB_REQUIS_DT_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Requisition Posting Type
C=Contingent Workforce
E=External Posting
I=Internal Posting
L=Labor Office
R=Recruitment
|
| 60 |
LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter code
|
| 61 |
LETTER_PRINTED_DT |
Date(10) |
DATE |
Date letter was printed
|
| 62 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 63 |
PGM_FLOW_CNTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Convenient AE State Record field for receiving result of a Do-When, Do-While, Do-Until, or other program flow control flag.
|
| 64 |
REQ_DESCR_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Description Type
|
| 65 |
REQ_DT_MEDIUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Medium
A=Ad
E=Email
I=Internet
J=Job Board Aggregator
O=Other
P=Posting
|
| 66 |
SCREENING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Screening Flag
F=Final Screening
P=Preliminary Screening
|
| 67 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 68 |
SQL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
|
| 69 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
|
| 70 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
|
| 71 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 72 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
|
| 73 |
TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Template ID
|
| 74 |
REQ_DT_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Required Date Description
|
| 75 |
HRS_SOURCE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Name
|
| 76 |
HRS_LOCATION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruiting location area
|
| 77 |
HRS_SCR_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening template ID
|
| 78 |
HRS_JO_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Template ID
|
| 79 |
HRS_TEAM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Team ID
|
| 80 |
HRS_RQMT_SUMM_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
RQMT_SUMM_ID
|
| 81 |
HRS_SCREENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Screening ID
|
| 82 |
HRS_RCRT_TMPL_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Template ID
|
| 83 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 84 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 85 |
CHECKLIST_DT |
Date(10) |
DATE |
Checklist Date
|
| 86 |
CHECKLIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Code
|
| 87 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
|
| 88 |
HRS_JO_PST_LIB_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Description ID
|
| 89 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 90 |
REQ_OPEN_DT |
Date(10) |
DATE |
Required Open Date
|
| 91 |
REQ_CLOSE_DT |
Date(10) |
DATE |
Required Close Date
|
| 92 |
RELATIVE_OPEN_DT |
Character(2) |
VARCHAR2(2) NOT NULL |
Relative Open Date
00=0 - On Approval Date
01=1 - One day after approval
02=2 - Two days after approval
03=3 - Three days after approval
04=4 - Four days after approval
05=5 - Five days after approval
06=6 - Six days after approval
07=7 - Seven days after approval
08=8 - Eight days after approval
09=9 - Nine days after approval
10=10 - Ten days after approval
|
| 93 |
POSTING_DURATION |
Number(3,0) |
SMALLINT NOT NULL |
Posting Duration (Days)
|
| 94 |
HRS_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Row Updated DateTime
|
| 95 |
HRS_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Updated Operator Id
|
| 96 |
UPG_HRSJOBOPID_OLD |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 97 |
COUNTER |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Counter
|
| 98 |
JPM_RATING1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic rating field generally prompted by RATING_MODEL
|