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


TABLE: HR.PAY_REPORT_FORMAT_MAPPINGS_F

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


PAY_REPORT_FORMAT_MAPPINGS_F is the DateTracked table that holds the
format mapping of a report for a given jurisdiction to the fixed
format defined for the magnetic tape.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Primary Key: PAY_REPORT_FORMAT_MAPPINGS_PK
  1. ColumnREPORT_TYPE
  2. ColumnREPORT_QUALIFIER
  3. ColumnREPORT_CATEGORY
  4. ColumnEFFECTIVE_START_DATE
  5. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PAY_REPORT_FORMAT_MAPPINGS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnREPORT_TYPE
ColumnREPORT_QUALIFIER
ColumnREPORT_CATEGORY
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
REPORT_TYPE VARCHAR2 (30) Yes Report whose format is being mapped eg. W2.
REPORT_QUALIFIER VARCHAR2 (30) Yes Refinement within report type eg. state for W2 reports.
REPORT_FORMAT VARCHAR2 (30) Yes Fixed format to be used for the report for this qualifier.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
RANGE_CODE VARCHAR2 (60)
Contains name of the procedure used to specify ranges of assignments to be processed in the archive.
ASSIGNMENT_ACTION_CODE VARCHAR2 (60)
Contains name of the procedure used to create the assignment actions to be processed.
INITIALIZATION_CODE VARCHAR2 (60)
Sets any global contexts that need to be set for the lifetime of the archiving. If this is NULL no archiving is performed.
ARCHIVE_CODE VARCHAR2 (60)
Set contexts used during the archive.
MAGNETIC_CODE VARCHAR2 (60)
Holds the driving PL/SQL procedure of the Magnetic Tape. If this is NULL no magnetic tape is produced.
REPORT_CATEGORY VARCHAR2 (30) Yes Denotes the media type.
REPORT_NAME VARCHAR2 (60)
The name of the report to be processed. If this is NULL no report is processed.
SORT_CODE VARCHAR2 (60)
This is used to sort the assignment actions into the order in which they should appear in the report, if a report is being processed.
UPDATABLE_FLAG VARCHAR2 (1)
Can archived data be modified (Y/N).
DEINITIALIZATION_CODE VARCHAR2 (60)
Deinitializes any contexts set up by the initialization_code procedure.
REPORT_FORMAT_MAPPING_ID NUMBER (15)
System generated primary key
BUSINESS_GROUP_ID NUMBER (15)
Business Group ID
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
TEMPORARY_ACTION_FLAG VARCHAR2 (1)
Indicattes if the actions used bt the process are temporary
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
Query Text

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


SELECT REPORT_TYPE
,      REPORT_QUALIFIER
,      REPORT_FORMAT
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RANGE_CODE
,      ASSIGNMENT_ACTION_CODE
,      INITIALIZATION_CODE
,      ARCHIVE_CODE
,      MAGNETIC_CODE
,      REPORT_CATEGORY
,      REPORT_NAME
,      SORT_CODE
,      UPDATABLE_FLAG
,      DEINITIALIZATION_CODE
,      REPORT_FORMAT_MAPPING_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      TEMPORARY_ACTION_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PAY_REPORT_FORMAT_MAPPINGS_F;

Dependencies

[top of page]

HR.PAY_REPORT_FORMAT_MAPPINGS_F does not reference any database object

HR.PAY_REPORT_FORMAT_MAPPINGS_F is referenced by following:

SchemaAPPS
SynonymPAY_REPORT_FORMAT_MAPPINGS_F
TriggerPAY_REPORT_FORMAT_MAPPINGS_WHO
SchemaPUBLIC
SynonymPAY_REPORT_FORMAT_MAPPINGS_F