[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_PAYROLL_SUB_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_PAYROLL_SUB_LINES
|
| Subobject Name: | |
| Status: | VALID |
PSP_PAYROLL_SUBLINES contains information where payroll
amount in a payroll line is split into more than one subline
because of changes in Human Resources information such as Dates of
Interests. One or more payroll sublines must correspond to one payroll
line.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSP_PAYROLL_SUB_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PAYROLL_SUB_LINE_ID
|
| PSP_PAYROLL_SUB_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYROLL_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PAYROLL_SUB_LINE_ID | NUMBER | (10) | Yes | System-generated primary key |
| SUB_LINE_START_DATE | DATE | Yes | Start date of subline | |
| SUB_LINE_END_DATE | DATE | Yes | End date of subline | |
| REASON_CODE | VARCHAR2 | (30) | Reason code why the subline is created | |
| PAY_AMOUNT | NUMBER | Yes | Payroll amount for given date range | |
| DAILY_RATE | NUMBER | Yes | Daily rate applied for given date range | |
| SALARY_USED | NUMBER | Yes | Salary used for given date range | |
| CURRENT_SALARY | NUMBER | Current salary | ||
| ORGANIZATION_ID | NUMBER | (9) | Foreign key to HR_ALL_ORGANIZATION_UNITS | |
| JOB_ID | NUMBER | (9) | Foreign key to PER_JOBS | |
| POSITION_ID | NUMBER | (15) | Foreign key to PER_POSITIONS | |
| EMPLOYMENT_BEGIN_DATE | DATE | Begin date of employment | ||
| EMPLOYMENT_END_DATE | DATE | End date of employment | ||
| EMPLOYEE_STATUS_INACTIVE_DATE | DATE | Date the employment status becomes inactive | ||
| EMPLOYEE_STATUS_ACTIVE_DATE | DATE | Date the employment status becomes active | ||
| ASSIGNMENT_BEGIN_DATE | DATE | Assignment begin date | ||
| ASSIGNMENT_END_DATE | DATE | Assignment end date | ||
| 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 | |
| PAYROLL_LINE_ID | NUMBER | (10) | Yes | Foreign key to PSP_PAYROLL_LINES |
| FTE | NUMBER | Full-time equivalent | ||
| GRADE_ID | NUMBER | (15) | Grade Identifier. Foreign key to PER_GRADES. | |
| PEOPLE_GROUP_ID | NUMBER | (15) | HR People group identifier | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_SUB_LINE_ID
, SUB_LINE_START_DATE
, SUB_LINE_END_DATE
, REASON_CODE
, PAY_AMOUNT
, DAILY_RATE
, SALARY_USED
, CURRENT_SALARY
, ORGANIZATION_ID
, JOB_ID
, POSITION_ID
, EMPLOYMENT_BEGIN_DATE
, EMPLOYMENT_END_DATE
, EMPLOYEE_STATUS_INACTIVE_DATE
, EMPLOYEE_STATUS_ACTIVE_DATE
, ASSIGNMENT_BEGIN_DATE
, ASSIGNMENT_END_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PAYROLL_LINE_ID
, FTE
, GRADE_ID
, PEOPLE_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
FROM PSP.PSP_PAYROLL_SUB_LINES;
PSP.PSP_PAYROLL_SUB_LINES does not reference any database object
PSP.PSP_PAYROLL_SUB_LINES is referenced by following:
PSP
PSP_PAYROLL_SUB_LINES#
|
|
|
|