Definition of table credential
Credential Table , Table Dump Name credenti

Alphabetical Field Summary

  • cre-date: (DATE) Date of record creation
  • cre-time: (CHAR) Time of record creation
  • cre-user-name: (CHAR) Name of user who created this record
  • credential-id: (INTG) Internally assigned identifier [DEFINE KEY]
  • credential-name: (CHAR) Name of this credential
  • credential-path: (INTG) Path number of this credential
  • default-credential: (LOGC) Is this the default credential?
  • description: (CHAR) Description of this credential
  • district-grade-order-high: (INTG) Disrict grade order high
  • district-grade-order-low: (INTG) Low district grade order
  • fed-field: (CHAR) (no description available)
  • other-field: (CHAR) (no description available)
  • school-year-id: (INTG) Internally Assigned Identifier
  • state-field: (CHAR) (no description available)
  • upd-date: (DATE) Date this record was last updated
  • upd-time: (CHAR) Time at which this record was last updated
  • upd-user-name: (CHAR) Name of user who last updated this record
  • update-seq: (INTG) Sequence to gate all updates through

    Alphabetical Index Summary

  • cred-by-name: school-year-id, credential-id, credential-name
  • cred-by-path: school-year-id, credential-id, credential-path
  • credential: (UNIQUE, PRIMARY) school-year-id, credential-id

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-cre.p (SOURCE NOT AVAILABLE)
  • DELETE: Overridable, Procedure is tr-d-cre.p (SOURCE NOT AVAILABLE)
  • REPLICATION-CREATE: Procedure is rp-c-cre.p (SOURCE NOT AVAILABLE)
  • REPLICATION-DELETE: Procedure is rp-d-cre.p (SOURCE NOT AVAILABLE)
  • REPLICATION-WRITE: Procedure is rp-u-cre.p (SOURCE NOT AVAILABLE)
  • WRITE: Overridable, Procedure is tr-u-cre.p (SOURCE NOT AVAILABLE)

    Other tables who reference credential

  • credential-area - (no description available)
  • credential-area-course - (no description available)
  • credential-area-study -
  • credential-assessment - (no description available)
  • credential-outcome - (no description available)
  • credential-standard -
  • stu-credential - (no description available)
  • stu-credential-area - (no description available)
  • stu-credential-assessment - (no description available)
  • stu-credential-outcome - (no description available)
  • stu-credential-standard - (no description available)
  • stu-credential-year - (no description available)

    Tables credential references

  • school-year - School year file

    Detailed Alphabetical Field Listing
    cre-date Data type: DATE
    Format: 99/99/9999
    Description: Date of record creation

    cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time of record creation

    cre-user-name Data type: CHARACTER
    Format: x(8)
    Description: Name of user who created this record

    credential-id Data type: INTEGER
    Format: 999999999
    Description: Internally assigned identifier [DEFINE KEY]
    Attributes: Index Component

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

    credential-path Data type: INTEGER
    Format: z9 (Initial Value: 0)
    Description: Path number of this credential
    Help: Path number of this credential
    Attributes: Index Component

    default-credential Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Is this the default credential?
    Help: Is this the default credential?

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

    district-grade-order-high Data type: INTEGER
    Format: 99 (Initial Value: 0)
    Description: Disrict grade order high
    Help: Highest grade that this credential should be considered for

    district-grade-order-low Data type: INTEGER
    Format: 99
    Description: Low district grade order
    Help: Lowest grade that this credential should be considered for

    fed-field Data type: CHARACTER
    Format: x(16)

    other-field Data type: CHARACTER
    Format: x(16)

    school-year-id Data type: INTEGER
    Format: 999999999
    Description: Internally Assigned Identifier
    Attributes: Index Component

    state-field Data type: CHARACTER
    Format: x(16)

    upd-date Data type: DATE
    Format: 99/99/9999
    Description: Date this record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Time at which this record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(8)
    Description: Name of user who last updated this record

    update-seq Data type: INTEGER
    Format: 999999999999
    Description: Sequence to gate all updates through
    Help: Internally assigned identifier

    Created on 05/07/2012 by DBHTML V1.2