| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
JPM_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
Profile Type name for a JPM Profile Type
|
| 3 |
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.
Prompt Table:
JPM_CAT_TYPES
|
| 4 |
JPM_CAT_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
Prompt Table:
JPM_CAT_ITEMS
|
| 5 |
JPM_CAT_ITEM_QUAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
Prompt Table:
JPM_JP_QUAL_INS
|
| 6 |
JPM_CAT_ITEM_QUAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting).
Prompt Table:
%EDITTABLE3
|
| 7 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 8 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 9 |
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.
Prompt Table:
JPM_PROFILE
|
| 10 |
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.
|
| 11 |
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
|
| 12 |
JPM_SOURCE_ID1 |
Character(12) |
VARCHAR2(12) NOT NULL |
JPM Profile Item Source ID1
|
| 13 |
JPM_SOURCE_ID2 |
Character(12) |
VARCHAR2(12) NOT NULL |
JPM Profile Item Source ID3
|
| 14 |
JPM_SOURCE_ID3 |
Character(12) |
VARCHAR2(12) NOT NULL |
JPM Profile Item Source ID3
|
| 15 |
JPM_JP_QUAL_SET |
Character(12) |
VARCHAR2(12) NOT NULL |
1st Instance Qualifier Set Name for a JPM Profile Item
|
| 16 |
JPM_JP_QUAL_SET2 |
Character(12) |
VARCHAR2(12) NOT NULL |
2nd Instance Qualifier Set Name for a JPM Profile Item
|
| 17 |
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.
|
| 18 |
JPM_WF_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
JPM Workflow Status field
A=Approved
D=Denied
N=New
P=Pending
S=Saved
|
| 19 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 20 |
JPM_DATE_1 |
Date(10) |
DATE |
generic profile item date property
|
| 21 |
JPM_DATE_2 |
Date(10) |
DATE |
generic profile item date property
|
| 22 |
JPM_EVAL_MTHD |
Character(4) |
VARCHAR2(4) NOT NULL |
Competency evaluation method.
|
| 23 |
JPM_TEXT1325_1 |
Long Character(1325) |
VARCHAR2(1325) |
Generic Text property for profile items
|
| 24 |
JPM_TEXT1325_2 |
Long Character(1325) |
VARCHAR2(1325) |
Generic Text property for profile items
|
| 25 |
JPM_TEXT254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 26 |
JPM_TEXT254_2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 27 |
JPM_TEXT254_3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 28 |
JPM_TEXT254_4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 29 |
JPM_YN_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 30 |
JPM_YN_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 31 |
JPM_YN_3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 32 |
JPM_YN_4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 33 |
JPM_YN_5 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Yes No property for profile items
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 34 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table:
RATING_MDL_TBL
|
| 35 |
JPM_INTEREST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile item property stating intertest level of the employee in the content item
Prompt Table:
INT_RATING_VW
|
| 36 |
JPM_MANDATORY |
Character(1) |
VARCHAR2(1) NOT NULL |
jpm
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 37 |
JPM_RATING1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic rating field generally prompted by RATING_MODEL
Prompt Table:
REVW_RATING_TBL
|
| 38 |
JPM_RATING2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic rating field generally prompted by RATING_MODEL
Prompt Table:
REVW_RATING_TBL
|
| 39 |
JPM_RATING3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic rating field generally prompted by RATING_MODEL
Prompt Table:
REVW_RATING_TBL
|
| 40 |
JPM_TEXT254_5 |
Character(254) |
VARCHAR2(254) NOT NULL |
Generic Text property for profile items
|
| 41 |
JPM_DATE_3 |
Date(10) |
DATE |
generic profile item date property
|
| 42 |
JPM_DATE_4 |
Date(10) |
DATE |
generic profile item date property
|
| 43 |
JPM_DATE_5 |
Date(10) |
DATE |
generic profile item date property
|
| 44 |
JPM_DATE_6 |
Date(10) |
DATE |
generic profile item date property
|
| 45 |
JPM_INTEGER_1 |
Number(8,0) |
INTEGER NOT NULL |
generic profile item integer property
|
| 46 |
JPM_INTEGER_2 |
Number(8,0) |
INTEGER NOT NULL |
generic profile item integer property
|
| 47 |
JPM_PCT_1 |
Number(3,0) |
SMALLINT NOT NULL |
generic percentage property
|
| 48 |
JPM_PCT_2 |
Number(3,0) |
SMALLINT NOT NULL |
generic percentage property
|
| 49 |
JPM_DECIMAL_1 |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
generic profile item decimal property
|
| 50 |
JPM_DECIMAL_2 |
Number(10,2) |
DECIMAL(9,2) NOT NULL |
generic profile item decimal property
|
| 51 |
JPM_PROMPT_1 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (1)
Prompt Table:
JPM_PROMPT_DVW
|
| 52 |
JPM_PROMPT_2 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (2)
Prompt Table:
JPM_PROMPT_DVW
|
| 53 |
JPM_PROMPT_3 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (3)
Prompt Table:
JPM_PROMPT_DVW
|
| 54 |
JPM_PROMPT_4 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (4)
Prompt Table:
JPM_PROMPT_DVW
|
| 55 |
JPM_PROMPT_5 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (5)
Prompt Table:
JPM_PROMPT_DVW
|
| 56 |
JPM_PROMPT_6 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (6)
Prompt Table:
JPM_PROMPT_DVW
|
| 57 |
JPM_PROMPT_7 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (7)
Prompt Table:
JPM_PROMPT_DVW
|
| 58 |
JPM_PROMPT_8 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (8)
Prompt Table:
JPM_PROMPT_DVW
|
| 59 |
JPM_PROMPT_9 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (9)
Prompt Table:
JPM_PROMPT_DVW
|
| 60 |
JPM_PROMPT_10 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (10)
Prompt Table:
JPM_PROMPT_DVW
|
| 61 |
JPM_PROMPT_11 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (11)
Prompt Table:
JPM_PROMPT_DVW
|
| 62 |
JPM_PROMPT_12 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (12)
Prompt Table:
JPM_PROMPT_DVW
|
| 63 |
JPM_PROMPT_13 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (13)
Prompt Table:
JPM_PROMPT_DVW
|
| 64 |
JPM_PROMPT_14 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (14)
Prompt Table:
JPM_PROMPT_DVW
|
| 65 |
JPM_PROMPT_15 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (15)
Prompt Table:
JPM_PROMPT_DVW
|
| 66 |
JPM_PROMPT_16 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (16)
Prompt Table:
JPM_PROMPT_DVW
|
| 67 |
JPM_PROMPT_17 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (17)
Prompt Table:
JPM_PROMPT_DVW
|
| 68 |
JPM_PROMPT_18 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (18)
Prompt Table:
JPM_PROMPT_DVW
|
| 69 |
JPM_PROMPT_19 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (19)
Prompt Table:
JPM_PROMPT_DVW
|
| 70 |
JPM_PROMPT_20 |
Character(12) |
VARCHAR2(12) NOT NULL |
User Prompt (20)
Prompt Table:
JPM_PROMPT_DVW
|
| 71 |
JPM_PERSON_ID_1 |
Character(11) |
VARCHAR2(11) NOT NULL |
Person id property for profile items
Prompt Table:
JPM_PERSON_NAME
|
| 72 |
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
|
| 73 |
JPM_VERIFY_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Property for how the profile item was verified.
E=Employee Claim
J=On the Job Training
N=Not Verified
O=Employer Observation
T=By Test
V=NVQ Authority
|
| 74 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
HCR_STONLY_I
|
| 75 |
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
|
| 76 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
Prompt Table:
JPM_SCHOOL_TBL
|
| 77 |
SCHOOL_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Name of the school
|
| 78 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
Prompt Table:
MAJOR_TBL
|
| 79 |
MAJOR_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Description of the major
|
| 80 |
JPM_MINOR_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Minor for degree or education content type
Prompt Table:
JPM_MAJOR_VW
|
| 81 |
MINOR_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Description of the minor
|
| 82 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 83 |
PRACTIC_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Practical Grade applicable in Germany.
|
| 84 |
THEORY_GRADE_GER |
Character(4) |
VARCHAR2(4) NOT NULL |
Track Theoretical Grade applicable in Germany.
|
| 85 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern Professional Education
Y/N Table Edit
Default Value: N
|
| 86 |
EVALUATION_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Evaluation ID
|
| 87 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Education Credit Hours
|
| 88 |
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
|
| 89 |
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
|
| 90 |
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
|
| 91 |
FACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Faculty Code (Japan HR)
Prompt Table:
FACULTY_TBL_JPN
|
| 92 |
FACULTY_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Faculty description
|
| 93 |
SUBFACULTY_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Sub Faculty Code(Japan HR)
Prompt Table:
SBFCLTY_TBL_JPN
|
| 94 |
SUBFACULTY_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Sub Faculty Name(Description)(Japan HR)
|
| 95 |
MAJOR_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Major Category(Japan HR)
H=Humanities
S=Sciences
|
| 96 |
FP_SUBJECT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
FPS Subject Code
Prompt Table:
FPMSUBJECTS
|
| 97 |
EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
|
| 98 |
SCHOOL_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
School Type
Prompt Table:
SCHOOL_TYPE_TBL
|
| 99 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 100 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
Set Control Field: SETID_DEPT
|
| 101 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUSUNIT_HR_VW
|
| 102 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 103 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
Set Control Field: SETID_LOCATION
|
| 104 |
JPM_ADHOC_DESCR |
Character(80) |
VARCHAR2(80) NOT NULL |
Page Title
|
| 105 |
FP_SKIL_HIR |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Hiring Requirement
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 106 |
FP_SKIL_PRM |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Promotion Requirement
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 107 |
FP_SKIL_TEN |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Tenure Requirement
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 108 |
FP_DEGR_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
FPS Degree
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 109 |
BONUS_AMOUNT_FRA |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bonus Amount
|
| 110 |
BONUS_DT_FRA |
Date(10) |
DATE |
Bonus Date
|
| 111 |
JPM_OBSTACLE_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Obstacle property
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
|
| 112 |
JPM_AREA_PREF_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Generic profile item property
Prompt Table:
JPM_GEOG_PRF_VW
|
| 113 |
JPM_AREA_PREF_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Generic profile item property
Prompt Table:
JPM_GEOG_PRF_VW
|
| 114 |
JPM_AREA_PREF_3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Generic profile item property
Prompt Table:
JPM_GEOG_PRF_VW
|
| 115 |
JPM_CNTRY_PREF_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Generic profile item property for country preference
Prompt Table:
COUNTRY_TBL
|
| 116 |
JPM_CNTRY_PREF_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Generic profile item property for country preference
Prompt Table:
COUNTRY_TBL
|
| 117 |
JPM_CNTRY_PREF_3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Generic profile item property for country preference
Prompt Table:
COUNTRY_TBL
|
| 118 |
JPM_LOC_BUNIT_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
generic profile item location BU property
Prompt Table:
BUSUNIT_HR_VW
|
| 119 |
JPM_SETID_LOC_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Generic Location Setid property
|
| 120 |
JPM_LOCATION_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
generic profile item location property
Prompt Table:
LOCATION_TBL
Set Control Field: JPM_SETID_LOC_1
|
| 121 |
JPM_LOC_BUNIT_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
generic profile item location BU property
Prompt Table:
BUSUNIT_HR_VW
|
| 122 |
JPM_SETID_LOC_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Generic Location Setid property
|
| 123 |
JPM_LOCATION_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
generic profile item location property
Prompt Table:
LOCATION_TBL
Set Control Field: JPM_SETID_LOC_2
|
| 124 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
Default Value: %Date
|
| 125 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|