Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

PLAN_ELEMENTS

Col #Column NameData TypeField LengthNull?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

DESCRIPTION

VARCHAR2

120

Y

  
3

SUB_NUMBER

VARCHAR2

20

Y

  
4

PARENT_ID

NUMBER

22

Y

  
5

DAY_CHARGE_ID

NUMBER

22

Y

  
6

ELEMENT_TYPE_ID

NUMBER

22

Y

  
7

FULL_NUMBER

VARCHAR2

50

Y

  
8

FEE_CYCLE_ID

NUMBER

22

Y

  
9

FINANCE_CODE

NUMBER

22

Y

  
10

FEE_CODE

VARCHAR2

120

Y

  
11

RATING_METHOD

VARCHAR2

400

Y

  
12

FEE_PROFILE_TYPE_ID

NUMBER

22

Y

  
13

RATING_METHOD_PROFILE_TYPE_ID

NUMBER22Y With 9.9 - Support for rating method profile type
Column
width33%

...