Definition of table state-report-record

State Report Records , Table Dump Name state-rr

Alphabetical Field Summary

build-ip-name: (CHAR) Builder IP for this record, if not default

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

default-build-state: (LOGC) Yes to build record by default, no to supress build by defau

export-ip-name: (CHAR) Export IP for this record, if not default

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

state-record-id: (INTG) Index component

state-record-order: (INTG) Enter the order you would like this record to the state

state-report-id: (INTG) Index component

state-report-period-id: (INTG) Internally assigned report period ID

state-report-record-id: (INTG) Internally assigned report-record-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

state-record-order: state-report-id, state-report-period-id, state-record-order, state-report-record-id

state-report-record: (UNIQUE, PRIMARY) state-report-id, state-report-period-id, state-record-id, state-report-record-id

Alphabetical Trigger Summary

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

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

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

Tables state-report-record references

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

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

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

Detailed Alphabetical Field Listing
build-ip-name Data type: CHARACTER
Format: x(32)
Help: Builder IP for this record, if not default

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

default-build-state Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to build record by default, no to supress build by defau

export-ip-name Data type: CHARACTER
Format: x(32)
Help: Export IP for this record, if not default

extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
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-order Data type: INTEGER
Format: zz9 (Initial Value: 1)
Help: Enter the order you would like this record to the state
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
Description: Internally assigned report period ID
Attributes: Index Component

state-report-record-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned report-record-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