Definition of table emp-demo
Employee Demographic Entry , Table Dump Name emp-demo

Alphabetical Field Summary

  • accrue-by-atnd-unit: (CHAR) Default attendance unit for employee accruals
  • cell-phone: (CHAR) Employee's Cell Phone
  • 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
  • email-address: (CHAR) Employee's Email Address
  • 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
  • is-applicant: (LOGC) Yes if this entry is for an applicant
  • job-code: (CHAR) Employee's job code
  • last-four-ssn: (CHAR) (no description available)
  • 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-id: emp-id
  • emp-name: emp-name
  • emp-seq: (UNIQUE, PRIMARY) emp-seq
  • emp-ssn: (UNIQUE) emp-ssn
  • ethnic-code: ethnic-code
  • extern-guid: extern-guid
  • is-applicant: is-applicant, emp-seq
  • job-code: job-code
  • last-four: last-four-ssn
  • loc-code: loc-code
  • marital-code: marital-code
  • status-code: status-code

    Alphabetical Trigger Summary

  • CREATE: Overridable, Procedure is tr-c-edm.p
  • DELETE: Overridable, Procedure is tr-d-edm.p
  • REPLICATION-CREATE: Procedure is rp-c-edm.p
  • REPLICATION-DELETE: Procedure is rp-d-edm.p
  • REPLICATION-WRITE: Procedure is rp-u-edm.p
  • WRITE: Overridable, Procedure is tr-u-edm.p

    Other tables who reference emp-demo

  • degree-study - Areas of study for the degree
  • emp-1095c - Employee 1095c filing record
  • emp-aca - (no description available)
  • emp-accr - Employee Accrual Blocks
  • emp-adjust - Employee Adjustments
  • emp-atnd - Employee Attendance Entries
  • emp-benefit - Employee Benefits
  • emp-contact - Employee Contacts
  • emp-counter - Employee Counters
  • emp-dc - (no description available)
  • emp-deduct - Employee Deductions file
  • emp-deduct-rate - Employee Deduction/Payrate linkage
  • emp-degree - Employee Degrees
  • emp-dependent - Employee Dependent Definition file
  • emp-distrib - Employee Distributions
  • emp-event - (no description available)
  • emp-fringe - (no description available)
  • emp-history - Employee Demographic Entry
  • emp-mpsers - (no description available)
  • emp-note - Employee Notes file
  • emp-pay-master - Employee Payroll Master
  • emp-payroll - The one per employee, once per payroll control file
  • emp-prof - Employee Professional Catagories
  • emp-quarter - Employee Quarterly Retirement reporting records
  • emp-rate - Employee Payrate records
  • emp-rate-hours - Employee Payrate Hourly detail
  • emp-rate-loc - Employee Payrate Locations records
  • emp-rate-savings - Employee payrate savings, typically used for Summer Savings
  • emp-retire - Employee Retirment Records
  • emp-site - Site Specific Employee data file
  • emp-state-item - Describes an employee state record entry
  • emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
  • emp-tdp - Employee DTL3 record
  • emp-unemp - Employee Unemployement counters
  • emp-w2 - Employee W2 Info
  • pay-check - Payroll Check file, one record per payroll check issued
  • pay-log - Payroll Message log file
  • prof-cert - Profession Catagory Certifications

    Tables emp-demo references

  • comp-code - Company Code definitions
  • dept-code - Department Code Definitions
  • div-code - Division Code Definitions
  • emp-dc - (no description available)
  • emp-group - Employee Groupings File
  • emp-mpsers - (no description available)
  • emp-tdp - Employee DTL3 record
  • ethnic-code - Ethnic Code definitions
  • 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

    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

    email-address Data type: CHARACTER
    Format: x(64)
    Help: Employee's Email Address

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

    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

    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

    last-four-ssn Data type: CHARACTER
    Format: x(4)
    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