Definition of table extracted-item

Describes an 'extracted' item for export , Table Dump Name stat-rit

Alphabetical Field Summary

cre-date: (DATE) Date this record was created

cre-time: (CHAR) Time this record was created

cre-user-name: (CHAR) Name of user who created this record

extern-guid: (CHAR) External Global Unique ID for this record

extracted-item-id: (INTG) Internally assigned ID

extracted-record-seq: (INTG) Internally assigned sequence

item-changed: (LOGC) 'Yes' if item has been changed since the build

item-char: (CHAR) Value of this item, if this item is a character

item-date: (DATE) Value of this item, if this item is a date

item-decimal: (DECM) Value of this item, if this item is a decimal (ten places)

item-integer: (INTG) Value of this item, if this item is an integer

item-logical: (LOGC) Value of this item, if this item is a logical

state-item-id: (INTG) Index Component

state-record-id: (INTG) Index component

state-record-item-id: (INTG) Internally assigned ID

state-report-id: (INTG) Index component

state-report-period-id: (INTG) Report period that this record is associated with

state-table-code-id: (INTG) Table code that this item is associated with, if any

state-table-name-id: (INTG) state table that this item is associated with, if any

state-version-id: (INTG) Internally Assigned ID

upd-date: (DATE) Date this record was last updated on

upd-time: (CHAR) Date this record was last updated

upd-user-name: (CHAR) Name of user who last updated this record

Alphabetical Index Summary

extern-guid: extern-guid

extracted-item: state-report-id, state-report-period-id, state-version-id, state-record-id, state-item-id, extracted-record-seq, extracted-item-id

extracted-record: (UNIQUE, PRIMARY) state-report-id, state-report-period-id, state-version-id, state-record-id, extracted-record-seq, extracted-item-id

record-item: state-version-id, state-record-id, state-item-id, extracted-item-id

state-item: state-version-id, state-item-id, extracted-item-id

state-record-item: state-version-id, state-report-id, state-report-period-id, state-record-id, state-item-id, state-record-item-id, extracted-record-seq, extracted-item-id

state-version: state-version-id, state-report-id, state-report-period-id, state-record-id, state-item-id, extracted-item-id

table-code: state-version-id, state-table-code-id, extracted-item-id

table-name: state-version-id, state-table-name-id, extracted-item-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-sri.p

DELETE: Overridable, Procedure is tr-d-sri.p

WRITE: Overridable, Procedure is tr-u-sri.p

Tables extracted-item references

extracted-record - A record extracted from the database, used to group extracte

state-item - Describes a reportable element

state-record - This table allows us to describe a state-specific reportable

state-record-item - Link between a state-item and a state-record

state-report - This table defines a state specific report.

state-report-period - Describes the intersection of a report and a period in time

state-table-code - State table codes

state-table-name - State table names

state-version - Date versioning

Detailed Alphabetical Field Listing
cre-date Data type: DATE
Format: 99/99/99
Help: Date this record was created

cre-time Data type: CHARACTER
Format: x(8)
Help: Time this record was created

cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record

extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component

extracted-item-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned ID
Attributes: Index Component

extracted-record-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned sequence
Attributes: Index Component

item-changed Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if item has been changed since the build

item-char Data type: CHARACTER
Format: x(28)
Help: Value of this item, if this item is a character

item-date Data type: DATE
Format: 99/99/9999
Help: Value of this item, if this item is a date

item-decimal Data type: DECIMAL (Decimals: 10)
Format: zzzzzzzzz9 (Initial Value: 0)
Help: Value of this item, if this item is a decimal (ten places)

item-integer Data type: INTEGER
Format: zzzzzzzzz9 (Initial Value: 0)
Help: Value of this item, if this item is an integer

item-logical Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Value of this item, if this item is a logical

state-item-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index Component
Help: State item that this record is associated with
Attributes: Index Component

state-record-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index component
Help: Record that this element is associated with
Attributes: Index Component

state-record-item-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned ID
Attributes: Index Component

state-report-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index component
Help: Report that this record is associated with
Attributes: Index Component

state-report-period-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Report period that this record is associated with
Attributes: Index Component

state-table-code-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Table code that this item is associated with, if any
Attributes: Index Component

state-table-name-id Data type: INTEGER
Format: zzzzzzzzz9
Help: state table that this item is associated with, if any
Attributes: Index Component

state-version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned ID
Attributes: Index Component

upd-date Data type: DATE
Format: 99/99/99
Help: Date this record was last updated on

upd-time Data type: CHARACTER
Format: x(8)
Help: Date this record was last updated

upd-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who last updated this record

Created on 11/14/2011 by DBHTML V1.2