Definition of table state-report-period

Describes the intersection of a report and a period in time , Table Dump Name stat-rpp

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

expiration-date: (DATE) Date after which this data can be purged (optional)

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

fiscal-year: (CHAR) Start year of fiscal year (i.e. 1992 for FY 1992/1993)

pay-id: (INTG) Payroll Identifier

payroll-year: (INTG) Payroll Year associated with this report period

period-end-date: (DATE) Enter an end date for the period

period-start-date: (DATE) Enter the start date for the period

report-built-at: (CHAR) Time this report was built

report-built-by: (CHAR) Name of user who built this report

report-built-on: (DATE) Date this report was built on

report-exported-at: (CHAR) Time this report was exported at

report-exported-by: (CHAR) Name of user who exported this report

report-exported-on: (DATE) Date this report was exported on

report-period-date: (DATE) Date of this report period

report-period-description: (CHAR) Description of this report period

report-period-frozen-at: (CHAR) Time this report period was frozen

report-period-frozen-by: (CHAR) Name of user who froze this period

report-period-frozen-on: (DATE) Date this report period was frozen

school-year-id: (INTG) Internally Assigned ID

state-report-id: (INTG) Index component

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

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

user-value[5]: (CHAR) User Defined Field

Alphabetical Index Summary

description: state-report-id, report-period-description, state-report-period-id

extern-guid: extern-guid

period-date: state-report-id, report-period-date, state-report-period-id

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

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

Alphabetical Trigger Summary

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

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

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

Other tables who reference state-report-period

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

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

state-report-record - State Report Records

Tables state-report-period references

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

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

expiration-date Data type: DATE
Format: 99/99/9999
Help: Date after which this data can be purged (optional)

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

fiscal-year Data type: CHARACTER
Format: 9999
Description: Start year of fiscal year (i.e. 1992 for FY 1992/1993)

pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payroll Identifier

payroll-year Data type: INTEGER
Format: 9999
Description: Payroll Year associated with this report period

period-end-date Data type: DATE
Format: 99/99/9999
Help: Enter an end date for the period

period-start-date Data type: DATE
Format: 99/99/9999
Help: Enter the start date for the period

report-built-at Data type: CHARACTER
Format: x(8)
Help: Time this report was built

report-built-by Data type: CHARACTER
Format: x(16)
Help: Name of user who built this report

report-built-on Data type: DATE
Format: 99/99/9999
Help: Date this report was built on

report-exported-at Data type: CHARACTER
Format: x(8)
Help: Time this report was exported at

report-exported-by Data type: CHARACTER
Format: x(16)
Help: Name of user who exported this report

report-exported-on Data type: DATE
Format: 99/99/9999
Help: Date this report was exported on

report-period-date Data type: DATE
Format: 99/99/9999
Help: Date of this report period
Attributes: Index Component

report-period-description Data type: CHARACTER
Format: x(60)
Help: Description of this report period
Attributes: Index Component

report-period-frozen-at Data type: CHARACTER
Format: x(8)
Help: Time this report period was frozen

report-period-frozen-by Data type: CHARACTER
Format: x(16)
Help: Name of user who froze this period

report-period-frozen-on Data type: DATE
Format: 99/99/9999
Help: Date this report period was frozen

school-year-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally Assigned ID

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

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-value Data type: CHARACTER (Extent: 5)
Format: x(8)
Description: User Defined Field
Help: Enter the value for this field

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