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

TABLE: PSP.PSP_PAYROLL_LINES

Object Details
Object Name: PSP_PAYROLL_LINES
Object Type: TABLE
Owner: PSP
FND Design Data: TablePSP.PSP_PAYROLL_LINES
Subobject Name:
Status: VALID


PSP_PAYROLL_LINES contains information on each payroll line
imported from Oracle Payroll and non-Oracle payroll sources after
a payroll process is run. Payroll information maintained here is used
for creating payroll sublines. Every payroll line must be split into
one or more payroll sublines based on Dates of Interests. Every
payroll line must correspond to one payroll control.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_PAYROLL_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_LINE_ID
PSP_PAYROLL_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_CONTROL_ID
PSP_PAYROLL_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_ID
PSP_PAYROLL_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
PAYROLL_LINE_ID NUMBER (10) Yes System-generated primary key
SET_OF_BOOKS_ID NUMBER (9) Yes Identifies Set of Books in General Ledger
ASSIGNMENT_ID NUMBER (9) Yes Foreign key to PER_ASSIGNMENTS_F
PERSON_ID NUMBER (9) Yes Foreign key to PER_PEOPLE_F
ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PAY_ELEMENT_ENTRIES_F
PAY_AMOUNT NUMBER
Yes Pay amount
STATUS_CODE VARCHAR2 (30) Yes Identifies status of the transaction. Values are New, Transferred, and Error.
PAYROLL_CONTROL_ID NUMBER (10) Yes Foreign key to PSP_PAYROLL_CONTROLS
CHECK_DATE DATE

Date on Pay Advices
EARNED_DATE DATE

Date-earned value for a payroll run, usually the same value as Effective Date
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX
GL_CODE_COMBINATION_ID NUMBER (15)
Foreign key to GL_CODE_COMBINATIONS
BALANCE_AMOUNT NUMBER

Calculated balance amount paid for various reasons
DR_CR_FLAG VARCHAR2 (1) Yes Indicates whether the value is D for Debit or C for Credit
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
EFFECTIVE_DATE DATE
Yes Session date for payroll run. This is Date Paid.
COST_ID NUMBER (9)
Foreign key to PAY_COSTS
ACCOUNTING_DATE DATE

Accounting Date
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
PAYROLL_ACTION_TYPE VARCHAR2 (2)
Payroll Action Type (R-Regular run, Q-Quick Pay, L-Retro)
OR_GL_CODE_COMBINATION_ID NUMBER (15)
Override GL Code Combination
OR_PROJECT_ID NUMBER (15)
Override Project Id
OR_TASK_ID NUMBER (15)
Override Task Id
OR_AWARD_ID NUMBER (15)
Override Award Id
OR_EXPENDITURE_ORG_ID NUMBER (15)
Override Expenditure Org Id
OR_EXPENDITURE_TYPE VARCHAR2 (30)
Override Expenditure Type
Query Text

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


SELECT PAYROLL_LINE_ID
,      SET_OF_BOOKS_ID
,      ASSIGNMENT_ID
,      PERSON_ID
,      ELEMENT_TYPE_ID
,      PAY_AMOUNT
,      STATUS_CODE
,      PAYROLL_CONTROL_ID
,      CHECK_DATE
,      EARNED_DATE
,      COST_ALLOCATION_KEYFLEX_ID
,      GL_CODE_COMBINATION_ID
,      BALANCE_AMOUNT
,      DR_CR_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      EFFECTIVE_DATE
,      COST_ID
,      ACCOUNTING_DATE
,      EXCHANGE_RATE_TYPE
,      PAYROLL_ACTION_TYPE
,      OR_GL_CODE_COMBINATION_ID
,      OR_PROJECT_ID
,      OR_TASK_ID
,      OR_AWARD_ID
,      OR_EXPENDITURE_ORG_ID
,      OR_EXPENDITURE_TYPE
FROM PSP.PSP_PAYROLL_LINES;

Dependencies

[top of page]

PSP.PSP_PAYROLL_LINES does not reference any database object

PSP.PSP_PAYROLL_LINES is referenced by following:

SchemaAPPS
SynonymPSP_PAYROLL_LINES
TriggerPSP_PAYROLL_LINES_WHO