FT_PM_ST2_AET

(SQL Table)
Index Back

Used in upgrading Legacy data

Upgrade Legacy data into JPM. State 1 is compared to state 2 for id assignments.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DT_COMPLETED Date(10) DATE Date Completed
3 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
4 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test
N=No
Y=Yes
5 LICENSE_NBR Character(15) VARCHAR2(15) NOT NULL License/Certification Number
6 ISSUED_BY Character(30) VARCHAR2(30) NOT NULL Issued By
7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
8 STATE Character(6) VARCHAR2(6) NOT NULL State
9 EXPIRATN_DT Date(10) DATE Expiration Date
10 LICENSE_VERIFIED Character(1) VARCHAR2(1) NOT NULL License Verified
11 RENEWAL Character(1) VARCHAR2(1) NOT NULL Renewal in Progress
12 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language
13 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate
14 TEACHER Character(1) VARCHAR2(1) NOT NULL Able to Teach
15 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
1=Low
2=Moderate
3=High
16 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
1=Low
2=Moderate
3=High
17 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
1=Low
2=Moderate
3=High
18 EVALUATION_DT Date(10) DATE Evaluation Date
19 MANDATE Character(15) VARCHAR2(15) NOT NULL Mandate
20 MANDATE_FUNCTION Character(15) VARCHAR2(15) NOT NULL Mandate Position
21 MANDATE_BEGIN_DATE Date(10) DATE Mandate Begin Date
22 MANDATE_END_DATE Date(10) DATE Mandate End Date
23 MAJOR Character(30) VARCHAR2(30) NOT NULL Major
24 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern Professional Education
25 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade
26 EDUCATOR Character(50) VARCHAR2(50) NOT NULL Educator
27 GRADUATE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Graduated
N=No
Y=Yes
28 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
29 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other
30 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
31 TERMINAL_DEGREE Character(1) VARCHAR2(1) NOT NULL Terminal Degree for Discipline
32 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Track Practical Grade applicable in Germany.
33 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Track Theoretical Grade applicable in Germany.
34 GRANTOR Character(20) VARCHAR2(20) NOT NULL The name of the person granting the award
35 END_DATE Date(10) DATE End Date
36 BONUS_DT_FRA Date(10) DATE Bonus Date
37 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus Amount
38 GVT_CREDIT_HOURS Character(3) VARCHAR2(3) NOT NULL Education Credit Hours
39 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
40 GPA Number(5,2) DECIMAL(4,2) NOT NULL GPA
41 YR_ACQUIRED Number(4,0) SMALLINT NOT NULL Year Acquired
42 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
43 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
44 APS_MINOR_AUS Character(30) VARCHAR2(30) NOT NULL This field holds the description of the minor degree attained by an individual.
45 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.
46 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
47 NVQ_START_DT Date(10) DATE NVQ Start Date
48 NVQ_COMP_DT Date(10) DATE NVQ Completion Date
49 NVQ_CERT_DT Date(10) DATE Certificate Award Date
50 NVQ_CAND_NBR Character(16) VARCHAR2(16) NOT NULL Registration Number
51 NVQ_CAND_DT Date(10) DATE Registration Date
52 FP_SUBJECT_CD Character(3) VARCHAR2(3) NOT NULL FPS Subject Code
53 FACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Faculty Code (Japan HR)
54 DESCR Character(30) VARCHAR2(30) NOT NULL Description
55 SUBFACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Sub Faculty Code(Japan HR)
56 SUBFACULTY_NAME Character(50) VARCHAR2(50) NOT NULL Sub Faculty Name(Description)(Japan HR)
57 MAJOR_CATEGORY Character(1) VARCHAR2(1) NOT NULL Major Category(Japan HR)
H=Humanities
S=Sciences
58 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
59 DT_ISSUED Date(10) DATE Issue Date
60 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
61 REVIEW_DT Date(10) DATE Review Date
62 NVQ_REVIEWER Character(11) VARCHAR2(11) NOT NULL Review ID
63 NVQ_REVIEW_TYP Character(3) VARCHAR2(3) NOT NULL Review Type
BRF=Brief Meeting
MET=Standard Meeting
REQ=Requested
REV=Official Review
64 DESCRLONG Long Character CLOB Long Description
65 EFFDT Date(10) DATE Effective Date
66 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
67 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
68 EP_TITLE Character(60) VARCHAR2(60) NOT NULL Title of an item
69 EP_SUB_LEVEL Character(1) VARCHAR2(1) NOT NULL Sub-Competency level
70 EP_DESCR254 Long Character CLOB 1325 character description field used in ePerformance
71 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.
72 JPM_DISTINCT_IND Character(1) VARCHAR2(1) NOT NULL Discinct Indicator
73 CM_CLUSTER Character(6) VARCHAR2(6) NOT NULL Competency Cluster
74 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
75 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
76 SETID Character(5) VARCHAR2(5) NOT NULL SetID
77 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
78 JOB_TASK Character(6) VARCHAR2(6) NOT NULL Job Task
79 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
80 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.
81 JOB_PROFILE_ID Character(12) VARCHAR2(12) NOT NULL Job Profile ID
82 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.
83 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.
84 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID
85 ELEMENT_CD Character(10) VARCHAR2(10) NOT NULL Element code
86 DATE_ACQUIRED Date(10) DATE Date Acquired
87 AREA_OF_STUDY Character(50) VARCHAR2(50) NOT NULL Area of Study
88 EP_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Item unique identifier
89 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
90 JPM_TEXT1325_1 Long Character(1325) VARCHAR2(1325) Generic Text property for profile items
91 JPM_TEXT254_1 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
92 JPM_TEXT254_2 Character(254) VARCHAR2(254) NOT NULL Generic Text property for profile items
93 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
94 EP_CONTENT_SRC Character(1) VARCHAR2(1) NOT NULL Content provider source
C=Customer Defined
D=DDI
L=Lominger
P=PDI
95 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
96 CM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Competency Category
A=Ability
K=Knowledge
N=NVQ - Unit
O=Other
S=Skill
97 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
98 UNIT_TITLE Character(70) VARCHAR2(70) NOT NULL Unit Title
99 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
100 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
101 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
102 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level
103 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency
104 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
105 REVIEWER_APPRVD Character(1) VARCHAR2(1) NOT NULL Reviewer is Approved
106 REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
107 REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status
108 EXP_DT Date(10) DATE Expected Completion Date
109 START_DT Date(10) DATE Start Date
110 COMP_DT Date(10) DATE Completion Date
111 PRESENTED_DT Date(10) DATE Evidence Presented
112 SUBMIT_DT Date(10) DATE Submission Date
113 YR_LAST_USED Number(4,0) SMALLINT NOT NULL Year Last Used
114 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
115 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
116 SATISFIED Character(1) VARCHAR2(1) NOT NULL This is a Yes/No flag to indicate if employee satisfied a certain criterion.
117 EP_MEASURE Long Character CLOB 1325 Character Item measurement description
118 EP_LANG_PROPER_USE Long Character(1325) VARCHAR2(1325) Language checker example of proper usage
119 EP_LANG_INCOR_USE Long Character(1325) VARCHAR2(1325) Language checker example of incorrect usage
120 AREA_OF_STDY_GRADE Character(4) VARCHAR2(4) NOT NULL Area Of Study Grade
121 JPM_ADHOC_DESCR Character(80) VARCHAR2(80) NOT NULL Page Title
122 FT_ALTERNATE_REC Character(50) VARCHAR2(50) NOT NULL Source Record
123 FT_ALTERNATE_KEY Character(254) VARCHAR2(254) NOT NULL Alternate Key
124 EMPLOYER Character(30) VARCHAR2(30) NOT NULL Employer
125 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
126 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
127 FP_SKIL_HIR Character(1) VARCHAR2(1) NOT NULL FPS Hiring Requirement
N=No
Y=Yes
128 FP_SKIL_PRM Character(1) VARCHAR2(1) NOT NULL FPS Promotion Requirement
N=No
Y=Yes
129 FP_SKIL_TEN Character(1) VARCHAR2(1) NOT NULL FPS Tenure Requirement
N=No
Y=Yes
130 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
131 FP_DEGR_REQUIRED Character(1) VARCHAR2(1) NOT NULL FPS Degree
N=No
Y=Yes
132 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
133 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
134 SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type
135 EDUCATION_LVL_ACHV Character(3) VARCHAR2(3) NOT NULL Education Level Achieved
136 COMPLETED Character(1) VARCHAR2(1) NOT NULL Completed
N=No
Y=Yes
137 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
138 JPM_RATING1 Character(1) VARCHAR2(1) NOT NULL Generic rating field generally prompted by RATING_MODEL
139 JPM_YN_2 Character(1) VARCHAR2(1) NOT NULL Generic Yes No property for profile items
N=No
Y=Yes
140 JPM_PCT_1 Number(3,0) SMALLINT NOT NULL generic percentage property
141 JPM_PCT_2 Number(3,0) SMALLINT NOT NULL generic percentage property
142 JPM_MANDATORY Character(1) VARCHAR2(1) NOT NULL jpm
N=No
Y=Yes
143 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.
144 EP_ITEM_CRIT_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if the critical field is available
145 EP_WEIGHT Number(3,0) SMALLINT NOT NULL Weight factor
146 EP_MIN_WEIGHT Number(3,0) SMALLINT NOT NULL Minumum weight used (percentage)
147 EP_ITEM_MANDTRY_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch used to determine if the mandatory field is available