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_SALARY_I

Object Details

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

PSB_SALARY_I is the interface table for importing salary information.
Salary information imported into this table is then transferred to the
normalized tables PSB_PAY_ELEMENTS, PSB_PAY_ELEMENT_OPTIONS, and
PSB_PAY_ELEMENT_RATES.
Salary assigned to an employee can be a Grade Rate structure, Grade
Step structure, or Non-Grade structure.
For the Grade Rate structure, RATE_OR_PAYSCALE_ID, GRADE_ID,
MAXIMUM_VALUE, MINIMUM_VALUE, MID_VALUE, and ELEMENT_VALUE
columns are required.
For the Grade Step structure, RATE_OR_PAYSCALE_ID, GRADE_ID, GRADE_STEP,
SEQUENCE_NUMBER, and ELEMENT_VALUE are required.
For Non-Grade structure, ELEMENT_VALUE is the only required column.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_SALARY_1_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	RATE_OR_PAYSCALE_ID GRADE_ID GRADE_STEP SEQUENCE_NUMBER DATA_EXTRACT_ID
PSB_SALARY_1_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	GRADE_ID DATA_EXTRACT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_ID	NUMBER	(20)	Yes	Business group unique identifier
SALARY_TYPE	VARCHAR2	(10)		Salary type for the element is RATE, STEP, or VALUE
DATA_EXTRACT_ID	NUMBER	(15)	Yes	Data extract unique identifier for the rate or payscale
RATE_OR_PAYSCALE_ID	NUMBER	(20)	Yes	Rate or pay scale identifier for the salary element of type RATE or STEP
RATE_OR_PAYSCALE_NAME	VARCHAR2	(30)		Rate or pay scale name
PAY_BASIS	VARCHAR2	(15)		Time basis for recording actual salary values is ANNUAL, MONTHLY, HOURLY, or PERIOD
GRADE_ID	NUMBER	(20)	Yes	Grade unique identifier
GRADE_NAME	VARCHAR2	(80)		Grade name
GRADE_STEP	NUMBER	(15)		Grade step is applicable to salary elements of type STEP
SEQUENCE_NUMBER	NUMBER			Incremental order of the grade step within the pay scale and grade
MINIMUM_VALUE	NUMBER			Minimum value for the grade rate
MAXIMUM_VALUE	NUMBER			Maximum value for the grade rate
MID_VALUE	NUMBER			Average value for the grade rate
ELEMENT_VALUE	NUMBER			Value for the grade rate or grade step
ELEMENT_TYPE_ID	NUMBER	(15)		Element type identifier in source Human Resource Management system
EFFECTIVE_START_DATE	DATE		Yes	Effective start date
EFFECTIVE_END_DATE	DATE			Effective end date
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 BUSINESS_GROUP_ID
,      SALARY_TYPE
,      DATA_EXTRACT_ID
,      RATE_OR_PAYSCALE_ID
,      RATE_OR_PAYSCALE_NAME
,      PAY_BASIS
,      GRADE_ID
,      GRADE_NAME
,      GRADE_STEP
,      SEQUENCE_NUMBER
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      MID_VALUE
,      ELEMENT_VALUE
,      ELEMENT_TYPE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM PSB.PSB_SALARY_I;

Dependencies

[top of page]

PSB.PSB_SALARY_I does not reference any database object

PSB.PSB_SALARY_I is referenced by following:

APPS: PSB_SALARY_I