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

TABLE: PSP.PSP_PAYROLL_INTERFACE

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


PSP_PAYROLL_INTERFACE contains non-Oracle sublines to be imported to Labor Distribution. Information in this table is used for integrating non-Oracle payroll data with labor distribution
data. The data in this table is at the sublines level and consists of employee and pay information for particular subline periods.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_PAYROLL_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_NAME
ColumnPAYROLL_INTERFACE_ID
PSP_PAYROLL_INTERFACE_U2 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnPAYROLL_INTERFACE_ID
PSP_PAYROLL_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_NAME
ColumnBUSINESS_GROUP_ID
ColumnSET_OF_BOOKS_ID
PSP_PAYROLL_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnASSIGNMENT_ID
Columns
Name Datatype Length Mandatory Comments
PAYROLL_INTERFACE_ID NUMBER (10) Yes System-generated primary key
PAYROLL_ID NUMBER (9) Yes Payroll Identifier.Foreign key to PAY_PAYROLLS_F
PAYROLL_PERIOD_ID NUMBER (9) Yes Payroll Period Identifier. Foreign key to PER_TIME_PERIODS
PERSON_ID NUMBER (9) Yes Employee Identifier. Foreign key to PER_PEOPLE_F
ASSIGNMENT_ID NUMBER (9) Yes Assignment Identifier. Foreign key to PER_ASSIGNMENTS_F
ELEMENT_TYPE_ID NUMBER (9) Yes Element Identifier. Foreign key to PSP_ELEMENT_TYPES
PAY_AMOUNT NUMBER
Yes Amount to be paid for selected subline period. Pay Amount equals daily rate multiplied by number of business days between subline start and end date.
EARNED_DATE DATE

Date pay amount is earned
CHECK_DATE DATE

Date check is made
EFFECTIVE_DATE DATE
Yes Date pay amount is effective. This is the default date used for summarizing transactions for posting to to General Ledger, Projects or Grants Accounting.
PAYROLL_SOURCE_CODE VARCHAR2 (30) Yes Payroll batch source.Foreign key to PSP_PAYROLL_SOURCES
FTE NUMBER

Full-time equivalent ratio
REASON_CODE VARCHAR2 (30)
Indicates what needs to be fixed to be able to successfully import the batch.Foreign key to PSP_LOOKUPS
SUB_LINE_START_DATE DATE
Yes Start date for current subline period
SUB_LINE_END_DATE DATE
Yes End date for current subline period
DAILY_RATE NUMBER
Yes Daily rate for pay amount
SALARY_USED NUMBER
Yes Salary to be used for pay amount
DR_CR_FLAG VARCHAR2 (1) Yes Indicates if distribution amount is a debit. D indicates Debit and C indicates Credit amount.
STATUS_CODE VARCHAR2 (1) Yes Code indicating status of current subline. Possible values are N for New, V for Valid, E for Error, and T for Transferred.
BATCH_NAME VARCHAR2 (30) Yes Batch name for current batch
ERROR_CODE VARCHAR2 (30)
Code indicating error for current subline
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
GL_POSTING_OVERRIDE_DATE DATE

General Ledger override date for posting. If defined, this date overrides the effective date for posting transactions to General Ledger.
GMS_POSTING_OVERRIDE_DATE DATE

For future use
ATTRIBUTE_CATEGORY VARCHAR2 (240)
Descriptive Flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment column
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Identifier. Foreign key to HR_ALL_ORGANIZATION_UNITS
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books Identifier. Foreign key to GL_SETS_OF_BOOKS
CURRENCY_CODE VARCHAR2 (15)
Currency Code
Query Text

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


SELECT PAYROLL_INTERFACE_ID
,      PAYROLL_ID
,      PAYROLL_PERIOD_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      ELEMENT_TYPE_ID
,      PAY_AMOUNT
,      EARNED_DATE
,      CHECK_DATE
,      EFFECTIVE_DATE
,      PAYROLL_SOURCE_CODE
,      FTE
,      REASON_CODE
,      SUB_LINE_START_DATE
,      SUB_LINE_END_DATE
,      DAILY_RATE
,      SALARY_USED
,      DR_CR_FLAG
,      STATUS_CODE
,      BATCH_NAME
,      ERROR_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      GL_POSTING_OVERRIDE_DATE
,      GMS_POSTING_OVERRIDE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
FROM PSP.PSP_PAYROLL_INTERFACE;

Dependencies

[top of page]

PSP.PSP_PAYROLL_INTERFACE does not reference any database object

PSP.PSP_PAYROLL_INTERFACE is referenced by following:

SchemaAPPS
SynonymPSP_PAYROLL_INTERFACE
TriggerPSP_PAYROLL_INTERFACE_WHO