Data Dictionary – Unit Structure

Table Name: head_count_temp

Purpose:	This table is used to store the intermediary results of the View Head Count report activity.
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Hrguid	nvarchar(40)	NOT NULL	Unique GUID generated on every session	Yes	hrguid
hrposncode	nvarchar(10)	NOT NULL	Position code	Yes	hrposncode
hrjobcd	nvarchar(10)	NOT NULL	Job code	Yes	hrcd
hrgradesetcode	nvarchar(5)	NOT NULL	Gradeset Code	Yes	hrcode
hrgradecode	nvarchar(5)	NOT NULL	Grade code	Yes
fte	numeric(5,2)	NULL	Full time Equivalent	No	hrratio
no_of_posts	int	NULL	Number of positions	No	hrnoofposts
posnctl_onoff_flag	nvarchar(1)	NULL	Position control flag ( on or off)	No	hrflag
position_title	nvarchar(25)	NULL	Position title	No	hrpositiontitle
grade_sdescription	nvarchar(30)	NULL	Grade short description	No	hrshortdesc12
gset_sdescription	nvarchar(30)	NULL	Grade set short description	No
dept_sdescription	nvarchar(80)	NULL	department short description	No	hrdesc40
dept_code	nvarchar(10)	NULL	Department code	No	hrcd
job_title	nvarchar(25)	NULL	Job title	No	hrjobtitle
budget_count	numeric(5,2)	NULL	Budget Count	No	hrratio
actual_count	numeric(5,2)	NULL	Actual Count	No
is_assgn	nvarchar(1)	NULL	If YES means assignment exists NO - Assignment does not exists.	No	hrflag

Table Name: utst_cmpy_weights_temp

Purpose:	Competency and position weightage temp table
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Guid	nvarchar(40)	NOT NULL	This is the temporary table used for storing the competency weight Global unique identifier	No	hrguid
position_code	nvarchar(10)	NULL	Position Code	No	HrPosnCode
competency_code	nvarchar(10)	NOT NULL	competency Code	No	hrcompcode
element_code	nvarchar(10)	NOT NULL	Competency element code	No	hrelementcode
class_code	nvarchar(10)	NOT NULL	Competency Class code	No	hrclasscode
competency_short_desc	nvarchar(100)	NULL	Competency Short description	No	HrDescription100
competency_weightage	numeric(15,4)	NOT NULL	Competency weightage	No	hrsalary
competency_weightage_per	numeric(15,4)	NULL	Competency weightage percentage	No
competency_weightage_sum	numeric(5,0)	NOT NULL	competency weightage sum	No	hrelementwt
temp_weightage	int	NULL	Temporary weightage	No	hrint
MapYes_No	nvarchar(40)	NULL	Map (Yes/No)	No	hrquickcodedesc
MapFlag	nvarchar(5)	NULL	Map flag	No	hrquickcode
SequenceNo	int	NULL	Sequence No	No	hrint

Table Name: UTST_DocumentID_Gen

Purpose:

To keep maximum id of Workflow document Id

Column Name

Column Datatype

Column Null Option

Column Comment

Column Is PK

Column Domain Name

MaxDoc_Id

int

NOT NULL

Maximum Document ID

Yes

Table Name: UTST_EmpUnit_TEMP

Purpose:	Temp table for Position and employment unit
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Empin_ou_code	int	NOT NULL	This table is used to store the temporary information whether the competency defined for the Employment Unit	Yes	hrouinstance
guid	nvarchar(40)	NOT NULL	Global unique identifier	Yes	hrguid
Position_Code	nvarchar(10)	NULL	position Code	No	hrposncode
mode_flag	nvarchar(1)	NULL	Mode flag is used if he has selected any rows	No	hrflag
Comp_def	nvarchar(40)	NULL	Competency defined (Yes or No)	No	hryesno

Table Name: UTST_Job

Purpose:	Different jobs in the organization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	hrouinstance
Job_Code	nvarchar(10)	NOT NULL	Job Code - User Entry	Yes	hrcd
Applicable_To_Flag	nvarchar(5)	NULL	This flag may be 'A','E','S' A - All OUs E - Existing OUs S - Selective OUs	No	hrquickcode
job_cost_type	nvarchar(5)	NULL	Direct and Indirect are sample values loaded. Values from user defined quick codes. Business process code 'UTST' Process variable code 'JCTP' These values can be used in the element account mapping screen - for capturing the account code for posting for the element (along with gradeset and grade)	No

Table Name: UTST_Job_Compy

Purpose:	The competencies required for the job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Job_Code	nvarchar(10)	NOT NULL	Job Code - User Entry	Yes	hrcd
Compy_MDL	int	NULL	MDL of the competency	No	HrCompmdl
compy_wt	int	NULL	Competency Weightage	No	hrcompwt
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	hrouinstance
Compy_Code	nvarchar(10)	NOT NULL	Competency Code which is assigned to this OU & Job	Yes	hrcompcode
EMPIN_OU_Code	int	NOT NULL	Employement Unit Code	Yes	hrouinstance

Table Name: UTST_Job_desc

Purpose:	The description of various jobs
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
U_Job_Desc	nvarchar(80)	NULL	the job description in uppercase	No	hrdesc40
Job_Desc	nvarchar(80)	NULL	the job description	No
U_Job_Title	nvarchar(25)	NULL	The title of job in upper case (for faster search)	No	hrjobtitle
Medical_Reqmts	nvarchar(255)	NULL	the medical requirements	No	hrremarks
SIC	nvarchar(100)	NULL	SIC	No	description
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd
Master_OU_Code	int	NOT NULL	Unit structure Master Ou Code	Yes	hrouinstance
Job_Title	nvarchar(25)	NULL	The title of job	No	hrjobtitle
Effective_To	datetime	NOT NULL	Effective To date	No	Datetime
Effective_From	datetime	NOT NULL	The start date	Yes
Lang_Id	int	NOT NULL	Language Id	Yes	HrLangCd

Table Name: UTST_Job_Dtls_Eff

Purpose:	The date dependent properties of job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Std_Hrs_UOM_Code	nvarchar(5)	NULL	Standard hours Unit of measurement code BP Code UTST PV Code STDU	No	hrquickcode
SalHr_Flag_Code	nvarchar(5)	NULL	salaried / Hourly Flag BP Code UTST PV Code SALH	No
Std_Hrs	numeric(6,2)	NULL	Standard hours	No	hrshours
Work_Condn_Code	nvarchar(5)	NULL	Work Condition code BP Code UTST PV Code WCON	No	hrquickcode
Work_Comp_Code	nvarchar(40)	NULL	Work Compensation code	No	hrquickcodedesc
Tipped_Flag	nvarchar(1)	NULL	Tipped Flag Y/N	No	hrflag
Mobile_Flag	nvarchar(1)	NULL	Indicates if the job involves traveling or otherwise 1- Travel 0 - Not Travel	No
Work_Exp	int	NULL	Work experience	No	hrmonthsexp
Medical_Check_Flag	nvarchar(1)	NULL	Medical Check Flag Value Y/N	No	hrflag
Work_Exp_UOM_Code	nvarchar(5)	NULL	work experience Unit of measurement code BP Code UTST PV Code WKEU	No	hrquickcode
FLSA	nvarchar(5)	NULL	Fair Labor Standards Act	No
Effective_From	datetime	NOT NULL	Effective from date	Yes	Datetime
Effective_To	datetime	NULL	Effective To date	No
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd
Master_OU_Code	int	NOT NULL	Unit structure - Master OU code	Yes	hrouinstance
Job_Class_Code	nvarchar(5)	NULL	Job Class code BP Code UTST PV Code JOBC	No	hrquickcode
Job_Family_Code	nvarchar(5)	NULL	Bp Code - UTST PV Code - JOBF	No
EEO_Class_Code	nvarchar(5)	NULL	EEO(Equal employment Opportunity Class Code BP Code UTST PV Code EEOC	No
Active_Flag	nvarchar(1)	NULL	Active Flag (Y/N)	No	hrflag
Job_Lvl_Code	int	NULL	job level code	No	hrint
Position_Control_Flag	nvarchar(1)	NULL	whether position is OFF/ ON for the Job	No	hrflag

Table Name: UTST_Job_Grade

Purpose:	The different grades applicable for the job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Grade_Set_Code	nvarchar(5)	NOT NULL	Grade Set Code from ORG Structure	Yes	hrcode
Grade_Code	nvarchar(5)	NOT NULL	Grade Code from ORG Structure	Yes
Effective_To	datetime	NOT NULL	Effective To date	No	Datetime
Master_OU_Code	int	NOT NULL	Unit Structure OU Code	Yes	hrouinstance
Effective_From	datetime	NOT NULL	Effective From date	Yes	Datetime
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd

Table Name: UTST_Job_Level

Purpose:	Different job levels in the organization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	HrOUInstance
Job_Lvl_Code	int	NOT NULL	Job Level Code- this will not be stored as entered by the user, Internally a number is generated based on a formula	Yes	hrint

Table Name: UTST_Job_Profile

Purpose:	The profile of the job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Profile_Id	int	NOT NULL	Profile Id - Quick Code	Yes
Lang_Id	int	NOT NULL	Language Id	Yes	hrlangcd
Effective_To	datetime	NOT NULL	Effective to date	No	Datetime
Job_Profile	nvarchar(75)	NULL	Job Profile	No	hressfuncjob
Master_OU_Code	int	NOT NULL	Unit Structure OU Code	Yes	hrouinstance
Effective_From	datetime	NOT NULL	Effective From date	Yes	Datetime
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd

Table Name: UTST_Job_Qualfn

Purpose:	The qualifications required to perform the job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Qualfn_Code	nvarchar(5)	NOT NULL	Qualification - Quick Code	Yes	hrquickcode
Mandatory_Flag	nvarchar(5)	NULL	Mandatory Flag - Yes/No	No
Priority	int	NULL	Order of Importance	No	hrint
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	hrouinstance

Table Name: UTST_Job_Terms

Purpose:	The terms and conditions of the job
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Valid_To	datetime	NULL	The Term entered is valid till this date	No	Datetime
Valid_From	datetime	NULL	The Term entered is valid from this date	No
Currency_Code	nvarchar(5)	NULL	Currency Code for the Security Deposit & Amount	No	hrquickcode
Security_Deposit	numeric(15,4)	NULL	Security Deposit	No	hrsalary
Amount	numeric(15,4)	NULL	Amount for the terms & condition(bonds)	No
Job_Code	nvarchar(10)	NOT NULL	Job Code	Yes	hrcd
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	hrouinstance
Period	varchar(25)	NULL	Period Description	No	HrDescription
Term_Id	int	NOT NULL	Term & Condition ID	Yes	hrint
Term_Code	nvarchar(5)	NULL	Quick Code from GNMAS	No	hrquickcode

Table Name: UTST_JobLvl_Desc

Purpose:	The job level desc in different languages
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes	HrOUInstance
Job_Lvl_Code	int	NOT NULL	Job Level Code	Yes	hrint
Lang_ID	int	NOT NULL	Language id in which descriptions are stored	Yes	HrLangCd
Joblvl_Shrt_Desc	nvarchar(30)	NULL	Job Level Short Description.	No	hrshortdesc12
U_Joblvl_Shrt_Desc	nvarchar(30)	NULL	Upper case of Job Level Short descriptions. This will be used in search criteria.	No
Joblvl_Long_Desc	nvarchar(80)	NULL	Job Level Long Description.	No	hrdesc40
U_Joblvl_Long_Desc	nvarchar(80)	NULL	Upper case of Job Level Long descriptions. This will be used in search criteria.	No
Comments	nvarchar(2000)	NULL	Job Level Comments	No	hrnotes

Table Name: UTST_JobOU_Map

Purpose:	The jobs and applicable OUs
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Job_Code	nvarchar(10)	NOT NULL	Job Code - User Entry	Yes	hrcd
EMPIN_OU_Code	int	NOT NULL	Applicable OU for the JOB code	Yes	hrouinstance
Master_OU_Code	int	NOT NULL	Unit Structure OU	Yes

Table Name: UTST_nonbasic_budget_dtl

Purpose:	Pay grid detail table to store non basic elements for budget
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_ou_code	int	NOT NULL	Stores the Master Ou Code.	Yes
empin_ou	int	NOT NULL	Empin Ou Code	Yes	hrouid
dept_code	nvarchar(10)	NOT NULL	Department Code	Yes	hrcd
serial_no	int	NOT NULL	Serial Number (Hidden field in the Multiline)	Yes	hrint
Pyrlprd_Start_Date	datetime	NOT NULL	Payroll Period Start Date.	No	Datetime
Payelement_Code	nvarchar(10)	NULL	Payelement Code	No	hrcd
Amount	numeric(15,4)	NULL	Amount	No	hrsalary
Comments	nvarchar(255)	NULL	Comments	No	hrtext255

Table Name: UTST_nonbasic_budget_hdr

Purpose:	Pay grid header table to store non basic elements for budget
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Stores the Master Ou Code.	Yes	hrouinstance
empin_ou	int	NOT NULL	EMPIN Ou Code	Yes	hrouid
dept_code	nvarchar(10)	NOT NULL	Department Code	Yes	hrcd
comments	nvarchar(255)	NULL	Comments	No	hrtext255

Table Name: UTST_Object_Count

Purpose:	Object count table for Unit Structure Component
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Object_Name	nvarchar(255)	NOT NULL	Object Name	Yes
Object_Type	nvarchar(5)	NULL	Object type (tables, views, index, etc..)	No	hrcode
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.	No	hrflag

Table Name: UTST_paygrid_dtl

Purpose:	Pay grid detail table to store the department wise salary information for budget purpose
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Parttime	int	NULL	Number of Part time Employees	No	hrint3
fulltime	int	NULL	Number of Full time Employees	No
Level_Code	nvarchar(5)	NOT NULL	Stores the Level Code	Yes	hrcode
budget	numeric(15,4)	NULL	Stores the Budget for the Level	No	hrnumeric15
FTE	numeric(7,2)	NULL	Full Time Equivalent	No	hrnoofunits
salary_per_week	numeric(15,4)	NULL	Stores the Salary Per week	No	hrsalary
Comments	nvarchar(255)	NULL	Stores the Comments.	No	hrtext255
empin_ou	int	NOT NULL	Stores the Employment Unit Code.	Yes	hrouid
master_ou_code	int	NOT NULL	Stores the Masterou Code	Yes	HrOUInstance
Grade_Code	nvarchar(5)	NOT NULL	Stores the Grade Code	Yes	hrcode
Position_Code	varchar(10)	NOT NULL	Stores the Position Code	Yes	HrPosnCode
dept_code	nvarchar(10)	NOT NULL	Stores the Department Code	Yes	hrcd
effective_from_date	datetime	NOT NULL	Stores the Effective From date	Yes	Datetime

Table Name: UTST_paygrid_hdr

Purpose:	Pay grid header table to store the department wise salary information for budget purpose
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
master_ou_code	int	NOT NULL	Stores the Master Ou Code of the employee	Yes	HrOUInstance
empin_ou	int	NOT NULL	Stores the Empin Ou Code of the Employee	Yes	hrouid
dept_code	nvarchar(10)	NOT NULL	Stores the Department Code	Yes	hrcd
effective_from_date	datetime	NOT NULL	Stores the Effective From date	Yes	Datetime
effective_to_date	datetime	NOT NULL	Stores the Effective To date	No
status	nvarchar(5)	NULL	Stores the Record Status	No	hrquickcode
comments	nvarchar(255)	NULL	Stores the Information on Comment Column in UI	No	hrtext255

Table Name: UTST_paygrid_tmp

Purpose:	Pay grid temp table for calculation
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Guid	nvarchar(40)	NOT NULL	Guid generated for the session.	Yes	hrguid
Position_Code	varchar(10)	NOT NULL	Stores the POsition COde	Yes	HrPosnCode
Grade_Code	nvarchar(5)	NOT NULL	Stores the Grade Code	Yes	hrcode
Level_Code	nvarchar(5)	NOT NULL	Stores the Level Code	Yes
fulltime	int	NULL	Number of Full time Employees	No	hrint3
parttime	int	NULL	Number of Part time Employees	No
FTE	numeric(7,2)	NULL	Full Time Equivalent	No	hrnoofunits
salary_per_week	numeric(15,4)	NULL	Stores the Salary Per week	No	hrsalary
budget	numeric(15,4)	NULL	Stores the Budget for the Level	No	hrnumeric15
Comments	nvarchar(255)	NULL	Stores the Comments.	No	hrtext255

Table Name: UTST_PosnCtl

Purpose:	Note: OFF scenario- The position code is stored in position Control Id ON scenario- The position Conrol id in Position Control Id field and its position code in position code field The attribute PosnCtl_ONOFF wiil say whether position control is on or Off
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master OU	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Controlid contains both position Code (For Off Scenario) and Position control ID ( For On Scenario)	Yes	HrPosnCode
PosnCtl_ONOff_Flag	nvarchar(1)	NOT NULL	Contains value 'Y' if it is position ise to Yes else 'N'	No	hrflag
Position_Code	nvarchar(10)	NULL	position Code - Off scenario	No	HrPosnCode
MaxDoc_Id	int	NULL	It is used for workflow purposes. Position On scenario.	No	hrint
MaxSeq_Id	int	NULL	Maximum sequence id used for generating the maximum number for authorization remarks.	No
no_of_posts	int	NULL	Number of Position for the Position Control	No	hrnoofposts

Table Name: UTST_PosnCtl_Auth

Purpose:	The position Control authorisation details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
AuthRej_Flag	nvarchar(1)	NULL	Contains the value A or R	No	hrflag
Sequence_Id	int	NOT NULL	a sequence no generation	Yes	hrint
Auth_User_Code	nvarchar(10)	NULL	the user code who is authorizing or aRejecting	No	hrusercode
Auth_Date	datetime	NULL	On which date it was Authorized or Rejected.	No	Datetime
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code	Yes	HrOUInstance
Effective_From	datetime	NOT NULL	Effective from date	Yes	Datetime
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position control Id	Yes	HrPosnCode

Table Name: UTST_PosnCtl_Auth_H

Purpose:	Position control authorisation details before final authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
AuthRej_Flag	varchar(1)	NULL	authorization / Reject Flag	No	HrFlag
Auth_User_Code	varchar(10)	NOT NULL	The use code who is authorizing or rejecting	No	HrUserCode
Auth_Date	datetime	NULL	The date on which it was authorized or rejectd	No	Datetime
Sequence_Id	int	NOT NULL	Sequence ID	Yes	hrint
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Master_OU_Code	int	NOT NULL	Unit structure Mater Ou code	Yes	HrOUInstance

Table Name: UTST_PosnCtl_Auth_Rem

Purpose:	Authorisation remarks in different languages
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Sequence_Id	int	NOT NULL	A sequence number	Yes	hrint
Language_Id	int	NOT NULL	Language Code	Yes	hrlangcd
Auth_Remarks	nvarchar(255)	NULL	Remarks	No	hrremarks
Master_OU_Code	int	NOT NULL	Unit Structure- Master Ou Code	Yes	HrOUInstance
Effective_From	datetime	NOT NULL	Effective from date	Yes	Datetime
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position control Id	Yes	HrPosnCode

Table Name: UTST_PosnCtl_Auth_Rem_H

Purpose:	Authorisation remarks in different languages before final authorization
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_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Auth_Remarks	varchar(4000)	NULL	Authorized remarks	No	hrnotes
Lang_Id	int	NOT NULL	Language ID	Yes	hrlangcd
Sequence_Id	int	NOT NULL	Sequence ID	Yes	hrint

Table Name: UTST_PosnCtl_Compy

Purpose:	the competencies required for position/position control id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID contains both position code (Off) position control Id (On)	Yes	HrPosnCode
EMPIN_OU_Code	int	NOT NULL	Employment Unit code	Yes	HrOUInstance
Compy_Code	nvarchar(10)	NOT NULL	Competency Code	Yes	hrcompcode
Compy_MDL	int	NULL	Competency Minimum desired level	No	hrcompmdl
Compy_Wt	numeric(15,4)	NULL	Competency weight	No	hrsalary
Mandatory_Flag	nvarchar(5)	NULL	Mandatory Flag contains (Y or N)	No	hrquickcode

Table Name: UTST_PosnCtl_Compy_H

Purpose:	the competencies required for position/position control id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Compy_MDL	int	NULL	Competency Minimum desired level	No	hrcompmdl
Compy_Code	nvarchar(10)	NOT NULL	Competency Code	Yes	hrcompcode
Compy_Wt	int	NULL	Competency weight	No	hrcompwt
Mandatory_Flag	nvarchar(5)	NULL	Mandatory Flag	No	hrquickcode
Master_OU_Code	int	NOT NULL	Unit structure Master OU Code	Yes	HrOUInstance
EMPIN_OU_Code	int	NOT NULL	Employment Unit Code	Yes
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode

Table Name: UTST_PosnCtl_Desc

Purpose:	The position/position control id title/desc details
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
U_Job_Title	nvarchar(25)	NULL	Upper case job title	No	hrjobtitle
Job_Title	nvarchar(25)	NULL	Job title	No
U_Position_Desc	nvarchar(80)	NULL	Upper case position description	No	hrdesc40
SIC	nvarchar(100)	NULL	SIC No	No	description
Job_Desc	nvarchar(80)	NULL	Job description	No	hrdesc40
Medical_Reqmts	nvarchar(255)	NULL	Medical requirements	No	hrremarks
Comments	nvarchar(2000)	NULL	Comments for position control	No	hrnotes
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control id (On)or Position code(Off)	Yes	HrPosnCode
Effective_From	datetime	NOT NULL	Effective from date	Yes	Datetime
Master_OU_Code	int	NOT NULL	Unit structure- Master Ou Code	Yes	HrOUInstance
Position_Desc	nvarchar(80)	NULL	Position description	No	hrdesc40
U_Position_Title	nvarchar(25)	NULL	Upper case position title for oracle	No	hrpositiontitle
Lang_Id	int	NOT NULL	Language code	Yes	hrlangcd
Position_Title	nvarchar(25)	NULL	Position Title	No	hrpositiontitle

Table Name: UTST_PosnCtl_Eff

Purpose:	The date dependent attributes of position/control id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID contains position code (Off) and Position control ID(On)	Yes	HrPosnCode
Effective_From	datetime	NOT NULL	Effective from	Yes	Datetime
Effective_To	datetime	NULL	Effective To	No
Active_Flag	nvarchar(1)	NULL	Active flag Y - active N - In active	No	hrflag
no_of_posts	int	NULL	Number of Posts for the position	No	hrnoofposts
Dept_Code	nvarchar(10)	NOT NULL	Department code	No	hrcd
Job_Code	nvarchar(10)	NOT NULL	Job Code	No
Rgltry_Region_Code	nvarchar(5)	NULL	Regulatory Region code BP Code - UTST PV Code - RERE	No	hrquickcode
EMPIN_OU_Code	int	NULL	Employment Unit code	No	hrouinstance
Work_Locn_Code	nvarchar(5)	NULL	Work location code	No	hrquickcode
Business_Unit	nvarchar(20)	NULL	Business unit code	No	buid
Rptng_Posn_Code	nvarchar(10)	NULL	Reporting Position Code	No	HrPosnCode
RegTemp_Flag	nvarchar(5)	NULL	BP Code - UTST PV Code - RETM	No	hrquickcode
FTE	numeric(5,2)	NULL	Full time Equivalent	No	hrratio
FullPart_Time_Flag	nvarchar(5)	NULL	BP Code UTST PV Code - FTPT	No	hrquickcode
Grade_Set_Code	nvarchar(30)	NULL	Grade set code	No	hrshortdesc12
Grade_Code	nvarchar(30)	NULL	Grade Code	No
Work_Condn_Code	nvarchar(5)	NULL	BP Code - UTST PV Code - WCON	No	hrquickcode
Work_Comp_Code	nvarchar(40)	NULL	Work Compensation Code	No	hrquickcodedesc
Std_Hrs	numeric(6,2)	NULL	Standard hours	No	hrshours
Std_Hrs_UOM_Code	nvarchar(5)	NULL	BP Code UTST PV Code - STDU	No	hrquickcode
SalHr_Flag_Code	nvarchar(5)	NULL	BP Code UTST PV Code SALH	No
Work_Exp	int	NULL	Work experience	No	hrmonthsexp
Work_Exp_UOM_Code	nvarchar(5)	NULL	Work experience UNit of measurement of code BP Code UTST PV Code WKEU	No	hrquickcode
Medical_Check_Flag	nvarchar(1)	NULL	Medical Check Flag	No	hrflag
Tipped_Flag	nvarchar(1)	NULL	Tipped Flag	No
Mobile_Flag	nvarchar(1)	NULL	Indicates if the job involves traveling or otherwise 1- Travel 0 - Not Travel	No
Rqst_Mod_Flag	int	NULL	Request Mode flag (Y/ N)	No	hrcheck
Document_Id	varchar(40)	NULL	Document Id	No	String
FLSA	nvarchar(5)	NULL	Fair Labor Standards Act	No	hrquickcode
Doc_state	varchar(40)	NULL	Pending or authorized	No	String
Doc_No	int	NULL	Document Number	No	hrint

Table Name: UTST_PosnCtl_Eff_Desc

Purpose:	The date dependent, Multilanguage enabled attributes of position /control Id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
U_Job_Title	nvarchar(25)	NULL	Upper Job Title	No	hrjobtitle
Job_Desc	nvarchar(80)	NULL	Job description	No	hrdesc40
Job_Title	nvarchar(25)	NULL	Job title	No	hrjobtitle
U_Position_Desc	nvarchar(80)	NULL	Upper Position description	No	hrdesc40
Comments	nvarchar(2000)	NULL	Comments	No	hrnotes
Medical_Reqmts	nvarchar(255)	NULL	Medical Requirements	No	hrremarks
SIC	nvarchar(100)	NULL	SIC	No	description
Effective_To	datetime	NOT NULL	Effective to date	No	Datetime
Master_OU_Code	int	NOT NULL	Unit Structure - Master Ou Code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Lang_Id	int	NOT NULL	Language Id	Yes	hrlangcd
Position_Desc	nvarchar(80)	NULL	Position Description	No	hrdesc40
U_Position_Title	nvarchar(25)	NULL	Upper Position title for Oracle	No	hrpositiontitle
Effective_From	datetime	NOT NULL	Effective From	No	Datetime
Position_Title	nvarchar(25)	NULL	Position Title	No	hrpositiontitle

Table Name: UTST_PosnCtl_H

Purpose:	The position control Id information before authorization
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Effective_From	datetime	NOT NULL	Effective from Date	No	Datetime
Position_Code	nvarchar(10)	NULL	Position Code	No	HrPosnCode
Active_Flag	nvarchar(1)	NULL	Active Flag (Y or N)	No	hrflag
Effective_To	datetime	NULL	Effective To date	No	Datetime
Auth_Init_Flag	nvarchar(3)	NULL	Authorizor Initiated flag whether authorization is over or not	No	HrFlag
Auth_Status_Code	varchar(5)	NULL	Pending for authorisation Authorised Rejected	No	hrquickcode
Modfn_Code	varchar(5)	NULL	Modification Code C or U	No
Request_type	nvarchar(5)	NULL	Request for edit Request for change	No
Dept_Code	varchar(10)	NOT NULL	Department code	No	hrcd
Job_Code	varchar(10)	NOT NULL	Job Code	No
Rgltry_Region_Code	varchar(5)	NULL	Regulatory Region Code BP Code UTST PV Code RERE	No	hrquickcode
Empin_OU_Code	int	NULL	Employment unit code	No	HrOUInstance
Work_Location_Code	varchar(5)	NULL	Work location Code	No	hrquickcode
Business_Unit	nvarchar(20)	NULL	Business unit code	No	buid
Rptng_Posn_Code	nvarchar(10)	NULL	Reporting Position Code	No	HrPosnCode
RegTemp_Flag	nvarchar(5)	NULL	regular and temporary BP Code UTST PV Code RETM	No	hrquickcode
FTE	numeric(5,2)	NULL	Full time Equivalent	No	hrratio
FullPart_Time_Flag	nvarchar(5)	NULL	Full or part time BP Code - UTST PV Code - FTPT	No	hrquickcode
Grade_Set_Code	nvarchar(30)	NULL	Grade set code	No	hrshortdesc12
Grade_Code	nvarchar(30)	NULL	Grade Code	No
Work_Condn_Code	nvarchar(5)	NULL	Work condition Code BP Code UTST PV Code WCON	No	hrquickcode
Work_Comp_Code	nvarchar(40)	NULL	Work compensation code	No	hrquickcodedesc
Std_Hrs	numeric(6,2)	NULL	Standard Hours	No	hrshours
Std_Hrs_UOM_Code	nvarchar(5)	NULL	Standard hours BP Code UTST PV Code	No	hrquickcode
SalHr_Flag_Code	nvarchar(5)	NULL	Salaried Hourly Flag Code	No
Work_Exp	int	NULL	Work experience	No	hrmonthsexp
Work_Exp_UOM_Code	nvarchar(5)	NULL	Work experience UOM Code BP Code UTST PV Code WKEU	No	hrquickcode
Medical_Check_Flag	nvarchar(1)	NULL	Medical Flag Value (Y or N)	No	hrflag
Tipped_Flag	nvarchar(1)	NULL	Tipped Flag Y/ N	No
Mobile_Flag	nvarchar(1)	NULL	Indicates if the job involves traveling or otherwise 1- Travel 0 - Not Travel	No
NewEffective_From	datetime	NOT NULL	New effective from date	No	Datetime
Document_Id	varchar(40)	NULL	Document ID	No	String
Rqst_Mod_Flag	int	NULL	Request Mode flag U- Update C- Correct	No	hrcheck
Flsa	nvarchar(5)	NULL		No	hrquickcode
Doc_state	varchar(40)	NULL	Document State Pending Authorized	No	String
Doc_No	int	NULL	Document NO	No	hrint
temp_flag	nvarchar(1)	NULL	Temporary Flag	No	hrflag

Table Name: UTST_PosnCtl_Profile

Purpose:	The profiles of position control id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Lang_Id	int	NOT NULL	Language code	Yes	HrLangCd
Profile_Id	int	NOT NULL	Profile id- a sequence number	Yes	hrint
Job_Profile	nvarchar(75)	NULL	Job Profile	No	hressfuncjob
Master_OU_Code	int	NOT NULL	Unit structure - Mater Ou Code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Effective_From	datetime	NOT NULL	Effective from date	Yes	Datetime

Table Name: UTST_PosnCtl_Profile_H

Purpose:	The position control id profile details
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_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Job_Profile	nvarchar(75)	NULL	Job profile	No	hressfuncjob
Profile_Id	int	NOT NULL	profile ID a Sequence No	Yes	hrint
Lang_Id	int	NOT NULL	Language ID	Yes	HrLangCd

Table Name: UTST_PosnCtl_Qualfn

Purpose:	The qualifications required for position control
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code	Yes	HrOUInstance
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position control Id contains Position code (Off) and position control Id(On)	Yes	HrPosnCode
Qualfn_Code	nvarchar(5)	NOT NULL	Qualification code	Yes	hrquickcode
Mandatory_Flag	nvarchar(5)	NULL	mandatory Flag - Y or N	No
Priority	int	NULL	a sequence number	No	hrint

Table Name: UTST_PosnCtl_Qualfn_H

Purpose:	The qualifications required for position control
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Qualfn_Code	nvarchar(5)	NOT NULL	Qualification Code	Yes	hrquickcode
Mandatory_Flag	nvarchar(5)	NULL	Mandatory Flag	No
Priority	int	NULL	It is a sequence no generated , the way we entered the qualification code .	No	hrint
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control ID	Yes	HrPosnCode
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code	Yes	HrOUInstance

Table Name: UTST_Recd_Auth_Post_Dtl

Purpose:	Authorize Position Detail 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
year_code	varchar(5)	NOT NULL	Year Code	Yes	hrquickcode
sl_no	int	NOT NULL	Serial Number	Yes	hrint
position_code	nvarchar(10)	NULL	Position Code	No	hrposncode
department_code	nvarchar(5)	NULL	Department code	No	hrcd
Quater1	int	NULL	First Quarter	No	hrint
Quater2	int	NULL	Second Quarter	No
Quater3	int	NULL	Third Quarter	No
Quater4	int	NULL	Fourth Quarter	No

Table Name: UTST_Recd_Auth_Post_Hdr

Purpose:	Authorize Position Header table for the year
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
year_code	varchar(5)	NOT NULL	Year Code	Yes	hrquickcode

Table Name: UTST_Temp

Purpose:	Temp table for Position control id
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Master_OU_Code	int	NOT NULL	Unit structure - Master Ou Code This table is used for generating the position control id	Yes	hrouinstance
Position_Code	nvarchar(10)	NOT NULL	Position code	Yes	HrPosnCode
Position_Ctl_Id	nvarchar(10)	NOT NULL	Position Control Id	Yes
Guid	nvarchar(40)	NOT NULL	Global Unique identifier	Yes	hrguid
Position_Title	nvarchar(25)	NULL	Position Title	No	hrpositiontitle

Table Name: UTST_tree_temp

Purpose:	Temp table to process Position Hierarchy
Column Name	Column Datatype	Column Null Option	Column Comment	Column Is PK	Column Domain Name
Srno	int	NULL	Serial No	No	hrint
ParentId	nvarchar(10)	NULL	Parent Id (Position Code)	No	HrPosnCode
ParentDesc	nvarchar(80)	NULL	Parent Position Description	No	hrdesc40
ChildId	nvarchar(10)	NULL	Child Id (Position Code)	No	HrPosnCode
ChildDesc	nvarchar(80)	NULL	Child Position Description	No	hrdesc40
guid	nvarchar(40)	NULL	Guid Key	No	hrguid
Reg_Temp_Parent	nvarchar(40)	NULL	Parent Position Temp field	No	hrquickcodedesc
Reg_temp_Child	nvarchar(40)	NULL	Child Position Temp field	No
Maxhead_parent	int	NULL	Maximum head count of employee for the parent position	No	hrnumber
Maxhead_child	int	NULL	Maximum head count of employee for the child position	No
Currhead_parent	nvarchar(80)	NULL	Current head count of employee for the parent position	No	hrdesc40
CurrHead_child	int	NULL	Current head count of employee for the Child position	No	hrnumber
Depdesc_parent	nvarchar(30)	NULL	Department description for parent position employee	No	hrshortdesc12
DepDesc_child	nvarchar(30)	NULL	Department description for child position employee	No
Jobdesc_parent	nvarchar(80)	NULL	Job description for parent position employee	No	hrdesc40
JobDesc_child	nvarchar(80)	NULL	Job description for child position employee	No
Comname_parent	nvarchar(80)	NULL	Company Name for parent position employee	No
Comname_child	nvarchar(80)	NULL	Company Name for child position employee	No
Position_headcd_parent	nvarchar(20)	NULL	Parent position employee code	No	hrempcode
Position_headcd_child	nvarchar(20)	NULL	child position employee code	No
Position_head_parent	nvarchar(77)	NULL	Parent position employee code	No	hrempname
Position_head_child	nvarchar(77)	NULL	Child position employee code	No
Photo_parent	nvarchar(255)	NULL	Parent position employee code photo	No	hrtext255
Photo_child	nvarchar(255)	NULL	Child position employee code photo	No