| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OFFER_COMPONENT |
Character(7) |
VARCHAR2(7) NOT NULL |
Offer Component
|
| 3 |
NULL_WORK_DATE |
Date(10) |
DATE |
This field is used for the HRMS 8 Upgrade.
|
| 4 |
NULL_WORK_DTTM |
DateTime(26) |
TIMESTAMP |
Null Work Date Time
|
| 5 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 6 |
APP_DT |
Date(10) |
DATE |
Date an application was submitted
|
| 7 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 8 |
EXPIRATION_DT |
Date(10) |
DATE |
Expiration Date
|
| 9 |
WC_DECISION_DTTM |
DateTime(26) |
TIMESTAMP |
Works Council decision date/time
|
| 10 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 11 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
|
| 12 |
DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
|
| 13 |
REG_DISABLED_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Registered Diabled Number
|
| 14 |
DISABILITY_CD_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability Code
DSB=Disabled
HDS=Heavily Disabled
HMD=Heavy Mental Disorder
MDR=Mental Disorder
|
| 15 |
DISABILITY_GR_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
This field tracks the disability grade of a dependent.
001=Disability Grade 1
002=Disability Grade 2
003=Disability Grade 3
004=Disability Grade 4
005=Disability Grade 5
006=Disability Grade 6
007=Disability Grade 7
|
| 16 |
WKRCOMP_DISGRD_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
This field tracks the worker's compensation disability grade of a dependent.
001=Disability Grade 1
002=Disability Grade 2
003=Disability Grade 3
004=Disability Grade 4
005=Disability Grade 5
006=Disability Grade 6
007=Disability Grade 7
008=Disability Grade 8
009=Disability Grade 9
010=Disability Grade 10
011=Disability Grade 11
012=Disability Grade 12
013=Disability Grade 13
014=Disability Grade 14
|
| 17 |
WKRCOMP_ISGRD_JPN |
Character(3) |
VARCHAR2(3) NOT NULL |
This field tracks the Workers Comp Injury and Sickness grade for a dependent
001=Inj/Sick Grade 1
002=Inj/Sick Grade 2
003=Inj/Sick Grade 3
|
| 18 |
DISABILITY_CD_UK |
Character(3) |
VARCHAR2(3) NOT NULL |
DISABILITY_CD_UK
DXT=Manual Dexterity
HRN=Hearing
LRN=Learning
MBL=Mobility
MNH=Mental Handicap
MNI=Mental Illness
OTH=Other
RSP=Respiratory
SPC=Speech
UNS=Unspecified
VSN=Vision
|
| 19 |
WC_DECISION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Works Council Decision
|
| 20 |
WC_OVERRIDE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by the functionnality Works Council Notification.
|
| 21 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 22 |
COUNTRY_PASSPORT |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Issuing Passport
|
| 23 |
STATE_PASSPORT |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 24 |
CITY_PASSPORT |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 25 |
ISSUING_AUTHORITY |
Character(50) |
VARCHAR2(50) NOT NULL |
Issuing Authority
|
| 26 |
JOB_REQ_NBR |
Character(6) |
VARCHAR2(6) NOT NULL |
Job requisition number
|
| 27 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 28 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
|
| 29 |
SCREENING_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Screening Flag
F=Final Screening
P=Preliminary Screening
|
| 30 |
OFFER_DT |
Date(10) |
DATE |
Offer Date
|
| 31 |
ROUTE_DT |
Date(10) |
DATE |
Route Date
|
| 32 |
ROUTE_TO_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Route To ID
|
| 33 |
RESPONSE_DUE_DT |
Date(10) |
DATE |
Response Due Date
|
| 34 |
RESPONSE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Response Code
HOL=Hold on File
INV=Invite for Interview
NOR=No Response
RIE=Reject-Insufficent Experience
RIS=Reject-Insufficent Skills
RNO=Reject-No Opening
ROR=Reject-Other
|
| 35 |
STATUS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a status.
|
| 36 |
STATUS_DT |
Date(10) |
DATE |
Status Date
|
| 37 |
STATUS_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies a reason associated with a particular status.
|
| 38 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 39 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 40 |
ACCOMMODATION_ID |
Number(4,0) |
SMALLINT NOT NULL |
Accommodation ID
|
| 41 |
ACCOMMODATION_OPT |
Number(3,0) |
SMALLINT NOT NULL |
Accommodation Options
|
| 42 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 43 |
PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency
|
| 44 |
CM_IMPORTANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Competency Importance
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
|
| 45 |
CM_IMPORTANCE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Competency Importance
|
| 46 |
DT_REQUESTED |
Date(10) |
DATE |
Date of Request
|
| 47 |
REQUIRED |
Character(8) |
VARCHAR2(8) NOT NULL |
Required
|
| 48 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
|
| 49 |
REQUEST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Request Status
A=Accepted
P=Pending
U=Undue Hardship
|
| 50 |
PROFICIENCY_MAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency mandatory
|
| 51 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 52 |
ACCOUNT_ID |
Number(3,0) |
SMALLINT NOT NULL |
Account ID
|
| 53 |
DEPENDENT_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Dependent ID
|
| 54 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 55 |
PASSPORT_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
Passport Number
|
| 56 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 57 |
END_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
End Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 58 |
HIRE_CTR_CD_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Hiring Center
|
| 59 |
COMP_RATE_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Compensation Rate Description
|
| 60 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
|
| 61 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
Y/N Table Edit
|
| 62 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 63 |
RE_JOIN_DSB_EE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
1=Readmitted Back to Work
2=Readmit. Perm part. Disablty
3=Readmit>55Inc Perm.Perm.OthCat
4=Readmit>55Inc.Perm.OthCat
5=Lmtd Intellectual Disability
S=Readmitted
Y/N Table Edit
|
| 64 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion
Y/N Table Edit
|
| 65 |
UNEMPLYMNT_CND_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Condition
1=Booked in Unemployment Office
2=Booked in Office more than 12
3=Agricultural
4=With subsidy over one year
5=Booked in Office more than 6 m
6=With One-yr-remaining Subsidy
7=W/ subsidy. Older than 52 yrs.
A=W/ Benefit. RDL 2/2009
B=With Employability Problems
C=Unemployed at 1-1-2011
D=Unemployed at 1-1-2011. 12/18
E=Unemployed 16-08-2011
F=Unemployed with Family support
G=Unemployed >6 m. Fam Support
H=Under 3 m. of work experience
I=Unemployed from another sector
J=Youth Employment
K=Unemployed w/o Education Certf
L=Unemployed >12m last 18 months
M=Part Time<333. RDL 2/2009
P=RDL 3/2014 - Fix rate
R=RDL 1/2015 Reduced rate
W=Collective Excl. from regist.
|
| 66 |
PROBATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Probation Period
|
| 67 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
|
| 68 |
VACATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Vacation period
|
| 69 |
VACN_PERIOD_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Vacation period unit
D=Work Days
M=Months
N=Natural Days
W=Weeks
|
| 70 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
|
| 71 |
CONTRIB_ID_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
Soc.Sec. Contribution ID - ESP
|
| 72 |
CONTRCT_EXP_END_DT |
Date(10) |
DATE |
Contract Expected End Date
|
| 73 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 74 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
|
| 75 |
CONTRACT_CLAUSE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Clause
|
| 76 |
CLAUSE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Clause Status
1=Optional
2=Required
|
| 77 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 78 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 79 |
CONTRACT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status -
The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active
I=Inactive
|
| 80 |
ADD_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Contract
|
| 81 |
CNT_MIN_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Minimum Hours Per Contract
|
| 82 |
CNT_MAX_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Hours Per Contract
|
| 83 |
YEAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More than one year expected
|
| 84 |
PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 85 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 86 |
COMMENTSHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
Short Comment
|
| 87 |
CNT_TEMPLATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract Template ID
|
| 88 |
BEGIN_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
|
| 89 |
CONTRACT_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Contract Seq#
|
| 90 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 91 |
DISABLE_TYPE_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability Type
AAH=Disabled Person Allowance
COT=Known as COTOREP
COT=Known as COTOREP
DIS=Disability Card
FEM=Spouse of mentally disabled
ORP=War Orphan
PEN=Pensioned, Volunteer Fire Man
RQT=Disabled Worker Recognition
TPI=Disability Pension Owner
TPM=Disability Milit Pension Owner
VAM=Work Accident or Disease
VGN=Re-Married War Widow
VGR=Not-Married War Widow
|
| 92 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 93 |
SEQUENCE_NBR |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 94 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 95 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 96 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 97 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Code
|
| 98 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 99 |
END_DT |
Date(10) |
DATE |
end date
|
| 100 |
ENDING_TITLE |
Character(30) |
VARCHAR2(30) NOT NULL |
Ending Job Title
|
| 101 |
ENDING_RATE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Ending Pay Rate
|
| 102 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 103 |
NATIONALITY_DT |
Date(10) |
DATE |
Nationality Date
|
| 104 |
NATION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality Key
|
| 105 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 106 |
DIS_BEGIN_DT_FRA |
Date(10) |
DATE |
Disability Begin Date
|
| 107 |
DIS_END_DT_FRA |
Date(10) |
DATE |
Disability End Date
|
| 108 |
DATE_ACQUIRED |
Date(10) |
DATE |
Date Acquired
|
| 109 |
DIS_COTOREP_RT_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
COTOREP Category
A=COTOREP A - Category
B=COTOREP B Category
C=COTOREP C Category
|
| 110 |
DIS_IPP_RT_FRA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Disability Rate
|
| 111 |
DIS_PRIOR_PLC_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Previous Placement
|
| 112 |
PLACEMENT_TYPE_FRA |
Character(4) |
VARCHAR2(4) NOT NULL |
Previous Placement Type
AP=Protected WorkShop
CAT=Helped by a Work Center
CDTD=Home Work Center
CFP=Professional Training Center
IMPR=Professional/Medical Center
|
| 113 |
WRK_ACCDNT_DIS_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability Due to WorkAccident
|
| 114 |
TITLE_NBR_FRA |
Character(12) |
VARCHAR2(12) NOT NULL |
Title Number
|
| 115 |
NOTIF_DT_FRA |
Date(10) |
DATE |
Notification Date
|
| 116 |
OCC_ILLNESS_FRA |
Character(3) |
VARCHAR2(3) NOT NULL |
Professional Disease
|
| 117 |
VISA_PERMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Visa/Permit Type
|
| 118 |
SUPPORT_DOC_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Supporting Document ID
|
| 119 |
ACCOMMODATION_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
Accommodation Type
|
| 120 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 121 |
ACCOM_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Cost of Accommodation
|
| 122 |
CHECKLIST_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Checklist Code
|
| 123 |
CHECKLIST_DT |
Date(10) |
DATE |
Checklist Date
|
| 124 |
EMPLOYER_SUGGESTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Suggested Option
|
| 125 |
ACCOM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accommodation Status
A=Approved
C=Consider
O=Offered
P=Accepted
R=Rejected
U=Undue Hardship
|
| 126 |
PAY_FREQ_ABBRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
|
| 127 |
US_SOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Occupational Classif
|
| 128 |
CAN_NOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
National Occupational Classif
|
| 129 |
REL_WRK_EXPER |
Character(1) |
VARCHAR2(1) NOT NULL |
Relevant Work Experience
|
| 130 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 131 |
FULL_PART_TIME |
Character(1) |
VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
|
| 132 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 133 |
GVT_PAY_PLAN |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Plan
|
| 134 |
GVT_OCC_SERIES |
Character(4) |
VARCHAR2(4) NOT NULL |
Occupational Series
|
| 135 |
GVT_TYPE_OF_APPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)
|
| 136 |
GVT_HOURS_PER_WEEK |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Hours Per Week
|
| 137 |
GVT_POSN_OCCUPIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
|
| 138 |
GVT_TENURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
|
| 139 |
INTERVIEWER |
Character(11) |
VARCHAR2(11) NOT NULL |
Interviewer
|
| 140 |
INTERVW_DT |
Date(10) |
DATE |
Interview date
|
| 141 |
GVT_TYPE_OF_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Experience Type
F=Federal Civilian Sector
O=Other
P=Private Sector
|
| 142 |
DISABILITY_ITA |
Character(3) |
VARCHAR2(3) NOT NULL |
Disability
BLN=Blind
CIV=Civil due to war disability
CNR=Civil Disabl.not Recognized
CVL=Civil Disability
DD=Deaf and Dumb
EXP=Expelled
LAB=Labor disability
SER=Civil servants disability
WAR=Due to war disability
WID=War widows and orphans
|
| 143 |
DISABILITY_PERCTG |
Number(3,0) |
SMALLINT NOT NULL |
Disability Percentage
|
| 144 |
DIAGNOSIS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Diagnosis Code
|
| 145 |
URL_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
URL #1
|
| 146 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 147 |
GEOG_PREFERENCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Geographic Preferences
C=Canada
E=East
I=International
MW=Midwest
N=North
NE=Northeast
NW=Northwest
S=South
SE=Southeast
SW=Southwest
W=West
|
| 148 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 149 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 150 |
RESUME_NUMBER |
Number(7,0) |
INTEGER NOT NULL |
Resume number
|
| 151 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
|
| 152 |
ADJUDICATION_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of abjudication.
|
| 153 |
APPLY_ONLINE_URL |
Character(30) |
VARCHAR2(30) NOT NULL |
Apply On-Line URL
|
| 154 |
AUTOPOP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Populate Flag - Indicates if auto populate is turned on or off.
|
| 155 |
AUTOPOP_MOHO_FTP |
Character(30) |
VARCHAR2(30) NOT NULL |
Auto Populate - URL for Mohomine Resume Extractor FTP Site
|
| 156 |
JOB_REQ_NBR_LAST |
Number(6,0) |
INTEGER NOT NULL |
Last Job Requisition # Used
|
| 157 |
LAST_APPLID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Applicant Id Assigned
|
| 158 |
LAST_AUTOPOPID |
Number(6,0) |
INTEGER NOT NULL |
Last assigned auto populate applicant ID
|
| 159 |
LAST_DUPLCTSET_ID |
Number(8,0) |
INTEGER NOT NULL |
Last duplicate set ID
|
| 160 |
LAST_INTVW_NBR |
Number(7,0) |
INTEGER NOT NULL |
Last Interview # Used
|
| 161 |
LAST_RESUME_NBR |
Number(7,0) |
INTEGER NOT NULL |
Last resume number used
|
| 162 |
PREEMPLOYMENT_VIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
View pre-employment request results.
|
| 163 |
RESUME_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Resume Template Id
|
| 164 |
RP_EDUCATION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resume Processing - Validate Education Flag
|
| 165 |
RP_WRK_EXP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Resume Processing - Validate Work Experience Flag
|
| 166 |
URL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
URL Identifier (see PSURLDEFN).
|
| 167 |
NUMROWS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Rows fetched.
|
| 168 |
PROCESS_PREHIRE |
Character(1) |
VARCHAR2(1) NOT NULL |
Prehire Processing Requested
|
| 169 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 170 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 171 |
HRS_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Person Id
|
| 172 |
HRS_PERSON_ID_LAST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Last Person Id counter
|
| 173 |
UPG_COUNTER |
Number(11,0) |
DECIMAL(11) NOT NULL |
Row Counter
|
| 174 |
HRS_PROFILE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Profile sequece
|
| 175 |
HRS_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 176 |
AREA_OF_STUDY |
Character(50) |
VARCHAR2(50) NOT NULL |
Area of Study
|
| 177 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 178 |
AREA_OF_STDY_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Area Of Study Grade
|
| 179 |
HRS_NOTES_SUBJ |
Character(254) |
VARCHAR2(254) NOT NULL |
Subject
|
| 180 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 181 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
|
| 182 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 183 |
SCHOOL_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
School Type
|
| 184 |
EDUCATION_LVL_ACHV |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Level Achieved
|
| 185 |
UPG_HRS_PREV_EDLVL |
Character(3) |
VARCHAR2(3) NOT NULL |
Previous Ed Level Achieved
|
| 186 |
UPG_HRS_NEW_EDLVL |
Character(12) |
VARCHAR2(12) NOT NULL |
If duplicate values for HRS_APP_SCHL.EDUCATION_LVL_ACHV exist during upgrade, this field will be set to a unique value equal to HRS_APP_SCHL.EDUCATION_LVL_ACHV + counter so that all data can be upgraded to the new release
|
| 187 |
HRS_CAT_ITEM_TXT |
Character(30) |
VARCHAR2(30) NOT NULL |
value of content item description extracted during resume processing when no matching jpm_cat_item_id is found
|
| 188 |
UPG_RCMNT_ID_LAST |
Number(15,0) |
DECIMAL(15) NOT NULL |
Previous App Tracking Recruitment ID - used in upgrades
|
| 189 |
UPG_RCM_INT_ID_NEW |
Number(15,0) |
DECIMAL(15) NOT NULL |
Recruitment Interview ID - used in upgrades
|
| 190 |
EVALUATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation ID
|
| 191 |
EVALUATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Evaluation Type
A=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self
|
| 192 |
REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
|
| 193 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 194 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 195 |
YR_LAST_USED |
Number(4,0) |
SMALLINT NOT NULL |
Year Last Used
|
| 196 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 197 |
INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Level
|
| 198 |
HRS_APP_CMP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Competency ID
|
| 199 |
COMPETENCY_TXT |
Character(30) |
VARCHAR2(30) NOT NULL |
Competency Text
|
| 200 |
HOW_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Verified By
E=Employee Claim
J=On the Job Training
N=Not Verified
O=Employer Observation
T=By Test
V=NVQ Authority
|
| 201 |
REVIEWER_APPRVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewer is Approved
|
| 202 |
REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
|
| 203 |
UPG_PRV_COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Previous Competency
|
| 204 |
HRS_TMP_CHAR12_01 |
Character(12) |
VARCHAR2(12) NOT NULL |
Temporary 12-char field for use in Recruiting Solutions upgrades
|
| 205 |
HRS_TMP_NBR12_01 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Temporary number field for use in Recruiting Solutions Upgrades
|
| 206 |
HRS_APP_ACMP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Accomplishment ID
|
| 207 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 208 |
JPM_PERSON_ID_1 |
Character(11) |
VARCHAR2(11) NOT NULL |
Person id property for profile items
|
| 209 |
MANDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate
|
| 210 |
MANDATE_BEGIN_DATE |
Date(10) |
DATE |
Mandate Begin Date
|
| 211 |
MANDATE_END_DATE |
Date(10) |
DATE |
Mandate End Date
|
| 212 |
MANDATE_FUNCTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate Position
|
| 213 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
|
| 214 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus Amount
|
| 215 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 216 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 217 |
PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Test
N=No
Y=Yes
|
| 218 |
LICENSE_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
License Verified
|
| 219 |
LICENSE_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
License/Certification Number
|
| 220 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Theoretical Grade applicable in Germany.
|
| 221 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Practical Grade applicable in Germany.
|
| 222 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
|
| 223 |
ISSUED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issued By
|
| 224 |
SUBFACULTY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Sub Faculty Name(Description)(Japan HR)
|
| 225 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
|
| 226 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
|
| 227 |
MAJOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Major
|
| 228 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 229 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
|
| 230 |
GRADUATE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduated
N=No
Y=Yes
|
| 231 |
EDUCATOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Educator
|
| 232 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 233 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern Professional Education
|
| 234 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Credit Hours
|
| 235 |
GVT_CRED_HRS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of education credit hours
C=Continuing Education
O=Other Pay
Q=Quarter Hours
S=Semester Hours
|
| 236 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 237 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
FPS Subject Code
|
| 238 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 239 |
GRANTOR |
Character(20) |
VARCHAR2(20) NOT NULL |
The name of the person granting the award
|