1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

BUS_GOAL

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the business goal

6

SEQ

2

SMALLINT

Sequence within business goal. Use ORDER_BY_SEQ to return business goals in the same order as specified in the toolset.

7

AMOUNT

4

INTEGER

Goal amount.

8

PRIORITY

4

INTEGER

Priority

The possible range is 0 (Low) to 9 (High)

9

TARGET_DATE

4

INTEGER

Target date of goal.

The format is YYYYMMDD

10

UNIT_OF_
MEASURE

32

VARCHAR

Goal amount, unit of measure

11

PARENT_GOAL_ID

4

INTEGER

ID of the parent business goal.

Join with BUS_GOAL.

Zero for root business goal (will be used in future release).