Definition of table room-catalog
Rooms catalog, within a building , Table Dump Name room-cat

Alphabetical Field Summary

  • bldg-id: (INTG) Building ID for this room
  • comments: (CHAR) Comments for/about this room
  • confirm-conflict: (LOGC) Yes to be asked about room conflict, No to silently allow
  • 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
  • dept-id: (INTG) Primary department resposible for this room
  • description: (CHAR) Description of this room
  • extern-guid: (CHAR) External Global Unique ID for this record
  • home-room: (LOGC) Is this room used as a home room?
  • include-attend: (LOGC) Is this room included in daily attendance?
  • include-room-availability: (LOGC) Should this room appear on the room availability report?
  • include-room-conflict: (LOGC) Include room on room conflicts report?
  • include-room-schedule: (LOGC) Should this room appear on the room schedule report?
  • max-capacity: (INTG) Maximum number of seats permitted/wanted in this room
  • personnel-id: (INTG) Personnel ID of the person assigned to this room
  • population-served-id: (INTG) Population Served ID
  • preferred-capacity: (INTG) Preferred number of seats allowed in this room
  • primary-key: (INTG) Unique, Primary key for record
  • role-code-id: (INTG) Internally Assigned Id
  • room-id: (INTG) [DEFINE KEY]
  • room-name: (CHAR) Room # or name
  • school-year-id: (INTG) School year for this record
  • state-course-code-id: (INTG) Internally Assigned ID
  • 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

  • description: school-year-id, bldg-id, description
  • extern-guid: extern-guid
  • personnel-id: school-year-id, bldg-id, personnel-id, room-id
  • room-id: (UNIQUE, PRIMARY) school-year-id, bldg-id, room-id
  • room-name: school-year-id, bldg-id, room-name

    Alphabetical Trigger Summary

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

    Other tables who reference room-catalog

  • daily-atnd-post-log - Log file of postings on a date/room basis
  • master-schd-meets - Course meets entry. There may be many of these for each c
  • stu-history - Student Activity History
  • stu-year - One record for each year a student exists in the district

    Tables room-catalog references

  • building - One record for each building, for each scheduling version, f
  • department - Department Classifications
  • email-info - (no description available)
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • personnel - Schools District personnel
  • population-served - Population served by a course
  • role-code - The role code associated with a course
  • school-year - School year file
  • spm-prof - SPM Profile/Base record. Only 1 per system!
  • state-course-code - State Course Codes
  • user-bldg - User Restricted to building list
  • user-department - User Department Level Restrictions
  • user-personnel - User Personnel level restrictions

    Detailed Alphabetical Field Listing
    bldg-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Building ID for this room
    Attributes: Index Component

    comments Data type: CHARACTER
    Format: x(68)
    Help: Comments for/about this room

    confirm-conflict Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to be asked about room conflict, No to silently allow

    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

    dept-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Primary department resposible for this room

    description Data type: CHARACTER
    Format: x(28)
    Help: Description of this room
    Attributes: Index Component

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

    home-room Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is this room used as a home room?

    include-attend Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Is this room included in daily attendance?

    include-room-availability Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Should this room appear on the room availability report?

    include-room-conflict Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Include room on room conflicts report?

    include-room-schedule Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Should this room appear on the room schedule report?

    max-capacity Data type: INTEGER
    Format: zzz9 (Initial Value: 0)
    Help: Maximum number of seats permitted/wanted in this room

    personnel-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Personnel ID of the person assigned to this room
    Attributes: Index Component

    population-served-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Help: Population Served ID

    preferred-capacity Data type: INTEGER
    Format: zzz9 (Initial Value: 0)
    Help: Preferred number of seats allowed in this room

    primary-key Data type: INTEGER
    Format: zzzzzzzzzzzz
    Help: Unique, Primary key for record

    role-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned Id

    room-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: [DEFINE KEY]
    Help: Internally assigned room ID
    Attributes: Index Component

    room-name Data type: CHARACTER
    Format: x(6)
    Help: Room # or name
    Attributes: Index Component

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

    state-course-code-id Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: Internally Assigned ID

    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