Definition of table emp-atnd

Employee Attendance Entries , Table Dump Name emp-atnd

Alphabetical Field Summary

acct-num: (CHAR) Account # for this attendance entry

atnd-code: (CHAR) Attendance code to record

atnd-comment: (CHAR) Any comments to record with this entry

atnd-date: (DATE) Date to record attendance entry for

atnd-duration: (DECM) Duration/Length of time to record for the entry

atnd-group-code: (CHAR) Attendance Group code for this entry

atnd-posted: (LOGC) Has attendance been posted?

atnd-posted-at: (CHAR) Time attendance was posted at

atnd-posted-by: (CHAR) User who posted this atnd entry

atnd-posted-on: (DATE) Date attendance was posted on

atnd-seq: (INTG) Attendance Identifier Sequence #

atnd-time: (CHAR) Time to record attendance entry is for

atnd-unit: (CHAR) Attendance unit to record attendance entry as

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

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

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

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

loc-code: (CHAR) Location code to record with this attendance entry

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

sub-atnd-seq: (INTG) Substitute Attendance Sequence #

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

sub-flag: (LOGC) Set TRUE if this is a substitute entry, not a regular ATND e

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

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

Alphabetical Index Summary

atnd-by-posted: emp-seq, atnd-posted, atnd-date

atnd-code: atnd-code, atnd-date

atnd-date: atnd-date, atnd-code

atnd-group-code: atnd-group-code, atnd-code, atnd-date

atnd-seq: emp-seq, atnd-seq

atnd-unit: atnd-unit

emp-atnd: (PRIMARY) emp-seq, atnd-date, atnd-time, atnd-code

extern-guid: extern-guid

loc-code: loc-code, atnd-date, atnd-code

Alphabetical Trigger Summary

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

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

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

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

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

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

Tables emp-atnd references

atnd-code - Attendance Code Definitions

atnd-group - Attendance Code Ground definitions

atnd-unit - Attendance Unit Code Definitions

emp-dc - (no description available)

emp-demo - Employee Demographic Entry

emp-distrib - Employee Distributions

emp-mpsers - (no description available)

emp-tdp - Employee DTL3 record

loc-code - Location Codes

pay-acct - Payroll Distribution Account List

pay-disburse - Record of per-payroll vendor disburements

pay-distrib - Payroll DIstributions file

Detailed Alphabetical Field Listing
acct-num Data type: CHARACTER
Format: x(30)
Help: Account # for this attendance entry

atnd-code Data type: CHARACTER
Format: x(8)
Help: Attendance code to record
Attributes: Index Component

atnd-comment Data type: CHARACTER
Format: x(40)
Help: Any comments to record with this entry

atnd-date Data type: DATE
Format: 99/99/9999
Help: Date to record attendance entry for
Attributes: Index Component

atnd-duration Data type: DECIMAL (Decimals: 3)
Format: -z,zz9.999 (Initial Value: 1)
Help: Duration/Length of time to record for the entry

atnd-group-code Data type: CHARACTER
Format: x(8)
Description: Attendance Group code for this entry
Attributes: Index Component

atnd-posted Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Has attendance been posted?
Attributes: Index Component

atnd-posted-at Data type: CHARACTER
Format: x(10)
Help: Time attendance was posted at

atnd-posted-by Data type: CHARACTER
Format: x(16)
Help: User who posted this atnd entry

atnd-posted-on Data type: DATE
Format: 99/99/9999
Help: Date attendance was posted on

atnd-seq Data type: INTEGER
Format: -z,zzz,zzz,zz9
Description: Attendance Identifier Sequence #
Attributes: Index Component

atnd-time Data type: CHARACTER
Format: x(8)
Help: Time to record attendance entry is for
Attributes: Index Component

atnd-unit Data type: CHARACTER
Format: x(8)
Help: Attendance unit to record attendance entry as
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

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

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

loc-code Data type: CHARACTER
Format: x(8)
Help: Location code to record with this attendance entry
Attributes: Index Component

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

sub-atnd-seq Data type: INTEGER
Format: -z,zzz,zzz,zz9
Description: Substitute Attendance Sequence #

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

sub-flag Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Description: Set TRUE if this is a substitute entry, not a regular ATND e

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

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