Definition of table personnel

Schools District personnel , Table Dump Name personl

Alphabetical Field Summary

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

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

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

fte: (DECM) Total FTE for this person

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

is-team-teaching: (LOGC) Yes if this personnel record represents a teaching team

known-as: (CHAR) Name of personnel as student refers to them

name: (CHAR) Name of this person (last name first)

personnel-class-id: (INTG) Primary Personnel classification for this person

personnel-code: (CHAR) Short Name/Code for this person

personnel-id: (INTG) [DEFINE KEY]

personnel-PIC: (CHAR) PIC for this personnel, as assigned by REP

personnel-ssn: (CHAR) SSN, if any, for this person

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

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

table-code-id-1: (INTG) User defined field 1 -- Table code ID

table-code-id-2: (INTG) User defined field 2 -- Table code ID

table-code-id-3: (INTG) User define field 3 -- Table code ID

table-name-id-1: (INTG) User defined field 1 -- Table name id

table-name-id-2: (INTG) User defined field 2 - Table name id

table-name-id-3: (INTG) User defined field 3 -- Table name id if any

team-teacher-list: (CHAR) List of codes for the real teachers that make up this team

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

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

user-value-1: (CHAR) User defined field 1 - Value of the field

user-value-2: (CHAR) User defined field 2 -- Value in the field

user-value-3: (CHAR) User define field 3 -- Value in the field

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

Alphabetical Index Summary

extern-guid: extern-guid

name: school-year-id, name

personnel-code: school-year-id, personnel-code

personnel-id: (UNIQUE, PRIMARY) school-year-id, personnel-id

personnel-ssn: school-year-id, personnel-ssn

user-name: school-year-id, user-name

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference personnel

behave-incident - Behavior Incidents, if the distict is tracking them

building - One record for each building, for each scheduling version, f

daily-atnd-post-log - Log file of postings on a date/room basis

department - Department Classifications

house - Houses for buildings

master-schd-meets - Course meets entry. There may be many of these for each c

personnel-bldg - Personnel/Building Linkage file

room-catalog - Rooms catalog, within a building

stu-behave - Student behaviour records

stu-behave-event - Student Behaviour Events

stu-counseling - (no description available)

stu-history - Student Activity History

stu-request - Student Requests File

stu-request-master - Student Request Master Controls

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

user-personnel - User Personnel level restrictions

Tables personnel references

email-info - (no description available)

personnel-class - Personnel CLassifications (teacher, vice-principle, etc)

school-year - School year file

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

user-access - User Access/Permissions file

user-personnel - User Personnel level restrictions

Detailed Alphabetical Field Listing
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

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

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

fte Data type: DECIMAL (Decimals: 2)
Format: 9.99 (Initial Value: 1.0)
Help: Total FTE for this person

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

is-team-teaching Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this personnel record represents a teaching team

known-as Data type: CHARACTER
Format: x(30)
Help: Name of personnel as student refers to them

name Data type: CHARACTER
Format: x(32)
Help: Name of this person (last name first)
Attributes: Index Component

personnel-class-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Primary Personnel classification for this person

personnel-code Data type: CHARACTER
Format: x(4)
Help: Short Name/Code for this person
Attributes: Index Component

personnel-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: [DEFINE KEY]
Help: Internally assigned personnel ID (or HRS.emp-demo.emp-seq #)
Attributes: Index Component

personnel-PIC Data type: CHARACTER
Format: x(10)
Help: PIC for this personnel, as assigned by REP

personnel-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Help: SSN, if any, for this person
Attributes: Index Component

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

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

table-code-id-1 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User defined field 1 -- Table code ID

table-code-id-2 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User defined field 2 -- Table code ID

table-code-id-3 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User define field 3 -- Table code ID

table-name-id-1 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User defined field 1 -- Table name id
Help: Table name, if any, that this is associated with

table-name-id-2 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User defined field 2 - Table name id
Help: Table name that this record is associated with

table-name-id-3 Data type: INTEGER
Format: zzzzzzzzzzz9
Description: User defined field 3 -- Table name id if any
Help: Table name associated with this record

team-teacher-list Data type: CHARACTER
Format: x(28)
Help: List of codes for the real teachers that make up this team

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

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

user-value-1 Data type: CHARACTER
Format: x(8)
Description: User defined field 1 - Value of the field

user-value-2 Data type: CHARACTER
Format: x(8)
Description: User defined field 2 -- Value in the field

user-value-3 Data type: CHARACTER
Format: x(8)
Description: User define field 3 -- Value in the field

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

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