Data Dictionary – HR Process Parameters (also called HR System Parameters)

Table Name: hrsp_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 names	Yes	hrtext255
object_type	nvarchar(5)	NULL	Object type (view, table and index etc)	No	hrcode
base_or_ext_flag	nvarchar(3)	NULL	Column base_or_ext_flag can have the following values only : 'B' when the objects are created internally, and 'E' when the objects are created externally.	No	hrflag

Table Name: hrsp_posnpref

Purpose:	System parameter for Position control on/off cases.
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
position_prefix	nvarchar(40)	NOT NULL	Unique Prefix Code used to generate Position Control ID.	Yes	HrParValue
start_value	nvarchar(40)	NULL	Contains the starting number from which the Position Control ID should be generated using the prefix code.	No
current_value	nvarchar(40)	NOT NULL	Stores the current value of the Position Control ID generated.	No
active_inactive_flag	nvarchar(1)	NULL	Contains values Y or N Y => the prefix code to generate Position Control ID is active N => the prefix code to generate Position Control ID is inactive	No	HrFlag
login_ou_code	int	NOT NULL	Login ou code	No	HrOuInstance

Table Name: hrsp_sysparam

Purpose:	This table stores System parameter information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
System_Param_Code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes	HrParCode
Owning_Component	nvarchar(50)	NULL	The component to which the parameter belongs.	No	HrCompDesc
priority	int	NULL	Priority of system parameter code	No	HrPriority
mandatory_flag	nvarchar(1)	NULL	Contains values Y => Yes or N => No Y => if the value for the parameter is mandatory. N => if the value for the parameter is not mandatory.	No	HrFlag
onetime_flag	nvarchar(1)	NULL	Contains values Y => Yes or N => No Y => if the parameter value can be set only once and cannot be modified. N => if the parameter value can be modified.	No

Table Name: hrsp_sysparam_comments

Purpose:	Comments for each system parameters will be stored in this table
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
login_language_code	int	NOT NULL	Language code through which the user is logged in.	Yes	HrLangCd
comments	nvarchar(2000)	NULL	Comments entered by the logged in user.	No	hrnotes
login_ou_code	int	NULL	Login OU code	No	HrOuInstance

Table Name: hrsp_sysparam_desc

Purpose:	This table stores the system parameters descriptions
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
System_parmeter_description	nvarchar(125)	NULL	Description of the Parameter.	No	HrParDesc
system_parameter_description_u	nvarchar(125)	NULL	Upper case of description of the Parameter.	No
language_code	int	NOT NULL	Language code in which the parameter is stored.	Yes	HrLangCd
system_param_code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes	HrParCode

Table Name: hrsp_sysparam_metaval_sys

Purpose:	This table stores the Meta values of system parameters, Which are possible values for the parameter.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
System_Param_Code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes
System_Param_Value	nvarchar(40)	NOT NULL	Value defined for the parameter.	Yes	HrParValue
Default_Flag	nvarchar(1)	NULL	Contains values Y or N Y => indicates system_Param_value is the default value for the parameter.	No	HrFlag

Table Name: hrsp_sysparam_qc

Purpose:

To store the system parameter quick codes

Column Name

Column Datatype

Column Null Option

Column Comment

Column Is PK

Column Domain Name

Quick_Code

nvarchar(5)

NOT NULL

Quick Code for system parameter values

Yes

HrQCodeSys

Table Name: hrsp_sysparam_qc_desc

Purpose:
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
language_code	int	NOT NULL	Language code in which quick code is stored.	Yes	HrLangCd
quick_code_description	nvarchar(40)	NOT NULL	Description for the quick code	No	HrParValue
quick_code	nvarchar(5)	NOT NULL	Quick Code.	Yes	HrQCodeSys

Table Name: hrsp_sysparam_values

Purpose:	This table stores the system parameters, Which is possible values and quick codes for the parameter.
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
System_Param_Code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes	HrParCode
System_Param_Value	nvarchar(40)	NOT NULL	Value defined for the parameter.	No	HrParValue
Quick_Code_Flag	nvarchar(1)	NOT NULL	Contains Values Y or N Y => the parameter value is from quick code. N => the parameter value is defined by user.	No	HrFlag
Login_OU_Code	int	NOT NULL	Login OU code	No	HrOuInstance

Table Name: hrsp_syspr_metavalqcr_sys

Purpose:	This table stores the Meta value Quick Codes of system parameters, Which is possible values for the parameter.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Quick_Code	nvarchar(5)	NOT NULL	Contains quick code values.	Yes	HrQCodeSys
Default_Flag	nvarchar(1)	NULL	Contains values Y or N Y => Quick_Code value is the default value for the parameter. N => if Quick_Code value is not the default value for the parameter.	No	HrFlag
System_Param_Code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes	HrParCode

Table Name: hrsp_vw_param_set_tmp

Purpose:	Temp table for System parameter set.
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	hrouid
sysparam_code	nvarchar(10)	NOT NULL	Unique ID to identify the Parameter Code.	Yes	HrParCode
component_name	nvarchar(20)	NOT NULL	Component to which the system parameter belongs.	Yes	hrcomponentcode
component_desc	nvarchar(40)	NULL	Description of the component.	No	hrcomponentdesc
sysparam_desc	nvarchar(125)	NULL	Description of system parameter.	No	HrParDesc
sysparam_value	nvarchar(40)	NULL	Contains the value defined for the system parameter.	No	HrParValue
guid	nvarchar(40)	NULL	Unique GUID generated on every session	No	hrguid