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_COST_DISTRIBUTIONS_I

Object Details

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

PSB_COST_DISTRIBUTIONS_I is the interface table which holds
the cost allocation details at various costing levels for a position.
Ranging from top to bottom, the costing levels are
PAYROLL, ELEMENT LINK, ORGANIZATION, and ASSIGNMENT.
The segment values at a lower level always override the value from
the higher level. The distribution proportions are defined at the
assignment level only. So there can be multiple combinations at
the assignment level. The total proportion for an assignment at any
point in time should equal 100. At all other levels, only one
combination can be entered. If no combination is defined at the assignment
level, then the distribution proportion at the next lowest level should
default to 100.The complete code combinations are built
by combining the segment values from the various levels with lower
level overriding values from a higher level. The details in this table
are used to populate PSB_POSITION_PAY_DISTRIBUTIONS in Public Sector
Budgeting.
Example Data
Fund Org Prog Acct
LEVEL SEG1 SEG2 SEG3 SEG4 PROPORTION
PAYROLL 101
ELEMENT LINK 6400
ORGANIZATION 220
ASSIGNMENT 321 6401 70 %
ASSIGNMENT 322 6401 30%
The following code combinations are derived from the above data :

101.220.321.6401 70 %
101.220.322.6401 30 %

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_COST_DISTRIBUTIONS_I_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSIGNMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DATA_EXTRACT_ID	NUMBER		Yes	Data extract unique identifier
ASSIGNMENT_ID	NUMBER	(20)	Yes	Human Resource Management Systems assignment unique identifier. For non-Oracle Human Resource Management Systems, the ASSIGNMENT_ID is EMPLOYEE_ID.
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group unique identifier
COSTING_LEVEL	VARCHAR2	(20)	Yes	Level at which the cost allocation percentages are defined. Valid values are PAYROLL, ELEMENT LINK, ORGANIZATION or ASSIGNMENT. For non-Oracle Human Resources Management Systems, set costing level to ASSIGNMENT.
PROPORTION	NUMBER		Yes	Proportion or distribution of the cost. For non-Oracle Human Resources Management Systems, set proportion to 100% if the cost of each employee (ASSIGNMENT_ID) is charged to one account. If an employee is charged to multiple accounts at a given time, use appropriate percentages,say 40% and 60% for the first and second accounts. If appropriate percentages cannot be determined, use 0% instead of 100%.
CHART_OF_ACCOUNTS_ID	NUMBER		Yes	Chart of accounts unique identifier
EFFECTIVE_START_DATE	DATE		Yes	Effective start date
EFFECTIVE_END_DATE	DATE			Effective end date
PROJECT_ID	NUMBER	(15)		Project identifier for Grants Accounting charging instructions
TASK_ID	NUMBER	(15)		Task identifier for Grants Accounting charging instructions
AWARD_ID	NUMBER	(15)		Award identifier for Grants Accounting charging instructions
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(15)		Cost allocation key flexfield identifier
EXPENDITURE_TYPE	VARCHAR2	(30)		Expenditure type for Grants Accounting charging instructions
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)		Expenditure organization identifier for Grants Accounting charging instructions
DESCRIPTION	VARCHAR2	(365)		Grants Accounting charging instructions description
SEGMENT1	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT2	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT3	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT4	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT5	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT6	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT7	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT8	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT9	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT10	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT11	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT12	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT13	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT14	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT15	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT16	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT17	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT18	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT19	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT20	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT21	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT22	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT23	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT24	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT25	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT26	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT27	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT28	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT29	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
SEGMENT30	VARCHAR2	(25)		The Accounting Flexfield segment value that is converted from the corresponding segment value in the Cost Allocation Flexfield.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT DATA_EXTRACT_ID
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      COSTING_LEVEL
,      PROPORTION
,      CHART_OF_ACCOUNTS_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      DESCRIPTION
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_COST_DISTRIBUTIONS_I;

Dependencies

[top of page]

PSB.PSB_COST_DISTRIBUTIONS_I does not reference any database object

PSB.PSB_COST_DISTRIBUTIONS_I is referenced by following:

APPS: PSB_COST_DISTRIBUTIONS_I