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: TablePAY.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: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: PAY_MAGNETIC_BLOCKS_PK
  1. ColumnMAGNETIC_BLOCK_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_MAGNETIC_BLOCKS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMAGNETIC_BLOCK_ID
PAY_MAGNETIC_BLOCKS_N50 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnREPORT_FORMAT
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePAY_MAGNETIC_RECORDS PAY_MAGNETIC_RECORDS_FK3 PAY_MAGNETIC_BLOCKS PAY_MAGNETIC_RECORDS NEXT_BLOCK_ID
TablePAY_MAGNETIC_RECORDS PAY_MAGNETIC_RECORDS_FK2 PAY_MAGNETIC_BLOCKS PAY_MAGNETIC_RECORDS MAGNETIC_BLOCK_ID
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.
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
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:

SchemaAPPS
SynonymPAY_MAGNETIC_BLOCKS
SchemaPUBLIC
SynonymPAY_MAGNETIC_BLOCKS