Skip to content

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

TABLE: PSP.PSP_PAYROLL_CONTROLS_EFC

Object Details
Object Name: PSP_PAYROLL_CONTROLS_EFC
Object Type: TABLE
Owner: PSP
Subobject Name:
Status: VALID


EFC Shadow table for PSP_PAYROLL_CONTROLS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EFC_ACTION_ID NUMBER
Yes Foreign key for HR_EFC_ACTIONS
PAYROLL_CONTROL_ID NUMBER (10) Yes Foreign key for PSP_PAYROLL_CONTROLS
TOTAL_DR_AMOUNT NUMBER

Total Debit Amount
TOTAL_CR_AMOUNT NUMBER

Total Credit Amount
SUBLINES_DR_AMOUNT NUMBER

Total Sublines debit amount
SUBLINES_CR_AMOUNT NUMBER

Total Sublines credit amount
DIST_DR_AMOUNT NUMBER

Total Distributed debit amount
DIST_CR_AMOUNT NUMBER

Total Distributed credit amount
OGM_DR_AMOUNT NUMBER

Summarized and transferred debit amount to Grants
OGM_CR_AMOUNT NUMBER

Summarized and transferred credit amount to Grants
GL_DR_AMOUNT NUMBER

Summarized and transferred debit amount to GL
GL_CR_AMOUNT NUMBER

Summarized and transferred credit amount to GL
CURRENCY_CODE VARCHAR2 (15)
Currency Code
Query Text

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


SELECT EFC_ACTION_ID
,      PAYROLL_CONTROL_ID
,      TOTAL_DR_AMOUNT
,      TOTAL_CR_AMOUNT
,      SUBLINES_DR_AMOUNT
,      SUBLINES_CR_AMOUNT
,      DIST_DR_AMOUNT
,      DIST_CR_AMOUNT
,      OGM_DR_AMOUNT
,      OGM_CR_AMOUNT
,      GL_DR_AMOUNT
,      GL_CR_AMOUNT
,      CURRENCY_CODE
FROM PSP.PSP_PAYROLL_CONTROLS_EFC;

Dependencies

[top of page]

PSP.PSP_PAYROLL_CONTROLS_EFC does not reference any database object

PSP.PSP_PAYROLL_CONTROLS_EFC is referenced by following:

SchemaPSP
ViewPSP_PAYROLL_CONTROLS_EFC#