Wednesday, June 25, 2014

OTL Tables

HXT_HOLIDAY_CALENDARS
ID            
ELEMENT_TYPE_ID
NAME          
ORGANIZATION_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE    

HXT_HOLIDAY_DAYS_VL
ID            
HCL_ID        
HOLIDAY_DATE
HOURS         
NAME

HXT_SHIFTS
ID                    
NAME                  
HOURS                 
STANDARD_START        
STANDARD_STOP         
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE    
EARLY_START
LATE_STOP     
CODE                   
DESCRIPTION           

HXT_WEEKLY_WORK_SCHEDULES_FMV
ID                    
NAME                  
BUSINESS_GROUP_ID
START_DAY             
MEANING               
DATE_FROM             
DESCRIPTION            

 HXT_WORK_SHIFTS_FMV
SHT_ID        
TWS_ID        
WEEK_DAY      
MEANING       
SEQ_NO        
EARLY_START
LATE_STOP     
OFF_SHIFT_PREM_ID     
SHIFT_DIFF_OVRRD_ID

HXT_ROTATION_PLANS
ID
NAME
DATE_FROM
DESCRIPTION

HXT_ROTATION_SCHEDULES
RTP_ID        
TWS_ID        
START_DATE

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect