| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 3 |
PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Test
N=No
Y=Yes
|
| 4 |
LICENSE_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
License/Certification Number
|
| 5 |
ISSUED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issued By
|
| 6 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 7 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 8 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 9 |
LICENSE_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
License Verified
|
| 10 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
|
| 11 |
NATIVE_LANGUAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Language
|
| 12 |
TRANSLATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Translate
|
| 13 |
TEACHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Teach
|
| 14 |
SPEAK_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low
2=Moderate
3=High
|
| 15 |
READ_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low
2=Moderate
3=High
|
| 16 |
WRITE_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low
2=Moderate
3=High
|
| 17 |
EVALUATION_DT |
Date(10) |
DATE |
Evaluation Date
|
| 18 |
MANDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate
|
| 19 |
MANDATE_FUNCTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate Position
|
| 20 |
MANDATE_BEGIN_DATE |
Date(10) |
DATE |
Mandate Begin Date
|
| 21 |
MANDATE_END_DATE |
Date(10) |
DATE |
Mandate End Date
|
| 22 |
MAJOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Major
|
| 23 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern Professional Education
|
| 24 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 25 |
EDUCATOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Educator
|
| 26 |
GRADUATE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduated
N=No
Y=Yes
|
| 27 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
|
| 28 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
|
| 29 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
|
| 30 |
SCHOOL_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
School Type
|
| 31 |
EDUCATION_LVL_ACHV |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Level Achieved
|
| 32 |
COMPLETED |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=No
Y=Yes
|
| 33 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
|
| 34 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Practical Grade applicable in Germany.
|
| 35 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Theoretical Grade applicable in Germany.
|
| 36 |
GRANTOR |
Character(20) |
VARCHAR2(20) NOT NULL |
The name of the person granting the award
|
| 37 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 38 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 39 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus Amount
|
| 40 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Credit Hours
|
| 41 |
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
|
| 42 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 43 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 44 |
EDUC_LVL_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field refers to the highest education attained by the member of staff.
This is an Australia specific code which is needed for DETYA electronic reporting purposes.
0=Non-Academic
1=Higher Degree
2=Bachelor's Degree
3=Other
4=No Info
|
| 45 |
APS_HEDUC_CD_AUS |
Character(2) |
VARCHAR2(2) NOT NULL |
The APS maintains a list of education codes that should be used for reporting purposes. Users should select the APS code to an existing education code in the system.
01=Doctorate
02=Masters
03=Postgraduate Diploma
04=Bachelor Degree
05=Undergraduate Diploma
06=Associate Diploma
07=Skilled Vocational Qualificatn
08=Basic Vocational Qualification
09=Year 12 (Higher School Cert)
11=Year 11
12=Year 10 (Leaving/School Cert)
13=Less than Year 10
97=Chose not to Give
|
| 46 |
APS_MINOR_AUS |
Character(30) |
VARCHAR2(30) NOT NULL |
This field holds the description of the minor degree attained by an individual.
|
| 47 |
APS_MINOR_CODE_AUS |
Character(10) |
VARCHAR2(10) NOT NULL |
Employee undertake multiple qualifications that can be classified as Major and Minor qualification. Minor code identifies the minor qualification undertaken by an employee.
|
| 48 |
NVQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The status of the employee's NVQ
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement
R=Reviewed
|
| 49 |
NVQ_START_DT |
Date(10) |
DATE |
NVQ Start Date
|
| 50 |
NVQ_COMP_DT |
Date(10) |
DATE |
NVQ Completion Date
|
| 51 |
NVQ_CERT_DT |
Date(10) |
DATE |
Certificate Award Date
|
| 52 |
NVQ_CAND_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Registration Number
|
| 53 |
NVQ_CAND_DT |
Date(10) |
DATE |
Registration Date
|
| 54 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
FPS Subject Code
|
| 55 |
FP_SKIL_HIR |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Hiring Requirement
N=No
Y=Yes
|
| 56 |
FP_SKIL_PRM |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Promotion Requirement
N=No
Y=Yes
|
| 57 |
FP_SKIL_TEN |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Tenure Requirement
N=No
Y=Yes
|
| 58 |
FP_DEGR_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Degree
N=No
Y=Yes
|
| 59 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
|
| 60 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 61 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
|
| 62 |
SUBFACULTY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Sub Faculty Name(Description)(Japan HR)
|
| 63 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 64 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 65 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 66 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 67 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 68 |
NVQ_REVIEWER |
Character(11) |
VARCHAR2(11) NOT NULL |
Review ID
|
| 69 |
NVQ_REVIEW_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Review Type
BRF=Brief Meeting
MET=Standard Meeting
REQ=Requested
REV=Official Review
|
| 70 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 71 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 72 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
|
| 73 |
EP_SUB_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Sub-Item unique identifier
|
| 74 |
EP_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Title of an item
|
| 75 |
EP_SUB_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub-Competency level
|
| 76 |
EP_DESCR254 |
Long Character |
CLOB |
1325 character description field used in ePerformance
|
| 77 |
EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
|
| 78 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
|
| 79 |
JPM_DISTINCT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Discinct Indicator
|
| 80 |
CM_CLUSTER |
Character(6) |
VARCHAR2(6) NOT NULL |
Competency Cluster
|
| 81 |
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
|
| 82 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 83 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 84 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 85 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 86 |
JOB_TASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Task
|
| 87 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 88 |
JPM_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
|
| 89 |
JOB_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Job Profile ID
|
| 90 |
JPM_ITEM_KEY_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification.
|
| 91 |
JPM_PARENT_KEY_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
This is the JPM_ITEM_KEY_ID of the item in the profile that is the parent or driving item of the item. Example- a sub competency may have the item key id of the competency as the parent key. It is used to link more than one item together in a profile where a relationship was established.
|
| 92 |
JPM_JP_ITEM_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Indicates the source of a JPM profile item so that changes to the profile item will be blocked in JPM. The changes can only be made through the source product.
ELM=Learning Management
EP=ePerformance
NVQ=Manage NVQ GBR
PROF=Another Profile
WADM=Workforce Administration
|
| 93 |
JPM_CAT_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
The name of the type of items that will be used in a Catalog and or in a Profile.
|
| 94 |
JPM_IMPORTANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
profile item importance rating
1=1- Low
2=2 - Below Average
3=3 - Average
4=4 - Above Average
5=5 - High
|
| 95 |
EVALUATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation ID
|
| 96 |
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
|
| 97 |
EVAL_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Method of Evaluation
|
| 98 |
ELEMENT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Element code
|
| 99 |
DATE_ACQUIRED |
Date(10) |
DATE |
Date Acquired
|
| 100 |
AREA_OF_STUDY |
Character(50) |
VARCHAR2(50) NOT NULL |
Area of Study
|
| 101 |
EP_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Item unique identifier
|
| 102 |
EP_ITEM_CRIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the critical field is available
|
| 103 |
EP_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Weight factor
|
| 104 |
EP_MIN_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Minumum weight used (percentage)
|
| 105 |
EP_ITEM_MANDTRY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the mandatory field is available
|
| 106 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 107 |
JPM_TEXT1325_1 |
Long Character(1325) |
VARCHAR2(1325) |
Generic Text property for profile items
|
| 108 |
JPM_TEXT254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 109 |
JPM_TEXT254_2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 110 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 111 |
EP_CONTENT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Content provider source
C=Customer Defined
D=DDI
L=Lominger
P=PDI
|
| 112 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 113 |
CM_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Competency Category
A=Ability
K=Knowledge
N=NVQ - Unit
O=Other
S=Skill
|
| 114 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 115 |
UNIT_TITLE |
Character(70) |
VARCHAR2(70) NOT NULL |
Unit Title
|
| 116 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 117 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
|
| 118 |
ACCOMP_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test
|
| 119 |
INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Level
|
| 120 |
PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency
|
| 121 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 122 |
REVIEWER_APPRVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewer is Approved
|
| 123 |
REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
|
| 124 |
REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
|
| 125 |
EXP_DT |
Date(10) |
DATE |
Expected Completion Date
|
| 126 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 127 |
COMP_DT |
Date(10) |
DATE |
Completion Date
|
| 128 |
PRESENTED_DT |
Date(10) |
DATE |
Evidence Presented
|
| 129 |
SUBMIT_DT |
Date(10) |
DATE |
Submission Date
|
| 130 |
YR_LAST_USED |
Number(4,0) |
SMALLINT NOT NULL |
Year Last Used
|
| 131 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 132 |
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
|
| 133 |
SATISFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Yes/No flag to indicate if employee satisfied a certain criterion.
|
| 134 |
EP_MEASURE |
Long Character |
CLOB |
1325 Character Item measurement description
|
| 135 |
EP_LANG_PROPER_USE |
Long Character(1325) |
VARCHAR2(1325) |
Language checker example of proper usage
|
| 136 |
EP_LANG_INCOR_USE |
Long Character(1325) |
VARCHAR2(1325) |
Language checker example of incorrect usage
|
| 137 |
AREA_OF_STDY_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Area Of Study Grade
|
| 138 |
JPM_ADHOC_DESCR |
Character(80) |
VARCHAR2(80) NOT NULL |
Page Title
|
| 139 |
DT_COMPLETED |
Date(10) |
DATE |
Date Completed
|
| 140 |
EMPLOYER |
Character(30) |
VARCHAR2(30) NOT NULL |
Employer
|
| 141 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 142 |
JPM_RATING1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic rating field generally prompted by RATING_MODEL
|
| 143 |
JPM_YN_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
|
| 144 |
JPM_PCT_1 |
Number(3,0) |
SMALLINT NOT NULL |
generic percentage property
|
| 145 |
JPM_PCT_2 |
Number(3,0) |
SMALLINT NOT NULL |
generic percentage property
|
| 146 |
JPM_MANDATORY |
Character(1) |
VARCHAR2(1) NOT NULL |
jpm
N=No
Y=Yes
|
| 147 |
OBSTACLES_MOBILITY |
Character(2) |
VARCHAR2(2) NOT NULL |
Obstacles to Mobility
FE=Family Member's Education
FH=Family Member's Health
FJ=Family Member's Job
H=Homeowner
N=None
OT=Other
P=Prefer Current Location
|
| 148 |
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
|