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.

FT_PM_ST2_AET

(SQL Table)

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

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

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 Practical Grade

33 THEORY_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Theoretical Grade

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

38 GVT_CREDIT_HOURS Character(3) VARCHAR2(3) NOT NULL Credit Hours

39 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

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 NVQ Status
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement

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 Subject

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
A=Advanced
B=Basic
I=Intermediate

70 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 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) User Text - 1325 Char

91 JPM_TEXT254_1 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char

92 JPM_TEXT254_2 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char

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(1325) VARCHAR2(1325) 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
CGRP=Catalog Group
ELM=Learning Management
EP=ePerformance
PROF=Another Profile

127 FP_SKIL_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Requirements
N=No
Y=Yes

128 FP_SKIL_PRM Character(1) VARCHAR2(1) NOT NULL Promotion Requirements
N=No
Y=Yes

129 FP_SKIL_TEN Character(1) VARCHAR2(1) NOT NULL Tenure Requirements
N=No
Y=Yes

130 JPM_IMPORTANCE Character(1) VARCHAR2(1) NOT NULL Relative Importance
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 Required ?
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

137 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

138 JPM_RATING1 Character(1) VARCHAR2(1) NOT NULL Rating 1

139 JPM_YN_2 Character(1) VARCHAR2(1) NOT NULL User Yes/No (2)
N=No
Y=Yes

140 JPM_PCT_1 Number(3,0) SMALLINT NOT NULL User Percent (1)

141 JPM_PCT_2 Number(3,0) SMALLINT NOT NULL User Percent (2)

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

#	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
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
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	Practical Grade
33	THEORY_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Theoretical Grade
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
38	GVT_CREDIT_HOURS	Character(3)	VARCHAR2(3) NOT NULL	Credit Hours
39	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
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	NVQ Status A=Achieved C=Cancelled E=Enrolled P=Previous Achievement
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	Subject
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 A=Advanced B=Basic I=Intermediate
70	EP_DESCR254	Long Character(1325)	VARCHAR2(1325)	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)	User Text - 1325 Char
91	JPM_TEXT254_1	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
92	JPM_TEXT254_2	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
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(1325)	VARCHAR2(1325)	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 CGRP=Catalog Group ELM=Learning Management EP=ePerformance PROF=Another Profile
127	FP_SKIL_HIR	Character(1)	VARCHAR2(1) NOT NULL	Hiring Requirements N=No Y=Yes
128	FP_SKIL_PRM	Character(1)	VARCHAR2(1) NOT NULL	Promotion Requirements N=No Y=Yes
129	FP_SKIL_TEN	Character(1)	VARCHAR2(1) NOT NULL	Tenure Requirements N=No Y=Yes
130	JPM_IMPORTANCE	Character(1)	VARCHAR2(1) NOT NULL	Relative Importance 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	Required ? 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
137	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
138	JPM_RATING1	Character(1)	VARCHAR2(1) NOT NULL	Rating 1
139	JPM_YN_2	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (2) N=No Y=Yes
140	JPM_PCT_1	Number(3,0)	SMALLINT NOT NULL	User Percent (1)
141	JPM_PCT_2	Number(3,0)	SMALLINT NOT NULL	User Percent (2)
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