JPM_ITM_ASOF_VW (SQL View)	Index Back
Catalog Items - Talent Mgmt Defines all of the Catalog Items for a particular Catalog Type

JPM_ITM_ASOF_VW

(SQL View)

Catalog Items - Talent Mgmt

Defines all of the Catalog Items for a particular Catalog Type

SELECT I.JPM_PROFILE_ID , I.JPM_CAT_TYPE , I.JPM_CAT_ITEM_ID , I.JPM_ITEM_KEY_ID , I.EFFDT , I.EFF_STATUS , I.JPM_JP_ITEM_SRC , I.JPM_SOURCE_ID1 , I.JPM_SOURCE_ID2 , I.JPM_SOURCE_ID3 , I.JPM_JP_QUAL_SET , I.JPM_JP_QUAL_SET2 , I.JPM_PARENT_KEY_ID , I.JPM_WF_STATUS , %subrec(JPM_ITM_PRP_SBR, I) FROM PS_JPM_JP_ITEMS I WHERE (I.JPM_CAT_ITEM_QUAL = ( SELECT MAX(Q.JPM_CAT_ITEM_QUAL) FROM PS_JPM_JP_ITEMS I1 , PS_JPM_JP_QUAL_INS Q WHERE I1.JPM_PROFILE_ID = I.JPM_PROFILE_ID AND I1.JPM_CAT_TYPE = I.JPM_CAT_TYPE AND I1.JPM_CAT_ITEM_ID = I.JPM_CAT_ITEM_ID AND I1.JPM_ADHOC_DESCR = I.JPM_ADHOC_DESCR AND Q.JPM_CAT_TYPE = I.JPM_CAT_TYPE AND Q.JPM_JP_QUAL_SET = I.JPM_JP_QUAL_SET AND Q.JPM_CAT_ITEM_QUAL = I1.JPM_CAT_ITEM_QUAL AND Q.SEQNO = ( SELECT MIN(Q2.SEQNO) FROM PS_JPM_JP_ITEMS I2 , PS_JPM_JP_QUAL_INS Q2 WHERE I2.JPM_PROFILE_ID = I.JPM_PROFILE_ID AND I2.JPM_CAT_TYPE = I.JPM_CAT_TYPE AND I2.JPM_CAT_ITEM_ID = I.JPM_CAT_ITEM_ID AND I2.JPM_ADHOC_DESCR = I.JPM_ADHOC_DESCR AND Q2.JPM_CAT_TYPE = I.JPM_CAT_TYPE AND Q2.JPM_JP_QUAL_SET = I.JPM_JP_QUAL_SET AND Q2.JPM_CAT_ITEM_QUAL = I2.JPM_CAT_ITEM_QUAL)) OR I.JPM_CAT_ITEM_QUAL = ' ') AND I.JPM_ITEM_KEY_ID = ( SELECT MAX(I4.JPM_ITEM_KEY_ID) FROM PS_JPM_JP_ITEMS I4 WHERE I4.JPM_PROFILE_ID = I.JPM_PROFILE_ID AND I4.JPM_CAT_TYPE = I.JPM_CAT_TYPE AND I4.JPM_CAT_ITEM_ID = I.JPM_CAT_ITEM_ID AND I4.JPM_ADHOC_DESCR = I.JPM_ADHOC_DESCR AND I4.JPM_CAT_ITEM_QUAL = I.JPM_CAT_ITEM_QUAL AND I4.EFFDT = I.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 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

3 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

4 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.

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %Date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

7 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

8 JPM_SOURCE_ID1 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID1

9 JPM_SOURCE_ID2 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID3

10 JPM_SOURCE_ID3 Character(12) VARCHAR2(12) NOT NULL JPM Profile Item Source ID3

11 JPM_JP_QUAL_SET Character(12) VARCHAR2(12) NOT NULL 1st Instance Qualifier Set Name for a JPM Profile Item

12 JPM_JP_QUAL_SET2 Character(12) VARCHAR2(12) NOT NULL 2nd Instance Qualifier Set Name for a JPM Profile Item

13 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.

14 JPM_WF_STATUS Character(2) VARCHAR2(2) NOT NULL JPM Workflow Status field
A=Approved
D=Denied
N=New
P=Pending
S=Saved
Default Value: N

15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

16 JPM_DATE_1 Date(10) DATE User Date (1)

17 JPM_DATE_2 Date(10) DATE User Date (2)

18 JPM_EVAL_MTHD Character(4) VARCHAR2(4) NOT NULL Evaluation Method

19 JPM_TEXT1325_1 Long Character(1325) VARCHAR2(1325) User Text - 1325 Char

20 JPM_TEXT1325_2 Long Character(1325) VARCHAR2(1325) User Text - 1325 Char

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

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

23 JPM_TEXT254_3 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char

24 JPM_TEXT254_4 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char

25 JPM_YN_1 Character(1) VARCHAR2(1) NOT NULL User Yes/No (1)
N=No
Y=Yes
Y/N Table Edit
Default Value: N

26 JPM_YN_2 Character(1) VARCHAR2(1) NOT NULL User Yes/No (2)
N=No
Y=Yes
Y/N Table Edit
Default Value: N

27 JPM_YN_3 Character(1) VARCHAR2(1) NOT NULL User Yes/No (3)
N=No
Y=Yes
Y/N Table Edit
Default Value: N

28 JPM_YN_4 Character(1) VARCHAR2(1) NOT NULL User Yes/No (4)
N=No
Y=Yes
Y/N Table Edit
Default Value: N

29 JPM_YN_5 Character(1) VARCHAR2(1) NOT NULL User Yes/No (5)
N=No
Y=Yes
Y/N Table Edit
Default Value: N

30 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
Prompt Table: RATING_MDL_TBL

31 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

32 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

33 JPM_INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level
Prompt Table: INT_RATING_VW

34 JPM_MANDATORY Character(1) VARCHAR2(1) NOT NULL jpm
N=No
Y=Yes
Y/N Table Edit
Default Value: N

35 JPM_MINOR_CD Character(10) VARCHAR2(10) NOT NULL Minor Code
Prompt Table: JPM_MAJOR_VW

36 JPM_RATING1 Character(1) VARCHAR2(1) NOT NULL Rating 1
Prompt Table: REVW_RATING_TBL

37 JPM_RATING2 Character(1) VARCHAR2(1) NOT NULL Rating 2
Prompt Table: JPM_RATING_VW1

38 JPM_RATING3 Character(1) VARCHAR2(1) NOT NULL Rating 3
Prompt Table: JPM_RATING_VW2

39 JPM_TEXT254_5 Character(254) VARCHAR2(254) NOT NULL User Text - 254 Char

40 JPM_DATE_3 Date(10) DATE User Date (3)

41 JPM_DATE_4 Date(10) DATE User Date (4)

42 JPM_DATE_5 Date(10) DATE User Date (5)

43 JPM_DATE_6 Date(10) DATE User Date (6)

44 JPM_INTEGER_1 Number(8,0) INTEGER NOT NULL User Integer (1)

45 JPM_INTEGER_2 Number(8,0) INTEGER NOT NULL User Integer (2)

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

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

48 JPM_DECIMAL_1 Number(10,2) DECIMAL(9,2) NOT NULL User Decimal (1)

49 JPM_DECIMAL_2 Number(10,2) DECIMAL(9,2) NOT NULL User Decimal (2)

50 JPM_PERSON_ID_1 Character(11) VARCHAR2(11) NOT NULL Person ID (1)
Prompt Table: PERSON_NAME

51 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

52 JPM_VERIFY_METHOD Character(1) VARCHAR2(1) NOT NULL How Verified
E=Employee Claim
J=On the Job Training
N=Not Verified
O=Employer Observation
T=By Test
V=NVQ Authority

53 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: HCR_STONLY_I

54 NVQ_STATUS Character(1) VARCHAR2(1) NOT NULL NVQ Status
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement

55 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code
Prompt Table: JPM_SCHOOL_TBL

56 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
Prompt Table: MAJOR_TBL

57 AVERAGE_GRADE Character(5) VARCHAR2(5) NOT NULL Average Grade

58 PRACTIC_GRADE_GER Character(4) VARCHAR2(4) NOT NULL Practical Grade

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

60 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern. Professional Education
Y/N Table Edit
Default Value: N

61 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID

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

63 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

64 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

65 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

66 FACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Faculty Code (Japan HR)
Prompt Table: FACULTY_TBL_JPN

67 SUBFACULTY_CODE Character(10) VARCHAR2(10) NOT NULL Sub Faculty Code(Japan HR)
Prompt Table: SBFCLTY_TBL_JPN

68 MAJOR_CATEGORY Character(1) VARCHAR2(1) NOT NULL Major Category(Japan HR)
H=Humanities
S=Sciences

69 FP_SUBJECT_CD Character(3) VARCHAR2(3) NOT NULL Subject
Prompt Table: FPMSUBJECTS

70 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID

71 SCHOOL_TYPE Character(3) VARCHAR2(3) NOT NULL School Type
Prompt Table: SCHOOL_TYPE_TBL

72 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

73 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

74 JPM_ADHOC_DESCR Character(80) VARCHAR2(80) NOT NULL Page Title

75 FP_SKIL_HIR Character(1) VARCHAR2(1) NOT NULL Hiring Requirements
N=No
Y=Yes
Y/N Table Edit
Default Value: N

76 FP_SKIL_PRM Character(1) VARCHAR2(1) NOT NULL Promotion Requirements
N=No
Y=Yes
Y/N Table Edit
Default Value: N

77 FP_SKIL_TEN Character(1) VARCHAR2(1) NOT NULL Tenure Requirements
N=No
Y=Yes
Y/N Table Edit
Default Value: N

78 FP_DEGR_REQUIRED Character(1) VARCHAR2(1) NOT NULL Required ?
N=No
Y=Yes
Y/N Table Edit
Default Value: N

79 BONUS_AMOUNT_FRA Number(8,2) DECIMAL(7,2) NOT NULL Bonus

80 BONUS_DT_FRA Date(10) DATE Bonus Date

81 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

82 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	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
3	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
4	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.
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
6	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
7	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
8	JPM_SOURCE_ID1	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID1
9	JPM_SOURCE_ID2	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID3
10	JPM_SOURCE_ID3	Character(12)	VARCHAR2(12) NOT NULL	JPM Profile Item Source ID3
11	JPM_JP_QUAL_SET	Character(12)	VARCHAR2(12) NOT NULL	1st Instance Qualifier Set Name for a JPM Profile Item
12	JPM_JP_QUAL_SET2	Character(12)	VARCHAR2(12) NOT NULL	2nd Instance Qualifier Set Name for a JPM Profile Item
13	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.
14	JPM_WF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	JPM Workflow Status field A=Approved D=Denied N=New P=Pending S=Saved Default Value: N
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
16	JPM_DATE_1	Date(10)	DATE	User Date (1)
17	JPM_DATE_2	Date(10)	DATE	User Date (2)
18	JPM_EVAL_MTHD	Character(4)	VARCHAR2(4) NOT NULL	Evaluation Method
19	JPM_TEXT1325_1	Long Character(1325)	VARCHAR2(1325)	User Text - 1325 Char
20	JPM_TEXT1325_2	Long Character(1325)	VARCHAR2(1325)	User Text - 1325 Char
21	JPM_TEXT254_1	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
22	JPM_TEXT254_2	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
23	JPM_TEXT254_3	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
24	JPM_TEXT254_4	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
25	JPM_YN_1	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (1) N=No Y=Yes Y/N Table Edit Default Value: N
26	JPM_YN_2	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (2) N=No Y=Yes Y/N Table Edit Default Value: N
27	JPM_YN_3	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (3) N=No Y=Yes Y/N Table Edit Default Value: N
28	JPM_YN_4	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (4) N=No Y=Yes Y/N Table Edit Default Value: N
29	JPM_YN_5	Character(1)	VARCHAR2(1) NOT NULL	User Yes/No (5) N=No Y=Yes Y/N Table Edit Default Value: N
30	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	Rating Model Prompt Table: RATING_MDL_TBL
31	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
32	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
33	JPM_INTEREST_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Interest Level Prompt Table: INT_RATING_VW
34	JPM_MANDATORY	Character(1)	VARCHAR2(1) NOT NULL	jpm N=No Y=Yes Y/N Table Edit Default Value: N
35	JPM_MINOR_CD	Character(10)	VARCHAR2(10) NOT NULL	Minor Code Prompt Table: JPM_MAJOR_VW
36	JPM_RATING1	Character(1)	VARCHAR2(1) NOT NULL	Rating 1 Prompt Table: REVW_RATING_TBL
37	JPM_RATING2	Character(1)	VARCHAR2(1) NOT NULL	Rating 2 Prompt Table: JPM_RATING_VW1
38	JPM_RATING3	Character(1)	VARCHAR2(1) NOT NULL	Rating 3 Prompt Table: JPM_RATING_VW2
39	JPM_TEXT254_5	Character(254)	VARCHAR2(254) NOT NULL	User Text - 254 Char
40	JPM_DATE_3	Date(10)	DATE	User Date (3)
41	JPM_DATE_4	Date(10)	DATE	User Date (4)
42	JPM_DATE_5	Date(10)	DATE	User Date (5)
43	JPM_DATE_6	Date(10)	DATE	User Date (6)
44	JPM_INTEGER_1	Number(8,0)	INTEGER NOT NULL	User Integer (1)
45	JPM_INTEGER_2	Number(8,0)	INTEGER NOT NULL	User Integer (2)
46	JPM_PCT_1	Number(3,0)	SMALLINT NOT NULL	User Percent (1)
47	JPM_PCT_2	Number(3,0)	SMALLINT NOT NULL	User Percent (2)
48	JPM_DECIMAL_1	Number(10,2)	DECIMAL(9,2) NOT NULL	User Decimal (1)
49	JPM_DECIMAL_2	Number(10,2)	DECIMAL(9,2) NOT NULL	User Decimal (2)
50	JPM_PERSON_ID_1	Character(11)	VARCHAR2(11) NOT NULL	Person ID (1) Prompt Table: PERSON_NAME
51	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
52	JPM_VERIFY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	How Verified E=Employee Claim J=On the Job Training N=Not Verified O=Employer Observation T=By Test V=NVQ Authority
53	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: HCR_STONLY_I
54	NVQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	NVQ Status A=Achieved C=Cancelled E=Enrolled P=Previous Achievement
55	SCHOOL_CODE	Character(10)	VARCHAR2(10) NOT NULL	School Code Prompt Table: JPM_SCHOOL_TBL
56	MAJOR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Major Code Prompt Table: MAJOR_TBL
57	AVERAGE_GRADE	Character(5)	VARCHAR2(5) NOT NULL	Average Grade
58	PRACTIC_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Practical Grade
59	THEORY_GRADE_GER	Character(4)	VARCHAR2(4) NOT NULL	Theoretical Grade
60	IPE_SW	Character(1)	VARCHAR2(1) NOT NULL	Intern. Professional Education Y/N Table Edit Default Value: N
61	EVALUATION_ID	Character(2)	VARCHAR2(2) NOT NULL	Evaluation ID
62	GVT_CREDIT_HOURS	Character(3)	VARCHAR2(3) NOT NULL	Credit Hours
63	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
64	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
65	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
66	FACULTY_CODE	Character(10)	VARCHAR2(10) NOT NULL	Faculty Code (Japan HR) Prompt Table: FACULTY_TBL_JPN
67	SUBFACULTY_CODE	Character(10)	VARCHAR2(10) NOT NULL	Sub Faculty Code(Japan HR) Prompt Table: SBFCLTY_TBL_JPN
68	MAJOR_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Major Category(Japan HR) H=Humanities S=Sciences
69	FP_SUBJECT_CD	Character(3)	VARCHAR2(3) NOT NULL	Subject Prompt Table: FPMSUBJECTS
70	EP_APPRAISAL_ID	Number(8,0)	INTEGER NOT NULL	Document ID
71	SCHOOL_TYPE	Character(3)	VARCHAR2(3) NOT NULL	School Type Prompt Table: SCHOOL_TYPE_TBL
72	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
73	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
74	JPM_ADHOC_DESCR	Character(80)	VARCHAR2(80) NOT NULL	Page Title
75	FP_SKIL_HIR	Character(1)	VARCHAR2(1) NOT NULL	Hiring Requirements N=No Y=Yes Y/N Table Edit Default Value: N
76	FP_SKIL_PRM	Character(1)	VARCHAR2(1) NOT NULL	Promotion Requirements N=No Y=Yes Y/N Table Edit Default Value: N
77	FP_SKIL_TEN	Character(1)	VARCHAR2(1) NOT NULL	Tenure Requirements N=No Y=Yes Y/N Table Edit Default Value: N
78	FP_DEGR_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required ? N=No Y=Yes Y/N Table Edit Default Value: N
79	BONUS_AMOUNT_FRA	Number(8,2)	DECIMAL(7,2) NOT NULL	Bonus
80	BONUS_DT_FRA	Date(10)	DATE	Bonus Date
81	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
82	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.