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_MAGNETIC_BLOCKS

Object Details

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

PAY_MAGNETIC_BLOCKS is the driving table for the fixed format version
of the magnetic tape process. It controls the outer layer of the tape
formatting, by specifying which cursors are opened and in what order.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_MAGNETIC_BLOCKS_PK	NORMAL	UNIQUE	APPS_TS_SEED	MAGNETIC_BLOCK_ID ZD_EDITION_NAME
PAY_MAGNETIC_BLOCKS_N50	NORMAL	NONUNIQUE	APPS_TS_SEED	REPORT_FORMAT

Columns

Name	Datatype	Length	Mandatory	Comments
MAGNETIC_BLOCK_ID	NUMBER	(9)	Yes	Surrogate primary key.
BLOCK_NAME	VARCHAR2	(80)	Yes	Descriptive block name.
MAIN_BLOCK_FLAG	VARCHAR2	(30)	Yes	Indicates whether the current block is the main entry block.
REPORT_FORMAT	VARCHAR2	(30)	Yes	Key from report format mapping table.
CURSOR_NAME	VARCHAR2	(80)		Holds package name.cursor name for driving cursor.
NO_COLUMN_RETURNED	NUMBER	(5)		Number of select values in cursor.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT MAGNETIC_BLOCK_ID
,      BLOCK_NAME
,      MAIN_BLOCK_FLAG
,      REPORT_FORMAT
,      CURSOR_NAME
,      NO_COLUMN_RETURNED
,      ZD_EDITION_NAME
FROM HR.PAY_MAGNETIC_BLOCKS;

Dependencies

[top of page]

HR.PAY_MAGNETIC_BLOCKS does not reference any database object

HR.PAY_MAGNETIC_BLOCKS is referenced by following:

HR: PAY_MAGNETIC_BLOCKS#