Definition of table stu-contact

Student Contacts file , Table Dump Name stu-cont

Alphabetical Field Summary

authorized-for-care: (LOGC) Yes if contact is allowed to care for student

carrier-route-id: (INTG) Carrier route for this address

cell-phone: (CHAR) Cellular Phone number for contact (if any)

cell-provider: (CHAR) Name of cell phone provider to send messages through, or "N/

comments: (CHAR) Comments about this contact

contact-active: (LOGC) Is this student contact currently an active contact?

contact-code-id: (INTG) Internally assigned Contact Code ID

contact-device-id[5]: (INTG) Index Component

contact-name: (CHAR) Name of contact, last name first

contact-order: (INTG) Order to list contacts

contact-type: (CHAR) Type of contact (Name, Address, Phone or Complete)

cre-date: (DATE) Date record was created

cre-time: (CHAR) Time this record was created at

cre-user-name: (CHAR) Name of user who created the record

device-alert[5]: (LOGC) Should this be used for informational messages?

device-emergency[5]: (LOGC) Should this method be used for emergency contacts only?

device-order[5]: (INTG) Order that this method of contact should be attempted

device-path[5]: (CHAR) Phone Number or email address for this contact device

device-provider[5]: (CHAR) Provider of this device (if applicable)

device-text-enabled[5]: (LOGC) Can this voice device receive textual messages?

email-address: (CHAR) Email address, if any, for this contact

email-direct-connect: (LOGC) 'Yes' to send direct connect messages to this email address

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

fax-phone: (CHAR) Fax number of contact (if any)

head-of-house: (LOGC) Is this contact the head of the students household?

home-phone: (CHAR) Home/Evening Phone number for this contact

lives-with-student: (LOGC) Yes if this contact lives with the student

mail-city: (CHAR) City of contact's mailing address

mail-state: (CHAR) State of contact's mailing address

mail-street: (CHAR) Street name of contact's mailing address

mail-street-apt: (CHAR) Apartment, if any, of contact's mailing address

mail-street-num: (CHAR) Street/House # of contact's mailing address

mail-type: (CHAR) Which mailing classes should be sent (All, Some or None)

mail-zip: (CHAR) Zip Code of the contacts mailing address

pager-phone: (CHAR) Pager number of contact (if any)

pager-provider: (CHAR) Name of pager provider to send text messages through, or "N/

password: (CHAR) Password for ParentWeb

preferred-phone: (CHAR) Preferred Phone # to use

stu-contact-seq: (INTG) Internally assigned contact sequence # [DEFINE KEY]

stu-seq: (INTG) Internally assigned Student Sequence #

upd-date: (DATE) Date record was last updated

upd-time: (CHAR) Time this record was last updated at

upd-user-name: (CHAR) Name of user record was updated by

use-student-address: (LOGC) Use the students primary address as this contact address

user-name: (CHAR) User name of this person (if any) for Parentweb

work-phone: (CHAR) Work/Day Phone number for this contact

Alphabetical Index Summary

contact-code: contact-code-id, stu-seq, stu-contact-seq

extern-guid: extern-guid

stu-contact: (UNIQUE, PRIMARY) stu-seq, stu-contact-seq

stu-contact-code: stu-seq, contact-code-id, stu-contact-seq

stu-contact-name: stu-seq, contact-name, stu-contact-seq

stu-contact-order: stu-seq, contact-order, stu-contact-seq

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference stu-contact

stu-behave - Student behaviour records

stu-behave-event - Student Behaviour Events

stu-contact-mailing - Student Contact Mailing definitions. For stu-contact records

stu-counseling - (no description available)

stu-course-atnd - Course Based student attendance

stu-daily-atnd - Daily student attendance entries

Tables stu-contact references

carrier-route - Carrier Route definitions

contact-code - Contact Codes file

stu-assign - (no description available)

stu-base - Student Base record

stu-request-master - Student Request Master Controls

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

user-access - User Access/Permissions file

Detailed Alphabetical Field Listing
authorized-for-care Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if contact is allowed to care for student

carrier-route-id Data type: INTEGER
Format: zzzzzzzzzz9
Description: Carrier route for this address

cell-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Cellular Phone number for contact (if any)

cell-provider Data type: CHARACTER
Format: x(16)
Help: Name of cell phone provider to send messages through, or "N/

comments Data type: CHARACTER
Format: x(68)
Help: Comments about this contact

contact-active Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this student contact currently an active contact?

contact-code-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Contact Code ID
Attributes: Index Component

contact-device-id Data type: INTEGER (Extent: 5)
Format: 999999999999999999999999 (Initial Value: 0)
Help: Index Component

contact-name Data type: CHARACTER
Format: x(30)
Help: Name of contact, last name first
Attributes: Index Component

contact-order Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Order to list contacts
Attributes: Index Component

contact-type Data type: CHARACTER
Format: x(8) (Initial Value: Complete)
Help: Type of contact (Name, Address, Phone or Complete)

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 this record was created at

cre-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who created the record

device-alert Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: no)
Help: Should this be used for informational messages?

device-emergency Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: no)
Help: Should this method be used for emergency contacts only?

device-order Data type: INTEGER (Extent: 5)
Format: 9 (Initial Value: 0)
Help: Order that this method of contact should be attempted

device-path Data type: CHARACTER (Extent: 5)
Format: x(255)
Help: Phone Number or email address for this contact device

device-provider Data type: CHARACTER (Extent: 5)
Format: x(11)
Help: Provider of this device (if applicable)

device-text-enabled Data type: LOGICAL (Extent: 5)
Format: Yes/No (Initial Value: no)
Help: Can this voice device receive textual messages?

email-address Data type: CHARACTER
Format: x(40)
Help: Email address, if any, for this contact

email-direct-connect Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: 'Yes' to send direct connect messages to this email address

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

fax-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Fax number of contact (if any)

head-of-house Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is this contact the head of the students household?

home-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Home/Evening Phone number for this contact

lives-with-student Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this contact lives with the student

mail-city Data type: CHARACTER
Format: x(25)
Help: City of contact's mailing address

mail-state Data type: CHARACTER
Format: !!
Help: State of contact's mailing address

mail-street Data type: CHARACTER
Format: x(20)
Help: Street name of contact's mailing address

mail-street-apt Data type: CHARACTER
Format: x(8)
Help: Apartment, if any, of contact's mailing address

mail-street-num Data type: CHARACTER
Format: x(8)
Help: Street/House # of contact's mailing address

mail-type Data type: CHARACTER
Format: x(4) (Initial Value: None)
Help: Which mailing classes should be sent (All, Some or None)

mail-zip Data type: CHARACTER
Format: xxxxx-xxxx
Help: Zip Code of the contacts mailing address

pager-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxxxxxxxxxx
Help: Pager number of contact (if any)

pager-provider Data type: CHARACTER
Format: x(16)
Help: Name of pager provider to send text messages through, or "N/

password Data type: CHARACTER
Format: x(28)
Help: Password for ParentWeb

preferred-phone Data type: CHARACTER
Format: x(10) (Initial Value: Work)
Help: Preferred Phone # to use

stu-contact-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned contact sequence # [DEFINE KEY]
Attributes: Index Component

stu-seq Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned Student Sequence #
Attributes: Index Component

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: Time this record was last updated at

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user record was updated by

use-student-address Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Use the students primary address as this contact address

user-name Data type: CHARACTER
Format: x(16)
Help: User name of this person (if any) for Parentweb

work-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Work/Day Phone number for this contact

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