[Home] [Help] [Dependency Information]
Object Name: | PAYBV_CN_PAYSLIP_ARCHIVE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAYBV_CN_PAYSLIP_ARCHIVE_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_INFORMATION_ID | NUMBER | (15) | Yes | System-generated primary key column. |
ACTION_CONTEXT_ID | NUMBER | (15) | Yes | Foreign key to PAY_ACTION_CONTEXTS. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | System generated primary key. |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | The system generated primary key. |
ASSIGNMENT_ID | NUMBER | (10) | Foreign key to PER_ASSIGNMENTS. | |
EFFECTIVE_DATE | DATE | Yes | Session date for the event; for payroll run, this is DATE PAID. | |
DATE_EARNED | DATE | Date Earned value for a payroll run, usually the same value as Date Paid. | ||
ACTION_INFORMATION_CATEGORY | VARCHAR2 | (80) | Yes | Developer descriptive flexfield column. |
ACTION_INFORMATION1 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION2 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION3 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION4 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION5 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION6 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION7 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION8 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION9 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION10 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION11 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION12 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION13 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION14 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION15 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION16 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION17 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION18 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION19 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION20 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION21 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION22 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION23 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION24 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION25 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION26 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION27 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION28 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION29 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
ACTION_INFORMATION30 | VARCHAR2 | (240) | Developer descriptive flexfield column. | |
BG_SECURITY_FLAG_CODE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION_INFORMATION_ID
, ACTION_CONTEXT_ID
, BUSINESS_GROUP_ID
, PAYROLL_ACTION_ID
, ASSIGNMENT_ACTION_ID
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, DATE_EARNED
, ACTION_INFORMATION_CATEGORY
, ACTION_INFORMATION1
, ACTION_INFORMATION2
, ACTION_INFORMATION3
, ACTION_INFORMATION4
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION11
, ACTION_INFORMATION12
, ACTION_INFORMATION13
, ACTION_INFORMATION14
, ACTION_INFORMATION15
, ACTION_INFORMATION16
, ACTION_INFORMATION17
, ACTION_INFORMATION18
, ACTION_INFORMATION19
, ACTION_INFORMATION20
, ACTION_INFORMATION21
, ACTION_INFORMATION22
, ACTION_INFORMATION23
, ACTION_INFORMATION24
, ACTION_INFORMATION25
, ACTION_INFORMATION26
, ACTION_INFORMATION27
, ACTION_INFORMATION28
, ACTION_INFORMATION29
, ACTION_INFORMATION30
, BG_SECURITY_FLAG_CODE
FROM APPS.PAYBV_CN_PAYSLIP_ARCHIVE_V;
|
|
|