Can I get detailed information on different dimensions like ASG_ITD, _YTD,PROC_PTD and when these imensions should be used. Under what circumstances these dimensions should be decided. Can I also know how to print the value of a formula which is returning to indirect results??
Can anybody provide me detailed on this. U can send this to my email sapna500@hotmail.com
Balance Dimensions
-
- Posts: 1
- Joined: Wed Jul 25, 2007 8:35 am
- Location: Egypt
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
-
- Posts: 12
- Joined: Wed Aug 01, 2007 3:10 pm
- Location: Egypt
dear SIR
This table describes the seeded balance dimensions:
Dimension Name Type Database Item Suffix
Payments N _PAYMENTS
Assignment Run R _ASG_RUN
Assignment Inception to Date A _ASG_ITD
Assignment Processing Period to Date A _ASG_PTD
Assignment Calendar Month to Date A _ASG_MONTH
Assignment Calendar Quarter to Date A _ASG_QTD
Assignment Calendar Year to Date A _ASG_YTD
Assignment Tax Quarter to Date A _ASG_TQTD
Assignment Tax Year to Date A _ASG_TYTD
Assignment Fiscal Quarter to Date A _ASG_FQTD
Assignment Fiscal Year to Date A _ASG_FYTD
Person Inception to Date P _PER_ITD
Person Processing Period to Date P _PER_PTD
Person Calendar Month to Date P _PER_MONTH
Person Calendar Quarter to Date P _PER_QTD
Person Calendar Year to Date P _PER_YTD
Person Tax Quarter to Date P _PER_TQTD
Person Tax Year to Date P _PER_TYTD
Person Fiscal Quarter to Date P _PER_FQTD
Person Fiscal Year to Date P _PER_FYTD
Element Entry Inception to Date A _ENTRY_ITD
Element Entry Processing Period to Date A _ENTRY_PTD
Element Entry Calendar Month to Date A _ENTRY_MONTH
Element Entry Calendar Quarter to Date A _ENTRY_QTD
Element Entry Calendar Year to Date A _ENTRY_YTD
Balances show the
positive or negative accumulation of particular values over periods of time.
it can be R =run, ,P person,
etc
Eng. Khalid seif el nasr
Oracle E-Business Consultant
HRMS Track Leader
Satyam Computer service
eng_khalidseif@yahoo.com
f
This table describes the seeded balance dimensions:
Dimension Name Type Database Item Suffix
Payments N _PAYMENTS
Assignment Run R _ASG_RUN
Assignment Inception to Date A _ASG_ITD
Assignment Processing Period to Date A _ASG_PTD
Assignment Calendar Month to Date A _ASG_MONTH
Assignment Calendar Quarter to Date A _ASG_QTD
Assignment Calendar Year to Date A _ASG_YTD
Assignment Tax Quarter to Date A _ASG_TQTD
Assignment Tax Year to Date A _ASG_TYTD
Assignment Fiscal Quarter to Date A _ASG_FQTD
Assignment Fiscal Year to Date A _ASG_FYTD
Person Inception to Date P _PER_ITD
Person Processing Period to Date P _PER_PTD
Person Calendar Month to Date P _PER_MONTH
Person Calendar Quarter to Date P _PER_QTD
Person Calendar Year to Date P _PER_YTD
Person Tax Quarter to Date P _PER_TQTD
Person Tax Year to Date P _PER_TYTD
Person Fiscal Quarter to Date P _PER_FQTD
Person Fiscal Year to Date P _PER_FYTD
Element Entry Inception to Date A _ENTRY_ITD
Element Entry Processing Period to Date A _ENTRY_PTD
Element Entry Calendar Month to Date A _ENTRY_MONTH
Element Entry Calendar Quarter to Date A _ENTRY_QTD
Element Entry Calendar Year to Date A _ENTRY_YTD
Balances show the
positive or negative accumulation of particular values over periods of time.
it can be R =run, ,P person,
etc
Eng. Khalid seif el nasr
Oracle E-Business Consultant
HRMS Track Leader
Satyam Computer service
eng_khalidseif@yahoo.com
f
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
Dears,
For detailed understanding you can refer for the following metalink notes:
1. How do you associate elements with balances?
Doc ID: Note:377395.1
2.BALANCES: Understanding Balances and Balance Retrieval
in Oracle Payroll
Doc ID: Note:74315.1
3. The Secret Life of Initial Balance Upload
Doc ID: Note:60057.1
4. How To Create a Database Item for a Balance?
Doc ID: Note:249935.1
This will clear most of the issues with concepts of balances.
Regards
Sayed.
For detailed understanding you can refer for the following metalink notes:
1. How do you associate elements with balances?
Doc ID: Note:377395.1
2.BALANCES: Understanding Balances and Balance Retrieval
in Oracle Payroll
Doc ID: Note:74315.1
3. The Secret Life of Initial Balance Upload
Doc ID: Note:60057.1
4. How To Create a Database Item for a Balance?
Doc ID: Note:249935.1
This will clear most of the issues with concepts of balances.
Regards
Sayed.
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
Dears
In addtion to this you can also refer the following table
Payroll Balance Dimensions
Oracle HRMS provides the following predefined balance dimensions.
Standard Dimensions
The following table provides the balance dimensions that you can use to sum values for single assignments:
Balance Dimensions
Database Item Suffix Description
_ASG_MONTH_NO_LEAVERS Since the start of the month to date for the employees who are neither joiners nor leavers.
_ASG_MONTH_NEW_JOINERS Since the start of the month to date for the employees who are new joiners.
_ASG_MONTH_LEAVERS Since the start of the month to date for the employees who are leavers.
_ASG_TU_MONTH_NO_LEAVERS Since the start of the month to date for the employees who are neither joiners nor leavers within the tax unit (Legal Employer).
_ASG_TU_MONTH_NEW_JOINERS Since the start of the month to date for the new joiners within the tax unit (Legal Employer).
In addtion to this you can also refer the following table
Payroll Balance Dimensions
Oracle HRMS provides the following predefined balance dimensions.
Standard Dimensions
The following table provides the balance dimensions that you can use to sum values for single assignments:
Balance Dimensions
Database Item Suffix Description
_ASG_MONTH_NO_LEAVERS Since the start of the month to date for the employees who are neither joiners nor leavers.
_ASG_MONTH_NEW_JOINERS Since the start of the month to date for the employees who are new joiners.
_ASG_MONTH_LEAVERS Since the start of the month to date for the employees who are leavers.
_ASG_TU_MONTH_NO_LEAVERS Since the start of the month to date for the employees who are neither joiners nor leavers within the tax unit (Legal Employer).
_ASG_TU_MONTH_NEW_JOINERS Since the start of the month to date for the new joiners within the tax unit (Legal Employer).
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
_ASG_TU_MONTH_LEAVERS Since the start of the month to date, who are leavers within the tax unit (Legal Employer).
_ASG_TU_ITD Since the start of the month to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_PTD Since the start of the processing period to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_MONTH Since the start of the calendar month to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_QTD Since the start of the calendar quarter to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_YTD Since the start of the calendar year to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_FQTD Since the start of the fiscal quarter to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_FYTD Since the start of the fiscal year to date for the assignment within the tax unit (Legal Employer).
_PER_TU_ITD Since the start of the month to date for a person within the tax unit (Legal Employer).
_PER_TU_PTD Since the start of the processing period to date for a person within the tax unit (Legal Employer).
_ASG_TU_ITD Since the start of the month to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_PTD Since the start of the processing period to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_MONTH Since the start of the calendar month to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_QTD Since the start of the calendar quarter to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_YTD Since the start of the calendar year to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_FQTD Since the start of the fiscal quarter to date for the assignment within the tax unit (Legal Employer).
_ASG_TU_FYTD Since the start of the fiscal year to date for the assignment within the tax unit (Legal Employer).
_PER_TU_ITD Since the start of the month to date for a person within the tax unit (Legal Employer).
_PER_TU_PTD Since the start of the processing period to date for a person within the tax unit (Legal Employer).
-
- Posts: 21
- Joined: Fri Oct 17, 2008 8:30 pm
- Location: India
_PER_TU_MONTH Since the start of the month to date for the person within the tax unit (Legal Employer).
_PER_TU_QTD Since the start of the calendar quarter to date for the person within the tax unit (Legal Employer).
_PER_TU_YTD Since the start of the calendar year to date for the person within the tax unit (Legal Employer).
_PER_TU_FQTD
_PER_TU_FYTD Since the start of the fiscal year to date for
_PER_TU_QTD Since the start of the calendar quarter to date for the person within the tax unit (Legal Employer).
_PER_TU_YTD Since the start of the calendar year to date for the person within the tax unit (Legal Employer).
_PER_TU_FQTD
_PER_TU_FYTD Since the start of the fiscal year to date for
Who is online
Users browsing this forum: No registered users and 1 guest