[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_ENC_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_ENC_LINES
|
| Subobject Name: | |
| Status: | VALID |
PSP_ENC_LINES stores the encumbrance lines created by the Create Encumbrance and Update Encumbrance processes.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSP_ENC_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ENC_LINE_ID
|
| PSP_ENC_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENC_CONTROL_ID
PERSON_ID
ASSIGNMENT_ID
|
| PSP_ENC_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENC_SUMMARY_LINE_ID
|
| PSP_ENC_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYROLL_ACTION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ENC_ELEMENT_TYPE_ID | NUMBER | (9) | Yes | Foreign key to PSP_ENC_ELEMENTS |
| ENC_LINE_ID | NUMBER | (9) | Yes | System-generated primary key for encumbrance lines |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
| 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) | Foreign key to Encumbrance Summary Lines | |
| PERSON_ID | NUMBER | (9) | Yes | Foreign key to PER_PEOPLE_F |
| ASSIGNMENT_ID | NUMBER | (9) | 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 | Encumbrance line status. N indicates new. |
| ENC_CONTROL_ID | NUMBER | (10) | Yes | Foreign key to PSP_ENC_CONTROLS |
| CHANGE_FLAG | VARCHAR2 | (1) | Indicates whether the current line is new line or liquidated line. N for new, L for liquidated | |
| ENC_START_DATE | DATE | POETA start date update by Pre-Processor | ||
| ENC_END_DATE | DATE | POETA end date update by Pre-Processor | ||
| PREV_EFFECTIVE_DATE | DATE | Previous Effective Date | ||
| 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 | Payroll Action Id | ||
| ORIG_GL_CODE_COMBINATION_ID | NUMBER | (15) | Original GL Code Combination | |
| 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 Expenditure Organization 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 | ||
| PREV_ENC_END_DATE | DATE | Previous Encumbrance End Date | ||
| PREV_ENCUMBRANCE_AMOUNT | NUMBER | Previous Encumbrance Amount |
Cut, paste (and edit) the following text to query this object:
SELECT ENC_ELEMENT_TYPE_ID
, ENC_LINE_ID
, BUSINESS_GROUP_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
, PREV_EFFECTIVE_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
, PREV_ENC_END_DATE
, PREV_ENCUMBRANCE_AMOUNT
FROM PSP.PSP_ENC_LINES;
PSP.PSP_ENC_LINES does not reference any database object
PSP.PSP_ENC_LINES is referenced by following:
APPS
PSP_ENC_LINES
PSP_ENC_LINES_WHO
|
|
|
|