Definition of table state-report

This table defines a state specific report. , Table Dump Name stat-rpt

Alphabetical Field Summary

comments: (CHAR) Comments for/about this entry

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

editor-proc-list: (CHAR) Enter a list of the procedures to edit the records.

export-delimiter: (CHAR) Character that should be treated as the delimiter

export-format: (CHAR) can be FIXED, DELIMITED, etc

export-proc-list: (CHAR) Enter a list of procedures to be used for export.

export-system-format: (CHAR) How should we handle line/page breaks?

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

fas-build-proc-list: (CHAR) Plugin for custom/state-specific build procedures

filler-char: (INTG) Enter the ASCII code of the filler character for this report

hrs-build-proc-list: (CHAR) Plugin for custom/state-specific build procedures

quote-data-flag: (LOGC) Yes if exported data should be quoted

quote-end-char: (INTG) Enter the ASCII value for the closing quote character.

quote-start-char: (INTG) Enter the ASCII value for the starting quotation character.

report-proc-list: (CHAR) Enter a list of procedures to be used for report creation.

report-type: (CHAR) Type of report (SRSD, REP, etc)

spm-build-proc-list: (CHAR) Plugin for custrom/state-specific SPM build procedures

state-report-id: (INTG) Index component

state-report-name: (CHAR) Name of this report

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

user-configurable-build-list: (LOGC) 'Yes' if user has option to configure records to build

user-value-label[5]: (CHAR) Enter the label for the user value

Alphabetical Index Summary

extern-guid: extern-guid

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

state-report-name: state-report-name

Alphabetical Trigger Summary

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

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

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

Other tables who reference state-report

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

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

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

state-report-record - State Report Records

Detailed Alphabetical Field Listing
comments Data type: CHARACTER
Format: x(60)
Help: Comments for/about this entry

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

editor-proc-list Data type: CHARACTER
Format: x(40)
Help: Enter a list of the procedures to edit the records.

export-delimiter Data type: CHARACTER
Format: x(1) (Initial Value: ,)
Description: Character that should be treated as the delimiter
Help: For delimited reports, what is the delimiter

export-format Data type: CHARACTER
Format: x(10) (Initial Value: DELIMITED)
Description: can be FIXED, DELIMITED, etc
Help: How should this report be formatted

export-proc-list Data type: CHARACTER
Format: x(40)
Help: Enter a list of procedures to be used for export.

export-system-format Data type: CHARACTER
Format: x(8)
Description: How should we handle line/page breaks?
Help: 'DOS' to force dos style page/line breaks

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

fas-build-proc-list Data type: CHARACTER
Format: x(40)
Description: Plugin for custom/state-specific build procedures
Help: Enter a list of names of the procedures to build FAS data

filler-char Data type: INTEGER
Format: zz9 (Initial Value: 32)
Help: Enter the ASCII code of the filler character for this report

hrs-build-proc-list Data type: CHARACTER
Format: x(40)
Description: Plugin for custom/state-specific build procedures
Help: Enter a list of the procedures to build HRS data.

quote-data-flag Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if exported data should be quoted

quote-end-char Data type: INTEGER
Format: zz9 (Initial Value: 34)
Help: Enter the ASCII value for the closing quote character.

quote-start-char Data type: INTEGER
Format: zz9 (Initial Value: 34)
Help: Enter the ASCII value for the starting quotation character.

report-proc-list Data type: CHARACTER
Format: x(40)
Help: Enter a list of procedures to be used for report creation.

report-type Data type: CHARACTER
Format: x(8)
Help: Type of report (SRSD, REP, etc)

spm-build-proc-list Data type: CHARACTER
Format: x(40)
Description: Plugin for custrom/state-specific SPM build procedures
Help: Enter a list of names of the procedures to build SPM data

state-report-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index component
Help: Internally assigned state report id
Attributes: Index Component

state-report-name Data type: CHARACTER
Format: x(16)
Description: Name of this report
Help: Enter the name of the state report
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

user-configurable-build-list Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: 'Yes' if user has option to configure records to build

user-value-label Data type: CHARACTER (Extent: 5)
Format: x(8)
Help: Enter the label for the user value

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