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

TABLE: PSP.PSP_ENC_SUMMARY_LINES_ARCH

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


PSP_ENC_SUMMARY_LINES_ ARCH stores archived records from PSP_ENC_SUMMARY_LINES table. These records are deleted from PSP_ENC_SUMMARY_LINES table when they are transferred to PSP_ENC_SUMMARY_LINES_ARCH table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_ENC_SUMMARY_LINES_ARCH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENC_SUMMARY_LINE_ID
PSP_ENC_SUMMARY_LINES_ARCH_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENC_CONTROL_ID
ColumnSTATUS_CODE
PSP_ENC_SUMMARY_LINES_ARCH_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGMS_BATCH_NAME
Columns
Name Datatype Length Mandatory Comments
ENC_SUMMARY_LINE_ID NUMBER (9) Yes System-generated primary key column
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
GMS_BATCH_NAME VARCHAR2 (10)
Interface group defining column required in PA_TRANSACTION_INTERFACE_ALL tables
TIME_PERIOD_ID NUMBER (15) Yes Foreign key to PER_TIME_PERIODS
PERSON_ID NUMBER (9)
Foreign key to PER_PEOPELE_F
ASSIGNMENT_ID NUMBER (9)
Foreign key to PER_ASSIGNMENTS_F
EFFECTIVE_DATE DATE
Yes End date for a payroll period or General Ledger calendar period
SET_OF_BOOKS_ID NUMBER (15) Yes Foreign key to GL_SETS_OF_BOOKS
GL_CODE_COMBINATION_ID NUMBER (15)
Foreign key to GL_CODE_COMBINATIONS
PROJECT_ID NUMBER (15)
Foreign key to PA_PROJECTS
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Expenditure organization identifier
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type
TASK_ID NUMBER (15)
Foreign key to PA_TASKS
AWARD_ID NUMBER (15)
Foreign key to GMS_AWARDS
SUMMARY_AMOUNT NUMBER
Yes Summary amount
DR_CR_FLAG VARCHAR2 (1) Yes Debit or credit flag. D indicates debit and C indicates credit.
GROUP_ID NUMBER (15)
Interface group defining column required in GL_INTERFACE_CONTROLS and GL_INTERFACE tables
INTERFACE_STATUS VARCHAR2 (50)
Status of the record after General Ledger Journal Import or Grants Accounting Transaction Import processes. This field is updated with STATUS from GL_INTERFACE table and TRANSACTION_REJECTION_CODE from PA_TRANSACTION_INTERFACE_ALL.
PAYROLL_ID NUMBER (9) Yes Foreign key to PAY_PAYROLLS_F
GL_PERIOD_ID NUMBER (9)
General Ledger calendar period identifier
GL_PROJECT_FLAG VARCHAR2 (1) Yes General Ledger or Projects flag. G indicates General Ledger and P indicates POETA.
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
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment column
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
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment column
REJECT_REASON_CODE VARCHAR2 (50)
Reason for rejection
ENC_CONTROL_ID NUMBER (9) Yes Foreign key to PSP_ENC_CONTROLS.
STATUS_CODE VARCHAR2 (1) Yes Indicates status for summary lines. A indicates Accepted, L indicates Liquidated, and P indicates Processed.
SUSPENSE_ORG_ACCOUNT_ID NUMBER (10)
Suspense Org Account Identifier
GL_POSTING_OVERRIDE_DATE DATE

GL Posting Override Date
SUPERCEDED_LINE_ID NUMBER (9)
Superceded Line Identifier
GMS_POSTING_OVERRIDE_DATE DATE

Altered date of posting for Projects/GMS transactions.
EXPENDITURE_ID NUMBER (15)
Expenditure identifier. Foreign key to PA_EXPENDITURES_ALL.
EXPENDITURE_ITEM_ID NUMBER (15)
Expenditure item identifier. Foreign key to PA_EXPENDITURE_ITEMS_ALL.
EXPENDITURE_ENDING_DATE DATE

Expenditure week ending date.
TXN_INTERFACE_ID NUMBER (15)
Transaction interface identifier. Foreign key to PA_TRANSACTION_INTERFACE_ALL.
INTERFACE_ID NUMBER (15)
Interface identifier
LIQUIDATE_REQUEST_ID NUMBER (15)
Request Id
PROPOSED_TERMINATION_DATE DATE

Proposed termination date
PAYROLL_ACTION_ID NUMBER

Foreign key for PAY_PAYROLL_ACTIONS
UPDATE_FLAG VARCHAR2 (1)
Encumbrance line update flag
Query Text

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


SELECT ENC_SUMMARY_LINE_ID
,      BUSINESS_GROUP_ID
,      GMS_BATCH_NAME
,      TIME_PERIOD_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_DATE
,      SET_OF_BOOKS_ID
,      GL_CODE_COMBINATION_ID
,      PROJECT_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      TASK_ID
,      AWARD_ID
,      SUMMARY_AMOUNT
,      DR_CR_FLAG
,      GROUP_ID
,      INTERFACE_STATUS
,      PAYROLL_ID
,      GL_PERIOD_ID
,      GL_PROJECT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE24
,      ATTRIBUTE23
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ATTRIBUTE25
,      REJECT_REASON_CODE
,      ENC_CONTROL_ID
,      STATUS_CODE
,      SUSPENSE_ORG_ACCOUNT_ID
,      GL_POSTING_OVERRIDE_DATE
,      SUPERCEDED_LINE_ID
,      GMS_POSTING_OVERRIDE_DATE
,      EXPENDITURE_ID
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ENDING_DATE
,      TXN_INTERFACE_ID
,      INTERFACE_ID
,      LIQUIDATE_REQUEST_ID
,      PROPOSED_TERMINATION_DATE
,      PAYROLL_ACTION_ID
,      UPDATE_FLAG
FROM PSP.PSP_ENC_SUMMARY_LINES_ARCH;

Dependencies

[top of page]

PSP.PSP_ENC_SUMMARY_LINES_ARCH does not reference any database object

PSP.PSP_ENC_SUMMARY_LINES_ARCH is referenced by following:

SchemaPSP
ViewPSP_ENC_SUMMARY_LINES_ARCH#