Definition of table spm-prof
SPM Profile/Base record. Only 1 per system! , Table Dump Name spm-prof

Alphabetical Field Summary

  • addr-validation-style: (CHAR) (no description available)
  • batch-gpa-enabled[7]: (LOGC) Yes if batch GPA calcs should occur on this day
  • batch-letter-enabled[7]: (LOGC) Yes if batch letter calculations should be done on this day
  • batch-scan-enabled[7]: (LOGC) Yes if batch scanner maintenance should occur on this day
  • batch-tran-enabled[7]: (LOGC) Yes if batch transcript calculations are done on this day
  • contact-flag-label[10]: (CHAR) Label for contact flags
  • 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
  • district-code: (CHAR) State assigned district code
  • district-type: (CHAR) Enter the district type
  • drop-email: (CHAR) Email to send drop notifications
  • enable-hrs: (LOGC) Enable personnel links to HRS (HRS must be installed)
  • enroll-email: (CHAR) Email address to send for enrollments
  • extern-guid: (CHAR) External Global Unique ID for this record
  • lock-during-schd: (LOGC) Yes to only allow one person at a time to schedule
  • primary-key: (INTG) Unique, Primary key for record
  • reporting-district-num: (CHAR) Enter the umbrella District
  • stu-id-len: (INTG) Length of the student ID field
  • system-student-ids: (LOGC) Yes to disallow users from editting student IDs
  • upcase-addr: (LOGC) Yes to automatically set all address to upper-case
  • upcase-names: (LOGC) Yes to cause all names to automatically converted to upper c
  • 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
  • use-behave-incidents: (LOGC) Yes to enable using behavior incident #s
  • use-carrier-route: (LOGC) Yes to validate addresses via carrier route, No to disable
  • use-ssn-as-id: (LOGC) Yes if student ID is also student SSN
  • user-course-format[10]: (CHAR) Enter the format for the field
  • user-course-label[10]: (CHAR) Enter the text for the fields label
  • user-course-table-name-id[10]: (INTG) Internally Assigned Id
  • user-course-type[10]: (CHAR) Enter the type of field you want to create
  • user-personnel-format-1: (CHAR) Format for user defined field
  • user-personnel-format-2: (CHAR) Format for user defined field
  • user-personnel-format-3: (CHAR) Format for user defined field
  • user-personnel-label-1: (CHAR) user defined field 2 label for personnel maint
  • user-personnel-label-2: (CHAR) user defined field 2 label for personnel maint
  • user-personnel-label-3: (CHAR) user defined field 3 label for personnel maint
  • user-personnel-table-name-id-1: (INTG) User defined field table name id
  • user-personnel-table-name-id-2: (INTG) User defined field table name id
  • user-personnel-table-name-id-3: (INTG) User defined field table name id
  • user-personnel-type-1: (CHAR) User defined field 1 for the personnel maint
  • user-personnel-type-2: (CHAR) User defined field 1 for the personnel maint
  • user-personnel-type-3: (CHAR) User defined field 1 for the personnel maint
  • web-motd: (CHAR) Message of the day, if any, for display via web

    Alphabetical Index Summary

  • spm-prof: (UNIQUE, PRIMARY) primary-key

    Alphabetical Trigger Summary

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

    Other tables who reference spm-prof

  • atnd-calendar-day - Building Attendance calendar
  • atnd-calendar-group - Attendance calendar group
  • atnd-class - Attendance Code Classes
  • atnd-class-link - Links between the attendance codes and class files
  • atnd-code - Attendance Code definitions
  • atnd-eligibility - Attendance Eligibility Codes
  • atnd-letter - One entry per attendance letter
  • atnd-letter-mailing - One record per selected mailing class for this letter
  • atnd-letter-relation - Attendance letter relationships. There is an entry for any l
  • behave-action - Behaviour Actions
  • behave-class - Behaviour class codes allow various behave-codes to be colle
  • behave-class-link - This file is used to link each behave-class to it's associat
  • behave-code - Behviour Codes
  • behave-follow-up - (no description available)
  • behave-incident - Behavior Incidents, if the distict is tracking them
  • behave-location - (no description available)
  • behave-variance - Table to describe variances between official and actual days
  • behave-victim - (no description available)
  • building - One record for each building, for each scheduling version, f
  • counseling-code - (no description available)
  • course-catalog - Course Catalog
  • course-group - Course Groups
  • course-group-alternate - Alternate course for a course group
  • course-level - Course Level header file. This has little content and mostly
  • course-stats - Course Request statistics
  • course-study-area - Course Study Area
  • credential-area-course - (no description available)
  • credential-area-study -
  • daily-atnd-post-log - Log file of postings on a date/room basis
  • department - Department Classifications
  • distance-learning - Distance learning codes
  • email-info - (no description available)
  • form-bldg - Form definitions, on a per building level
  • grad-requirement-name - Graduation Requirements Names
  • grad-requirement-study - Graduation Requirement Study Area Controls
  • grade-catalog - Grades Catalog
  • grading-comment - Grading Comments. These are comments that teachers can assig
  • grading-mark - List of possible marks (not grades) for this building
  • grading-period - Grading period file holds a list of grading periods for a gi
  • grading-period-honor - Honor rolls enabled for a given grading period
  • grading-period-mark - List of marks enabled for this grading period
  • grading-setup - Grading setup controls building level setup/policy issues wi
  • honor-roll - Honor roll setup/defitions
  • honor-roll-comment - Comment codes required or forbidden from this honor roll
  • honor-roll-exclude - Honor rolls you can't already have if you want to get this o
  • honor-roll-grade - List of required or forbidden grades for this honor roll
  • honor-roll-group - List of course gourps that are required or forbidden from th
  • house - Houses for buildings
  • imported-item -
  • instruction-setting - Instruction settings for students and courses
  • interleave-code - Scheduler Interleave codes
  • master-schd - Master Schedule records One entry per course, per section fo
  • master-schd-conflict - One entry per master schd record that conflicts with a cours
  • master-schd-meets - Course meets entry. There may be many of these for each c
  • master-schd-post-log - Log file of postings on a per-section basis
  • master-schd-stats - Master Schedule Statistics
  • period-catalog - Period Name catalog
  • personnel - Schools District personnel
  • personnel-bldg - Personnel/Building Linkage file
  • personnel-class - Personnel CLassifications (teacher, vice-principle, etc)
  • population-served - Population served by a course
  • progress-comment - Progress Report Comments
  • progress-period - Progress reporting periods
  • role-code - The role code associated with a course
  • room-catalog - Rooms catalog, within a building
  • scan-form-dataset - Scan form datasets. Many forms are simple and only have one
  • scan-form-line - Scan Form Line info
  • scan-form-sheet - Scan Form Sheets
  • schd-group - Scheduling Group
  • schd-period - These define the minimum period a course can be scheduled fo
  • schd-status - Student Schedule Status Code
  • schd-version - Master Schedule Versions
  • status-code - Student Status Codes
  • stu-assign - (no description available)
  • stu-assign-totals - (no description available)
  • stu-atnd-letter - One entry per letter a student receives
  • stu-atnd-letter-event - Events that comprise a student attendance letter
  • stu-atnd-letter-item - This has one entry for each 'item' that appears on a letter.
  • stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records
  • stu-counseling - (no description available)
  • stu-grade-comment - Student Grade comments
  • stu-grade-mark - One entry for each mark a student received for the associate
  • stu-history - Student Activity History
  • stu-makeup-event - (no description available)
  • stu-makeup-summary - (no description available)
  • stu-rank-gpa - Ranking and GPA data for a grading-period for a student
  • stu-rank-gpa-by-mark - Ranking and GPA by period mark
  • stu-request-master - Student Request Master Controls
  • stu-site - Site Specific Student data file
  • stu-transcript-mark - Student transcript marks
  • 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
  • study-area - Study Areas for courses
  • test-record-layout - (no description available)
  • transcript-grade - List of grades/buildings that are considered for transcripts
  • user-access - User Access/Permissions file
  • user-bldg - User Restricted to building list
  • user-department - User Department Level Restrictions
  • user-grade - User Grade level restriction
  • user-personnel - User Personnel level restrictions

    Tables spm-prof references

  • email-info - (no description available)

    Detailed Alphabetical Field Listing
    addr-validation-style Data type: CHARACTER
    Format: x(16)

    batch-gpa-enabled Data type: LOGICAL (Extent: 7)
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if batch GPA calcs should occur on this day

    batch-letter-enabled Data type: LOGICAL (Extent: 7)
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if batch letter calculations should be done on this day

    batch-scan-enabled Data type: LOGICAL (Extent: 7)
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if batch scanner maintenance should occur on this day

    batch-tran-enabled Data type: LOGICAL (Extent: 7)
    Format: Yes/No (Initial Value: Yes)
    Help: Yes if batch transcript calculations are done on this day

    contact-flag-label Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Label for contact flags

    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

    district-code Data type: CHARACTER
    Format: x(8)
    Help: State assigned district code

    district-type Data type: CHARACTER
    Format: x(8)
    Help: Enter the district type

    drop-email Data type: CHARACTER
    Format: x(128)
    Help: Email to send drop notifications

    enable-hrs Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Enable personnel links to HRS (HRS must be installed)

    enroll-email Data type: CHARACTER
    Format: x(128)
    Help: Email address to send for enrollments

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

    lock-during-schd Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to only allow one person at a time to schedule

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

    reporting-district-num Data type: CHARACTER
    Format: x(16)
    Help: Enter the umbrella District

    stu-id-len Data type: INTEGER
    Format: z9 (Initial Value: 6)
    Help: Length of the student ID field

    system-student-ids Data type: LOGICAL
    Format: Yes/No (Initial Value: N)
    Help: Yes to disallow users from editting student IDs

    upcase-addr Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to automatically set all address to upper-case

    upcase-names Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to cause all names to automatically converted to upper c

    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

    use-behave-incidents Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes to enable using behavior incident #s

    use-carrier-route Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Yes to validate addresses via carrier route, No to disable

    use-ssn-as-id Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if student ID is also student SSN

    user-course-format Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Enter the format for the field

    user-course-label Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Enter the text for the fields label

    user-course-table-name-id Data type: INTEGER (Extent: 10)
    Format: zzzzzzzzzzz9
    Description: Internally Assigned Id

    user-course-type Data type: CHARACTER (Extent: 10)
    Format: x(8)
    Help: Enter the type of field you want to create

    user-personnel-format-1 Data type: CHARACTER
    Format: x(16)
    Description: Format for user defined field
    Help: Enter the format for the field when it is on the screen

    user-personnel-format-2 Data type: CHARACTER
    Format: x(16)
    Description: Format for user defined field
    Help: Enter the format for the field when it is on the screen

    user-personnel-format-3 Data type: CHARACTER
    Format: x(16)
    Description: Format for user defined field
    Help: Enter the format for the field when it is on the screen

    user-personnel-label-1 Data type: CHARACTER
    Format: x(16)
    Description: user defined field 2 label for personnel maint
    Help: Enter the label you would like to appear for this field

    user-personnel-label-2 Data type: CHARACTER
    Format: x(16)
    Description: user defined field 2 label for personnel maint
    Help: Enter the label you would like to appear for this field

    user-personnel-label-3 Data type: CHARACTER
    Format: x(16)
    Description: user defined field 3 label for personnel maint
    Help: Enter the label you would like to appear for this field

    user-personnel-table-name-id-1 Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: User defined field table name id

    user-personnel-table-name-id-2 Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: User defined field table name id

    user-personnel-table-name-id-3 Data type: INTEGER
    Format: zzzzzzzzzzz9
    Description: User defined field table name id

    user-personnel-type-1 Data type: CHARACTER
    Format: x(9)
    Description: User defined field 1 for the personnel maint
    Help: Enter the type of field you want to create

    user-personnel-type-2 Data type: CHARACTER
    Format: x(9)
    Description: User defined field 1 for the personnel maint
    Help: Enter the type of field you want to create

    user-personnel-type-3 Data type: CHARACTER
    Format: x(9)
    Description: User defined field 1 for the personnel maint
    Help: Enter the type of field you want to create

    web-motd Data type: CHARACTER
    Format: x(50)
    Help: Message of the day, if any, for display via web

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