Table Name: AC_Mdl_AC_Model_Definition
|
Purpose: |
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
mdl_ouinstance |
integer |
NOT NULL |
|
Yes |
UDD_Ctxt_OUInstance | |
|
mdl_model_no |
VARCHAR(20) |
NOT NULL |
|
Yes |
UDD_Model | |
|
mdl_ac_make |
VARCHAR(45) |
NOT NULL |
|
No |
UDD_Make | |
|
mdl_ac_type |
VARCHAR(25) |
NOT NULL |
|
No |
UDD_QuickCodes | |
|
mdl_description |
VARCHAR(150) |
NOT NULL |
|
No |
UDD_Txt1501 | |
|
mdl_status |
VARCHAR(15) |
NOT NULL |
|
No |
UDD_DocStatus | |
|
mdl_creationdate |
datetime |
NULL |
|
No |
Datetime | |
|
mdl_created_by |
VARCHAR(30) |
NOT NULL |
|
No |
UDD_Ctxt_User | |
|
mdl_modifieddate |
datetime |
NULL |
|
No |
Datetime | |
|
mdl_modified_by |
VARCHAR(30) |
NOT NULL |
|
No |
UDD_Ctxt_User | |
|
mdl_timestamp |
Integer |
NOT NULL |
|
No |
UDD_TimeStamp | |
|
mdl_typecertno |
VARCHAR(40) |
NOT NULL |
|
No |
UDD_RefDocNo | |
|
|
|
|
|
|
|
|
Table Name: behr_cert_hdr
|
Purpose: |
Certificate Master - To record ATA, Skill, Certificate details.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance |
|
certificate_code |
nvarchar(30) |
NOT NULL |
Certificate Code as entered |
Yes |
hrcertnum |
|
ata_no |
nvarchar(30) |
NOT NULL |
Valid ATA Number |
No |
atanumber |
|
skill_code |
nvarchar(10) |
NULL |
Defined Skill Code |
No |
hrcd |
|
status |
nvarchar(5) |
NULL |
Status to know Active or Inactive. |
No |
hrquickcode |
|
appl_res_group |
nvarchar(5) |
NOT NULL |
Applicable Resource Group can either be Mechanic or Inspector |
No |
|
|
certification_category |
nvarchar(5) |
NOT NULL |
Certification Category from user defined Quick codes |
No |
|
|
certification_class |
nvarchar(5) |
NOT NULL |
Certificate class to which Certificate belongs |
No |
|
|
certificaton_agency |
nvarchar(5) |
NOT NULL |
The agency, which gives the certificate. |
No |
|
|
certification_requirement |
nvarchar(255) |
NOT NULL |
The requirements for possessing the certificate. |
No |
hrtext255 |
|
certification_val_period |
int |
NOT NULL |
Period for which the certificate is valid |
No |
hrint |
|
certification_time_unit |
nvarchar(5) |
NOT NULL |
The time unit will be like days, weeks, months, etc |
No |
hrquickcode |
|
currency_requirement |
nvarchar(255) |
NOT NULL |
The requirements for currency checks |
No |
hrtext255 |
|
currency_period |
nvarchar(100) |
NOT NULL |
The period at which the currency checks for the certificate will be conducted |
No |
description |
|
currency_time_unit |
nvarchar(5) |
NOT NULL |
The time unit will be like days, weeks, months, etc |
No |
hrquickcode |
|
recertification_requirement |
nvarchar(255) |
NOT NULL |
The requirements for re-certification. |
No |
hrtext255 |
|
recertification_period |
int |
NOT NULL |
The period at which the re-certification has to be done. |
No |
hrint |
|
recertification_time_unit |
nvarchar(5) |
NOT NULL |
The time unit will be like days, weeks, months, etc. |
No |
hrquickcode |
|
supportive_requirement |
nvarchar(255) |
NOT NULL |
The requirements as specific, which are more of supportive for the certificate. |
No |
hrtext255 |
|
reference |
nvarchar(255) |
NOT NULL |
The references pertaining to the certificate definition. |
No |
|
|
remarks |
nvarchar(255) |
NOT NULL |
Remarks for Certificate given |
No |
|
|
mode_flag |
nvarchar(3) |
NULL |
mode_flag Contains 'I' for Insert, 'U' for Update. |
No |
HrFlag |
Table Name: behr_cert_lang_dtl
|
Purpose: |
Language Dependent - Certificate Title Information
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance |
|
certificate_code |
nvarchar(30) |
NOT NULL |
Defined Certificate Code |
Yes |
hrcertnum |
|
language_code |
int |
NOT NULL |
Language Code i.e. login language |
Yes |
hrint |
|
certificate_title |
nvarchar(30) |
NULL |
Title given to the Certificate |
No |
hrdescription |
|
u_certificate_title |
nvarchar(30) |
NULL |
Title given to the Certificate(In upper case) |
No |
|
Table Name: behr_cert_wunt_dtl
|
Purpose: |
Certificate - Work Unit Details
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance |
|
certificate_code |
nvarchar(30) |
NOT NULL |
Defined Certificate Code |
Yes |
hrcertnum |
|
workunt_cd |
nvarchar(80) |
NOT NULL |
The work unit code as defined in the 'Maintenance Task' component of Boeing. |
Yes |
hrquickcodedesc |
|
sl_no |
int |
NULL |
Sl_no |
No |
hrint |
|
workunt_type |
nvarchar(5) |
NULL |
The work unit type will be Tasks, standard procedures, etc. |
No |
hrquickcode |
|
authorization_ou |
int |
NOT NULL |
The org.unit where the work unit is applicable. |
No |
HrOuInstance |
Table Name: behr_jobrt_dtl
|
Purpose: |
Standard & overtime details for every job code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
|
|
job_code |
nvarchar(10) |
NOT NULL |
Job Code Entered by user |
Yes |
Hrcd |
|
standard_rate |
numeric(15,4) |
NULL |
Standard Rate (In Working Hours) |
No |
Hrsalary |
|
overtime_rate |
numeric(15,4) |
NULL |
Overtime Rate(In Extra Time) |
No |
|
Table Name: behr_skill
|
Purpose: |
One of the Skill master table, we will store only master_ou and skill code in this table.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance |
|
skill_code |
nvarchar(10) |
NOT NULL |
The unique code with which the skill is identified.(Entered by the user) |
Yes |
hrcd |
Table Name: behr_skill_hdr
|
Purpose: |
Skill Code Master with details for type, rate, desired level with history details.
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
ot_rate |
numeric(15,4) |
NULL |
ot rate for a skill |
No |
HrSalary | |
|
skill_rate |
numeric(15,4) |
NOT NULL |
The rate for each skill. |
No |
hrsalary | |
|
sno |
int |
NULL |
Serial Number to track each row in multiline. |
No |
hrint | |
|
min_des_lvl |
int |
NOT NULL |
The minimum expected level of skill that an employee is supposed to posses is mentioned. |
No |
hrcompmdl | |
|
status |
nvarchar(5) |
NOT NULL |
Status |
No |
hrquickcode | |
|
mode_flag |
nvarchar(3) |
NULL |
mode_flag Contains 'I' for Insert, 'U' for Update. |
No |
HrFlag | |
|
skill_code |
nvarchar(10) |
NOT NULL |
The unique code with which the skill is identified. |
Yes |
hrcd | |
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance | |
|
skill_type |
nvarchar(5) |
NOT NULL |
The attribute that can be used to group skills. Skill Type can be like, Technical Skills, Non-Technical Skills, etc. |
No |
hrquickcode | |
|
eff_from_date |
datetime |
NOT NULL |
Date from which Skill is effective |
Yes |
Datetime | |
|
eff_to_date |
datetime |
NULL |
effective to date for a given skill |
No |
| |
|
|
|
|
|
|
|
|
Table Name: behr_skill_lang_dtl
|
Purpose: |
Language Dependent - Skill description
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
eff_from_date |
datetime |
NOT NULL |
Date from whick skill is effective |
Yes |
|
|
skill_desc |
nvarchar(12) |
NULL |
Description about the Skill Code |
No |
hrshortdesc12 |
|
u_skill_desc |
nvarchar(12) |
NULL |
Description about the Skill Code ( In Upper Case) |
No |
|
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
HrOuInstance |
|
language_code |
int |
NOT NULL |
Language Code i.e.Login Language |
Yes |
hrint |
|
skill_code |
nvarchar(10) |
NOT NULL |
The unique code with which the skill is identified. |
Yes |
hrcd |
Table Name: behr_skill_qual_map_dtl
|
Purpose: |
Skill Qualification Mapping details
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
qualification_code |
nvarchar(5) |
NOT NULL |
The unique code with which the Qualification code is identified. |
Yes |
|
|
master_ou_code |
int |
NOT NULL |
HRSTP OU Code selected in the OU Combo |
Yes |
|
|
|
|
|
|
|
|
Table Name: behr_wunt_obj_dtl
|
Purpose: |
Details of Aircraft Model / Base Part number for each Certificate - Work Unit Combination
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
certificate_code |
nvarchar(30) |
NOT NULL |
Defined Certificate Code |
Yes |
hrcertnum |
|
workunt_cd |
nvarchar(80) |
NOT NULL |
The work unit code as defined in the 'Maintenance Task' component of Boeing. |
Yes |
hrquickcodedesc |
|
aircraft_or_basepart |
nvarchar(80) |
NOT NULL |
The aircraft model code. or The reference part number while effecting modifications on the part number |
Yes |
hrquickcodedes |
|
sl_no |
int |
NOT NULL |
Sl_no (Record Serial Number) |
No |
hrint |
|
obj_type |
nvarchar(5) |
NOT NULL |
Whether it is aircraft model or base part. |
No |
hrquickcode |
|
aircraft_model |
nvarchar(30) |
NOT NULL |
The aircraft model code. |
No |
hrmodel |
|
base_part |
nvarchar(80) |
NOT NULL |
The reference part number while effecting modifications on the part number |
No |
hrpartno |
Table Name: hrgm_addnl_dtl
|
Purpose: |
Additional Master screen detail table. This table will store values for each additional masters.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
gnmas ou code |
Yes |
|
|
master_key |
nvarchar(255) |
NOT NULL |
|
Yes |
|
|
effective_from_date |
datetime |
NOT NULL |
from date |
Yes |
|
|
code_sl_no |
INT |
NOT NULL |
serial number to be internally generated and incremented for each code in Multi line. |
Yes |
|
|
code |
nvarchar(10) |
NOT NULL |
store code |
No |
|
|
description |
nvarchar(80) |
NULL |
store Description |
No |
|
|
long_desc |
nvarchar(1000) |
NULL |
store long description |
No |
|
|
parameter1 |
nvarchar(255) |
NULL |
store parameter1 |
No |
|
|
parameter2 |
nvarchar(255) |
NULL |
store parameter2 |
No |
|
|
parameter3 |
nvarchar(255) |
NULL |
store parameter3 |
No |
|
|
parameter4 |
nvarchar(255) |
NULL |
store parameter4 |
No |
|
|
active_flag |
nvarchar(80) |
NULL |
Whether the code is active or not - (Y/N) BP GEN PV MAND |
No |
|
|
comments |
nvarchar(255) |
NULL |
store ML Comments |
No |
|
|
|
|
|
|
|
|
Table Name: hrgm_addnl_master
|
Purpose: |
Additional Master Screen Master table. This will store key columns with history details
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
gnmas ou |
Yes |
HrOuInstance |
|
master_key |
nvarchar(255) |
NOT NULL |
An Internal Key will be generated which will be a combination of masterid,applicableou,key1,key2 |
Yes |
HrHdnText1 |
|
effective_from_date |
datetime |
NOT NULL |
from date |
Yes |
Datetime |
|
master_id |
nvarchar(10) |
NULL |
store master id |
No |
HrCd |
|
master_desc |
nvarchar(80) |
NULL |
store master description |
No |
hrclassdesc |
|
applicable_ou |
int |
NOT NULL |
applicable ou code (Zero for 'ALL') |
No |
HrOuInstance |
|
key1 |
nvarchar(10) |
NULL |
store key1 |
No |
HrCd |
|
key2 |
nvarchar(10) |
NULL |
store key2 |
No |
|
|
effective_to_date |
datetime |
NULL |
to date |
No |
Datetime |
|
comments |
nvarchar(255) |
NULL |
store header comments |
No |
HrText255 |
Table Name: HRGM_Guidance_Text_Dtl
|
Purpose: |
Guidance Text Metadata details (Componentwise / languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
component_code |
nvarchar(30) |
NOT NULL |
Component Code as in Deployment Database |
Yes |
|
|
guidance_text_code |
nvarchar(5) |
NOT NULL |
Metadata Code identified Component_Code: HRMSORGST Guidance_Text_Code: CGOU Guidance_Text: Use this page for Grade Set - Grade - Org.Unit Mapping |
Yes |
|
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
|
|
guidance_text |
nvarchar(255) |
NULL |
Component_Code: HRMSORGST Guidance_Text_Code: CGOU Guidance_Text: Use this page for Grade Set - Grade - Org.Unit Mapping |
No |
|
|
|
|
|
|
|
|
Table Name: HRGM_Local_Dtl
|
Purpose: |
Local Code Description for every GNMAS Ou Code, Country, State combination (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_Code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
|
|
country_code |
nvarchar(5) |
NOT NULL |
Country Code From Enterprise Modeller |
Yes |
|
|
state_code |
nvarchar(10) |
NOT NULL |
State Code as recorded by User |
Yes |
|
|
local_type_code |
nvarchar(5) |
NOT NULL |
Local Type Code as recorded in State Master (Quick Code of Local Type1: Ex: County Quick Code of Local Type2: Ex: City/Town Quick Code of Local Type3: Ex: School District) |
Yes |
|
|
local_code |
nvarchar(10) |
NOT NULL |
Respect Local Codes for Every Local Type identified for the State |
Yes |
|
|
language_code |
int |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
|
|
local_name |
nvarchar(80) |
NULL |
Local Name as entered by Login User |
No |
|
|
u_local_name |
nvarchar(80) |
NULL |
Local Name as entered by Login User (In Upper Case) |
No |
|
|
local_short_description |
nvarchar(30) |
NULL |
Local Short Description as entered by Login User |
No |
|
|
u_local_short_description |
nvarchar(30) |
NULL |
Local Short Description as entered by Login User (In Upper Case) |
No |
|
|
local_comment |
nvarchar(2000) |
NULL |
Comments as recorded by Login User |
No |
|
|
|
|
|
|
|
|
Table Name: HRGM_Local_Hdr
|
Purpose: |
Local Codes for every GNMAS Ou Code, Country, State combination
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
||
|
country_code |
nvarchar(5) |
NOT NULL |
Country Code From Enterprise Modeller |
Yes |
||
|
state_code |
nvarchar(10) |
NOT NULL |
State Code as recorded by User |
Yes |
||
|
local_type_code |
nvarchar(5) |
NOT NULL |
Local Type Code as recorded in State Master (Quick Code of Local Type1: Ex: County Quick Code of Local Type2: Ex: City/Town Quick Code of Local Type3: Ex: School District) |
Yes |
||
|
local_code |
nvarchar(10) |
NOT NULL |
Respect Local Codes for Every Local Type identified for the State |
Yes |
||
|
login_ou_code |
int |
NULL |
OU Code where GNMAS Component is deployed and from where this page is launched |
No |
||
|
active_inactive_flag |
nvarchar(3) |
NULL |
Y if Local Code is Active, N if Inactive |
No |
||
|
|
|
|
|
|
|
|
Table Name: hrgm_object_count
|
Purpose: |
Object count table for GNMAS Component.
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
object_name |
nvarchar(255) |
NOT NULL |
%AttDef |
Yes |
HrText255 | |
|
object_type |
nvarchar(5) |
NOT NULL |
|
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: HRGM_QC_BP_Hdr
|
Purpose: |
Quick Code - Business Process Codes
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
Table Name: HRGM_QC_BP_Lang_Dtl
|
Purpose: |
Quick Codes - Business Process Description (languagewise)
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
|
|
|
|
|
| |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd | |
|
business_process_description |
nvarchar(80) |
NULL |
Business Process Description Identified as Metadata (Ex: HREI - Employment Information) |
No |
HrBusinessProcess | |
|
|
|
|
|
|
|
|
Table Name: HRGM_QC_BP_PV_Map
|
Purpose: |
Quick Codes - Business Process Codes and Process Variable Codes Mapping
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
system_defined_flag |
nvarchar(3) |
NULL |
Y if System Defined, N if User Defined |
No |
HrFlag |
Table Name: HRGM_QC_PV_Hdr
|
Purpose: |
Quick Code - Process Variables Codes
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode | |
|
|
|
|
|
|
|
|
Table Name: HRGM_QC_PV_Lang_Dtl
|
Purpose: |
Quick Codes - Process Variable Description (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
|
|
|
|
|
|
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
process_variable_description |
nvarchar(80) |
NULL |
Process Variable Description Identified as Metadata (Ex: ASTY - Assignment Type) |
No |
HrProcessVariable |
Table Name: HRGM_QC_Security_BP_Dtl
|
Purpose: |
Quick Codes - Userwise Permission list for Business Process Codes
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata |
Yes |
HrBusinessProcessCode |
|
business_process_comment |
nvarchar(2000) |
NULL |
Comments as recorded by the Login User |
No |
hrnotes |
|
login_ou_code |
int |
NOT NULL |
Login OU Code where GNMAS Component is deployed and from where this page is launched |
Yes |
HrOuInstance |
|
login_user_name |
nvarchar(30) |
NOT NULL |
Login User Name who has permission to GNMAS Component |
Yes |
HrUserName |
Table Name: HRGM_QC_Security_Hdr
|
Purpose: |
Quick Codes - Security Permission check details
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
login_ou_code |
int |
NOT NULL |
OU Code where GNMAS Component is deployed and from where this page is launched |
Yes |
HrOuInstance |
|
set_permission |
INT |
NOT NULL |
1 if Permission is Checked, 0 if Permission is not Checked |
No |
Hrcheck |
|
enable_security |
INT |
NULL |
1 if Enable Security is Checked, 0 if Enable Security is not Checked |
No |
|
|
security_comment |
nvarchar(2000) |
NULL |
Comments as recorded by the user |
No |
hrnotes |
Table Name: HRGM_QC_Sys_Lang_Dtl
|
Purpose: |
Quick Codes - System defined Description for Codes (metadata) of a specific Business Process and Process Variable Combination (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
value_code |
nvarchar(5) |
NOT NULL |
Quick Code (Identified as Metadata) |
Yes |
HrQuickCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
value_description |
nvarchar(80) |
NULL |
Quick Code Description (Identified as Metadata) (Ex: For the Quick Code: NWHIR the description is "New Hire") |
No |
HrQuickCodeDesc |
|
u_value_description |
nvarchar(80) |
NULL |
Quick Code Description in Upper Case (Identified as Metadata) (Ex: For the Quick Code: NWHIR the description is "NEW HIRE") |
No |
|
Table Name: HRGM_QC_Sys_Value_Dtl
|
Purpose: |
Quick Codes - System defined Codes (metadata) for a specific Business Process and Process Variable Combination
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
value_code |
nvarchar(5) |
NOT NULL |
Quick Code (Identified as Metadata) |
Yes |
HrQuickCode |
|
user_modifiable_flag |
nvarchar(3) |
NULL |
Y if System Identified Quick Code and Modifiable by User, N if System Identified Quick Code and Not Modifiable by User |
No |
HrFlag |
|
sequence_number |
INT |
NULL |
Sequence Number in which the quick code need to be sorted. |
No |
HrInt |
Table Name: hrgm_qc_user_cmnt_dtl
|
Purpose: |
Quick Codes - User defined Comments for a specific GNMAS OU Code, Business Process and Process Variable Combination (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
quick_code_comment |
nvarchar(2000) |
NULL |
Comments as recorded by the Login User |
No |
hrnotes |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
Table Name: HRGM_QC_User_Hdr
|
Purpose: |
Quick Codes - User defined details for a specific GNMAS OU Code, Business Process and Process Variable Combination
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
login_ou_code |
int |
NULL |
OU Code where GNMAS Component is deployed and from where this page is launched |
No |
HrOuInstance |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
Table Name: HRGM_QC_User_Lang_Dtl
|
Purpose: |
Quick Codes - User defined Description for Codes of a specific GNMAS OU Code, Business Process and Process Variable Combination (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
value_code |
nvarchar(5) |
NOT NULL |
Quick Code (Both Identified as Metadata & Created by User through Edit Quick Codes Page) |
Yes |
HrQuickCode |
|
value_description |
nvarchar(80) |
NULL |
Quick Code Description (Both Identified as Metadata & Created by User through Edit Quick Codes Page) (Ex: For the Quick Code: NWHIR the description is "New Hire") |
No |
HrQuickCodeDesc |
|
u_value_description |
nvarchar(80) |
NULL |
Quick Code Description stored in Upper Case (Both Identified as Metadata & Created by User through Edit Quick Codes Page) (Ex: For the Quick Code: NWHIR the description is "NEW HIRE") |
No |
|
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
Table Name: HRGM_QC_User_Value_Dtl
|
Purpose: |
Quick Codes - User defined Codes for a specific GNMAS OU Code, Business Process and Process Variable Combination
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
modifiable_flag |
nvarchar(3) |
NULL |
Y if System Identified Quick Code and Modifiable by User, N if System Identified Quick Code and Not Modifiable by User, N if User Created Quick Code |
No |
HrFlag |
|
system_defined_flag |
nvarchar(3) |
NULL |
Y if System Defined, N if User Defined |
No |
|
|
active_inactive_flag |
nvarchar(3) |
NULL |
Y if Quick Code is Active, N if Inactive |
No |
|
|
sequence_number |
INT |
NULL |
Sequence Number in which the quick code need to be sorted. |
No |
HrInt |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
value_code |
nvarchar(5) |
NOT NULL |
Quick Code (Both Identified as Metadata & Created by User through Edit Quick Codes Page) |
Yes |
HrQuickCode |
|
business_process_code |
nvarchar(4) |
NOT NULL |
Business Process Code Identified as Metadata (Ex: HREI - Employment Information) |
Yes |
HrBusinessProcessCode |
|
process_variable_code |
nvarchar(4) |
NOT NULL |
Process Variable Code Identified as Metadata (Ex: ASTY - Assignment Type) |
Yes |
HrProcessVariableCode |
Table Name: HRGM_Qual_Hdr
|
Purpose: |
Qualification Master Information for every GNMAS OU Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_Code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
qualification_code |
nvarchar(5) |
NOT NULL |
Qualification Code as defined by User |
Yes |
HrCode |
|
qualification_type_code |
nvarchar(5) |
NULL |
Qualification Type (Value from Quick Codes: BP: GEN, PV: QUTY) |
No |
HrQuickCode |
|
level_code |
nvarchar(5) |
NULL |
Qualification Type (Value from Quick Codes: BP: GEN, PV: QLVL) |
No |
|
|
specialization_code |
nvarchar(5) |
NULL |
Qualification Type (Value from Quick Codes: BP: GEN, PV: SPLZ) |
No |
|
|
login_ou_code |
int |
NULL |
OU Code where GNMAS Component is deployed and from where this page is launched |
No |
HrOuInstance |
|
active_inactive_flag |
nvarchar(3) |
NULL |
Y if Qualification Code is Active, N if Inactive |
No |
HrFlag |
|
qual_group_level |
nvarchar(5) |
NOT NULL |
|
No |
hrquickcode |
Table Name: HRGM_Qual_Lang_Dtl
|
Purpose: |
Qualification Master Information for every GNMAS OU Code (languagewise Qualification Description)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_Code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
qualification_code |
nvarchar(5) |
NOT NULL |
Qualification Code as defined by User |
Yes |
HrCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
qualification_description |
nvarchar(30) |
NULL |
Qualification Description as recorded by Login User |
No |
HrDescription |
|
u_qualification_description |
nvarchar(30) |
NULL |
Qualification Description in Upper Case as recorded by Login User |
No |
|
|
qualification_comment |
nvarchar(2000) |
NULL |
Comments as recorded by Login User |
No |
hrnotes |
Table Name: HRGM_State_Hdr
|
Purpose: |
State Master Information for every GNMAS OU Code (Country details are from Enterprise Modeller - EMOD)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
country_code |
nvarchar(5) |
NOT NULL |
Country Code From Enterprise Modeller |
Yes |
countrycode |
|
state_code |
nvarchar(10) |
NOT NULL |
State Code as recorded by User |
Yes |
HrStateCode |
|
local_type1_code |
nvarchar(5) |
NULL |
Local Type 1 (Values from Quick Codes) BP: GEN, PV: LTY1 Ex: District, County ... |
No |
HrQuickCode |
|
local_type2_code |
nvarchar(5) |
NULL |
Local Type 2 (Values from Quick Codes) BP: GEN, PV: LTY2 Ex: City/Town |
No |
|
|
local_type3_code |
nvarchar(5) |
NULL |
Local Type 3 (Values from Quick Codes) BP: GEN, PV: LTY3 Ex: School District, Panchayats... |
No |
|
|
login_ou_code |
int |
NULL |
OU Code where GNMAS Component is deployed and from where this page is launched |
No |
HrOuInstance |
|
active_inactive_flag |
nvarchar(3) |
NULL |
Y if State Code is Active, N if Inactive |
No |
HrFlag |
Table Name: HRGM_State_Lang_Dtl
|
Purpose: |
State Master Information for every GNMAS OU Code (languagewise State Description)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
country_code |
nvarchar(5) |
NOT NULL |
Country Code From Enterprise Modeller |
Yes |
countrycode |
|
state_code |
nvarchar(10) |
NOT NULL |
State Code as recorded by User |
Yes |
HrStateCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
state_name |
nvarchar(30) |
NULL |
State Name as entered by Login User |
No |
HrStateDesc |
|
u_state_name |
nvarchar(30) |
NULL |
State Name as entered by Login User (Upper Case) |
No |
|
|
state_comment |
nvarchar(2000) |
NULL |
Comments as recorded by Login User |
No |
hrnotes |
Table Name: hrgm_union_comm_cmnt
|
Purpose: |
Committee Comments for every GNMAS OU Code, Union Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
union_committee_comment |
nvarchar(2000) |
NULL |
Comment for the Committee as entered by User |
No |
hrnotes |
Table Name: hrgm_union_comm_dtl
|
Purpose: |
Committee Codes (system generated number) for every GNMAS OU Code, Union Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
union_committee_id |
INT |
NOT NULL |
Serial Number generated to store Committee for that Union |
Yes |
HrInt |
|
effective_from_date |
datetime |
NULL |
Effective From Date as entered by User |
No |
Datetime |
|
effective_to_date |
datetime |
NULL |
Effective To Date as entered by User |
No |
|
Table Name: hrgm_union_comm_lang_dtl
|
Purpose: |
Committee Names for every GNMAS OU Code, Union Code (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
union_committee_id |
INT |
NOT NULL |
Serial Number generated to store Committee for that Union |
Yes |
HrInt |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
committee_name |
nvarchar(30) |
NOT NULL |
Committee Name for that Union as entered by User |
No |
HrDescription |
|
purpose |
nvarchar(80) |
NULL |
Purpose information as entered by User |
No |
hrdesc40 |
|
head_name |
nvarchar(80) |
NULL |
Head Name as entered by User |
No |
HrEmpName |
Table Name: hrgm_union_hdr
|
Purpose: |
Union Master Information for every GNMAS OU Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
registration_date |
datetime |
NULL |
Union Registration Date |
No |
Datetime |
|
registration_no |
nvarchar(30) |
NULL |
Union Registration Number (Uniqueness of this attribute is not checked) |
No |
HrDescription |
|
country_code |
nvarchar(5) |
NULL |
Country Code from Enterprise Modeller |
No |
HrQuickCode |
|
state_code |
nvarchar(10) |
NULL |
State Code mapped to a Country in State Master |
No |
HrStateCode |
|
local_type1_code |
nvarchar(5) |
NULL |
Local Code for the Selected Country/State and Local Type 1 Code (Ex: Any local code |
No |
HrQuickCode |
|
local_type2_code |
nvarchar(5) |
NULL |
Local Code for the Selected Country/State and Local Type 2 Code |
No |
|
|
zip_code |
nvarchar(80) |
NULL |
Zip code as entered by User |
No |
HrZip |
|
phone_1 |
nvarchar(30) |
NULL |
Phone Number 1 as entered by User |
No |
HrPhone |
|
phone_2 |
nvarchar(30) |
NULL |
Phone Number 2 as entered by User |
No |
|
|
phone_3 |
nvarchar(30) |
NULL |
Phone Number 3 as entered by User |
No |
|
|
fax_1 |
nvarchar(30) |
NULL |
Fax Number 1 as entered by User |
No |
|
|
fax_2 |
nvarchar(30) |
NULL |
Fax Number 2 as entered by User |
No |
|
|
email_Id |
nvarchar(80) |
NULL |
Email ID as entered by User |
No |
HrEmailId |
|
website |
nvarchar(80) |
NULL |
Website as entered by User |
No |
|
|
person_phone_Number |
nvarchar(30) |
NULL |
Contact Person Phone Number as entered by User |
No |
HrPhone |
|
person_email_id |
nvarchar(80) |
NULL |
Contact Person Email ID as entered by User |
No |
HrEmailId |
|
person_fax_number |
nvarchar(30) |
NULL |
Contact Person Fax Number as entered by User |
No |
HrPhone |
|
person_mobile_number |
nvarchar(30) |
NULL |
Contact Person Mobile Number as entered by User |
No |
HrMobile |
|
login_ou_code |
int |
NULL |
Login OU Code |
No |
HrOuInstance |
|
active_inactive_flag |
nvarchar(3) |
NULL |
Y if Local Code is Active, N if Inactive |
No |
HrFlag |
Table Name: hrgm_union_lang_dtl
|
Purpose: |
Union Code Description for every GNMAS OU Code (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
union_name |
nvarchar(30) |
NULL |
Union Name for that Union as entered by User |
No |
HrDescription |
|
u_union_name |
nvarchar(30) |
NULL |
Union Name in UpperCase for that Union as entered by User |
No |
|
|
membership_name |
nvarchar(30) |
NULL |
Membership Name for that Union as entered by User |
No |
|
|
u_membership_name |
nvarchar(30) |
NULL |
Membership Name in UpperCase for that Union as entered by User |
No |
|
|
address_1 |
nvarchar(80) |
NULL |
Address line 1 for that Union as entered by User |
No |
HrAddress |
|
address_2 |
nvarchar(80) |
NULL |
Address line 2 for that Union as entered by User |
No |
|
|
address_3 |
nvarchar(80) |
NULL |
Address line 3 for that Union as entered by User |
No |
|
|
contact_person |
nvarchar(80) |
NULL |
Contact Person for that Union as entered by User |
No |
HrEmpName |
|
union_comment |
nvarchar(2000) |
NULL |
Comments for that Union as entered by User |
No |
hrnotes |
Table Name: hrgm_union_local_comnt
|
Purpose: |
Local Group Comments for every GNMAS OU Code, Union Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
union_local_comment |
nvarchar(2000) |
NULL |
Comment for that Local as entered by User |
No |
hrnotes |
Table Name: hrgm_union_local_dtl
|
Purpose: |
Local Group Information (system generated number) for every GNMAS OU Code, Union Code
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
union_group_id |
INT |
NOT NULL |
Serial Number generated to store Group ID for that Union |
Yes |
HrInt |
|
phone |
nvarchar(30) |
NULL |
Phone Number of the Union Group as entered by User |
No |
HrPhone |
|
email_id |
nvarchar(80) |
NULL |
Email ID of the Union Group as entered by User |
No |
HrEmailId |
Table Name: hrgm_union_local_lang_dtl
|
Purpose: |
Local Group Name for every GNMAS OU Code, Union Code (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
union_group_id |
INT |
NOT NULL |
Serial Number generated to store Group ID for that Union |
Yes |
HrInt |
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
group_name |
nvarchar(30) |
NOT NULL |
Group Name for that Union as entered by User |
No |
HrDescription |
|
contact_person |
nvarchar(80) |
NULL |
Contact Person for that Union as entered by User |
No |
HrEmpName |
|
address |
nvarchar(80) |
NULL |
Address detail for that Union as entered by User |
No |
HrAddress |
Table Name: hrgm_union_offbearer_dtl
|
Purpose: |
Union - Office Bearer Information for every GNMAS OU Code, Union Code (languagewise)
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
master_ou_code |
int |
NOT NULL |
GNMAS OU Code Selected in the OU Combo |
Yes |
HrOuInstance |
|
union_code |
nvarchar(5) |
NOT NULL |
Union Code as entered by Login User |
Yes |
HrQuickCode |
|
offbearer_code |
nvarchar(5) |
NOT NULL |
Office Bearer Code (Only 3) as entered by User |
Yes |
|
|
language_code |
INT |
NOT NULL |
Language Code (1 if English) as selected in Language Combo |
Yes |
HrLangCd |
|
offbearer_name |
nvarchar(80) |
NOT NULL |
Office Bearer Name as entered by User |
No |
HrEmpName |
|
offbearer_address |
nvarchar(80) |
NULL |
Office Bearer Address as entered by User |
No |
HrAddress |
|
offbearer_phone |
nvarchar(30) |
NULL |
Office Bearer Contact Phone Number as entered by User |
No |
HrPhone |
|
offbearer_email_id |
nvarchar(80) |
NULL |
Office Bearer Email ID as entered by User |
No |
HrEmailId |