Definition of table atnd-code
Attendance Code Definitions , Table Dump Name atd-code

Alphabetical Field Summary

  • accr-requires: (CHAR) Code required ANY, SOME or ONE of the listed accrual blocks
  • allow-unit-override: (LOGC) Allow changes to the unit type during Attendance Entry?
  • atnd-code: (CHAR) A brief name for an attendance code (i.e. SICK, CONF, etc)
  • atnd-group-code: (CHAR) Attendance group to catagorize the code with
  • atnd-unit: (CHAR) Describe the prefered attendance unit for this code
  • cre-date: (DATE) Date this record was created
  • cre-user-name: (CHAR) Name of user who created this record
  • description: (CHAR) A brief description of the attendance code
  • extern-guid: (CHAR) External Global Unique ID for this record
  • over-accr-atnd-code: (CHAR) Attendance code to suggest when an accrual is exceeded
  • primary-key: (INTG) Unique, Primary key for record
  • require-acct-num: (LOGC) 'Yes' to require that the account # must be filled in
  • require-comment: (LOGC) 'Yes' to require that the comment must be filled in
  • require-location: (LOGC) 'Yes' to require that the location must be filled in
  • require-sub: (LOGC) 'Yes' to require that the substitute SSN must be filled in
  • require-time: (LOGC) 'Yes' to require that the start time must be filled in
  • sub-atnd-code: (CHAR) The preferred Attendance code to use for substitute entries
  • upd-date: (DATE) Date this record was last updated
  • upd-user-name: (CHAR) Name of user who last updated this record
  • use-acct-num: (LOGC) Use Account #'s when recording attendance with this code?
  • use-comment: (LOGC) Use comment when recording attendance with this code?
  • use-location: (LOGC) Use location codes when recording attendance with this code?
  • use-sub: (LOGC) Use Substitutes when recording attendance with this code?
  • use-time: (LOGC) Use Start time when recording attendance with this code?

    Alphabetical Index Summary

  • atnd-code: (UNIQUE, PRIMARY) atnd-code
  • atnd-group-code: atnd-group-code, atnd-code
  • atnd-unit: atnd-unit
  • description: description
  • extern-guid: extern-guid
  • sub-atnd-code: sub-atnd-code

    Alphabetical Trigger Summary

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

    Other tables who reference atnd-code

  • atnd-accr - Attendance code -> Accrual Code assignments
  • emp-atnd - Employee Attendance Entries

    Tables atnd-code references

  • atnd-group - Attendance Code Ground definitions
  • atnd-unit - Attendance Unit Code Definitions
  • emp-atnd - Employee Attendance Entries

    Detailed Alphabetical Field Listing
    accr-requires Data type: CHARACTER
    Format: x(4) (Initial Value: Any)
    Help: Code required ANY, SOME or ONE of the listed accrual blocks

    allow-unit-override Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Allow changes to the unit type during Attendance Entry?

    atnd-code Data type: CHARACTER
    Format: x(8)
    Help: A brief name for an attendance code (i.e. SICK, CONF, etc)
    Attributes: Index Component

    atnd-group-code Data type: CHARACTER
    Format: x(8)
    Help: Attendance group to catagorize the code with
    Attributes: Index Component

    atnd-unit Data type: CHARACTER
    Format: x(8)
    Help: Describe the prefered attendance unit for this code
    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

    description Data type: CHARACTER
    Format: x(28)
    Help: A brief description of the attendance code
    Attributes: Index Component

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

    over-accr-atnd-code Data type: CHARACTER
    Format: x(8)
    Help: Attendance code to suggest when an accrual is exceeded

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

    require-acct-num Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' to require that the account # must be filled in

    require-comment Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: 'Yes' to require that the comment must be filled in

    require-location Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' to require that the location must be filled in

    require-sub Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' to require that the substitute SSN must be filled in

    require-time Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: 'Yes' to require that the start time must be filled in

    sub-atnd-code Data type: CHARACTER
    Format: x(8)
    Help: The preferred Attendance code to use for substitute entries
    Attributes: Index Component

    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

    use-acct-num Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Use Account #'s when recording attendance with this code?

    use-comment Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Use comment when recording attendance with this code?

    use-location Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Use location codes when recording attendance with this code?

    use-sub Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Use Substitutes when recording attendance with this code?

    use-time Data type: LOGICAL
    Format: Yes/No (Initial Value: no)
    Help: Use Start time when recording attendance with this code?

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