P 2 K_PR_PAY_TRANSACTIONS
Back to current versionRestore this version

Alias: PTR#

(P2K_PR_PAY_TRANSACTIONS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR50


Pay Transactions

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PBT_IDNumber(10)IDYlink to P2K_PR_BATCHES
PPH_IDNumber(10)ID link to P2K_PR_PAY_HEADERS
SPM_IDNumber(10)ID link to P2K_SA_PREMIUMS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
DWR_IDNumber(10)IDYlink to P2K_CM_WORK_RULES
DTC_IDNumber(10)ID link to P2K_CM_TIME_CODES
MEX_ID_GENERATEDNumber(10)ID link to P2K_AM_EXECUTIONS
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
MEX_ID_INTO_PAYROLLNumber(10)ID link to P2K_AM_EXECUTIONS
PAY_TRAN_STATUSVarchar2(2)X_PAY_TRAN_STATUSY
PAY_TRAN_SOURCEVarchar2(2)X_PAY_TRAN_SOURCEY
START_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
END_DATEDate()DATE
TIME_OR_AMOUNTNumber(18)AMT12V6
SCHEDULED_TIMENumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
DISTRIBUTION_MASKVarchar2(50)DISTRIBUTION
WORK_IN_PROCESSVarchar2(1)TOGGLE
REFERENCE_INFOVarchar2(2000)VARCHAR2000
AUDIT_TEXTVarchar2(4000)VARCHAR4000
RATE_OVERRIDDENVarchar2(1)TOGGLE
WORK_ORDERVarchar2(50)VARCHAR50
TRANSACTION_POINTERVarchar2(30)VARCHAR30
USE_ALTERNATE_TIME_CODEVarchar2(1)TOGGLE

Derived Fields#

Column Name
DRV_EAS_ID_CODE
DRV_GENERATED_BY
DRV_LEAVE
DRV_OTHER
DRV_REG
DRV_TOTAL_HOURS
DRV_UPDATED_BY

User Fields: Allowed
Audit Logging: Not Allowed

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation