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

TABLE: PA.PA_PAY_INTERFACE_TEMP

Object Details
Object Name: PA_PAY_INTERFACE_TEMP
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PAY_INTERFACE_TEMP
Subobject Name:
Status: VALID

PA_PAY_INTERFACE_TEMP holds payroll data during payroll integration process temporarily.

Temporary Table Details

PA.PA_PAY_INTERFACE_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
COST_TYPE VARCHAR2 (12)
Type of the payroll action
EFFECTIVE_DATE DATE
Yes Session date of the payroll run
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS
CONSOLIDATION_SET_NAME VARCHAR2 (60) Yes Consolidation set name
PAYROLL_NAME VARCHAR2 (80) Yes User name for payroll
ORGANIZATION_NAME VARCHAR2 (240) Yes Name of the employee organization
LOCATION_CODE VARCHAR2 (60)
Location code
FULL_NAME VARCHAR2 (240)
Full name of the employee
FIRST_NAME VARCHAR2 (150)
First name of the employee
LAST_NAME VARCHAR2 (150) Yes Last name of the employee
MIDDLE_NAMES VARCHAR2 (60)
Middle name of the employee
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
NATIONAL_IDENTIFIER VARCHAR2 (30)
National identifier
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number
ELEMENT_NAME VARCHAR2 (80) Yes Pay element name
REPORTING_NAME VARCHAR2 (80)
Reporting name of the pay element
CLASSIFICATION_NAME VARCHAR2 (80) Yes Classification name
INPUT_VALUE_NAME VARCHAR2 (80) Yes Input value name
UOM VARCHAR2 (4000)
Unit of measure for the input value
OUTPUT_CURRENCY_CODE VARCHAR2 (15)
Foreign key to FND_CURRENCIES
CREDIT_AMOUNT NUMBER

Indicates whether the value is a debit (D) or credit (C)
DEBIT_AMOUNT NUMBER

Indicates whether the value is a debit (D) or credit (C)
CONCATENATED_SEGMENTS VARCHAR2 (2000)
Key flexfield segment column
SEGMENT1 VARCHAR2 (60)
Key flexfield segment
SEGMENT2 VARCHAR2 (60)
Key flexfield segment
SEGMENT3 VARCHAR2 (60)
Key flexfield segment
SEGMENT4 VARCHAR2 (60)
Key flexfield segment
SEGMENT5 VARCHAR2 (60)
Key flexfield segment
SEGMENT6 VARCHAR2 (60)
Key flexfield segment
SEGMENT7 VARCHAR2 (60)
Key flexfield segment
SEGMENT8 VARCHAR2 (60)
Key flexfield segment
SEGMENT9 VARCHAR2 (60)
Key flexfield segment
SEGMENT10 VARCHAR2 (60)
Key flexfield segment
SEGMENT11 VARCHAR2 (60)
Key flexfield segment
SEGMENT12 VARCHAR2 (60)
Key flexfield segment
SEGMENT13 VARCHAR2 (60)
Key flexfield segment
SEGMENT14 VARCHAR2 (60)
Key flexfield segment
SEGMENT15 VARCHAR2 (60)
Key flexfield segment
SEGMENT16 VARCHAR2 (60)
Key flexfield segment
SEGMENT17 VARCHAR2 (60)
Key flexfield segment
SEGMENT18 VARCHAR2 (60)
Key flexfield segment
SEGMENT19 VARCHAR2 (60)
Key flexfield segment
SEGMENT20 VARCHAR2 (60)
Key flexfield segment
SEGMENT21 VARCHAR2 (60)
Key flexfield segment
SEGMENT22 VARCHAR2 (60)
Key flexfield segment
SEGMENT23 VARCHAR2 (60)
Key flexfield segment
SEGMENT24 VARCHAR2 (60)
Key flexfield segment
SEGMENT25 VARCHAR2 (60)
Key flexfield segment
SEGMENT26 VARCHAR2 (60)
Key flexfield segment
SEGMENT27 VARCHAR2 (60)
Key flexfield segment
SEGMENT28 VARCHAR2 (60)
Key flexfield segment
SEGMENT29 VARCHAR2 (60)
Key flexfield segment
SEGMENT30 VARCHAR2 (60)
Key flexfield segment
PAYROLL_ACTION_ID NUMBER (9) Yes Identifier of the payroll action of costing
ASSIGNMENT_ACTION_ID NUMBER (15) Yes Foreign key to PAY_ASSIGNMENT_ACTIONS
CONSOLIDATION_SET_ID NUMBER (9) Yes Identifier of the consolidation set to which the payroll belongs
PAYROLL_ID NUMBER (9) Yes Identifier of the employee payroll
TAX_UNIT_ID NUMBER

Identifier of the tax unit
ORGANIZATION_ID NUMBER (15) Yes Identifier of the employee organization
LOCATION_ID NUMBER (15)
Employee location
PERSON_ID NUMBER (10) Yes Identifier of the employee whose payroll is being interfaced. Foreign key to PER_ALL_PEOPLE_F
ASSIGNMENT_ID NUMBER (10) Yes Identifier of the assignment assigned to the person
CLASSIFICATION_ID NUMBER (9) Yes Foreign ket to PAY_ELEMENT_CLASSIFICATIONS
ELEMENT_TYPE_ID NUMBER (9) Yes Identifier of the pay element from Oracle Payroll
INPUT_VALUE_ID NUMBER (9) Yes Identifier of the input value
RUN_RESULT_ID NUMBER (15)
Identifier of the run result
GRE_NAME VARCHAR2 (4000)
Identifies the government reporting entity or legal entity associated with the assignment
COST_ID NUMBER (15) Yes Foreign key to PAY_COSTS
TRANSFERED_TO_PRJ VARCHAR2 (30)
Flag that indicates whether the payroll amount is transrfered to projects
TIME_PERIOD_ID NUMBER (15) Yes Foreign key to PER_TIME_PERIODS
TIME_PERIOD_START_DATE DATE
Yes Start date of pay period
TIME_PERIOD_END_DATE DATE
Yes End date of pay period
SOURCE_CREATOR_TYPE VARCHAR2 (30) Yes Sub-system responsible for maintaining an element entry
SOURCE_START_DATE DATE

Start date of pay period in case of retro amounts
SOURCE_END_DATE DATE

End date of pay period in case of retro amounts
Query Text

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


SELECT COST_TYPE
,      EFFECTIVE_DATE
,      BUSINESS_GROUP_ID
,      CONSOLIDATION_SET_NAME
,      PAYROLL_NAME
,      ORGANIZATION_NAME
,      LOCATION_CODE
,      FULL_NAME
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAMES
,      EMPLOYEE_NUMBER
,      NATIONAL_IDENTIFIER
,      ASSIGNMENT_NUMBER
,      ELEMENT_NAME
,      REPORTING_NAME
,      CLASSIFICATION_NAME
,      INPUT_VALUE_NAME
,      UOM
,      OUTPUT_CURRENCY_CODE
,      CREDIT_AMOUNT
,      DEBIT_AMOUNT
,      CONCATENATED_SEGMENTS
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      CONSOLIDATION_SET_ID
,      PAYROLL_ID
,      TAX_UNIT_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      CLASSIFICATION_ID
,      ELEMENT_TYPE_ID
,      INPUT_VALUE_ID
,      RUN_RESULT_ID
,      GRE_NAME
,      COST_ID
,      TRANSFERED_TO_PRJ
,      TIME_PERIOD_ID
,      TIME_PERIOD_START_DATE
,      TIME_PERIOD_END_DATE
,      SOURCE_CREATOR_TYPE
,      SOURCE_START_DATE
,      SOURCE_END_DATE
FROM PA.PA_PAY_INTERFACE_TEMP;

Dependencies

[top of page]

PA.PA_PAY_INTERFACE_TEMP does not reference any database object

PA.PA_PAY_INTERFACE_TEMP is referenced by following:

SchemaAPPS
SynonymPA_PAY_INTERFACE_TEMP