eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PSB.PSB_HRMS_FACTORS

Object Details

Object Name:	PSB_HRMS_FACTORS
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_HRMS_FACTORS
Subobject Name:
Status:	VALID

PSB_HRMS_FACTORS stores conversion factors for rates from Human
Resource Management Systems periods to Public Sector Budgeting
periods. For example, if salary is defined in Human Resource
Management Systems as Weekly amounts and budgets are calculated
in Monthly amounts, the week-to-month conversion factor is applied to
the salary defined in Human Resource Management Systems.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
HRMS_PERIOD_TYPE	VARCHAR2	(10)	Yes	Oracle Human Resource Management system period type
BUDGET_PERIOD_TYPE	VARCHAR2	(10)	Yes	Public Sector Budgeting period type
FACTOR	NUMBER		Yes	Conversion factor

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HRMS_PERIOD_TYPE
,      BUDGET_PERIOD_TYPE
,      FACTOR
FROM PSB.PSB_HRMS_FACTORS;

Dependencies

[top of page]

PSB.PSB_HRMS_FACTORS does not reference any database object

PSB.PSB_HRMS_FACTORS is referenced by following:

APPS: PSB_HRMS_FACTORS