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

TABLE: PSP.PSP_ENC_LINES_ARCH

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


PSP_ENC_LINES_ARCH stores archived records from PSP_ENC_LINES_HISTORY table. These records are deleted from PSP_ENC_LINES_HISTORY table when they are transferred to PSP_ENC_LINES_ARCH table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_ENC_LINES_ARCH_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENC_LINE_ID
PSP_ENC_LINES_ARCH_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENC_CONTROL_ID
PSP_ENC_LINES_ARCH_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ID
Columns
Name Datatype Length Mandatory Comments
ENC_LINE_ID NUMBER (9) Yes Encumbrance line identifier
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
ENC_ELEMENT_TYPE_ID NUMBER (9) Yes Foreign key to PSP_ENC_ELEMENTS
ENCUMBRANCE_DATE DATE
Yes Encumbrance date
DR_CR_FLAG VARCHAR2 (1) Yes Debit or Credit flag. D indicates debit and C indicates credit.
ENCUMBRANCE_AMOUNT NUMBER (10) Yes Encumbrance amount
ENC_LINE_TYPE VARCHAR2 (1) Yes Indicates status of current encumbrance line type. N indicates New and U indicates Update.
SCHEDULE_LINE_ID NUMBER (9)
Foreign key to PSP_SCHEDULE_LINES
ORG_SCHEDULE_ID NUMBER (9)
Foreign key to PSP_DEFAULT_LABOR_SCHEDULES
DEFAULT_ORG_ACCOUNT_ID NUMBER (10)
Foreign key to PSP_ORGANIZATION_ACCOUNTS
SUSPENSE_ORG_ACCOUNT_ID NUMBER (10)
Foreign key to PSP_ORGANIZATION_ACCOUNTS
ELEMENT_ACCOUNT_ID NUMBER (10)
Foreign key to PSP_ELEMENT_TYPE_ACCOUNTS
GL_PROJECT_FLAG VARCHAR2 (1) Yes General Ledger or Projects flag. G indicates General Ledger and P indicates POETA.
ENC_SUMMARY_LINE_ID NUMBER (9) Yes Foreign key to PSP_ENC_SUMMARY_LINES
PERSON_ID NUMBER (9) Yes Foreign key to PER_PEOPLE_F
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ASSIGNMENTS_F
AWARD_ID NUMBER (10)
Foreign key to GMS_AWARDS
TASK_ID NUMBER (10)
Foreign key to PA_TASKS
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type reference to PA_ORGANIZATIONS_EXPEND_V
EXPENDITURE_ORGANIZATION_ID NUMBER (10)
Expenditure Organization identifier
PROJECT_ID NUMBER (10)
Foreign key to PA_PROJECTS
GL_CODE_COMBINATION_ID NUMBER (15)
Foreign key to GL_CODE_COMBINATIONS
TIME_PERIOD_ID NUMBER (15) Yes Foreign key to PER_TIME_PERIODS
PAYROLL_ID NUMBER (9) Yes Foreign key to PAY_PAYROLLS_F
SET_OF_BOOKS_ID NUMBER (15) Yes Foreign key to GL_SETS_OF_BOOKS
DEFAULT_REASON_CODE VARCHAR2 (50)
Default reason code
SUSPENSE_REASON_CODE VARCHAR2 (50)
Suspense reason code
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
STATUS_CODE VARCHAR2 (1) Yes Indicates status of the encumbrance lines. A indicates accepted by General Ledger or Grants Accounting.
ENC_CONTROL_ID NUMBER (10) Yes Foreign key to PSP_ENC_CONTROLS
CHANGE_FLAG VARCHAR2 (1)
Change Flag
ENC_START_DATE DATE

POETA start date update by Pre-Processor
ENC_END_DATE DATE

POETA end date update by Pre-Processor
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
PAYROLL_ACTION_ID NUMBER

Foreign key to PAY_PAYROLL_ACTIONS
ORIG_GL_CODE_COMBINATION_ID NUMBER (15)
Original GL Code combination Id
ORIG_PROJECT_ID NUMBER (15)
Original Project id
ORIG_TASK_ID NUMBER (15)
Original Task id
ORIG_AWARD_ID NUMBER (15)
Original Award Id
ORIG_EXPENDITURE_ORG_ID NUMBER (15)
Original Exp Org Id
ORIG_EXPENDITURE_TYPE VARCHAR2 (30)
Original Expenditure Type
HIERARCHY_CODE VARCHAR2 (30)
Hierarchy Code
HIERARCHY_START_DATE DATE

Hierarchy Start Date
HIERARCHY_END_DATE DATE

Hierarchy End Date
Query Text

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


SELECT ENC_LINE_ID
,      BUSINESS_GROUP_ID
,      ENC_ELEMENT_TYPE_ID
,      ENCUMBRANCE_DATE
,      DR_CR_FLAG
,      ENCUMBRANCE_AMOUNT
,      ENC_LINE_TYPE
,      SCHEDULE_LINE_ID
,      ORG_SCHEDULE_ID
,      DEFAULT_ORG_ACCOUNT_ID
,      SUSPENSE_ORG_ACCOUNT_ID
,      ELEMENT_ACCOUNT_ID
,      GL_PROJECT_FLAG
,      ENC_SUMMARY_LINE_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      AWARD_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_ID
,      GL_CODE_COMBINATION_ID
,      TIME_PERIOD_ID
,      PAYROLL_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_REASON_CODE
,      SUSPENSE_REASON_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      STATUS_CODE
,      ENC_CONTROL_ID
,      CHANGE_FLAG
,      ENC_START_DATE
,      ENC_END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PAYROLL_ACTION_ID
,      ORIG_GL_CODE_COMBINATION_ID
,      ORIG_PROJECT_ID
,      ORIG_TASK_ID
,      ORIG_AWARD_ID
,      ORIG_EXPENDITURE_ORG_ID
,      ORIG_EXPENDITURE_TYPE
,      HIERARCHY_CODE
,      HIERARCHY_START_DATE
,      HIERARCHY_END_DATE
FROM PSP.PSP_ENC_LINES_ARCH;

Dependencies

[top of page]

PSP.PSP_ENC_LINES_ARCH does not reference any database object

PSP.PSP_ENC_LINES_ARCH is referenced by following:

SchemaAPPS
SynonymPSP_ENC_LINES_ARCH
TriggerPSP_ENC_LINES_ARCH_WHO