CM_DRILL_MAP

(SQL Table)
Index Back

Cost Management Drilldown tbl

GMG CN# CM750-8.0 Drilldown; Metadata used for drilldown paths.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
2 FROM_PANELNAME Character(18) VARCHAR2(18) NOT NULL From Panel Name
3 CM_DRILL_ACTION Character(3) VARCHAR2(3) NOT NULL Cost Management Drill Action
DDN=Drill Down
DET=More Detail
DUN=Drill Up; Non Posted
DUP=Drill Up
EXP=Expand Transaction Entries
4 TO_PANELNAME Character(18) VARCHAR2(18) NOT NULL To Panel Name
5 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
6 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
7 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
8 KEYCOUNT Number(3,0) SMALLINT NOT NULL Number of Keys
9 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
10 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
11 KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
12 KEY4 Character(65) VARCHAR2(65) NOT NULL Fourth Key
13 KEY5 Character(65) VARCHAR2(65) NOT NULL Fifth Key
14 KEY6 Character(65) VARCHAR2(65) NOT NULL Sixth Key
15 KEY7 Character(65) VARCHAR2(65) NOT NULL Seventh Key
16 KEY8 Character(65) VARCHAR2(65) NOT NULL Eighth Key
17 KEY9 Character(65) VARCHAR2(65) NOT NULL Ninth Key
18 KEY10 Character(65) VARCHAR2(65) NOT NULL Tenth Key
19 KEY11 Character(65) VARCHAR2(65) NOT NULL Eleventh Key
20 KEY12 Character(65) VARCHAR2(65) NOT NULL Twelfth Key
21 KEY13 Character(65) VARCHAR2(65) NOT NULL Thirteenth Key
22 KEY14 Character(65) VARCHAR2(65) NOT NULL Fourteenth Key
23 KEY15 Character(65) VARCHAR2(65) NOT NULL Fifteenth Key
24 KEY16 Character(50) VARCHAR2(50) NOT NULL Sixteenth Key