Table: SETLOCALAREATNI

SETLOCALAREATNI

Name

SETLOCALAREATNI

Comment

SETLOCALAREATNI shows the list of TNIs constituent to a local area in a settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

LOCALAREAID

SETTLEMENTDATE

SETTLEMENTRUNNO

TNI


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement date of the settlement run

SETTLEMENTRUNNO

NUMBER(3,0)

X

Settlement run number of the settlement run

LOCALAREAID

VARCHAR2(30)

X

Unique identifier for the local area

TNI

VARCHAR2(30)

X

Unique identifier for a TNI constituent to the local area as at the settlement run

LASTCHANGED

DATE

 

Last changed date time for the record