How to make leave calendar in Oracle HRMS
-
- Posts: 6
- Joined: Thu Nov 27, 2008 7:28 am
- Location: Pakistan
How to make leave calendar in Oracle HRMS
Does any body know how to make calendar for leaves purpose and also how to make leave paln???
Thanks
Maria
Thanks
Maria
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
-
- Posts: 6
- Joined: Thu Nov 27, 2008 7:28 am
- Location: Pakistan
-
- Posts: 388
- Joined: Wed Oct 03, 2007 11:32 pm
- Location: Saudi Arabia
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
dear alruwaished,
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
-
- Posts: 6
- Joined: Thu Nov 27, 2008 7:28 am
- Location: Pakistan
Dear Najaf,
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria
-
- Posts: 388
- Joined: Wed Oct 03, 2007 11:32 pm
- Location: Saudi Arabia
[quote]dear alruwaished,
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
<i><div align="right">Originally posted by sayed.najafali
Are you sure what are you speaking about. Please do not provide base less replies
dear Maria/shakir,
for creating and UDT you need to follow the following steps.
1. HRMS Manager -> Other Definitions -> Table Structure
a.User Column Key Name
<Col_name> <col name>
b. Sequence Exact User Row Key
10 <Row Name> <Row Name>
2. HRMS Manager -> Other Definitions -> Table Values
query for the table structure you created and then query for the rows and then insert the values.
hope this helps, feel free to revert back for any more clarifications
Regards
Sayed
<i><div align="right">Originally posted by sayed.najafali
-
- Posts: 6
- Joined: Thu Nov 27, 2008 7:28 am
- Location: Pakistan
Dear Najaf,
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria
I've created the table using Table Structure in Other definitions.
table name is 'leave_calendar' match type is 'MATCH' and key unit of measure is 'Date'.
In columns I have got 1 column that is 'Calendar' and in rows I have '10' in sequence and '04-DEC-2008' in exact.
after creating table structure I put table values using 'table value' in other definitions.
Now please tell me, have i created it correctly and how do can I cal it in Absence form and mark on calendar.
Thanks for your help.
Regards,
Maria
Who is online
Users browsing this forum: No registered users and 0 guests