Wiki: TABLES-TS

Table Name	Alias	Description
P2K_TS_ALLOWED_CLOCK_DEVICES	TACD
P2K_TS_ALLOWED_DEPARTMENTS	TADP	Allowed Departments
P2K_TS_ALLOWED_DISTRIBUTIONS	TADS	Allowed Distributions
P2K_TS_ALLOWED_WORK_LOCATIONS	TAWL
P2K_TS_AUTHORIZED_JOBS	TAJ	Authorized Jobs
P2K_TS_CALL_LOGS	TLG	Call Logs
P2K_TS_CLOCK_CARDS	TCC	Clock Cards
P2K_TS_CLOCK_CARD_DETAILS	TCCD	Clock Card Details
P2K_TS_CLOCK_DEVICES	TCD	Clock Devices
P2K_TS_CLOCK_ENTRIES	TCE	Clock Entries
P2K_TS_EVENT_SITES	TES	Event Sites
P2K_TS_LEAVE_REQUESTS	TLR
P2K_TS_LEAVE_REQUEST_PERIODS	TLRP
P2K_TS_REPLACEMENT_JOBS	TRJ	Replacement Jobs
P2K_TS_SCHEDULED_SHIFTS	TSH
P2K_TS_SCHEDULERS	TSD
P2K_TS_SHIFTS	TSS	Shifts
P2K_TS_SHIFT_DETAILS	TSSD	Shift Details
P2K_TS_SHIFT_PATTERNS	TSP	Shift Patterns
P2K_TS_SHIFT_PATTERN_DETAILS	TSPD	Shift Pattern Details
P2K_TS_SHIFT_RULES	TSSR	Shift Rules
P2K_TS_SHIFT_SEQUENCED_DAYS	TSQD
P2K_TS_SHIFT_SEQUENCES	TSQ
P2K_TS_SHIFT_TIME_SLOTS	TSST	Shift Time Slots
P2K_TS_STATION_POSTS	TWSP	Station Posts
P2K_TS_STATION_REQUIREMENTS	TSR	Station Requirements
P2K_TS_TEAM_POSTS	TTP	Team Posts
P2K_TS_TEAM_POST_DETAILS	TTPD	Team Post Details
P2K_TS_TIME_BATCHES	TBT	Time Batches
P2K_TS_TIME_ENTRIES	TTE	Time Entries
P2K_TS_TIME_EXCEPTIONS	TTX	Time Exceptions
P2K_TS_TIME_EXCEPTION_CONTROLS	TTXT
P2K_TS_TIME_RULES	TRL	Time Rules
P2K_TS_TIME_RULE_TYPES	TRT	Time Rule Types
P2K_TS_WORKERS	TWO
P2K_TS_WORKER_DETAILS	TWOD
P2K_TS_WORK_AREAS	TWA	Work Areas
P2K_TS_WORK_AREA_DETAILS	TWAD	Work Area Details
P2K_TS_WORK_DIVISIONS	TWD	Work Divisions
P2K_TS_WORK_DIVISION_DETAILS	TWDD	Work Division Details
P2K_TS_WORK_REQUIREMENTS	TWR
P2K_TS_WORK_RESTRICTIONS	TRE	Work Restrictions
P2K_TS_WORK_STATIONS	TWS	Work Stations
P2K_TS_WORK_STATION_DETAILS	TWSD	Work Station Details
P2K_TS_WORK_STATION_SHIFTS	TWSS	Work Station Shifts
P2K_TS_WORK_TEAMS	TWT	Work Teams

Notes #

Click to create a new notes page