Alias: PTR#

(P2K_PR_PAY_TRANSACTIONS)

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

Pay Transactions

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
PBT_ID	Number(10)	ID	Y	link to P2K_PR_BATCHES
PPH_ID	Number(10)	ID		link to P2K_PR_PAY_HEADERS
SPM_ID	Number(10)	ID		link to P2K_SA_PREMIUMS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
DTX_ID	Number(10)	ID		link to P2K_CM_TAX_JURISDICTIONS
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
DWR_ID	Number(10)	ID	Y	link to P2K_CM_WORK_RULES
MEX_ID_GENERATED	Number(10)	ID		link to P2K_AM_EXECUTIONS
DTC_ID	Number(10)	ID		link to P2K_CM_TIME_CODES
DCC_ID	Number(10)	ID		link to P2K_CM_COST_CENTERS
MEX_ID_INTO_PAYROLL	Number(10)	ID		link to P2K_AM_EXECUTIONS
PAY_TRAN_STATUS	Varchar2(2)	X_PAY_TRAN_STATUS	Y
PAY_TRAN_SOURCE	Varchar2(2)	X_PAY_TRAN_SOURCE	Y
START_DATE	Date()	DATE	Y
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
END_DATE	Date()	DATE
TIME_OR_AMOUNT	Number(18)	AMT12V6
SCHEDULED_TIME	Number(9)	AMT5V4
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
DISTRIBUTION_MASK	Varchar2(50)	DISTRIBUTION
WORK_IN_PROCESS	Varchar2(1)	TOGGLE
REFERENCE_INFO	Varchar2(2000)	VARCHAR2000
AUDIT_TEXT	Varchar2(4000)	VARCHAR4000
RATE_OVERRIDDEN	Varchar2(1)	TOGGLE
WORK_ORDER	Varchar2(50)	VARCHAR50
TRANSACTION_POINTER	Varchar2(30)	VARCHAR30
USE_ALTERNATE_TIME_CODE	Varchar2(1)	TOGGLE
EQUIPMENT_CODE	Varchar2(30)	VARCHAR30
POSTED_EQUIPMENT	Varchar2(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

---

Notes #

Click to create a new notes page