Definition of table grad-study-requirement
Graduation Study Requirement , Table Dump Name grd-sreq

Alphabetical Field Summary

  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created
  • cre-user-name: (CHAR) Name of user who created the record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • grad-requirement-id: (INTG) Graduation Requirement ID
  • grad-study-requirement-id: (INTG) [DEFINE KEY]
  • max-credit: (DECM) Maximum credit to meet this requirement
  • min-credit: (DECM) Minimum Credit to meet this requirement
  • parent-grad-requirement-item-id: (INTG) Parent Item of this Requirement Item, if any
  • prefered-child: (LOGC) Yes if this is a child and "prefered" in a child selection t
  • requirement-order: (INTG) Order of this requirement amongst its siblings
  • school-year-id: (INTG) School year for this record
  • study-area-id: (INTG) Study Area ID of this definition
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Record last updated at
  • upd-user-name: (CHAR) Name of user record was updated by

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • grad-study-requirement-id: (UNIQUE, PRIMARY) school-year-id, grad-requirement-id, grad-study-requirement-id
  • requirement-by-order: school-year-id, grad-requirement-id, parent-grad-requirement-item-id, requirement-order, grad-study-requirement-id
  • requirement-by-study-area: school-year-id, grad-requirement-id, study-area-id, grad-study-requirement-id

    Alphabetical Trigger Summary

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

    Tables grad-study-requirement references

  • course-study-area - Course Study Area
  • credential-area-study -
  • grad-requirement-name - Graduation Requirements Names
  • grad-requirement-study - Graduation Requirement Study Area Controls
  • school-year - School year file
  • study-area - Study Areas for courses

    Detailed Alphabetical Field Listing
    cre-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Description: Time record was created

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

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

    grad-requirement-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Graduation Requirement ID
    Attributes: Index Component

    grad-study-requirement-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: [DEFINE KEY]
    Help: Graduation Study Requirement ID
    Attributes: Index Component

    max-credit Data type: DECIMAL (Decimals: 3)
    Format: zzzz9.999 (Initial Value: 0)
    Help: Maximum credit to meet this requirement

    min-credit Data type: DECIMAL (Decimals: 3)
    Format: zzzzz9.999 (Initial Value: 0)
    Help: Minimum Credit to meet this requirement

    parent-grad-requirement-item-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Parent Item of this Requirement Item, if any
    Attributes: Index Component

    prefered-child Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if this is a child and "prefered" in a child selection t

    requirement-order Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Help: Order of this requirement amongst its siblings
    Attributes: Index Component

    school-year-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: School year for this record
    Attributes: Index Component

    study-area-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Study Area ID of this definition
    Attributes: Index Component

    upd-date Data type: DATE
    Format: 99/99/9999 (Initial Value: TODAY)
    Description: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Description: Record last updated at

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Description: Name of user record was updated by

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