Table Name: hrtrpt_crs_dtls_tmp
|
Purpose: |
cost of corse details
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
tr_area |
nvarchar(5) |
NULL |
Training area name |
No |
hrquickcode |
|
month_str |
nvarchar(40) |
NULL |
Starting month name |
No |
hrquickcodedesc |
|
sno |
int |
NULL |
Serial number |
No |
hrint |
|
course |
nvarchar(5) |
NULL |
Course name |
No |
hrcode |
|
coursedts |
nvarchar(255) |
NULL |
Course details |
No |
hrtext255 |
|
noofdays |
int |
NULL |
noofdays |
No |
hrint |
|
noofpart |
int |
NULL |
noofpart |
No |
|
|
venue |
nvarchar(40) |
NULL |
Training venue name |
No |
hrquickcodedesc |
|
tcost |
numeric(15,4) |
NULL |
Training cost |
No |
hrsalary |
|
sdf_subsidy |
numeric(15,4) |
NULL |
sdf_subsidy |
No |
|
|
sdf_date |
nvarchar(11) |
NULL |
sdf_date |
No |
hrdate |
|
comments |
nvarchar(1500) |
NULL |
Comments |
No |
hrtext1500 |
|
texpense |
numeric(15,4) |
NULL |
expense |
No |
hrsalary |
|
exp1_hdr |
nvarchar(5) |
NULL |
Expenses of the item |
No |
hrquickcode |
|
exp1_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item |
No |
hrsalary |
|
exp2_hdr |
nvarchar(5) |
NULL |
Expenses of the item 2 |
No |
hrquickcode |
|
exp2_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 2 |
No |
hrsalary |
|
exp3_hdr |
nvarchar(5) |
NULL |
Expenses of the item 3 |
No |
hrquickcode |
|
exp3_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 3 |
No |
hrsalary |
|
exp4_hdr |
nvarchar(5) |
NULL |
Expenses of the item 4 |
No |
hrquickcode |
|
exp4_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 4 |
No |
hrsalary |
|
exp5_hdr |
nvarchar(5) |
NULL |
Expenses of the item 5 |
No |
hrquickcode |
|
exp5_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 5 |
No |
hrsalary |
|
exp6_hdr |
nvarchar(5) |
NULL |
Expenses of the item 6 |
No |
hrquickcode |
|
exp6_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 6 |
No |
hrsalary |
|
exp7_hdr |
nvarchar(5) |
NULL |
Expenses of the item 7 |
No |
hrquickcode |
|
exp7_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 7 |
No |
hrsalary |
|
exp8_hdr |
nvarchar(5) |
NULL |
Expenses of the item 8 |
No |
hrquickcode |
|
exp8_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 8 |
No |
hrsalary |
|
exp9_hdr |
nvarchar(5) |
NULL |
Expenses of the item 9 |
No |
hrquickcode |
|
exp9_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 9 |
No |
hrsalary |
|
exp10_hdr |
nvarchar(5) |
NULL |
Expenses of the item 10 |
No |
hrquickcode |
|
exp10_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 10 |
No |
hrsalary |
|
exp11_hdr |
nvarchar(5) |
NULL |
Expenses of the item 11 |
No |
hrquickcode |
|
exp11_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 11 |
No |
hrsalary |
|
exp12_hdr |
nvarchar(5) |
NULL |
Expenses of the item 12 |
No |
hrquickcode |
|
exp12_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 12 |
No |
hrsalary |
|
exp13_hdr |
nvarchar(5) |
NULL |
Expenses of the item 13 |
No |
hrquickcode |
|
exp13_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 13 |
No |
hrsalary |
|
exp14_hdr |
nvarchar(5) |
NULL |
Expenses of the item 14 |
No |
hrquickcode |
|
exp14_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 14 |
No |
hrsalary |
|
exp15_hdr |
nvarchar(5) |
NULL |
Expenses of the item 15 |
No |
hrquickcode |
|
exp15_val |
numeric(15,4) |
NULL |
Value of the Expenses of the item 15 |
No |
hrsalary |
|
trgcal_ou_code |
int |
NULL |
Training calendar ou code |
No |
hrouid |
|
trgcal_code |
nvarchar(5) |
NULL |
Training Calendar code |
No |
hrcode |
|
pmc_id |
int |
NULL |
Unique id to denote a Pgm/Module/Course combination within a training calendar. |
No |
hrint10 |
|
|
|
|
|
|
|
Table Name: hrtrpt_crs_ehdr_tmp
|
Purpose: |
header details for courses
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
tr_area |
nvarchar(5) |
NULL |
Training area name |
No |
hrquickcode |
|
month_str |
nvarchar(40) |
NULL |
Month name |
No |
hrquickcodedesc |
|
exp1_hdr |
nvarchar(5) |
NULL |
Expenses of the item 1 |
No |
hrquickcode |
|
exp2_hdr |
nvarchar(5) |
NULL |
Expenses of the item 2 |
No |
|
|
exp3_hdr |
nvarchar(5) |
NULL |
Expenses of the item 3 |
No |
|
|
exp4_hdr |
nvarchar(5) |
NULL |
Expenses of the item 4 |
No |
|
|
exp5_hdr |
nvarchar(5) |
NULL |
Expenses of the item 5 |
No |
|
|
exp6_hdr |
nvarchar(5) |
NULL |
Expenses of the item 6 |
No |
|
|
exp7_hdr |
nvarchar(5) |
NULL |
Expenses of the item 7 |
No |
|
|
exp8_hdr |
nvarchar(5) |
NULL |
Expenses of the item 8 |
No |
|
|
exp9_hdr |
nvarchar(5) |
NULL |
Expenses of the item 9 |
No |
|
|
exp10_hdr |
nvarchar(5) |
NULL |
Expenses of the item 10 |
No |
|
|
exp11_hdr |
nvarchar(5) |
NULL |
Expenses of the item 11 |
No |
|
|
exp12_hdr |
nvarchar(5) |
NULL |
Expenses of the item 12 |
No |
|
|
exp13_hdr |
nvarchar(5) |
NULL |
Expenses of the item 13 |
No |
|
|
exp14_hdr |
nvarchar(5) |
NULL |
Expenses of the item 14 |
No |
|
|
exp15_hdr |
nvarchar(5) |
NULL |
Expenses of the item 15 |
No |
|
Table Name: hrtrpt_mandays_rep_tmp
|
Purpose: |
mamdatory for courses
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
guid |
nvarchar(40) |
NOT NULL |
Gobally unique identifier |
No |
hrguid |
|
empcode |
nvarchar(20) |
NULL |
Employee code |
No |
hrempcode |
|
empname |
nvarchar(77) |
NULL |
Employee name |
No |
hrempname |
|
deptdesc |
nvarchar(40) |
NULL |
Department description |
No |
hrdesc40 |
|
jobtitle |
nvarchar(40) |
NULL |
job title |
No |
|
|
positiontitle |
nvarchar(40) |
NULL |
Position title |
No |
|
|
pmc_id |
int |
NULL |
Unique id to denote a Pgm/Module/Course combination within a training calendar. |
No |
hrint10 |
|
asgn_no |
int |
NULL |
Assignment number |
No |
hrassgnno |
|
coursecode |
nvarchar(5) |
NULL |
Course code |
No |
hrcode |
|
course_start_dt |
datetime |
NULL |
Course start date |
No |
Datetime |
|
course_end_dt |
datetime |
NULL |
Course end date |
No |
|
|
coursedesc |
nvarchar(40) |
NULL |
Course description |
No |
hrdesc40 |
|
noofmandays |
int |
NULL |
manadatory days |
No |
hrint |
|
hrmandays |
int |
NULL |
days |
No |
|
|
empunit |
nvarchar(40) |
NULL |
Employee unit |
No |
oudesc |
|
trgcal_code |
nvarchar(5) |
NULL |
Training calendar code. |
No |
hrcode |
Table Name: hrtrpt_month_dtls_tmp
|
Purpose: |
To store the month details of the training calendar.
|
||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name |
|
trgcal_ou_code |
int |
NULL |
Training calendar ou code |
No |
hrouid |
|
trgcal_code |
nvarchar(5) |
NULL |
Training calendar code |
No |
hrcode |
|
tr_area |
nvarchar(5) |
NULL |
Training area |
No |
hrquickcode |
|
exp_hdr |
nvarchar(5) |
NULL |
expendiure |
No |
|
|
budget |
numeric(15,4) |
NULL |
budget |
No |
hrsalary |
|
fir |
numeric(15,4) |
NULL |
First month of year |
No |
|
|
sec |
numeric(15,4) |
NULL |
Second month of year |
No |
|
|
third |
numeric(15,4) |
NULL |
Third month of year |
No |
|
|
fourth |
numeric(15,4) |
NULL |
Fourth month of year |
No |
|
|
fifth |
numeric(15,4) |
NULL |
Fifth month of year |
No |
|
|
sixth |
numeric(15,4) |
NULL |
Sixth month of year |
No |
|
|
seventh |
numeric(15,4) |
NULL |
Seventh month of year |
No |
|
|
eighth |
numeric(15,4) |
NULL |
Eighth month of year |
No |
|
|
ninth |
numeric(15,4) |
NULL |
Nineth month of year |
No |
|
|
tenth |
numeric(15,4) |
NULL |
Tenth month of year |
No |
|
|
eleventh |
numeric(15,4) |
NULL |
Eleventh month of year |
No |
|
|
twelth |
numeric(15,4) |
NULL |
twelve month of year |
No |
|
|
parameter |
nvarchar(5) |
NULL |
Parameter of month |
No |
hrquickcode |
Table Name: hrtrpt_month_names_tmp
|
Purpose: |
To store month name details
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
fir |
nvarchar(40) |
NULL |
First month of year |
No |
hrquickcodedesc | |
|
sec |
nvarchar(40) |
NULL |
second month of year |
No |
| |
|
third |
nvarchar(40) |
NULL |
third month of year |
No |
| |
|
fourth |
nvarchar(40) |
NULL |
fourth month of year |
No |
| |
|
fifth |
nvarchar(40) |
NULL |
fifth month of year |
No |
| |
|
sixth |
nvarchar(40) |
NULL |
Sixth month of year |
No |
| |
|
seventh |
nvarchar(40) |
NULL |
seventh month of year |
No |
| |
|
eighth |
nvarchar(40) |
NULL |
eighth month of year |
No |
| |
|
ninth |
nvarchar(40) |
NULL |
nine month of year |
No |
| |
|
tenth |
nvarchar(40) |
NULL |
tenth month of year |
No |
| |
|
eleventh |
nvarchar(40) |
NULL |
eleventh month of year |
No |
| |
|
twelth |
nvarchar(40) |
NULL |
twelth month of year |
No |
| |
|
|
|
|
|
|
|
|
Table Name: hrtrpt_trg_schedule_tmp
|
Purpose: |
To store training schedule details of trainees.
|
|||||
|
Column Name |
Column Datatype |
Column Null Option |
Column Comment |
Column Is PK |
Column Domain Name | |
|
slno |
int |
IDENTITY |
Serial number |
Yes |
hrint10 | |
|
guid |
nvarchar(40) |
NOT NULL |
Globally unique identifier |
Yes |
hrguid | |
|
trgcal_code |
nvarchar(5) |
NOT NULL |
Training cal code |
Yes |
hrcode | |
|
trgcal_ou_desc |
nvarchar(40) |
NULL |
Training cal ou code |
No |
oudesc | |
|
cal_desc |
nvarchar(25) |
NULL |
Calendar description |
No |
hrdescription | |
|
cal_status |
nvarchar(40) |
NULL |
Calendar status |
No |
hrquickcodedesc | |
|
int_ext_flag |
nvarchar(3) |
NULL |
int |
No |
hrflag | |
|
pgm_desc |
nvarchar(40) |
NULL |
Program description |
No |
hrbndesc40 | |
|
mod_desc |
nvarchar(40) |
NULL |
Module description |
No |
hrdesc40 | |
|
course_code |
nvarchar(5) |
NULL |
Course code |
No |
hrcode | |
|
course_desc |
nvarchar(40) |
NULL |
Course description |
No |
hrdesc40 | |
|
start_dt |
datetime |
NULL |
Start date |
No |
Datetime | |
|
end_dt |
datetime |
NULL |
End date |
No |
| |
|
sortby |
nvarchar(40) |
NULL |
Sortby |
No |
hrdesc40 | |
|
thenby1 |
nvarchar(40) |
NULL |
Thenby1 |
No |
| |
|
thenby2 |
nvarchar(40) |
NULL |
Thenby2 |
No |
| |
|
|
|
|
|
|
|
|