Definition of table pay-schd
Payroll Schedule for a year One entry per possible payroll for the year.
, Table Dump Name pay-schd
Alphabetical Field Summary
calendar-year: (INTG) Calendar year for this payroll
check-print-done: (LOGC) Check printing completed at least once
comments[3]: (CHAR) Any comments regarding this payroll
extern-guid: (CHAR) External Global Unique ID for this record
fiscal-year: (CHAR) Fiscal year this payroll falls in
gl-tran-num: (INTG) GL Tran # for distributions
journal-code: (CHAR) Journal code associated with the assign GL tran-num
pay-calcs-done: (LOGC) Yes if payroll calculations have been done at least once?
pay-check-date: (DATE) Check date for this payroll
pay-ending-date: (DATE) Date payroll period ended
pay-id: (INTG) Payroll Identifier
pay-num: (CHAR) Payroll number.
pay-starts-cal-year: (LOGC) Is this payroll the start of the calendar year?
pay-starts-fiscal-year: (LOGC) Is this pay the start of a new fiscal year?
pay-starts-month: (LOGC) Is this payroll the start of a new month?
pay-starts-payroll: (LOGC) Is this pay the start of a new payroll year?
pay-starts-quarter: (LOGC) Is this payroll the start of a new quarter?
payroll-year: (INTG) Payroll year associated with this record
post-payroll-done: (LOGC) Post Payroll Processing done at least once
pre-payroll-done: (LOGC) Yes if pre-payroll processing has been run at least once
primary-key: (INTG) Unique, Primary key for record
qtr-num: (INTG) Quarter of calendar year this payroll falls in
Alphabetical Index Summary
calendar-year: calendar-year, pay-id
extern-guid: extern-guid
pay-id: (UNIQUE, PRIMARY) pay-id
pay-num: payroll-year, pay-num
pay-stat: pre-payroll-done, post-payroll-done, pay-id
payroll-year: payroll-year, pay-id
Alphabetical Trigger Summary
CREATE: Overridable, Procedure is tr-c-psc.p
DELETE: Overridable, Procedure is tr-d-psc.p
REPLICATION-CREATE: Procedure is rp-c-psc.p
REPLICATION-DELETE: Procedure is rp-d-psc.p
REPLICATION-WRITE: Procedure is rp-u-psc.p
WRITE: Overridable, Procedure is tr-u-psc.p
Other tables who reference pay-schd
emp-adjust - Employee Adjustments
emp-counter - Employee Counters
emp-deduct - Employee Deductions file
emp-deduct-rate - Employee Deduction/Payrate linkage
emp-distrib - Employee Distributions
emp-pay-master - Employee Payroll Master
emp-payroll - The one per employee, once per payroll control file
emp-rate - Employee Payrate records
emp-rate-hours - Employee Payrate Hourly detail
emp-rate-loc - Employee Payrate Locations records
emp-rate-savings - Employee payrate savings, typically used for Summer Savings
emp-retire - Employee Retirment Records
emp-taxes - Employee Taxes (FICA, Medicare, FIT, SIT & LIT)
emp-unemp - Employee Unemployement counters
fringe-period - Fringe Benefit Period
mpsers-period - (no description available)
pay-check - Payroll Check file, one record per payroll check issued
pay-cycle-schd - Linkage file between cycles and the payroll active for them
pay-deduct - Payroll Master Deductions definition
pay-disburse - Record of per-payroll vendor disburements
pay-distrib - Payroll DIstributions file
pay-log - Payroll Message log file
pay-rate - Master Payrate definitions
Tables pay-schd references
emp-payroll - The one per employee, once per payroll control file
emp-w2 - Employee W2 Info
pay-cycle-schd - Linkage file between cycles and the payroll active for them
pay-profile - Payroll System Profile
pay-year - Payroll Year definitions
Detailed Alphabetical Field Listing
calendar-year Data type: INTEGER
Format: 9999 (Initial Value: 0)
Help: Calendar year for this payroll
Attributes: Index Component
check-print-done Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Check printing completed at least once
comments Data type: CHARACTER (Extent: 3)
Format: x(70)
Help: Any comments regarding this payroll
extern-guid Data type: CHARACTER
Format: x(32)
Description: External Global Unique ID for this record
Attributes: Index Component
fiscal-year Data type: CHARACTER
Format: 9999
Help: Fiscal year this payroll falls in
gl-tran-num Data type: INTEGER
Format: 999999
Description: GL Tran # for distributions
journal-code Data type: CHARACTER
Format: x(6)
Description: Journal code associated with the assign GL tran-num
pay-calcs-done Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Yes if payroll calculations have been done at least once?
pay-check-date Data type: DATE
Format: 99/99/9999
Help: Check date for this payroll
pay-ending-date Data type: DATE
Format: 99/99/9999
Help: Date payroll period ended
pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Payroll Identifier
Attributes: Index Component
pay-num Data type: CHARACTER
Format: x(4)
Help: Payroll number.
Attributes: Index Component
pay-starts-cal-year Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this payroll the start of the calendar year?
pay-starts-fiscal-year Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this pay the start of a new fiscal year?
pay-starts-month Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this payroll the start of a new month?
pay-starts-payroll Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this pay the start of a new payroll year?
pay-starts-quarter Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Is this payroll the start of a new quarter?
payroll-year Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Payroll year associated with this record
Attributes: Index Component
post-payroll-done Data type: LOGICAL
Format: Yes/No (Initial Value: no)
Help: Post Payroll Processing done at least once
Attributes: Index Component
pre-payroll-done Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Yes if pre-payroll processing has been run at least once
Attributes: Index Component
primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record
qtr-num Data type: INTEGER
Format: 9 (Initial Value: 1)
Help: Quarter of calendar year this payroll falls in
Created on 12/28/2020 by DBHTML V1.2