Definition of table mpsers-period
No table description available
, Table Dump Name mpsers-p
Alphabetical Field Summary
begin-date: (DATE) Beginning date of this MPSERS period
comments: (CHAR) Comments about this MPSERS period
cre-date: (DATE) Date this record was created
cre-time: (CHAR) Creation time of this record
cre-user-name: (CHAR) Name of user who created this record
end-date: (DATE) End date for this MPSERS period
end-pay-id: (INTG) Ending pay identifier
mpsers-period-id: (INTG) Internally assigned identifier [DEFINE KEY]
payroll-year: (INTG) Payroll year associated with this record
period-label: (CHAR) Name of this MPSERS period
period-num: (INTG) Period Number for this period
primary-key: (INTG) Unique, Primary key for record
start-pay-id: (INTG) Starting payroll identifier
upd-date: (DATE) Date this record was last updated
upd-time: (CHAR) Time of last update to this record
upd-user-name: (CHAR) Name of user who last updated this record
Alphabetical Index Summary
end-pay-id: end-pay-id, mpsers-period-id
mpsers-date: payroll-year, begin-date, end-date, mpsers-period-id
mpsers-period: (UNIQUE, PRIMARY) mpsers-period-id, begin-date, end-date
pay-dates: start-pay-id, end-pay-id, mpsers-period-id
period-label: payroll-year, period-label
period-num: payroll-year, period-num
Alphabetical Trigger Summary
CREATE: Overridable, Procedure is tr-c-mpp.p
DELETE: Overridable, Procedure is tr-d-mpp.p
REPLICATION-CREATE: Procedure is rp-c-mpp.p
REPLICATION-DELETE: Procedure is rp-d-mpp.p
REPLICATION-WRITE: Procedure is rp-u-mpp.p
WRITE: Overridable, Procedure is tr-u-mpp.p
Other tables who reference mpsers-period
accr-code - Accrual Block Code Definitions
emp-aca - (no description available)
emp-accr - Employee Accrual Blocks
emp-dc - (no description available)
emp-deduct - Employee Deductions file
emp-fringe - (no description available)
emp-mpsers - (no description available)
emp-rate - Employee Payrate records
emp-tdp - Employee DTL3 record
fringe-period - Fringe Benefit Period
Tables mpsers-period references
emp-accr - Employee Accrual Blocks
pay-year - Payroll Year definitions
Detailed Alphabetical Field Listing
begin-date Data type: DATE
Format: 99/99/9999
Help: Beginning date of this MPSERS period
Attributes: Index Component
comments Data type: CHARACTER
Format: x(60)
Help: Comments about this MPSERS period
cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was created
cre-time Data type: CHARACTER
Format: x(8)
Help: Creation time of this record
cre-user-name Data type: CHARACTER
Format: x(16)
Help: Name of user who created this record
Attributes: Mandatory
end-date Data type: DATE
Format: 99/99/9999
Help: End date for this MPSERS period
Attributes: Index Component
end-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Ending pay identifier
Attributes: Index Component
mpsers-period-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned identifier [DEFINE KEY]
Attributes: Index Component
payroll-year Data type: INTEGER
Format: 9999 (Initial Value: 0)
Description: Payroll year associated with this record
Help: Payroll year for this MPSERS period
Attributes: Index Component
period-label Data type: CHARACTER
Format: x(8)
Help: Name of this MPSERS period
Attributes: Index Component
period-num Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Period Number for this period
Attributes: Index Component
primary-key Data type: INTEGER
Format: zzzzzzzzz9
Help: Unique, Primary key for record
start-pay-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Starting payroll identifier
Attributes: Index Component
upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date this record was last updated
upd-time Data type: CHARACTER
Format: x(8)
Help: Time of last update to this record
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