Definition of table credential-area
No table description available , Table Dump Name cre-area

Alphabetical Field Summary

  • area-mnemonic: (CHAR) Area Mnemonic
  • area-name: (CHAR) Name of this credential area
  • area-order: (INTG) Order of this area
  • area-required: (LOGC) Is this credential area required?
  • 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) Internally assigned identifier [DEFINE KEY]
  • credential-id: (INTG) Credential this area belongs to
  • credential-style: (CHAR) Holistic, Simple, Points
  • credential-threshold: (DECM) Passing percentage for this credential area
  • description: (CHAR) Description of this credential area
  • fed-field: (CHAR) (no description available)
  • holistic-high: (DECM) Highest mark on a holistic scale
  • holistic-low: (DECM) Lowest mark on a holistic scale
  • holistic-threshold: (DECM) Threshold for a holistic scale
  • other-field: (CHAR) (no description available)
  • perennial-area: (LOGC) Is this a perennial or an annual area?
  • require-details: (LOGC) Require details when average is below threshold
  • school-year-id: (INTG) Internally Assigned Identifier
  • simple-format: (CHAR) Format for simple credentials
  • state-field: (CHAR) (no description available)
  • summarized-as: (CHAR) The heading into which this area will be "rolled up" for vie
  • 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

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

    Alphabetical Trigger Summary

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

    Other tables who reference credential-area

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

    Tables credential-area references

  • credential - Credential Table
  • school-year - School year file

    Detailed Alphabetical Field Listing
    area-mnemonic Data type: CHARACTER
    Format: x(8)
    Description: Area Mnemonic
    Help: Mnemonic for this credential area (short name)

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

    area-order Data type: INTEGER
    Format: 999 (Initial Value: 0)
    Description: Order of this area
    Help: Order this area should be displayed in
    Attributes: Index Component

    area-required Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this credential area required?
    Help: Is this credential area a requiered area?

    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: Internally assigned identifier [DEFINE KEY]
    Attributes: Index Component

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

    credential-style Data type: CHARACTER
    Format: x(8) (Initial Value: Points)
    Description: Holistic, Simple, Points
    Help: Style of this credential area (Holistic,Simple,Points)

    credential-threshold Data type: DECIMAL (Decimals: 2)
    Format: 99.99
    Description: Passing percentage for this credential area
    Help: Passing percentage for this credential area

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

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

    holistic-high Data type: DECIMAL (Decimals: 2)
    Format: 99.99 (Initial Value: 0)
    Help: Highest mark on a holistic scale

    holistic-low Data type: DECIMAL (Decimals: 2)
    Format: 99.99 (Initial Value: 0)
    Help: Lowest mark on a holistic scale

    holistic-threshold Data type: DECIMAL (Decimals: 2)
    Format: 99.99 (Initial Value: 0)
    Description: Threshold for a holistic scale
    Help: Where on the holistic scale does "credentialed" begin?

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

    perennial-area Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Description: Is this a perennial or an annual area?
    Help: Should this area be used across multiple school years?

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

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

    simple-format Data type: CHARACTER
    Format: x(16)
    Description: Format for simple credentials
    Help: Display format for simple credentials (Pass/Fail, Yes/No, 1/

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

    summarized-as Data type: CHARACTER
    Format: x(16)
    Description: The heading into which this area will be "rolled up" for vie

    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