Definition of table extracted-record

A record extracted from the database, used to group extracted items , Table Dump Name ext-recd

Alphabetical Field Summary

acct-num: (CHAR) Account number this record is associated with.

builder-tag: (CHAR) A way to identify this record

built-by-builder: (LOGC) Yes if built by builder, no for manual build.

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

emp-seq: (INTG) Employee sequence link for employee related items (HRS)

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

extracted-record-comment: (CHAR) Extract Comments

extracted-record-num: (INTG) Extracted record number

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

item-source: (CHAR) Database item originates from ("FAS", "SPM", "HRS", etc.)

record-purgable: (LOGC) Can instances of this record be purged after build

record-type: (CHAR) Internal Ordering Use ONLY

state-record-id: (INTG) Index component

state-report-id: (INTG) Index component

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

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

stu-seq: (INTG) Student sequence for student related items (SPM)

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

comments-type: state-version-id, state-report-id, state-report-period-id, comments, record-type

extern-guid: extern-guid

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

record-tag: state-version-id, state-report-id, state-report-period-id, state-record-id, builder-tag

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

report-tag: state-report-id, state-report-period-id, state-version-id, builder-tag

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

type-comments: state-version-id, state-report-id, state-report-period-id, record-type, comments

version-tag: state-version-id, state-report-id, state-report-period-id, builder-tag

Alphabetical Trigger Summary

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

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

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

Other tables who reference extracted-record

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

Tables extracted-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

state-version - Date versioning

Detailed Alphabetical Field Listing
acct-num Data type: CHARACTER
Format: x(30)
Description: Account number this record is associated with.

builder-tag Data type: CHARACTER
Format: x(8)
Help: A way to identify this record
Attributes: Index Component

built-by-builder Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Description: Yes if built by builder, no for manual build.

comments Data type: CHARACTER
Format: x(60)
Help: Comments for/about this entry
Attributes: Index Component

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

emp-seq Data type: INTEGER
Format: zzzzzzzzz9 (Initial Value: 0)
Help: Employee sequence link for employee related items (HRS)

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

extracted-record-comment Data type: CHARACTER
Format: x(68)
Description: Extract Comments

extracted-record-num Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: 0)
Description: Extracted record number

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

item-source Data type: CHARACTER
Format: x(8)
Help: Database item originates from ("FAS", "SPM", "HRS", etc.)

record-purgable Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Can instances of this record be purged after build

record-type Data type: CHARACTER
Format: x(16)
Help: Internal Ordering Use ONLY
Attributes: Index Component

state-record-id Data type: INTEGER
Format: zzzzzzzzz9
Description: Index component
Help: Internally assigned state record 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
Description: Internally assigned report period ID
Attributes: Index Component

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

stu-seq Data type: INTEGER
Format: zzzzzzzzz9 (Initial Value: 0)
Help: Student sequence for student related items (SPM)

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