table - cmn_rota_roster «Roster»

Derivation Hierarchy

cmn_rota_roster
«Roster»

Global

Subclasses:: No Subclasses
Siblings:: No Siblings

Table Details

Name:: cmn_rota_roster
Label:: Roster (en)

Created On:: 2022.09.17 02:25:21
Created By:: system

Updated On:: 2022.09.17 02:55:01
Updated By:: system

Column Updated On:: 2022.09.17 02:25:21
Column Updated By:: system

Scope Name:: Global
Scope:: global

Listing:: open
Dictionary:: open

Columns

Status	Name	Label	Datatype	Length	Scope	Reference	Included By
	active	Active	boolean	40	Global		cmn_rota_roster
M	attempts	Number of reminders	integer	40	Global		cmn_rota_roster
	dow_for_rotate	Day of week for rotation	integer[choice]	40	Global		cmn_rota_roster
	forced_communication_channel	Forced communication channel	string[choice]	40	Global		cmn_rota_roster
	last_reminder_time	Last reminder time	glide_date_time	40	Global		cmn_rota_roster
M D	name	Name	string	80	Global		cmn_rota_roster
	order	Order	integer	40	Global		cmn_rota_roster
	reminder_lead_time	Reminder lead time (days)	integer	40	Global		cmn_rota_roster
M	rota	Shift	reference	32	Global	cmn_rota	cmn_rota_roster
	rotation_all_day	All day rotation	boolean	40	Global		cmn_rota_roster
	rotation_interval_count	Rotate every	repeat_count	40	Global		cmn_rota_roster
M	rotation_interval_type	Rotation interval	string[choice]	40	Global		cmn_rota_roster
M	rotation_start_date	Rotation start date	integer_date	40	Global		cmn_rota_roster
	rotation_start_dow	Start rotation on	string[choice]	40	Global		cmn_rota_roster
	rotation_start_time	Rotation start time	integer_time	40	Global		cmn_rota_roster
	send_reminders	Send on-call reminders	boolean	40	Global		cmn_rota_roster
	sys_created_by	Created by	string	40	Global		cmn_rota_roster
	sys_created_on	Created	glide_date_time	40	Global		cmn_rota_roster
K	sys_id	Sys ID	GUID	32	Global		cmn_rota_roster
	sys_mod_count	Updates	integer	40	Global		cmn_rota_roster
	sys_updated_by	Updated by	string	40	Global		cmn_rota_roster
	sys_updated_on	Updated	glide_date_time	40	Global		cmn_rota_roster
	time_before_escalation	Time before escalation	glide_duration	40	Global		cmn_rota_roster
M	time_between_reminders	Time between reminders	glide_duration	40	Global		cmn_rota_roster

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Referenced

cmn_rota_roster referenced from table:: cmn_rota, cmn_rota_esc_step_def, cmn_rota_member, on_call_add_member, on_call_escalation_level, on_call_remove_member, on_call_swap_member, roster_schedule_span, st_on_call_hour, v_alternate_rotation, v_on_call, v_rotation, v_user_rotation

Diagram cmn_rota_roster «Roster» / Global (global)

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out