Data Dictionary – Security Definitions

Table Name: future_emp_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
master_ou_code	INT	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment Number	Yes	HrAssgnNo
assignment_defined_ou_code	INT	NOT NULL	Assignment defined OU code	Yes	HrOuInstance
assignment_effective_from_date	datetime	NOT NULL	Assignment Effective from date	Yes	Datetime
assignment_comments	nvarchar(2000)	NULL	Assignment comments	No	hrnotes
assignment_effective_to_date	datetime	NULL	Assignment Effective to date	No	Datetime
org_regltry_region_code	nvarchar(5)	NULL	Organisational regulatory region code	No	HrQuickCode
org_work_locn_code	nvarchar(5)	NULL	Organisational worklocation code	No	HrCode
org_business_unit_code	nvarchar(20)	NULL	Organisational business unit code	No	buid
dept_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job Code	No
job_grade_set_code	nvarchar(5)	NULL	Job grade set code	No	HrCode
job_grade_code	nvarchar(5)	NULL	Job grade code	No
sup_employee_code	nvarchar(20)	NULL	Supervisor employee code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_defined_ou_code	INT	NULL	Supervisor assignment defined code	No	HrOuInstance
gnmas_ou_code	INT	NULL	GNMAS ou code	No
orgst_ou_code	INT	NULL	Organisationa; OU code	No
unstr_ou_code	INT	NULL	Unit structure Code	No
hrchy_ou_code	INT	NULL	Hierarchy OU Code	No
sedef_ou_code	INT	NULL	Security Definition OU Code	No

Table Name: job_lvl_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	Yes
job_code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd
effective_from	datetime	NOT NULL	Effective from date	Yes	Datetime
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
sedef_ou_code	int	NOT NULL	Sequrity definition OU	Yes	hrouinstance
effective_to	datetime	NULL	Effective to date	No	Datetime
active_flag	nvarchar(3)	NULL	active flag	No	hrflag
job_lvl_code	int	NULL	Job level code	No	HrInt
job_lvl	int	NULL	Job level	No

Table Name: sedf_bpc_dls_dtl

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
secdef_ou	INT	NOT NULL	Security Definition Code	Yes	HrOuInstance
bpc_code	nvarchar(10)	NOT NULL	Business Process chain Code	Yes	hrcd
dls_flag	nvarchar(3)	NOT NULL	DLS (Data level security) flag on/off (Y/N)	Yes	hrflag

Table Name: sedf_bucket_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
master_ou_code	INT	NOT NULL	Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	Security Key	Yes	HrInt
process_flag	nvarchar(5)	NULL	Process Flag	No	HrCode

Table Name: sedf_dls_lang_parameters

Purpose:	Table to hold comments for the System Activity - Data Level Secuirty for a given login SEDEF OU Code and language.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
login_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
language_code	int	NOT NULL	Language Code.	Yes	hrlangcd
comments	nvarchar(2000)	NULL	Comments as entered.	No	hrnotes

Table Name: sedf_dls_parameters

Purpose:	Table to hold values for DLS ON/OFF and Default value for Span of control for every login SEDEF OU Code.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
login_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
dlsenabled_qccode	nvarchar(5)	NOT NULL	DLS ON/OFF having values Y/N respectively.	No	HrCode
level_of_span	int	NOT NULL	Default value for Indirect Span of control.Minimum value will be 0.	No	hrcheck

Table Name: sedf_emp_list_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
master_ou_code	INT	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
sup_employee_code	nvarchar(20)	NULL	Supervisor Employee Code	No
level_of_span	int	NULL	Level of span	No	HrInt

Table Name: sedf_group

Purpose:	Table to hold all the Groups defined for a login SEDEF OU Code and their status.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group code as entered.	Yes	hrcd
grp_active_flag	nvarchar(3)	NULL	Active/Inactive flag value as entered for an entered Group (values Y/N respectively).	No	hrflag
grp_rule	nvarchar(30)	NULL	Rule Name as entered.	No	hrformula

Table Name: sedf_grp_lang_dtl

Purpose:	Table to hold information such as Name, comments, etc for a defined group for a login SEDEF OU Code and language code.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group Code as entered.	Yes	hrcd
language_code	int	NOT NULL	Language Code.	Yes	hrlangcd
grp_short_desc	nvarchar(30)	NULL	Group Short Description as entered.	No	hrshortdesc12
u_grp_short_desc	nvarchar(30)	NULL	Group Short description in upper case.	No
grp_long_desc	nvarchar(80)	NULL	Group Long description as entered.	No	hrdesc40
u_grp_long_desc	nvarchar(80)	NULL	Group Long description in upper case.	No
comments	nvarchar(2000)	NULL	Comments as entered.	No	hrnotes

Table Name: sedf_grp_perm_lang_dtl

Purpose:	Table to Hold Comments for the activity "Define Security Group Permissions" for a given Login SEDEF OU Code, Group, Permissions To Combination and language.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group as selected.	Yes	hrcd
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
language_code	int	NOT NULL	Language Code	Yes	hrlangcd
comments	nvarchar(2000)	NULL	Comments as entered.	No	hrnotes

Table Name: sedf_grp_usr_act_dtl

Purpose:	Table to hold all User-Role-BPC combinations present in a entered group for a login SEDEF OU Code for whom permissions have been defined.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.
sedf_key	int	NOT NULL	SEDF Key generated by system for a given SEDEF OU Code-User -Role-BPC combination.
sec_group_code	nvarchar(10)	NOT NULL	Security Group code as entered.
active_inactive_flag	nvarchar(3)	NULL	Active/Inactive flag value as entered for a given SEDF key.
grp_based_basis_cd	nvarchar(5)	NULL	Basis for deriving the SEDF Key.Possible values are : DIRT - for Direct EXPN - for Exceptions RULE - For Rule

Table Name: sedf_grp_usr_exp_dtl

Purpose:	This table will store Security group - user exception details. In this table specified sedef key will be consided as exceptions for security refresh.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group code as entered.	Yes	hrcd
sedf_key	int	NOT NULL	SEDF Key generated by system for a given SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
active_inactive_flag	nvarchar(3)	NULL	Active/Inactive flag value as entered for a given SEDF key (values Y/N respectively).	No	hrflag
grp_based_basis_cd	nvarchar(5)	NULL	Basis for deriving the SEDF Key.Possible values are : DIRT - for Direct EXPN - for Exceptions RULE - For Rule	No	HrQuickCode

Table Name: sedf_grp_usr_perm_dtl

Purpose:	Table to hold Regular permissions (as entered) for a particular login SEDEF OU Code, Group and Permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group as selected.	Yes	hrcd
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
permission_serial_no	INT	NOT NULL	Running serial number generated by the system.	Yes	HrNumber
permitted_ei_ou_code	INT	NULL	Employment Unit OU Code as selected.-99 if ALL is selected.	No	HrOuInstance
department_code	nvarchar(10)	NULL	Department code as entered in the multiline.	No	hrcd
job_code	nvarchar(10)	NULL	Job code as entered in the multiline.	No
job_level_from	INT	NULL	Job Level From code as entered in the multiline.	No	HrPLevelCode
job_level_to	INT	NULL	Job Level To code as entered in the multiline.	No
grade_set_code	nvarchar(5)	NULL	Grade Set code as entered in the multiline.	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code as entered in the multiline.	No
work_loc_code	nvarchar(10)	NULL	Work Location code as entered in the multiline.	No	hrcd
business_unit_id	nvarchar(20)	NULL	Business Unit code as entered in the multiline.	No	buid
include_flag	nvarchar(5)	NULL	Include as selected in the multiline (Y/N).	No	HrQuickCode

Table Name: sedf_grp_usr_perm_hdr

Purpose:	Table to hold Header information (like type of permissions given) for a particular login SEDEF OU Code, Group and Permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sec_group_code	nvarchar(10)	NOT NULL	Security Group as selected.	Yes	hrcd
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
all_employee_basis	int	NULL	All employee basis value as selected: 0 if not Checked 1 if checked.	No	hrcheck
subordinate_basis	int	NULL	Subordinate basis value as selected: 0 if not Checked 1 if checked.	No
regular_basis	int	NULL	Regular basis value as selected : 0 if multiline data NOT entered 1 if multiline data entered	No
perm_rule	nvarchar(30)	NULL	Rule name as entered.	No	hrformula
exclude_self	int	NULL	Exclude Self value as selected : 0 if NOT selected 1 if selected	No	hrcheck
exception_basis	nvarchar(5)	NULL	Exception Basis value : 0 if not employees included as exceptions 1 if an employee is included as exception.	No	HrQuickCode
span_of_control	INT	NULL	Span of control as entered/default span of control.	No	HrNumber
login_ou_code	INT	NULL	Login Security Definitions OU Code.	No	HrOuInstance
login_language_code	int	NULL	Login Language code	No	hrlangcd

Table Name: sedf_key

Purpose:	Table to hold distinct SEDF keys for the login OU code for a given User Name, Role Name and Business Process Chain.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF key generated by system.	Yes	hrint
user_name	nvarchar(25)	NULL	User Name as entered/selected.	No	HrUserName
user_role_name	nvarchar(40)	NULL	User Role as entered/selected.	No	HrLoginRole
business_process_chain	nvarchar(128)	NULL	BPC value as entered/selected (from Quick Codes). BP - SEDF PV - BPCN	No	hrbusinessprocesschain

Table Name: sedf_key_num

Purpose:	Last SEDF key table for the login SEDEF OU Code.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key_last_no	int	NOT NULL	Last SEDF key generated by system.	No	hrint

Table Name: sedf_object_count

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
object_name	nvarchar(255)	NOT NULL	Object Name	Yes	hrtext255
object_type	nvarchar(5)	NULL	Object Type (Table, View and SP etc..)	No	HrCode
base_or_ext_flag	nvarchar(3)	NULL	Base or Customisation flag	No	hrflag

Table Name: sedf_perm_desc_dtl_tmp

Purpose:	Temporary table to store the regular permissions and their corresponding description.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
permission_serial_no	INT	NOT NULL	Permission serial Number	Yes	HrNumber
permitted_ei_ou_code	INT	NULL	Permitted OU code	No	HrOuInstance
permitted_ei_ou_desc	nvarchar(40)	NULL	Permitted OU description	No	hrorgunitdesc
department_code	nvarchar(10)	NULL	Department code	No	hrcd
dept_sdescription	nvarchar(30)	NULL	Department description	No	hrshortdesc12
job_code	nvarchar(10)	NULL	Job code	No	hrcd
job_desc	nvarchar(25)	NULL	Job description	No	hrjobtitle
job_level_from	INT	NULL	Job level From	No	HrPLevelCode
job_level_from_desc	nvarchar(30)	NULL	Job level from description	No	hrshortdesc12
job_level_to	INT	NULL	Job level to	No	HrPLevelCode
job_level_to_desc	nvarchar(30)	NULL	Job level to description	No	hrshortdesc12
grade_set_code	nvarchar(5)	NULL	Grade set Code	No	HrCode
grade_set_desc	nvarchar(30)	NULL	Grade set Code description	No	hrshortdesc12
grade_code	nvarchar(5)	NULL	Grade Code	No	HrCode
grade_desc	nvarchar(30)	NULL	Grade Code description	No	hrshortdesc12
work_loc_code	nvarchar(10)	NULL	Worklocation code	No	hrcd
work_loc_desc	nvarchar(30)	NULL	Worklocation code description	No	hrshortdesc12
business_unit_id	nvarchar(20)	NULL	Business Unit ID	No	buid
business_unit_desc	nvarchar(40)	NULL	Business Unit ID description	No	desc40
include_flag	nvarchar(5)	NULL	Include flag	No	HrQuickCode
include_desc	nvarchar(40)	NULL	Include Description	No	hrquickcodedesc

Table Name: sedf_refresh_permn_dtl

Purpose:	Table to hold all requests by particular login SEDEF OU Codes for refreshing the permissions for all the Users defined in the respective OU Code.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
process_serial_number	INT	NOT NULL	Running serial number generated by the system.	Yes	HrNumber
process_date	datetime	NOT NULL	Date when refresh was requested.	No	Datetime
process_status_flag	nvarchar(3)	NULL	Status of the Refresh.Possible values are : P - Pending I - Initialized C - Completed A - Aborted	No	hrflag
process_status_desc	nvarchar(25)	NULL	Status description	No	HrDescription

Table Name: sedf_reg_list_tmp

Purpose:	Temporary table to hold all the employee assignments, assignment parameters and their descriptions for a given SEDEF OU Code, SEDF key and permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	Yes	HrGuid
master_ou_code	int	NOT NULL	Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permission to	Yes	HrQuickCode
permitted_ng_ou_code	INT	NOT NULL	Permitted OU	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	int	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted OU	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignment effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignment effective to date	No
department_code	nvarchar(10)	NULL	department code	No	hrcd
job_code	nvarchar(10)	NULL	job code	No
job_level_code	int	NULL	job level code	No	hrint
grade_set_code	nvarchar(5)	NULL	gradeset code	No	HrCode
grade_code	nvarchar(5)	NULL	grade code	No
work_place_code	nvarchar(5)	NULL	worklocation code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business unit ID	No	buid
sup_employee_code	nvarchar(20)	NULL	supervisor employee code	No	HrEmpCode
sup_assignment_number	int	NULL	supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	supervisor assignment ou	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	permission basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	Security group code	No	hrcd

Table Name: sedf_sec_grp_rule_tmp

Purpose:	Temporary table to store all the derived SEDEF Key, employee code, etc combinations for an entered Rule (used in Groups).
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
user_name	nvarchar(25)	NOT NULL	Username	Yes	HrUserName
user_role_name	nvarchar(40)	NOT NULL	User Role name	Yes	HrLoginRole
business_process_chain	nvarchar(128)	NOT NULL	BPC for the Quickcode	Yes	hrbusinessprocesschain
sec_group_code	nvarchar(10)	NULL		No	hrcd
basis_code	nvarchar(5)	NULL	Basis Code	No	HrQuickCode
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
employee_name	nvarchar(77)	NULL	Name of the employee	No	hrempname
user_status	nvarchar(40)	NULL	User Status	No	hryesno
user_status_desc	nvarchar(25)	NULL	User Status description	No	HrDescription
business_process_code	nvarchar(5)	NULL	Business Process code	No	HrQuickCode
sedf_key	int	NULL	Security definition key	No	hrint

Table Name: sedf_sub_fullexp_tmp

Purpose:	Temporary table used to populate with all employee assignments when Subordinate permissions are given.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
guid	VARCHAR(40)	NOT NULL	Unique GUID generated on every session	Yes	HrGuid
slno	INT	NOT NULL	Serial Number	Yes	HrInt
master_ou_code	INT	NULL	Interacting Master OU code	No	HrOuInstance
permitted_ng_ou_code	int	NULL	Permitted OU	No
employee_code	VARCHAR(10)	NULL	Employee Code	No	HrEmpCode
assignment_number	INT	NULL	Assignment number	No	HrAssgnNo
permitted_ei_ou_code	INT	NULL	Perrmitted OU Code	No	HrOuInstance
sup_employee_code	VARCHAR(10)	NULL	Supervisor employee code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_defined_ou_code	INT	NULL	Supervisor assignment OU code	No	HrOuInstance
assignment_eff_from_date	datetime	NULL	Assignment from date of an employee	No	Datetime
assignment_eff_to_date	datetime	NULL	Assignment To date of an employee	No

Table Name: sedf_usr_BuntId_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Unique GUID generated on every session	No	HrOuInstance
sedf_key	int	NOT NULL	Security Definiton Key	No	hrint
permission_to	nvarchar(5)	NOT NULL	Permission To	No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	Permitted OU	No	HrOuInstance
work_loc_code	nvarchar(10)	NOT NULL	Worklocation code	No	hrcd
department_code	nvarchar(10)	NULL	Department Code	No
business_unit_id	nvarchar(20)	NOT NULL	Business Unit code	No	buid
guid	nvarchar(40)	NOT NULL		No	HrGuid

Table Name: sedf_usr_dept_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	No	HrOuInstance
sedf_key	int	NOT NULL	Security Definiton Key	No	hrint
permission_to	nvarchar(5)	NOT NULL	Permission To	No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	No	HrOuInstance
work_loc_code	nvarchar(10)	NOT NULL	Worklocation Code	No	hrcd
department_code	nvarchar(10)	NOT NULL	Department code	No
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid

Table Name: sedf_usr_emp_exceptn_dtl

Purpose:	Table to hold all employee assignments added through exception and all employee assignments to whom permissions have been changed (Inactive or Permissions Till Date) for a given Login SEDEF OU Code, SEDF Key and Permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF Key generated by system for the selected SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from quick codes). BP - SEDF PV - PERT	Yes	HrQuickCode
exception_serial_no	INT	NOT NULL	Running Serial number generated by the system.	Yes	HrNumber
permitted_ng_ou_code	INT	NULL	EMPNG OU Code from Employee Assignment for the entered/selected employee assignment.	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code as entered/selected employee assignment.	No	HrEmpCode
assignment_number	INT	NULL	Assignment Number as entered/selected employee assignment.	No	HrAssgnNo
permitted_ei_ou_code	INT	NULL	EMPIN OU Code from Employee Assignment for the entered/selected employee assignment.	No	HrOuInstance
assignment_nature_flag	nvarchar(3)	NULL	Assignment nature flag for entered/selected Employee Assignment.	No	hrflag
permission_till_date	datetime	NULL	Permissions Till date as entered.	No	Datetime
permission_basis_code	nvarchar(5)	NULL	Permissions Basis flag derived by system from Quick Codes. BP - SEDF PV - PEBS REGL - for Regular basis ALL - For ALL Basis REMP - Subordinate Basis RULE - Rule basis AEAX - Exception basis	No	HrQuickCode
active_flag	nvarchar(3)	NULL	Active/Inactive Flag (Y/N) as selected.	No	hrflag

Table Name: sedf_usr_emp_exceptn_dtl_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Intearcting Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	Security Definition key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	Permission To	Yes	HrQuickCode
exception_serial_no	INT	NOT NULL	serial number	Yes	HrNumber
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
permitted_ng_ou_code	INT	NULL	Permitted OU code	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	INT	NULL	Assignment Number	No	HrAssgnNo
permitted_ei_ou_code	INT	NULL	Permitted OU code	No	HrOuInstance
assignment_nature_flag	nvarchar(3)	NULL	Employee Assignment nature flag	No	hrflag
permission_till_date	datetime	NULL	Permission till date	No	Datetime
permission_basis_code	nvarchar(5)	NULL	Permission basic code	No	HrQuickCode
active_flag	nvarchar(3)	NULL	Active flag	No	hrflag

Table Name: sedf_usr_emp_execptn_dtl_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	Security Key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	Permission to	Yes	HrQuickCode
exception_serial_no	INT	NOT NULL	serial number	Yes	HrNumber
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NULL	Permitted ou	No	HrOuInstance
employee_code	nvarchar(20)	NULL	Employee Code	No	HrEmpCode
assignment_number	INT	NULL	Assignment number	No	HrAssgnNo
permitted_ei_ou_code	INT	NULL		No	HrOuInstance
assignment_nature_flag	nvarchar(3)	NULL	Assignment nature flag	No	hrflag
permission_till_date	datetime	NULL	Permission till date	No	Datetime
permission_basis_code	nvarchar(5)	NULL	Permission basis code	No	HrQuickCode
active_flag	nvarchar(3)	NULL	Active falg	No	hrflag

Table Name: sedf_usr_full_explode_add_reg

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted employee induction OU code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignement effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignement effective to date	No
department_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job code	No
grade_set_code	nvarchar(5)	NULL	Gradeset code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_place_code	nvarchar(5)	NULL	workloaction code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment ou	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	permission basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	Security group code	No	hrcd

Table Name: sedf_usr_full_explode_all

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted employee induction OU code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignement effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignement effective to date	No
department_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job code	No
grade_set_code	nvarchar(5)	NULL	Gradeset code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_place_code	nvarchar(5)	NULL	workloaction code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment ou	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	permission basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	Security group code	No	hrcd

Table Name: sedf_usr_full_explode_dtl

Purpose:	Table to hold the Permissions List (all employee assignments) for a given login SEDEF OU Code, SEDF Key and permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF Key generated by system for the selected SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	GUID as generated by system.	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	EMPNG OU Code from Employee Assignment for the employee assignment.	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Permitted employee code.	Yes	HrEmpCode
assignment_number	int	NOT NULL	Permitted assignment Number.	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted EMPIN OU Code.	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Permitted assignment effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Permitted assignment effective to date	No
department_code	nvarchar(10)	NULL	Employee assignment's department code	No	hrcd
job_code	nvarchar(10)	NULL	Employee assignment's Job code	No
grade_set_code	nvarchar(5)	NULL	Employee assignment's Grade Set code	No	HrCode
grade_code	nvarchar(5)	NULL	Employee assignment's Grade code	No
work_place_code	nvarchar(5)	NULL	Employee assignment's Work Location code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Employee assignment's Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Employee assignment's Supervisor code.	No	HrEmpCode
sup_assignment_number	int	NULL	Employee assignment's Supervisor assignment number.	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment’s EMPIN OU Code.	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	The basis through which the employee is permitted.Possible values are : (values derived from Quick Codes BP - SEDF PV - PEBS) REGL - for Regular basis ALL - For ALL Basis REMP - Subordinate Basis RULE - Rule basis AEAX - Exception basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	Security Group code if the SEDF Key is there in a Group.	No	hrcd

Table Name: sedf_usr_full_explode_exc

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	Security Key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	Permission To	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment OU code	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted Employee Induction OU Code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignment Effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignment Effective to date	No
department_code	nvarchar(10)	NULL	Department Code	No	hrcd
job_code	nvarchar(10)	NULL	Job Code	No
grade_set_code	nvarchar(5)	NULL	Grade set code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_place_code	nvarchar(5)	NULL	Worklocation code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Supervisor employee code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment defined OU	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	Permission basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	security group code	No	hrcd

Table Name: sedf_usr_full_explode_reg_add

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted employee induction OU code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignement effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignement effective to date	No
department_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job code	No
grade_set_code	nvarchar(5)	NULL	Gradeset code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_place_code	nvarchar(5)	NULL	workloaction code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment ou	No	HrOuInstance

Table Name: sedf_usr_full_explode_reg_rem

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted employee induction OU code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignement effective from date	Yes	Datetime
assignment_eff_to_date	datetime	NULL	Assignement effective to date	No
department_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job code	No
grade_set_code	nvarchar(5)	NULL	Gradeset code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_place_code	nvarchar(5)	NULL	workloaction code	No	HrQuickCode
business_unit_id	nvarchar(20)	NULL	Business Unit code	No	buid
sup_employee_code	nvarchar(20)	NULL	Supervisor Employee Code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
sup_assignment_def_ou_cd	INT	NULL	Supervisor assignment ou	No	HrOuInstance
permission_basis	nvarchar(5)	NULL	permission basis	No	HrQuickCode
sec_group_code	nvarchar(10)	NULL	Security group code	No	hrcd

Table Name: sedf_usr_jbgrstgd_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	No	HrOuInstance
sedf_key	int	NOT NULL	Security Definiton Key	No	hrint
permission_to	nvarchar(5)	NOT NULL	Permission To	No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	No	HrOuInstance
job_level	INT	NULL	Job level	No	HrPLevelCode
job_code	nvarchar(10)	NOT NULL	Job code	No	hrcd
grade_set_code	nvarchar(5)	NOT NULL	grade set code	No	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code	No
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid

Table Name: sedf_usr_joblvl_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	No	HrOuInstance
sedf_key	int	NOT NULL	Security Key	No	hrint
permission_to	nvarchar(5)	NOT NULL	Permission To	No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	No	HrOuInstance
work_loc_code	nvarchar(10)	NOT NULL	Worklocation code	No	hrcd
department_code	nvarchar(10)	NULL	Department code	No
business_unit_id	nvarchar(20)	NOT NULL	Business Unit Code	No	buid
job_level	INT	NULL	Job level	No	HrPLevelCode
job_code	nvarchar(10)	NOT NULL	Job code	No	hrcd
grade_set_code	nvarchar(5)	NOT NULL	Grade set code	No	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code	No
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session.	No	HrGuid

Table Name: sedf_usr_perm_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
			Unique GUID generated on every session	Yes
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	Yes	HrOuInstance
master_ou_code_orgst	INT	NOT NULL	Interacting organisational Master OU code	No
master_ou_code_untst	INT	NOT NULL	Interacting Master OU code	No

Table Name: sedf_usr_perm_hdr_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Master OU code	Yes
sedf_key	int	NOT NULL	Security Key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	Permission To	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID is generated on every session	Yes	HrGuid
all_employee_basis	INT	NULL	All Employee Basis	No	Hrcheck
subordinate_basis	INT	NULL	All Employee subordinate Basis	No
regular_basis	INT	NULL	Regular basis	No
sp_rule	nvarchar(30)	NULL	Rule for SP	No	hrformula
exclude_self	INT	NULL	Exclude self	No	Hrcheck
exception_basis	INT	NULL	Exception basis	No
span_of_control	INT	NULL	Span of control	No	HrNumber
login_ou_code	INT	NULL	Login OU code	No	HrOuInstance
login_language_code	INT	NULL	Language Code	No	HrLangCd

Table Name: sedf_usr_perm_lang_dtl

Purpose:	Table to Hold Comments for the activity "Define User Permissions on Employees" for a given Login SEDEF OU Code, SEDF Key, Permissions To Combination and language.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF Key generated by system for the selected SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from quick codes). BP - SEDF PV - PERT	Yes	HrQuickCode
language_code	int	NOT NULL	Language code.	Yes	hrlangcd
comments	nvarchar(2000)	NULL	Comments as entered.	No	hrnotes

Table Name: sedf_usr_permission_dtl

Purpose:	Table to hold Regular permissions (as entered) for a particular login SEDEF OU Code, SEDDF key and Permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF Key generated by system for the selected SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
permission_serial_no	INT	NOT NULL	Running serial number generated by the system	Yes	HrNumber
permitted_ei_ou_code	INT	NULL	Employment Unit OU Code as selected.-99 if ALL is selected.	No	HrOuInstance
department_code	nvarchar(10)	NULL	Department code as entered in the multiline.	No	hrcd
job_code	nvarchar(10)	NULL	Job code as entered in the multiline.	No
job_level_from	INT	NULL	Job Level From code as entered in the multiline.	No	HrPLevelCode
job_level_to	INT	NULL	Job Level To code as entered in the multiline.	No
grade_set_code	nvarchar(5)	NULL	Grade Set code as entered in the multiline.	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code as entered in the multiline.	No
work_loc_code	nvarchar(10)	NULL	Work Location code as entered in the multiline.	No	hrcd
business_unit_id	nvarchar(20)	NULL	Business Unit code as entered in the multiline.	No	buid
include_flag	nvarchar(5)	NULL	Include as selected in the multiline (Y/N).	No	HrQuickCode

Table Name: sedf_usr_permission_dtl_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	Yes	HrOuInstance
sedf_key	int	NOT NULL	Security Code	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	Permission to	Yes	HrQuickCode
permission_serial_no	INT	NOT NULL	Permission serial number	Yes	HrNumber
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ei_ou_code	INT	NULL	Permitted OU	No	HrOuInstance
department_code	nvarchar(10)	NULL	Department code	No	hrcd
job_code	nvarchar(10)	NULL	Job Code	No
job_level_from	INT	NULL	Job level From	No	HrPLevelCode
job_level_to	INT	NULL	Job level to	No
grade_set_code	nvarchar(5)	NULL	Grade set code	No	HrCode
grade_code	nvarchar(5)	NULL	Grade code	No
work_loc_code	nvarchar(10)	NULL	Worklocation code	No	hrcd
business_unit_id	nvarchar(20)	NULL	Business Unit ID	No	buid
include_flag	nvarchar(5)	NULL	Include flag	No	HrQuickCode

Table Name: sedf_usr_permission_hdr

Purpose:	Table to hold Header information (like type of permissions given) for a particular login SEDEF OU Code, SEDDF key and Permissions To combination.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Login Security Definitions OU Code.	Yes	HrOuInstance
sedf_key	int	NOT NULL	SEDF Key generated by system for the selected SEDEF OU Code-User -Role-BPC combination.	Yes	hrint
permission_to	nvarchar(5)	NOT NULL	Permissions To value as selected (from Quick Codes). BP - SEDF PV - PERT	Yes	HrQuickCode
all_employee_basis	int	NULL	All employee basis value as selected: 0 if not Checked 1 if checked.	No	hrcheck
subordinate_basis	int	NULL	Subordinate basis value as selected: 0 if not Checked 1 if checked.	No
regular_basis	int	NULL	Regular basis value as selected : 0 if multiline data NOT entered 1 if multiline data entered	No
sp_rule	nvarchar(30)	NULL	Rule name as entered.	No	hrformula
exclude_self	int	NULL	Exclude Self value as selected : 0 if NOT selected 1 if selected	No	hrcheck
exception_basis	int	NULL	Exception Basis value: 0 if not employees included as exceptions 1 if an employee is included as exception.	No
span_of_control	INT	NULL	Span of control as entered/default span of control.	No	HrNumber
login_ou_code	INT	NULL	Login SEDEF OU Code.	No	HrOuInstance
login_language_code	int	NULL	Login Language Code.	No	hrlangcd

Table Name: sedf_usr_semexpno

Purpose:

Table not used - was use for semi explosion.

Column Name

Column Datatype

Column Null Option

Column Comment

Column Is PK

Column Domain Name

location

int

NULL

Location Number

hrint

Table Name: sedf_usr_semi_exp_map

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
permission_to	nvarchar(5)	NOT NULL	Permission TO	Yes	HrQuickCode
location	int	NOT NULL	Loaction	Yes	hrint
sedf_key	int	NOT NULL	Security Definiton key	Yes
master_ou_code	INT	NOT NULL	Interating Master OU code	Yes	HrOuInstance

Table Name: sedf_usr_semi_explode_dtl

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
location	int	NOT NULL	Location	Yes	hrint
master_ou_code	INT	NOT NULL	Interacting Master OU code	No	HrOuInstance
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	No
department_code	nvarchar(10)	NOT NULL	Department code	No	hrcd
job_code	nvarchar(10)	NOT NULL	Job Code	No
job_level	INT	NOT NULL	Job Level	No	HrPLevelCode
grade_set_code	nvarchar(5)	NOT NULL	Grade set Code	No	HrCode
grade_code	nvarchar(5)	NOT NULL	Grade code	No
work_place_code	nvarchar(5)	NOT NULL	Worklocation code	No	HrQuickCode
business_unit_id	nvarchar(20)	NOT NULL	Business Unit ID	No	buid

Table Name: sedf_usr_semiexp_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	%AttDef	No	HrOuInstance
sedf_key	int	NOT NULL		No	hrint
permission_to	nvarchar(5)	NOT NULL		No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	%AttDef	No	HrOuInstance
work_loc_code	nvarchar(10)	NOT NULL	%AttDef	No	hrcd
department_code	nvarchar(10)	NULL		No
business_unit_id	nvarchar(20)	NOT NULL		No	buid
job_level	INT	NULL		No	HrPLevelCode
job_code	nvarchar(10)	NOT NULL	%AttDef	No	hrcd
grade_set_code	nvarchar(5)	NOT NULL		No	HrCode
grade_code	nvarchar(5)	NOT NULL		No
guid	nvarchar(40)	NOT NULL		No	HrGuid

Table Name: sedf_usr_wl_dtl_tmp

Purpose:	Table not used - was use for semi explosion.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting Master OU code	No	HrOuInstance
sedf_key	int	NOT NULL	Security Definiton Key	No	hrint
permission_to	nvarchar(5)	NOT NULL	Permission To	No	HrQuickCode
permitted_ei_ou_code	INT	NOT NULL	Permitted OU code	No	HrOuInstance
work_loc_code	nvarchar(10)	NOT NULL	Worklocation Code	No	hrcd
guid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	No	HrGuid

Table Name: span_tmp

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted Ou code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted ou code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignment effective from date	Yes	Datetime
sup_code	nvarchar(20)	NULL	Supervisor code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
span_level	int	NULL	Span level	No	HrInt

Table Name: span_tmp1

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Interacting master ou code	Yes	HrOuInstance
sedf_key	int	NOT NULL	security key	Yes	HrInt
permission_to	nvarchar(5)	NOT NULL	permission to	Yes	HrQuickCode
guid	nvarchar(40)	NOT NULL	Unique GUID	Yes	HrGuid
permitted_ng_ou_code	INT	NOT NULL	Permitted Ou code	Yes	HrOuInstance
employee_code	nvarchar(20)	NOT NULL	Employee Code	Yes	HrEmpCode
assignment_number	INT	NOT NULL	Assignment number	Yes	HrAssgnNo
permitted_ei_ou_code	INT	NOT NULL	Permitted Ou code	Yes	HrOuInstance
assignment_eff_from_date	datetime	NOT NULL	Assignment effective from date	Yes	Datetime
sup_code	nvarchar(20)	NULL	Supervisor code	No	HrEmpCode
sup_assignment_number	INT	NULL	Supervisor assignment number	No	HrAssgnNo
span_level	int	NULL	Span level	No	HrInt