Data Dictionary – Employee Code Setup

Table Name: secp_citizenship_cmts

Table Name: secp_citizenship_dtls

Purpose:	This table stores the information about the citizenship details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Employee Number generation Org Unit for which citizenship identification details are being defined	Yes
country_code	nvarchar(5)	NOT NULL	Country code for Citizenship	Yes	countrycode
language_code	int	NOT NULL	Language code for this record	Yes	HrLangCd
cit_literal_value	nvarchar(80)	NULL	Label for Citizenship Identification Number to be used in Personal Information	No	hrdesc40
ct_idn_fmt	nvarchar(25)	NULL	Format for citizenship identification number to be used in Personal Information	No	hrdescription
login_ou_code	INT	NULL	Login ou code for the record	No	HrOuInstance

Table Name: secp_emplpref

Purpose:	Employee Code control table stores starting, current value for employee code series
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Employee Number generation Org Unit for which details are being defined	Yes
employee_prefix	nvarchar(40)	NOT NULL	Prefix to be used for Employee Number generation in Personal Information	Yes	HrParValue
start_value	nvarchar(40)	NULL	Start Value for the prefix in case the number generation scheme is 'Automatic'	No
current_value	nvarchar(40)	NOT NULL	Current Value for the prefix which will be automatically incremented whenever an employee code is generated in Personal Information.	No
active_inactive_flag	nvarchar(3)	NULL	Flag 'Y' indicates prefix is 'Active' Flag 'N' indicated prefix is 'In Active'	No	HrFlag
login_ou_code	int	NOT NULL	Login ou for the record	No	HrOuInstance

Table Name: secp_object_count

Purpose:	Employee Code setup component object count table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
object_name	nvarchar(255)	NOT NULL	Object Name
object_type	nvarchar(5)	NULL	Object type (Table, View and Index etc..)
base_or_ext_flag	nvarchar(1)	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.

Table Name: secp_setparam_comments

Table Name: secp_sysparam

Purpose:	Stores Metadata information for Employee Number Generation
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
System_Param_Code	nvarchar(10)	NOT NULL	System Parameter Code	Yes	HrParCode
Priority	int	NOT NULL	Priority ( 1,2,3...)	No	HrPriority

Table Name: secp_sysparam_desc

Purpose:	Stores Metadata information for Employee Number Generation. System parameter description Information
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
System_Param_Code	nvarchar(10)	NOT NULL	System Parameter Code	Yes	HrParCode
Language_Code	int	NOT NULL	Language Code ( 1 for English)	Yes	HrLangCd
System_Parmeter_Description	nvarchar(125)	NULL	System parameter description	No	HrParDesc
U_System_Parmeter_Description	nvarchar(125)	NULL	Upper case of System parameter description	No

Table Name: secp_sysparam_qc

Purpose:

Stores Metadata information for Employee Number Generation

Column Name

Column Datatype

Column Null Option

Column Comment

Column Is PK

Column Domain Name

quick_code

varchar(5)

NOT NULL

Quick Code

Yes

HrQCodeSys

Table Name: secp_sysparam_qc_desc

Purpose:	Stores Metadata information for Employee Number Generation
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Language_Code	int	NOT NULL	Language Code ( 1 for English)	Yes	HrLangCd
Quick_Code_Description	varchar(40)	NOT NULL	Quick code description	No	HrParValue
Quick_code	varchar(5)	NOT NULL	Quick Code	Yes	HrQCodeSys

Table Name: secp_sysparam_values

Purpose:	Stores Metadata information for Employee Number Generation Detail table
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	System parameter Codes: PIEMPLEN -- Employee code length(Value) PIENUM --- Number generation scheme(Automatic/Manual) PIEPFX -- Prefix Applicable or not (Yes/NO) PIEPFXLEN -- prefix length (value)	Yes	HrParCode
quick_code_flag	nvarchar(3)	NULL	Flag may be NULL or 'Y' If the system parameter value is a quick code flag will be stored as 'Y' If the system parameter value is a 'value' flag will be stored as NULL	No	HrFlag
System_Param_Value	nvarchar(40)	NOT NULL	System Parameter value	No	HrParValue
Login_OU_Code	int	NOT NULL	Login OU code	No	HrOuInstance

Table Name: secp_syspr_metavalqcr_sys

Purpose:	Stores Metadata information for Employee Number Generation
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
quick_code	varchar(5)	NOT NULL	Quick Code	Yes	HrQCodeSys
Default_Flag	varchar(1)	NULL	Flag	No	HrFlag
System_Param_Code	nvarchar(10)	NOT NULL	System param code	Yes	HrParCode

Table Name: secp_user_employee_hdr

Purpose:	User employee mapping table. In this table we can have one employee can be mapped multiple user in different period
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	INT	NOT NULL	Employee Number generation Org Unit for which User Employee mapping is being done	Yes	HrOuInstance
user_name	nvarchar(25)	NOT NULL	Valid rvw login user name	Yes	HrUserName
employee_code	varchar(10)	NOT NULL	Employee Code for user employee mapping	Yes	hrempcode
mapped_from_date	datetime	NOT NULL	Date from which User name is mapped to the specific employee code	No	Datetime
mapped_till_date	datetime	NULL	Date till which User name is mapped to the specific employee code.	No
login_ou_code	INT	NULL	Login ou for the record	No	HrOuInstance

Table Name: secp_user_employee_hdr_tmp

Purpose:	User - Employee mapping header temp table.
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
User_Name	nvarchar(25)	NOT NULL	Valid UserName of an employee	Yes	HrUserName
Employee_Code	varchar(10)	NOT NULL	Employee Code	Yes	hrempcode
Mapped_From_Date	datetime	NOT NULL	Mapped from date	No	Datetime
Mapped_Till_Date	datetime	NULL	Mapped to date	No
Login_OU_Code	INT	NULL	Login OU code	No	HrOuInstance
Guid	nvarchar(40)	NULL	Unique GUID generated on every session	No	hrguid

Table Name: secp_useremp_comments

Purpose:	User employee mapping comments table.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
login_ou_code	int	NOT NULL	Employee Login OU code	Yes	HrOuInstance
language_code	int	NOT NULL	Language Code of an employee (1 for English)	Yes
uemap_comments	nvarchar(2000)	NULL	Comments	No	hrnotes