Definition of table schd-status

Student Schedule Status Code , Table Dump Name schd-sts

Alphabetical Field Summary

atnd-drop-action: (CHAR) How should attendance be handled?

audit-flag: (LOGC) Does this schedule status code represent an audit of this cl

award-credit: (LOGC) Should the course have credit awarded?

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

description: (CHAR) Description of the schedule status code

dropped: (LOGC) Yes if the student is no longer attending the class

extern-guid: (CHAR) External Global Unique ID for this record

include-attend: (LOGC) Yes if course should be considered for attendance

include-gpa: (LOGC) Yes if course should be included in GPA calculations

include-honor: (LOGC) Yes if this course should be considered for honor rolls

include-progress: (LOGC) Yes if this course should appear on student progress reports

include-rank: (LOGC) Yes if course should be considered when ranking students

include-report-card: (LOGC) Yes if this course should appear on students report cards

primary-key: (INTG) Unique, Primary key for record

progress-drop-action: (CHAR) How should progress reports be handled?

report-card-drop-action: (CHAR) How should report cards be handled ?

schd-status-code: (CHAR) Name of this schedule status code

schd-status-id: (INTG) [DEFINE KEY]

school-year-id: (INTG) School year ID associated with this record

tested-out-flag: (LOGC) Does this schedule status indicate the student has tested ou

transcript-drop-action: (CHAR) How should transcripts be handled ?

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, description, schd-status-id

extern-guid: extern-guid

schd-status-code: school-year-id, schd-status-code

schd-status-id: (UNIQUE, PRIMARY) school-year-id, schd-status-id

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-scs.p (SOURCE NOT AVAILABLE)

DELETE: Overridable, Procedure is tr-d-scs.p (SOURCE NOT AVAILABLE)

REPLICATION-CREATE: Procedure is rp-c-scs.p (SOURCE NOT AVAILABLE)

REPLICATION-DELETE: Procedure is rp-d-scs.p (SOURCE NOT AVAILABLE)

REPLICATION-WRITE: Procedure is rp-u-scs.p (SOURCE NOT AVAILABLE)

WRITE: Overridable, Procedure is tr-u-scs.p (SOURCE NOT AVAILABLE)

Other tables who reference schd-status

status-code - Student Status Codes

stu-schedule - Student Schedule

Tables schd-status references

email-info - (no description available)

school-year - School year file

spm-prof - SPM Profile/Base record. Only 1 per system!

Detailed Alphabetical Field Listing
atnd-drop-action Data type: CHARACTER
Format: x(6) (Initial Value: Keep)
Help: How should attendance be handled?

audit-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Does this schedule status code represent an audit of this cl

award-credit Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Should the course have credit awarded?

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

description Data type: CHARACTER
Format: x(28)
Help: Description of the schedule status code
Attributes: Index Component

dropped Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if the student is no longer attending the class

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

include-attend Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be considered for attendance

include-gpa Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be included in GPA calculations

include-honor Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should be considered for honor rolls

include-progress Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should appear on student progress reports

include-rank Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if course should be considered when ranking students

include-report-card Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes if this course should appear on students report cards

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

progress-drop-action Data type: CHARACTER
Format: x(6) (Initial Value: Keep)
Help: How should progress reports be handled?

report-card-drop-action Data type: CHARACTER
Format: x(6) (Initial Value: Keep)
Help: How should report cards be handled ?

schd-status-code Data type: CHARACTER
Format: x(8)
Help: Name of this schedule status code
Attributes: Index Component

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

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

tested-out-flag Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Does this schedule status indicate the student has tested ou

transcript-drop-action Data type: CHARACTER
Format: x(6) (Initial Value: Keep)
Help: How should transcripts be handled ?

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