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

TABLE: HR.PAY_NO_ALTINN_TRANSFERS

Object Details
Object Name: PAY_NO_ALTINN_TRANSFERS
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


Holds the Status of the Altinn Transactions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSFER_ID NUMBER (9)
System-generated primary key column.
TRANSFER_STATUS VARCHAR2 (40)
Status of the Transaction (A:Active D:Deleted R:aRchived S:Saved)
CONCURRENT_REQUEST_ID NUMBER (15)
Concurrent Request ID (Foreign key to FND_CONCURRENT_REQUESTS)
PAYROLL_ACTION_ID NUMBER (9)
Payroll Action ID (Foreign key to PAY_PAYROLL_ACTIONS.)
REPORT_NAME VARCHAR2 (40)
Report Name
RUN_EFFECTIVE_DATE DATE

Effective Date
SHIPMENT_REFERENCE VARCHAR2 (80)
Shipment Reference
ORGANIZATION_ID NUMBER (15)
Organization ID (Foreign key to HR_ORGANIZATION_UNITS.)
BUSINESS_GROUP_ID NUMBER (15)
Business Group ID (Foreign key to HR_ORGANIZATION_UNITS.)
RECEIPT_ID NUMBER (15)
Altinn Receipt ID
RECEIPT_STATUS VARCHAR2 (60)
Altinn Receipt Status
RECEIPT_TEXT VARCHAR2 (200)
Altinn Receipt Text
RECEIPT_LAST_UPDATED DATE

Date when receipt was last updated in this row.
ALT_ELEMENT_ID NUMBER (15)
Altinn Element ID
ALT_ARCHIVE_REF VARCHAR2 (100)
Altinn Archive Reference
CURR_STATE VARCHAR2 (80)
Current State of Transaction in Altinn
NEXT_STATE VARCHAR2 (80)
Next State of Transaction in Altinn
TFR_INFORMATION_CATEGORY VARCHAR2 (200)
Developer descriptive flexfield structure definition column.
TFR_INFORMATION1 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION2 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION3 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION4 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION5 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION6 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION7 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION8 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION9 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION10 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION11 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION12 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION13 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION14 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION15 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION16 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION17 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION18 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION19 VARCHAR2 (200)
Developer descriptive flexfield column.
TFR_INFORMATION20 VARCHAR2 (200)
Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT TRANSFER_ID
,      TRANSFER_STATUS
,      CONCURRENT_REQUEST_ID
,      PAYROLL_ACTION_ID
,      REPORT_NAME
,      RUN_EFFECTIVE_DATE
,      SHIPMENT_REFERENCE
,      ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      RECEIPT_ID
,      RECEIPT_STATUS
,      RECEIPT_TEXT
,      RECEIPT_LAST_UPDATED
,      ALT_ELEMENT_ID
,      ALT_ARCHIVE_REF
,      CURR_STATE
,      NEXT_STATE
,      TFR_INFORMATION_CATEGORY
,      TFR_INFORMATION1
,      TFR_INFORMATION2
,      TFR_INFORMATION3
,      TFR_INFORMATION4
,      TFR_INFORMATION5
,      TFR_INFORMATION6
,      TFR_INFORMATION7
,      TFR_INFORMATION8
,      TFR_INFORMATION9
,      TFR_INFORMATION10
,      TFR_INFORMATION11
,      TFR_INFORMATION12
,      TFR_INFORMATION13
,      TFR_INFORMATION14
,      TFR_INFORMATION15
,      TFR_INFORMATION16
,      TFR_INFORMATION17
,      TFR_INFORMATION18
,      TFR_INFORMATION19
,      TFR_INFORMATION20
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PAY_NO_ALTINN_TRANSFERS;

Dependencies

[top of page]

HR.PAY_NO_ALTINN_TRANSFERS does not reference any database object

HR.PAY_NO_ALTINN_TRANSFERS is referenced by following:

SchemaHR
ViewPAY_NO_ALTINN_TRANSFERS#