Populating the Drop-Down Rowset

The drop-down rowset defines the content for drop-down list boxes and defines the menu structure as well as the content for drop-down menus.

Populate the drop-down ID field (PTDESCRn_DD_ID using a display template, or PTDESCRn_DROPDOWN_ID if not using a display template) on the node record with a unique identifier, such as EMPL.

Populate the drop-down data rowset according to these rules:

• Each list item in the menu is either a folder or a menu item.

  Assign a unique value in PTORGDRPLSTITM_ID for each item.

• Populate PTNODE LISTDESCR with a label for each item.

• Folders have children.

• Menu items have no children.

• Determine the parent for each item. This is the group ID.

  Set PTORGDRPLS_ GRP_ID to the parent ID, PTORG DRPLSTITM_ID.

• Top-level list items have no parent. Set the group ID to blank.

• Drop-down list box items have no parent. Set the group ID to blank.

• Determine the display order of each list item within its group.

For example, suppose you want to create a drop-down menu with the following structure:

Level 1	Level 2	Level 3
Talent	Teamwork
	Planning
Compensation	Objectives	Objective A
		Objective B
	Performance	Self Appraisal
		Peer Appraisal
Time
Absence

For this example, the drop-down data rowset contains these rows:

PTDESCR_ DRP DWN_ID	PTORG DRPLST ITM_ID	PTORG DRPLS_ GRP_ID	PTND_ DISPLAY_ ORDER	PTNODE LISTDESCR
EMPL	TALENT		1	Talent
EMPL	COMP		2	Competency
EMPL	TIME		3	Time
EMPL	ABS		4	Absence
EMPL	TEAM	TALENT	1	Teamwork
EMPL	PLAN	TALENT	2	Planning
EMPL	OBJ	COMP	1	Objectives
EMPL	PERF	COMP	2	Performance
EMPL	OBJA	OBJ	1	Objective A
EMPL	OBJB	OBJ	2	Objective B
EMPL	SELF	PERF	1	Self Appraisal
EMPL	PEER	PERF	2	Peer Appraisal