| # |
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
|
| 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
|
| 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 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
|
| 31 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Practical Grade
|
| 32 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Theoretical Grade
|
| 33 |
GRANTOR |
Character(20) |
VARCHAR2(20) NOT NULL |
The name of the person granting the award
|
| 34 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 35 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 36 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus
|
| 37 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Hours
|
| 38 |
GVT_CRED_HRS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Hours Type
C=Continuing Education
O=Other Pay
Q=Quarter Hours
S=Semester Hours
|
| 39 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 40 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 41 |
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
|
| 42 |
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
|
| 43 |
APS_MINOR_AUS |
Character(30) |
VARCHAR2(30) NOT NULL |
This field holds the description of the minor degree attained by an individual.
|
| 44 |
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.
|
| 45 |
NVQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
NVQ Status
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement
|
| 46 |
NVQ_START_DT |
Date(10) |
DATE |
NVQ Start Date
|
| 47 |
NVQ_COMP_DT |
Date(10) |
DATE |
NVQ Completion Date
|
| 48 |
NVQ_CERT_DT |
Date(10) |
DATE |
Certificate Award Date
|
| 49 |
NVQ_CAND_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Registration Number
|
| 50 |
NVQ_CAND_DT |
Date(10) |
DATE |
Registration Date
|
| 51 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Subject
|
| 52 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
|
| 53 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 54 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
|
| 55 |
SUBFACULTY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Sub Faculty Name(Description)(Japan HR)
|
| 56 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 57 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
|
| 58 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 59 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
|
| 60 |
REVIEW_DT |
Date(10) |
DATE |
Review Date
|
| 61 |
NVQ_REVIEWER |
Character(11) |
VARCHAR2(11) NOT NULL |
Review ID
|
| 62 |
NVQ_REVIEW_TYP |
Character(3) |
VARCHAR2(3) NOT NULL |
Review Type
BRF=Brief Meeting
MET=Standard Meeting
REQ=Requested
REV=Official Review
|
| 63 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 64 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 65 |
COMPETENCY |
Character(8) |
VARCHAR2(8) NOT NULL |
Competency
|
| 66 |
EP_SUB_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Sub-Item unique identifier
|
| 67 |
EP_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Title of an item
|
| 68 |
EP_SUB_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub-Competency level
A=Advanced
B=Basic
I=Intermediate
|
| 69 |
EP_DESCR254 |
Long Character(1325) |
VARCHAR2(1325) |
1325 character description field used in ePerformance
|
| 70 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
|
| 71 |
JPM_DISTINCT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Discinct Indicator
|
| 72 |
CM_CLUSTER |
Character(6) |
VARCHAR2(6) NOT NULL |
Competency Cluster
|
| 73 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 74 |
JOB_FAMILY |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Family
|
| 75 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 76 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 77 |
JOB_TASK |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Task
|
| 78 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 79 |
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.
|
| 80 |
JOB_PROFILE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Job Profile ID
|
| 81 |
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.
|
| 82 |
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.
|
| 83 |
EVALUATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation ID
|
| 84 |
ELEMENT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Element code
|
| 85 |
DATE_ACQUIRED |
Date(10) |
DATE |
Date Acquired
|
| 86 |
AREA_OF_STUDY |
Character(50) |
VARCHAR2(50) NOT NULL |
Area of Study
|
| 87 |
EP_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Item unique identifier
|
| 88 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 89 |
JPM_TEXT1325_1 |
Long Character(1325) |
VARCHAR2(1325) |
User Text - 1325 Char
|
| 90 |
JPM_TEXT254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
User Text - 254 Char
|
| 91 |
JPM_TEXT254_2 |
Character(254) |
VARCHAR2(254) NOT NULL |
User Text - 254 Char
|
| 92 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 93 |
EP_CONTENT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Content provider source
C=Customer Defined
D=DDI
L=Lominger
P=PDI
|
| 94 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 95 |
CM_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Competency Category
A=Ability
K=Knowledge
N=NVQ - Unit
O=Other
S=Skill
|
| 96 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 97 |
UNIT_TITLE |
Character(70) |
VARCHAR2(70) NOT NULL |
Unit Title
|
| 98 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 99 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
|
| 100 |
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
|
| 101 |
INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Interest Level
|
| 102 |
PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Proficiency
|
| 103 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 104 |
REVIEWER_APPRVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reviewer is Approved
|
| 105 |
REVIEW_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Status
|
| 106 |
EXP_DT |
Date(10) |
DATE |
Expected Completion Date
|
| 107 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 108 |
COMP_DT |
Date(10) |
DATE |
Completion Date
|
| 109 |
PRESENTED_DT |
Date(10) |
DATE |
Evidence Presented
|
| 110 |
SUBMIT_DT |
Date(10) |
DATE |
Submission Date
|
| 111 |
YR_LAST_USED |
Number(4,0) |
SMALLINT NOT NULL |
Year Last Used
|
| 112 |
YEARS_OF_EXP |
Number(5,1) |
DECIMAL(4,1) NOT NULL |
Years of Work Experience
|
| 113 |
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
|
| 114 |
SATISFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
This is a Yes/No flag to indicate if employee satisfied a certain criterion.
|
| 115 |
EP_MEASURE |
Long Character(1325) |
VARCHAR2(1325) |
1325 Character Item measurement description
|
| 116 |
EP_LANG_PROPER_USE |
Long Character(1325) |
VARCHAR2(1325) |
Language checker example of proper usage
|
| 117 |
EP_LANG_INCOR_USE |
Long Character(1325) |
VARCHAR2(1325) |
Language checker example of incorrect usage
|
| 118 |
AREA_OF_STDY_GRADE |
Character(4) |
VARCHAR2(4) NOT NULL |
Area Of Study Grade
|
| 119 |
JPM_ADHOC_DESCR |
Character(80) |
VARCHAR2(80) NOT NULL |
Page Title
|