Definition of table Attendance

Employee Attendance , Table Dump Name res-0002

Alphabetical Field Summary

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

atnd-code: (CHAR) Attendance code to record

atnd-code-description: (CHAR) A brief description of the attendance code

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-loc-code: (CHAR) Location code to record with this attendance entry

atnd-loc-description: (CHAR) A brief description of the location

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

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

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

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

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

sub-atnd-code: (CHAR) Attendance code to record

sub-atnd-code-description: (CHAR) A brief description of the attendance code

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

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

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

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

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

sub-atnd-loc-description: (CHAR) A brief description of the location

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

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

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

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

sub-comp-description: (CHAR) A brief description of the company's purpose

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

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

sub-dept-description: (CHAR) A brief description of the departments purpose

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

sub-div-description: (CHAR) A brief description of the division's purpose

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

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

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

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

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

sub-emp-sex: (LOGC) Employee's sex

sub-emp-ssn: (CHAR) Employee's SSN

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

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

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

sub-job-description: (CHAR) A brief description of the job

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

sub-loc-description: (CHAR) A brief description of the location

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

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

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

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

Alphabetical Index Summary

atnd-code: (PRIMARY) atnd-code

atnd-code-description: atnd-code-description

atnd-date: atnd-date

atnd-group-code: atnd-group-code

atnd-loc-code: atnd-loc-code

atnd-loc-description: atnd-loc-description

atnd-time: atnd-time

atnd-unit: atnd-unit

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

status-code: status-code

sub-atnd-code: sub-atnd-code

sub-atnd-code-description: sub-atnd-code-description

sub-atnd-date: sub-atnd-date

sub-atnd-group-code: sub-atnd-group-code

sub-atnd-loc-code: sub-atnd-loc-code

sub-atnd-loc-description: sub-atnd-loc-description

sub-atnd-time: sub-atnd-time

sub-atnd-unit: sub-atnd-unit

sub-comp-code: sub-comp-code

sub-comp-description: sub-comp-description

sub-dept-code: sub-dept-code

sub-dept-description: sub-dept-description

sub-div-code: sub-div-code

sub-div-description: sub-div-description

sub-emp-group-code: sub-emp-group-code

sub-emp-id: sub-emp-id

sub-emp-name: sub-emp-name

sub-emp-ssn: sub-emp-ssn

sub-ethnic-code: sub-ethnic-code

sub-job-code: sub-job-code

sub-job-description: sub-job-description

sub-loc-code: sub-loc-code

sub-loc-description: sub-loc-description

sub-marital-code: sub-marital-code

sub-status-code: sub-status-code

Tables Attendance 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
atnd-acct-num Data type: CHARACTER
Format: x(30)
Description: Account # for this attendance entry

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

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

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

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

atnd-duration Data type: DECIMAL (Decimals: 3)
Format: -z,zz9.999 (Initial Value: 0)
Description: 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-loc-code Data type: CHARACTER
Format: x(8)
Description: Location code to record with this attendance entry
Attributes: Index Component

atnd-loc-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the location
Attributes: Index Component

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

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

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

sub-atnd-acct-num Data type: CHARACTER
Format: x(30)
Description: Account # for this attendance entry

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

sub-atnd-code-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the attendance code
Attributes: Index Component

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

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

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

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

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

sub-atnd-loc-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the location
Attributes: Index Component

sub-atnd-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

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

sub-atnd-unit Data type: CHARACTER
Format: x(8)
Description: Attendance unit to record attendance entry as
Attributes: Index Component

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

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

sub-cre-date Data type: DATE
Format: 99/99/9999
Description: Date this record was created

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

sub-dept-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the departments purpose
Attributes: Index Component

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

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

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

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

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

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

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

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

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

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

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

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

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

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

sub-loc-description Data type: CHARACTER
Format: x(28)
Description: A brief description of the location
Attributes: Index Component

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

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

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

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

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