P 2 K_PR_TIME_SHEET_ENTRIES

Alias: PTSE#

(P2K_PR_TIME_SHEETS_ENTRIES)

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


Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
PTS_IDNumber(10)IDYlink to P2K_PR_TIME_SHEETS
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
DDP_IDNumber(10)IDYlink to P2K_CM_DEPARTMENTS
DTC_IDNumber(10)IDYlink to P2K_CM_TIME_CODES
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DCC_IDNumber(10)ID link to P2K_CM_COST_CENTERS
AAL_IDNumber(10)ID link to P2K_AT_LEAVE_LINES
TBT_IDNumber(10)ID link to P2K_TS_TIME_BATCHES
ENTRY_DATEDate()DATEY
WORK_ORDERVarchar2(50)VARCHAR50
START_TIMENumber(5)MINUTES
END_TIMENumber(5)MINUTES
TIME_OR_AMOUNTNumber(18)AMT12V6
DISTRIBUTION_CODEVarchar2(50)DISTRIBUTION
REASON_FOR_TIMEVarchar2(2)X_REASON_FOR_TIME
REFERENCE_INFOVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TSS_IDNumber(10)ID link to P2K_TS_SHIFTS
TIME_SHEET_ENTRY_SOURCEVarchar2(2)X_TIME_SHEET_ENTRY_SOURCE
USE_ALTERNATE_TIME_CODEVarchar2(1)TOGGLE
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
AUTHORIZATION_STATUSVarchar2(2)X_AUTHORIZATION_STATUS
TRT_IDNumber(10)ID link to P2K_TS_TIME_RULE_TYPES
TIME_ALLOCATIONVarchar2(2)X_TIME_ALLOCATION
CHANGED_BY_PROCESSVARCHAR2(30) VARCHAR30
MANUAL_CHANGE_USERVARCHAR2(30) VARCHAR30

Derived Fields#

Column Name
DRV_AAL_SUMMARY
DRV_ENTRY_SUMMARY
DRV_PREMIUM_CODES
DRV_TIME_ALLOCATION_PERCENT

User Fields: Allowed
Audit Logging: Not Allowed

Notes #

Click to create a new notes page

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