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: HR.PAY_MESSAGE_LINES

Object Details

Object Name:	PAY_MESSAGE_LINES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_MESSAGE_LINES
Subobject Name:
Status:	VALID

PAY_MESSAGE_LINES holds details of messages that may result from
running a process, including any fatal, warning or general error
messages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_MESSAGE_LINES_PK

LINE_SEQUENCE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_MESSAGE_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_SEQUENCE
PAY_MESSAGE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID
PAY_MESSAGE_LINES_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_SEQUENCE	NUMBER	(15)	Yes	Displays sequence of this line. This is a global sequence.
PAYROLL_ID	NUMBER	(9)		Foreign key to PAY_PAYROLLS.
MESSAGE_LEVEL	VARCHAR2	(1)	Yes	Indicates the severity of the message, from fatal errors to general messages.
SOURCE_ID	NUMBER	(15)	Yes	Generic foreign key to the message owner.
SOURCE_TYPE	VARCHAR2	(1)	Yes	Specifies the message owner type: assignment action, payroll action or Business Group.
LINE_TEXT	VARCHAR2	(2000)		Text for the line.

Query Text

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


SELECT LINE_SEQUENCE
,      PAYROLL_ID
,      MESSAGE_LEVEL
,      SOURCE_ID
,      SOURCE_TYPE
,      LINE_TEXT
FROM HR.PAY_MESSAGE_LINES;

Dependencies

[top of page]

HR.PAY_MESSAGE_LINES does not reference any database object

HR.PAY_MESSAGE_LINES is referenced by following:

HR: PAY_MESSAGE_LINES#