Definition of table emp-history

Employee Demographic Entry , Table Dump Name emp-hist

Alphabetical Field Summary

accrue-by-atnd-unit: (CHAR) Default attendance unit for employee accruals

cell-phone: (CHAR) Employee's Cell Phone

comments: (CHAR) Enter Comments about this entry

comp-code: (INTG) Employee's assigned company

cre-date: (DATE) Date this record was created

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

dept-code: (INTG) Employee's assigned department code

div-code: (INTG) Employee's assigned division

emp-active: (LOGC) Is employee currently active?

emp-addr-1: (CHAR) Employee's home street address

emp-addr-2: (CHAR) Employee's home street address

emp-birth-date: (DATE) Employee's Birthdate

emp-city: (CHAR) Employee's Home City

emp-fte: (DECM) Employee's Full Time Equivilency (0.00 to 1.00)

emp-group-code: (CHAR) An employee grouping classification

emp-id: (CHAR) Employee ID (if used)

emp-name: (CHAR) Employee's name in "LAST NAME, FIRST NAME M" order

emp-phone: (CHAR) Employee's Home Phone

emp-salary: (DECM) Employee's current salary (not used by Payroll)

emp-seq: (INTG) Employee's Unique Sequence #

emp-sex: (LOGC) Employee's sex

emp-ssn: (CHAR) Employee's SSN

emp-state: (CHAR) Employee's Home State

emp-zip: (CHAR) Employee's Home Zip Code

ethnic-code: (CHAR) Employee's ethnicity code

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

history-code-id: (INTG) Internally Assigned history code

history-date: (DATE) Effective date of this change

history-seq: (INTG) Internally Assigned History Sequence

is-applicant: (LOGC) Yes if this entry is for an applicant

job-code: (CHAR) Employee's job code

loc-code: (CHAR) Employee's Primary Location

local-experience: (DECM) Employee's experience with the district, in years

mail-addr-1: (CHAR) Employee's mailing address

mail-addr-2: (CHAR) Employee's mailing address

mail-city: (CHAR) Employee's Mailing City

mail-state: (CHAR) Employee's Mailing State

mail-zip: (CHAR) Employee's Mailing Zip code

marital-code: (CHAR) Employee's Marital status

num-children: (INTG) Number of children employee has

num-depend: (INTG) Number of dependent an employee has

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

status-code: (CHAR) Employee's status code

total-experience: (DECM) Total employee experience, in years

union-member: (LOGC) Does employee belong to a union?

unlisted-addr: (LOGC) Is the Home Address unlisted?

unlisted-phone: (LOGC) Is the Home Phone unlisted?

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

upd-user-name: (CHAR) Name of user who last updated this record

work-phone: (CHAR) Employee's work phone number

Alphabetical Index Summary

atnd-unit: accrue-by-atnd-unit

comp-code: comp-code

dept-code: dept-code

div-code: div-code

emp-group-code: emp-group-code

emp-hist: (UNIQUE, PRIMARY) emp-seq, history-seq

emp-hist-by-code: emp-seq, history-code-id, history-date, history-seq

emp-history: emp-seq, history-date, history-seq

emp-id: emp-id

emp-seq: emp-seq

emp-ssn: emp-ssn

ethnic-code: ethnic-code

extern-guid: extern-guid

history-by-code: history-code-id, history-date, history-seq

history-date: history-date, history-seq

is-applicant: is-applicant, emp-seq

job-code: job-code

loc-code: loc-code

marital-code: marital-code

status-code: status-code

Alphabetical Trigger Summary

CREATE: Overridable, Procedure is tr-c-ehs.p

DELETE: Overridable, Procedure is tr-d-ehs.p

REPLICATION-CREATE: Procedure is rp-c-ehs.p

REPLICATION-DELETE: Procedure is rp-d-ehs.p

REPLICATION-WRITE: Procedure is rp-u-ehs.p

WRITE: Overridable, Procedure is tr-u-ehs.p

Tables emp-history references

comp-code - Company Code definitions

dept-code - Department Code Definitions

div-code - Division Code Definitions

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-group - Employee Groupings File

emp-mpsers - (no description available)

emp-tdp - Employee DTL3 record

ethnic-code - Ethnic Code definitions

history-code - Employee History Activity Codes

job-code - Definition of district job codes

loc-code - Location Codes

marital-code - Marital Status Codes

status-code - Employee Status Codes

Detailed Alphabetical Field Listing
accrue-by-atnd-unit Data type: CHARACTER
Format: x(8)
Help: Default attendance unit for employee accruals
Attributes: Index Component

cell-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx
Help: Employee's Cell Phone

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

comp-code Data type: INTEGER
Format: 99 (Initial Value: 0)
Help: Employee's assigned company
Attributes: Index Component

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was created

cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record
Attributes: Mandatory

dept-code Data type: INTEGER
Format: 9999 (Initial Value: 0)
Help: Employee's assigned department code
Attributes: Index Component

div-code Data type: INTEGER
Format: 9999 (Initial Value: 0)
Help: Employee's assigned division
Attributes: Index Component

emp-active Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is employee currently active?

emp-addr-1 Data type: CHARACTER
Format: x(30)
Help: Employee's home street address

emp-addr-2 Data type: CHARACTER
Format: x(30)
Help: Employee's home street address

emp-birth-date Data type: DATE
Format: 99/99/9999
Help: Employee's Birthdate

emp-city Data type: CHARACTER
Format: x(20)
Help: Employee's Home City

emp-fte Data type: DECIMAL (Decimals: 2)
Format: 9.99 (Initial Value: 0)
Help: Employee's Full Time Equivilency (0.00 to 1.00)

emp-group-code Data type: CHARACTER
Format: x(8)
Help: An employee grouping classification
Attributes: Index Component

emp-id Data type: CHARACTER
Format: 999999
Help: Employee ID (if used)
Attributes: Index Component

emp-name Data type: CHARACTER
Format: x(30)
Help: Employee's name in "LAST NAME, FIRST NAME M" order

emp-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx
Help: Employee's Home Phone

emp-salary Data type: DECIMAL (Decimals: 2)
Format: $zzz,zz9.99 (Initial Value: 0)
Help: Employee's current salary (not used by Payroll)

emp-seq Data type: INTEGER
Format: zzzzzzzz9
Description: Employee's Unique Sequence #
Attributes: Index Component

emp-sex Data type: LOGICAL
Format: Male/Female (Initial Value: no)
Help: Employee's sex

emp-ssn Data type: CHARACTER
Format: xxx-xx-xxxx
Help: Employee's SSN
Attributes: Index Component

emp-state Data type: CHARACTER
Format: !!
Help: Employee's Home State

emp-zip Data type: CHARACTER
Format: x(10)
Help: Employee's Home Zip Code

ethnic-code Data type: CHARACTER
Format: x(8)
Help: Employee's ethnicity code
Attributes: Index Component

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 (Initial Value: 0)
Description: Internally Assigned history code
Attributes: Index Component

history-date Data type: DATE
Format: 99/99/9999
Description: Effective date of this change
Attributes: Index Component

history-seq Data type: INTEGER
Format: zzzzzzzzzzz9 (Initial Value: 0)
Help: Internally Assigned History Sequence
Attributes: Index Component

is-applicant Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if this entry is for an applicant
Attributes: Index Component

job-code Data type: CHARACTER
Format: x(8)
Help: Employee's job code
Attributes: Index Component

loc-code Data type: CHARACTER
Format: x(8)
Help: Employee's Primary Location
Attributes: Index Component

local-experience Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Employee's experience with the district, in years

mail-addr-1 Data type: CHARACTER
Format: x(30)
Help: Employee's mailing address

mail-addr-2 Data type: CHARACTER
Format: x(30)
Help: Employee's mailing address

mail-city Data type: CHARACTER
Format: x(20)
Help: Employee's Mailing City

mail-state Data type: CHARACTER
Format: !!
Help: Employee's Mailing State

mail-zip Data type: CHARACTER
Format: x(10)
Help: Employee's Mailing Zip code

marital-code Data type: CHARACTER
Format: x(8)
Help: Employee's Marital status
Attributes: Index Component

num-children Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of children employee has

num-depend Data type: INTEGER
Format: zz9 (Initial Value: 0)
Help: Number of dependent an employee has

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

status-code Data type: CHARACTER
Format: x(8)
Help: Employee's status code
Attributes: Index Component

total-experience Data type: DECIMAL (Decimals: 3)
Format: z9.999 (Initial Value: 0)
Help: Total employee experience, in years

union-member Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Does employee belong to a union?

unlisted-addr Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is the Home Address unlisted?

unlisted-phone Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is the Home Phone unlisted?

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was last updated

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Name of user who last updated this record

work-phone Data type: CHARACTER
Format: (xxx) xxx-xxxx ~xxxxx
Help: Employee's work phone number

Created on 12/28/2020 by DBHTML V1.2