Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_FILE_DETAILS

Object Details
Object Name: PAY_FILE_DETAILS
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_FILE_DETAILS
Subobject Name:
Status: VALID


PAY_FILE_DETAILS is a Table that holds specific internal files thathave been generated.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PAY_FILE_DETAILS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFILE_DETAIL_ID
SYS_IL0000408648C00006$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000408648C00007$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PAY_FILE_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_ID
ColumnSOURCE_TYPE
Columns
Name Datatype Length Mandatory Comments
FILE_DETAIL_ID NUMBER (15) Yes System generated Primary Key
SOURCE_ID NUMBER (15) Yes Foreign Key to an entity described by the SOURCE_TYPE column
SOURCE_TYPE VARCHAR2 (30) Yes Denotes the source of the SOURCE_ID attribute
FILE_TYPE VARCHAR2 (30) Yes Denotes the type of file.
FILE_LOCATION VARCHAR2 (255)
The Operating System location of the file.
FILE_FRAGMENT CLOB (4000)
Whole or Partial file content
BLOB_FILE_FRAGMENT BLOB (4000)
BLOB File Fragment
INTERNAL_FILE_NAME VARCHAR2 (240)
Internal name for the file
SEQUENCE NUMBER (15)
File Sequence
Query Text

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


SELECT FILE_DETAIL_ID
,      SOURCE_ID
,      SOURCE_TYPE
,      FILE_TYPE
,      FILE_LOCATION
,      FILE_FRAGMENT
,      BLOB_FILE_FRAGMENT
,      INTERNAL_FILE_NAME
,      SEQUENCE
FROM HR.PAY_FILE_DETAILS;

Dependencies

[top of page]

HR.PAY_FILE_DETAILS does not reference any database object

HR.PAY_FILE_DETAILS is referenced by following:

SchemaHR
ViewPAY_FILE_DETAILS#