Definition of table Professional_Category
Professional Categories , Table Dump Name res-0016

Alphabetical Field Summary

  • cert-type: (CHAR) Type of certification (Permit, Certified, Provisional, etc)
  • comp-code: (INTG) Employee's assigned company
  • comp-code-description: (CHAR) A brief description of the company's purpose
  • dept-code: (INTG) Employee's assigned department code
  • dept-code-description: (CHAR) A brief description of the departments purpose
  • div-code: (INTG) Employee's assigned division
  • div-code-description: (CHAR) A brief description of the division's purpose
  • emp-active: (LOGC) Is employee currently active?
  • emp-fte: (DECM) Employee's Full Time Equivilency (0.00 to 1.00)
  • emp-group: (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-pic: (CHAR) Employee's PIC (assigned by State)
  • emp-sex: (LOGC) Employee's sex
  • emp-ssn: (CHAR) Employee's SSN
  • ethnic-code: (CHAR) Employee's ethnicity code
  • is-applicant: (LOGC) Yes if this entry is for an applicant
  • job-code: (CHAR) Employee's job code
  • job-code-description: (CHAR) A brief description of the job
  • loc-code: (CHAR) Employee's Primary Location
  • loc-code-description: (CHAR) A brief description of the job
  • marital-code: (CHAR) Employee's Marital status
  • prof-code: (CHAR) Professional catagory code for employee
  • prof-comment: (CHAR) Comments regarding this catagory
  • prof-expire-date: (DATE) Date Certificate/Permit expires
  • prof-issue-date: (DATE) Date Certificate/Permit was issued
  • prof-license: (CHAR) License/Certificate/Permit #
  • prof-num: (INTG) Certificate #
  • prof-primary: (LOGC) Is this considered the employee's primary catagory?
  • prof-test-date: (DATE) Date of last testing associated with this catagory/certifica
  • status-code: (CHAR) Employee's status code
  • union-member: (LOGC) Does employee belong to a union?
  • univ-code: (CHAR) University employees certification was issued from
  • univ-description: (CHAR) A brief description of the university

    Alphabetical Index Summary

  • cert-type: (PRIMARY) cert-type
  • comp-code: comp-code
  • dept-code: dept-code
  • div-code: div-code
  • emp-group: emp-group
  • emp-id: emp-id
  • emp-name: emp-name
  • emp-ssn: emp-ssn
  • ethnic-code: ethnic-code
  • is-applicant: is-applicant
  • job-code: job-code
  • loc-code: loc-code
  • marital-code: marital-code
  • prof-code: prof-code
  • prof-num: prof-num
  • status-code: status-code
  • univ-code: univ-code
  • univ-description: univ-description

    Tables Professional_Category references

  • Contacts - Employee Contacts
  • Counters - Employee Gross and Tax Counters
  • Deductions - Employee Deductions
  • Degree - Employee Degrees
  • Dependents - Employee Dependents
  • Distributions - Employee Distributions
  • Events - Employee Events
  • Notes - Employee Notes
  • Payrates - Employee Payrates
  • Payrate_Distributions - Payrate Related Distributions
  • Retirement - Per Payroll Retirement
  • Taxes - Employee Tax Setup (no counters)
  • W2 - Employee W2 information

    Detailed Alphabetical Field Listing
    cert-type Data type: CHARACTER
    Format: x(8)
    Description: Type of certification (Permit, Certified, Provisional, etc)
    Attributes: Index Component

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

    comp-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the company's purpose

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

    dept-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the departments purpose

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

    div-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the division's purpose

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

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

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

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

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

    emp-pic Data type: CHARACTER
    Format: x(10)
    Description: Employee's PIC (assigned by State)

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

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

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

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

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

    job-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

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

    loc-code-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the job

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

    prof-code Data type: CHARACTER
    Format: x(8)
    Description: Professional catagory code for employee
    Attributes: Index Component

    prof-comment Data type: CHARACTER
    Format: x(40)
    Description: Comments regarding this catagory

    prof-expire-date Data type: DATE
    Format: 99/99/9999
    Description: Date Certificate/Permit expires

    prof-issue-date Data type: DATE
    Format: 99/99/9999
    Description: Date Certificate/Permit was issued

    prof-license Data type: CHARACTER
    Format: x(10)
    Description: License/Certificate/Permit #

    prof-num Data type: INTEGER
    Format: zz9 (Initial Value: 0)
    Description: Certificate #
    Attributes: Index Component

    prof-primary Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Description: Is this considered the employee's primary catagory?

    prof-test-date Data type: DATE
    Format: 99/99/9999
    Description: Date of last testing associated with this catagory/certifica

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

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

    univ-code Data type: CHARACTER
    Format: x(8)
    Description: University employees certification was issued from
    Attributes: Index Component

    univ-description Data type: CHARACTER
    Format: x(28)
    Description: A brief description of the university
    Attributes: Index Component

    Created on 08/13/2012 by DBHTML V1.2