Definition of table accr-code

Accrual Block Code Definitions , Table Dump Name acr-code

Alphabetical Field Summary

accr-code: (CHAR) A brief name for the accrual (i.e. SICK, VAC, LEAVE, etc)

accr-group-code: (CHAR) An accrual block grouping code

atnd-unit: (CHAR) Attendance unit prefered for this accrual

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 accrual definition

end-date: (DATE) Default ending date (Month, Day) for the accrual code

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

initial-accrual: (DECM) Initial accrual to assign an employee (only for 1st time)

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

remains-to-accr-code: (CHAR) Accrual code to transfer end of year remainder to

start-date: (DATE) Default starting date (Month, Day) for the accrual code

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

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

use-remains: (LOGC) Carry remaining accrual balance from previous years forward?

Alphabetical Index Summary

accr-code: (UNIQUE, PRIMARY) accr-code

accr-group-code: accr-group-code, accr-code

atnd-unit: atnd-unit

description: description

extern-guid: extern-guid

reamins-to-accr-code: remains-to-accr-code

Alphabetical Trigger Summary

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

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

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

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

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

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

Other tables who reference accr-code

atnd-accr - Attendance code -> Accrual Code assignments

emp-accr - Employee Accrual Blocks

Tables accr-code references

accr-group - Accrual Group Code

atnd-accr - Attendance code -> Accrual Code assignments

atnd-unit - Attendance Unit Code Definitions

emp-accr - Employee Accrual Blocks

mpsers-period - (no description available)

Detailed Alphabetical Field Listing
accr-code Data type: CHARACTER
Format: x(8)
Help: A brief name for the accrual (i.e. SICK, VAC, LEAVE, etc)
Attributes: Index Component

accr-group-code Data type: CHARACTER
Format: x(8)
Help: An accrual block grouping code
Attributes: Index Component

atnd-unit Data type: CHARACTER
Format: x(8)
Help: Attendance unit prefered for this accrual
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 accrual definition
Attributes: Index Component

end-date Data type: DATE
Format: 99/99/9999
Help: Default ending date (Month, Day) for the accrual code

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

initial-accrual Data type: DECIMAL (Decimals: 3)
Format: z,zz9.999 (Initial Value: 0)
Help: Initial accrual to assign an employee (only for 1st time)

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

remains-to-accr-code Data type: CHARACTER
Format: x(8)
Help: Accrual code to transfer end of year remainder to
Attributes: Index Component

start-date Data type: DATE
Format: 99/99/9999
Help: Default starting date (Month, Day) for the accrual code

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-remains Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Carry remaining accrual balance from previous years forward?

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