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_RECORDS

Object Details

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

PAY_MAGNETIC_RECORDS controls the detailed formatting of the fixed
format version of the magnetic tape process. It specifies which
formatting formulas are invoked to enable tape records to be written
to the output files.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: PAY_MAGNETIC_RECORDS_PK

MAGNETIC_BLOCK_ID
SEQUENCE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_MAGNETIC_RECORDS_PK	NORMAL	UNIQUE	APPS_TS_SEED	MAGNETIC_BLOCK_ID SEQUENCE
PAY_MAGNETIC_RECORDS_FK2	NORMAL	NONUNIQUE	APPS_TS_SEED	MAGNETIC_BLOCK_ID
PAY_MAGNETIC_RECORDS_FK3	NORMAL	NONUNIQUE	APPS_TS_SEED	NEXT_BLOCK_ID
PAY_MAGNETIC_RECORDS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FORMULA_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_MAGNETIC_RECORDS		PAY_MAGNETIC_BLOCKS	PAY_MAGNETIC_RECORDS NEXT_BLOCK_ID
PAY_MAGNETIC_RECORDS		PAY_MAGNETIC_BLOCKS	PAY_MAGNETIC_RECORDS MAGNETIC_BLOCK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULA_ID	NUMBER	(9)	Yes	Foreign key to PAY_FORMULAS.
MAGNETIC_BLOCK_ID	NUMBER	(9)	Yes	Foreign key to PAY_MAGNETIC_BLOCKS.
NEXT_BLOCK_ID	NUMBER	(9)		Foreign key to PAY_MAGNETIC_BLOCKS.
OVERFLOW_MODE	VARCHAR2	(30)	Yes	Indicates whether the formula is run for each cursor row once only or more than once.
SEQUENCE	NUMBER	(5)	Yes	Sequence of formulas within a block.
FREQUENCY	NUMBER	(5)		Number of iterations within the block before the record is output.
LAST_RUN_EXECUTED_MODE	VARCHAR2	(30)	Yes	Specifies the rules for formula execution when the last row is retrieved from the cursor.
ACTION_LEVEL	VARCHAR2	(30)		Determines whether the record is precalculated due to multithreading.
BLOCK_LABEL	VARCHAR2	(30)		Block label
BLOCK_ROW_LABEL	VARCHAR2	(30)		Block row label
XML_PROC_NAME	VARCHAR2	(256)		pl/sql that generates the xml

Query Text

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


SELECT FORMULA_ID
,      MAGNETIC_BLOCK_ID
,      NEXT_BLOCK_ID
,      OVERFLOW_MODE
,      SEQUENCE
,      FREQUENCY
,      LAST_RUN_EXECUTED_MODE
,      ACTION_LEVEL
,      BLOCK_LABEL
,      BLOCK_ROW_LABEL
,      XML_PROC_NAME
FROM HR.PAY_MAGNETIC_RECORDS;

Dependencies

[top of page]

HR.PAY_MAGNETIC_RECORDS does not reference any database object

HR.PAY_MAGNETIC_RECORDS is referenced by following:

APPS: PAY_MAGNETIC_RECORDS
PUBLIC: PAY_MAGNETIC_RECORDS