!!!Alias: PTR Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ 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] |[DTC_ID]|Number(10)|[ID]| |link to [P2K_CM_TIME_CODES] |[MEX_ID_GENERATED]|Number(10)|[ID]| |link to [P2K_AM_EXECUTIONS] |[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|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[END_DATE]|Date()|[DATE]| | |[TIME_OR_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| | |[SCHEDULED_TIME]|Number(9)|[AMT5V4|AMTnn]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | |[DISTRIBUTION_MASK]|Varchar2(50)|[DISTRIBUTION]| | |[WORK_IN_PROCESS]|Varchar2(1)|[TOGGLE]| | |[REFERENCE_INFO]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| | |[AUDIT_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[RATE_OVERRIDDEN]|Varchar2(1)|[TOGGLE]| | |[WORK_ORDER]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[TRANSACTION_POINTER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[USE_ALTERNATE_TIME_CODE]|Varchar2(1)|[TOGGLE]| | User Fields: Allowed\\ Audit Logging: Not Allowed\\