Appendix: Content Type and Profile Type Properties

This appendix provides an overview of properties and discusses:

Click to jump to parent topicUnderstanding Properties

When you set up a content type, you select the properties, or field names, that are shared by items of that type. The system displays the properties that you define for a content type as fields on the Item Details page when you set up content items. These properties will be used to describe the content items when you define them.

After you add content types to profiles to create content sections, you will then add the properties that will be available for viewing or updating when the content item is added to a profile. When users add profile items to the profile, the system displays the properties you define for the content section.

The order in which properties are displayed on the Item Details page or in profiles is determined by the system. The tables in this appendix list the properties in the order that they are displayed.

See Also

Setting Up Content Types and Properties

Defining Content Sections

Click to jump to parent topicContent Type Properties

This table lists the properties (field names) that you can add to a content type in the Content Types component, the order in which the properties are displayed on the Item Details page, the default label text, and the type of information you can track using this property.

Sequence

Property

Default Label Text

Description

1

JPM_CAT_ITEM_ID

Content Item ID

The system populates this field with the item ID.

Note. This is a required property and the system adds it to all new content types.

2

EFFDT

Effective Date

The item's effective date.

Note. This is a required property and the system adds it to all new content types.

3

EFF_STATUS

Status as of Effective Date

The item status as of the effective date.

Note. This is a required property and the system adds it to all new content types.

4

JPM_DESCR90

Description

The item description. It is used as a related display field for the item ID in the profile.

Note. This is a required property and the system adds it to all new content types.

5

DESCRLONG

Long Description

A long description of the content item.

6

DESCRSHORT

Short Description

A short description of the content item.

7

CM_CATEGORY

Category

The category to which an item belongs. An item can belong to one category only.

This property is useful for competency-related content types. However you can also use content groups to group items.

8

JPM_CAT_ITEM_SRC

Content Item Source

Specifies the origin of a content item. Valid values are: Customer Defined, DDI, Lominger, or PDI.

9

RATING_MODEL

Rating Model

The rating model. Use this field if the content type is associated with rating models.

10

COUNTRY

Country

The country in which this item applies.

This property is useful for content types that have country-specific items.

11

EP_SUB_LEVEL

Level

The level of the item. When this row is entered in a content type, the List field appears. Select a list that contains the values you want to use. Lists and valid values are defined on the Custom List Values page. This property is used with sub-competencies.

12

EDUCATION_LVL

Education Level

The education level desired or required for this content item.

13

TYPE_OF_STUDY_GER

Type Of Study

(DEU) A German property that indicates the type of study. Valid values are: Chemistry, Commerce, Constr/Mining, Electronic, Food, Forestry, Glass, Hotels, Mechanic, Other, Printing, Public Sector, and Textiles. This property is used with degrees.

14

FIELD_OF_STUD_GER

Field Of Study

(DEU) A German property that indicates the field of study (Commercial, Industrial, or Technical). This property is used with degrees.

15

FP_DEGREE_LVL

Level

(FRA) The degree level. This field is used for French Public Sector only.

16

HP_STATS_DEG_LVL

Stats-Can Degree Level

(CAN) The Canadian degree level.

17

SATISFACTION_MTHD

Satisfaction Method

Use to specify how an element is achieved. Valid values are: Attend Training Course, Dispensation Given, Off Job Training, On Job Training, Possess License/Certificate, Recognition of Prior Learning, Supervisor Assessment. This property is used with the ELEMENT content type.

18

NVQ_LEVEL

Level

(GBR) The level of an NVQ (1, 2, 3, 4 or 5)

19

JPM_DURATION_1

Duration (1)

A generic duration field to enter the number of days, months, years, or hours. Use the field in conjunction with the Duration Type (1) field, which defines the duration unit.

20

JPM_DURATION_TYPE1

Duration Type (1)

Specifies the units for the Duration (1) field. Select from Days, Months, Years, or Hours.

21

JPM_DURATION_2

Duration (2)

A generic duration field to enter the number of days, months, years, or hours. Use the field in conjunction with the Duration Type (2) field, which defines the duration unit.

22

JPM_DURATION_TYPE2

Duration Type (2)

Specifies the units for the Duration (2) field. Select from Days, Months, Years, or Hours.

23

JPM_YN_1

User Yes/No (1)

A generic Yes/No check box. If the check box is selected, it indicates Yes, and if it is not selected this indicates No.

24

JPM_YN_2

User Yes/No (2)

A generic Yes/No check box.

25

JPM_YN_3

User Yes/No (3)

A generic Yes/No check box.

26

JPM_YN_4

User Yes/No (4)

A generic Yes/No check box.

27

JPM_YN_5

User Yes/No (5)

A generic Yes/No check box.

28

JPM_DATE_1

User Date (1)

A generic date field.

29

JPM_DATE_2

User Date (2)

A generic date field.

30

JPM_TEXT254_1

User Text - 254 Char

A comment field of up to 254 characters.

31

JPM_TEXT254_2

User Text - 254 Char

A comment field of up to 254 characters.

32

JPM_TEXT254_3

User Text - 254 Char

A comment field of up to 254 characters.

33

JPM_TEXT254_4

User Text - 254 Char

A comment field of up to 254 characters.

34

JPM_TEXT1325_1

User Text - 1325 Char

A comment field of up to 1325 characters.

35

JPM_TEXT1325_2

User Text - 1325 Char

A comment field of up to 1325 characters.

Click to jump to parent topicProfile Type Properties

This table lists the properties (field names) that you can add to a content section in the Profile Types component, the order in which the properties are displayed on the profile page, the property attributes, and any special Profile Management processing tied to the property.

Sequence

Content Property

Data Type

Maximum Length

Prompt Value Source

Country Section

Special Processing

1

JPM_CAT_ITEM_ID

Character

12

   

Automatically included in the content section.

2

EFFDT

Date

     

Automatically included in the content section.

If effective dated content is not desired, then it can be removed.

3

EFF_STATUS

Character

1

Translate values A, I

   

4

JPM_JP_ITEM_SRC

Character

4

   

Automatically set by interfacing products. If this field has a value, then the profile item cannot be updated in Profile Management.

5

JPM_CAT_ITEM_QUAL

Character

12

   

User configurable key tied to a qualifier set.

6

JPM_CAT_ITEM_QUAL2

Character

12

   

User configurable key tied to a qualifier set.

7

JPM_ADHOC_DESCR

Character

     

Automatically included for free-form content types.

8

JPM_PERSON_ID_1

Character

11

PERSON_NAME

   

9

EP_APPRAISAL_ID

Number

8

     

10

RATING_MODEL

Character

4

Rating Model table

 

Value automatically defaults from content item definition, then from profile type content section if none exists.

11

JPM_RATING1

Character

1

Rating Model table

   

12

JPM_INTEREST_LEVEL

Character

1

Rating Model INT

   

13

JPM_VERIFY_METHOD

Character

1

Translate values

   

14

BUSINESS_UNIT

Character

5

Business Unit Table

 

PERSON profile validations

15

LOCATION

Character

10

Location Table

 

PERSON profile validations

16

MAJOR_DESCR

Character

100

   

PERSON profile validations

17

COUNTRY

Character

3

Country Table

 

PERSON profile validations

18

STATE

Character

6

State Table

 

PERSON profile validations

19

SCHOOL_TYPE

Character

3

School Type Table

   

20

SCHOOL_CODE

Character

10

School Table

 

PERSON profile validations

21

SCHOOL_DESCR

Character

100

   

PERSON profile validations

22

MAJOR_CODE

Character

10

Major Table

   

23

JPM_MINOR_CD

Character

10

Major Table

   

24

MINOR_DESCR

Character

100

   

PERSON profile validations

25

AVERAGE_GRADE

Character

5

     

26

PRACTIC_GRADE_GER

Character

4

 

DEU

 

27

THEORY_GRADE_GER

Character

4

 

DEU

 

28

IPE_SW

Character

1

Translate values Y/N

DEU

 

29

EDUC_LVL_AUS

Character

1

Highest education achievement translate values

AUS

 

30

APS_HEDUC_CD_AUS

Character

2

Higher education level translate values

AUS

 

31

FACULTY_CODE

Character

10

JPN Faculty Table

JPN

 

32

FACULTY_DESCR

Character

100

 

JPN

PERSON profile validations

33

SUBFACULTY_CODE

Character

10

JPN Sub-Faculty Table

JPN

 

34

SUBFACULTY_DESCR

Character

100

 

JPN

PERSON profile validations

35

MAJOR_CATEGORY

Character

1

Education category translate values

JPN

 

36

GVT_CREDIT_HOURS

Character

3

 

USF

 

37

GVT_CRED_HRS_TYPE

Character

1

Education credit unit translate values

USF

 

38

JPM_RATING2

Character

1

Rating Model table

   

39

JPM_RATING3

Character

1

Rating Model table

   

40

FP_SUBJECT_CD

Character

3

FPS Degree Subject Table

FPS

 

41

FP_SKIL_HIR

Character

1

Translate values Y/N

FPS

 

42

FP_SKIL_PRM

Character

1

Translate values Y/N

FPS

 

43

FP_SKIL_TEN

Character

1

Translate values Y/N

FPS

 

44

FP_DEGR_REQUIRED

Character

1

Translate values Y/N

FPS

 

45

BONUS_AMOUNT_FRA

Number

5.2

 

FRA

 

46

BONUS_DT_FRA

Date

   

FRA

 

47

NVQ_STATUS

Character

1

NVQ Status translate values

   

48

JPM_IMPORTANCE

Character

1

Importance rating level translate values

   

49

JPM_INTEGER_1

Number

8

   

PERSON profile validations

50

JPM_INTEGER_2

Number

8

   

PERSON profile validations

51

JPM_PCT_1

Number

3

     

52

JPM_PCT_2

Number

3

     

53

JPM_DECIMAL_1

Number

7.2

     

54

JPM_DECIMAL_2

Number

7.2

     

55

JPM_MANDATORY

Character

1

Translate values Y/N

   

56

JPM_YN_1

Character

1

Translate values Y/N

 

PERSON profile validations

57

JPM_YN_2

Character

1

Translate values Y/N

   

58

JPM_YN_3

Character

1

Translate values Y/N

   

59

JPM_YN_4

Character

1

Translate values Y/N

   

60

JPM_YN_5

Character

1

Translate values Y/N

   

62

JPM_DATE_2

Date

     

PERSON profile validations

63

JPM_DATE_3

Date

     

PERSON profile validations

64

JPM_DATE_4

Date

       

65

JPM_DATE_5

Date

       

66

JPM_DATE_6

Date

       

67

JPM_TEXT254_1

Character

254

     

68

JPM_TEXT254_2

Character

254

     

69

JPM_TEXT254_3

Character

254

     

70

JPM_TEXT254_4

Character

254

     

71

JPM_TEXT254_5

Character

254

     

72

JPM_TEXT1325_1

Character

1325

   

PERSON profile validations

73

JPM_TEXT1325_2

Character

1325

     

74

SETID_DEPT

Character

5

SetID Table

   

75

DEPTID

Character

10

Department Table

   

76

JPM_OBSTACLE_1

Character

2

Translate values

   

77

JPM_LOC_BUNIT_1

Character

5

Business Unit Table

   

78

JPM_LOCATION_1

Character

10

Location Table

   

79

JPM_LOC_BUNIT_2

Character

5

Business Unit Table

   

80

JPM_LOCATION_2

Character

10

Location Table

   

81

JPM_AREA_PREF_1

Character

2

Geographic Preference Table

   

82

JPM_AREA_PREF_2

Character

2

Geographic Preference Table

   

83

JPM_AREA_PREF_3

Character

2

Geographic Preference Table

   

84

JPM_CNTRY_PREF_1

Character

3

Country Table

   

85

JPM_CNTRY_PREF_2

Character

3

Country Table

   

86

JPM_CNTRY_PREF_3

Character

3

Country Table

   

87

LASTUPDDTTM

DateTime

     

Set by system when profile item is added of updated.

88

LASTUPDOPRID

Character

30

   

Set by system when profile item is added of updated.

89

JPM_SOURCE_ID2

Character

12

   

Contains the syndication source profile ID. This property is always display-only.

90

JPM_WF_STATUS

Character

1

Translate values Approved, Denied, Pending, Saved, New

 

System updates workflow status of a profile item. This property is always display-only.

Click to jump to parent topicProperty Initializations and Validations

The following initialization/validations are delivered to work with the PERSON Profile Type definition. An entry for the profile type exists in the table JPM_PKG_TYPES to specify that the validations in the application class ControllerPerson are active. If these validations are not desired, then the entry for the PERSON profile type can be removed from JPM_PKG_TYPES. When creating a new profile type, these validations will be included if the profile type is cloned from the delivered PERSON profile type and the Copy Validations check box is selected.

Property

Profile

Content Type

Validation/Initialization

JPM_TEXT1325_1

PERSON

Competency

Populated with content item description.

JPM_INTEGER_1

JPM_INTEGER_2

PERSON

Competency

Year Acquired must be earlier than or equal to Year Last Used.

EFFDT

JPM_DATE_3

PERSON

Membership

Honors & Awards

Date issued cannot be greater than end date.

EFFDT

JPM_DATE_3

PERSON

Licenses

Issue Date cannot be greater than Expiration Date.

JPM_DATE_3

JPM_DATE_2

PERSON

Membership

Mandate End Date cannot be greater than Mandate Begin Date.

JPM_YN_1

JPM_INTEGER_2

PERSON

Degrees

Graduate Indicator must not be selected when Year Acquired is in future.

GVT_CRED_HRS_TYPE

GVT_CREDIT_HOURS

PERSON

Degrees

Credit Hours Type is required if Credit Hours are entered

COUNTRY STATE

SCHOOL_CODE

PERSON

Degrees

Education Level

Ensures that country, state, and school code values work together.

COUNTRY

STATE

PERSON

Licenses

Ensures that country, state values work together.

BUSINESS_UNIT

LOCATION

COUNTRY

PERSON

Current Location

Initializes values from primary job.

JPM_YN_1 JPM_DATE_3

PERSON

Licenses

Set the Renewal Required field from the content catalog.

If renewal is required, then set expiration date to date issued plus renewal length.

FACULTY_DESCR

PERSON

Degrees

Populate Faculty description from JPN Faculty Table if code specified.

SUBFACULTY_DESCR

PERSON

Degrees

Populate Sub Faculty description from JPN Faculty Table if code specified.

MAJOR_DESCR

PERSON

Degrees

Populate Major description from Major Table if code specified.

MINOR_DESCR

PERSON

Degrees

Populate Minor description from the Major Table if code specified.

SCHOOL_DESCR

   

Populate SCHOOL_DESCR from School Table if code specified.