Definition of table credential-assessment
No table description available , Table Dump Name cred-ass

Alphabetical Field Summary

  • assessment-mnemonic: (CHAR) Assessment code
  • assessment-name: (CHAR) Name of this assessment
  • assessment-order: (INTG) Assessment order
  • assessment-strands: (CHAR) Assessment Strand Information
  • assessment-threshold: (DECM) Assessment Threshold
  • assessment-weight: (DECM) Weight of this assessment
  • 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-area-id: (INTG) Credential Area this assessment belongs to
  • credential-assessment-id: (INTG) Internally assigned identifier [DEFINE KEY]
  • credential-id: (INTG) Credential this assessment belongs to
  • fed-field: (CHAR) (no description available)
  • other-field: (CHAR) (no description available)
  • possible-points: (DECM) Maximum possible points for this credential assessment
  • require-details: (LOGC) Require details for this assessment when average is below th
  • 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

    Alphabetical Index Summary

  • assessment-by-name: school-year-id, credential-id, credential-area-id, assessment-name
  • assessment-by-order: school-year-id, credential-id, credential-area-id, assessment-order
  • credential-assessment: (UNIQUE, PRIMARY) school-year-id, credential-id, credential-area-id, credential-assessment-id

    Alphabetical Trigger Summary

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

    Other tables who reference credential-assessment

  • credential-outcome - (no description available)
  • stu-credential-assessment - (no description available)
  • stu-credential-outcome - (no description available)

    Tables credential-assessment references

  • credential - Credential Table
  • credential-area - (no description available)
  • school-year - School year file

    Detailed Alphabetical Field Listing
    assessment-mnemonic Data type: CHARACTER
    Format: x(8)
    Description: Assessment code
    Help: Mnemonic (short name) for this assessment

    assessment-name Data type: CHARACTER
    Format: x(16)
    Help: Name of this assessment
    Attributes: Index Component

    assessment-order Data type: INTEGER
    Format: 999 (Initial Value: 0)
    Description: Assessment order
    Help: Order for this assessment
    Attributes: Index Component

    assessment-strands Data type: CHARACTER
    Format: x(255)
    Description: Assessment Strand Information
    Help: Strands for this assessment

    assessment-threshold Data type: DECIMAL (Decimals: 2)
    Format: 99.99 (Initial Value: 0)
    Description: Assessment Threshold
    Help: Threshold for this assessment

    assessment-weight Data type: DECIMAL (Decimals: 2)
    Format: 9.99 (Initial Value: 1.00)
    Help: Weight of this assessment

    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-area-id Data type: INTEGER
    Format: 999999999999
    Description: Credential Area this assessment belongs to
    Attributes: Index Component

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

    credential-id Data type: INTEGER
    Format: 999999999
    Description: Credential this assessment belongs to
    Attributes: Index Component

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

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

    possible-points Data type: DECIMAL (Decimals: 2)
    Format: zzz,zz9
    Description: Maximum possible points for this credential assessment

    require-details Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Require details for this assessment when average is below th
    Help: Require grid cells when student average is below threshold

    school-year-id Data type: INTEGER
    Format: 999999999
    Description: Internally Assigned Identifier
    Help: School Year this assessments is associated with
    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

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