Definition of table state-table-name

State table names , Table Dump Name stat-tbn

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

description: (CHAR) Description of this table

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

level-format[10]: (CHAR) Format for this table level

level-label[10]: (CHAR) Label to use for this level

level-width[10]: (INTG) On screen widht for this table level (1 to 32)

state-table-name-id: (INTG) Internally assigned table name ID

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

table-format: (CHAR) Format of this table's codes

table-levels: (INTG) Number of additional levels for the table

table-name: (CHAR) Name of this table

table-width: (INTG) Width of table codes for this table

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

state-table-name: (UNIQUE, PRIMARY) state-version-id, state-table-name-id

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

Alphabetical Trigger Summary

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

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

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

Other tables who reference state-table-name

extracted-item - Describes an 'extracted' item for export

state-item - Describes a reportable element

state-table-code - State table codes

Tables state-table-name references

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

description Data type: CHARACTER
Format: x(28)
Help: Description of this table

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

level-format Data type: CHARACTER (Extent: 10)
Format: x(16) (Initial Value: x(32))
Help: Format for this table level

level-label Data type: CHARACTER (Extent: 10)
Format: x(28)
Help: Label to use for this level

level-width Data type: INTEGER (Extent: 10)
Format: z9 (Initial Value: 32)
Help: On screen widht for this table level (1 to 32)

state-table-name-id Data type: INTEGER
Format: zzzzzzzzz9
Help: Internally assigned table name ID
Attributes: Index Component

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

table-format Data type: CHARACTER
Format: x(20) (Initial Value: x(8))
Help: Format of this table's codes

table-levels Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Number of additional levels for the table

table-name Data type: CHARACTER
Format: x(8)
Help: Name of this table
Attributes: Index Component

table-width Data type: INTEGER
Format: z9 (Initial Value: 8)
Help: Width of table codes for this table

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