Definition of table status-code

Student Status Codes , Table Dump Name stat-cod

Alphabetical Field Summary

award-credit: (LOGC) Should this student have credit awarded?

calc-gpa: (LOGC) Yes to have GPA calculated for the student, No to disable it

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 student status code

drop-schd: (LOGC) Yes if student schedules should be dropped

enrolled: (LOGC) Yes if this status code means the student is enrolled

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

history-code-id: (INTG) Optional default history code for this status code

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

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

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

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

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

include-requests: (LOGC) Yes to include on request sheets

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

schd-status-id: (INTG) Optional Schd Status code to use when dropping courses

school-year-id: (INTG) School year for this record

status-code: (CHAR) Name of student status code

status-code-id: (INTG) Internally assigned Status Code ID [DEFINE KEY]

status-group-id: (INTG) ID of he status group this code is assocaited with

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

extern-guid: extern-guid

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

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

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference status-code

stu-history - Student Activity History

stu-year - One record for each year a student exists in the district

Tables status-code references

email-info - (no description available)

history-code - Student History Activity Codes

schd-status - Student Schedule Status Code

school-year - School year file

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

status-group - Status groups are collections of status codes. Status groups

Detailed Alphabetical Field Listing
award-credit Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Should this student have credit awarded?

calc-gpa Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to have GPA calculated for the student, No to disable it

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 student status code
Attributes: Index Component

drop-schd Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if student schedules should be dropped

enrolled Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this status code means the student is enrolled

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

history-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Optional default history code for this status code

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

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

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

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

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

include-requests Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Yes to include on request sheets

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

schd-status-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Optional Schd Status code to use when dropping courses

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

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

status-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Status Code ID [DEFINE KEY]
Attributes: Index Component

status-group-id Data type: INTEGER
Format: zzzzzzzzzz9
Description: ID of he status group this code is assocaited with

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