Definition of table stu-edp-course
No table description available , Table Dump Name stedpcrs

Alphabetical Field Summary

  • completed: (LOGC) Has this course been completed?
  • course-desc: (CHAR) Description of this course
  • course-id: (INTG) SPM Course ID
  • 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
  • grade-id: (INTG) Internally Assigned Identifier
  • section-id: (INTG) SPM section-id
  • stu-edp-course-seq: (INTG) Internally Assigned Identifier [DEFINE KEY]
  • stu-edp-seq: (INTG) Internally Assigned Identifier
  • stu-seq: (INTG) Internally assigned identifier
  • 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

  • stu-edp-course: (UNIQUE, PRIMARY) stu-seq, stu-edp-seq, grade-id, stu-edp-course-seq

    Alphabetical Trigger Summary

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

    Tables stu-edp-course references

  • course-catalog - Course Catalog
  • course-stats - Course Request statistics
  • credential-area-course - (no description available)
  • grade-catalog - Grades Catalog
  • master-schd - Master Schedule records One entry per course, per section fo
  • master-schd-display - This is a transient table used for master schedule display s
  • promotion-path-grade - Promotion Grade/Bldg list for promotion paths
  • stu-assign - (no description available)
  • stu-base - Student Base record
  • stu-edp - (no description available)
  • stu-request-master - Student Request Master Controls
  • stu-transcript-year - Student Transcript Year record. One per student, per transcr
  • stu-year - One record for each year a student exists in the district
  • transcript-grade - List of grades/buildings that are considered for transcripts
  • user-grade - User Grade level restriction

    Detailed Alphabetical Field Listing
    completed Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Has this course been completed?

    course-desc Data type: CHARACTER
    Format: x(28)
    Help: Description of this course

    course-id Data type: INTEGER
    Format: 999999999999
    Description: SPM Course ID
    Help: Course ID of the course that fills this requirement

    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

    grade-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned Identifier
    Help: Grade this EDP course is associated with
    Attributes: Index Component

    section-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: SPM section-id
    Help: Section ID of the section that fills this requirement

    stu-edp-course-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned Identifier [DEFINE KEY]
    Attributes: Index Component

    stu-edp-seq Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned Identifier
    Help: Student EDP this course is associated with
    Attributes: Index Component

    stu-seq Data type: INTEGER
    Format: 999999999999
    Description: Internally assigned identifier
    Help: Student this edp course is associated with
    Attributes: Index Component

    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