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

TABLE: PSP.PSP_ENC_CHANGED_ASSIGNMENTS

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


This table captures all the changed assignments, used for Encumbrance Update process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_ENC_CHANGED_ASSIGNMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
PSP_ENC_CHANGED_ASSIGNMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PSP_ENC_CHANGED_ASSIGNMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ACTION_ID
ColumnASSIGNMENT_ID
ColumnPAYROLL_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (9) Yes Assignment Id
PAYROLL_ID NUMBER (9) Yes Payroll_id
CHANGE_TYPE VARCHAR2 (2) Yes Change Type
PROCESSED_FLAG VARCHAR2 (1)
Processed Flag
REFERENCE_ID NUMBER (15)
Reference Id
ACTION_TYPE VARCHAR2 (1)
Identifies the DML operation
REQUEST_ID NUMBER

Identifies the corresponding Update Enc Lines request
CHK_ASG_END_DATE_FLAG VARCHAR2 (1)
Flag that checks assignment end date status
PAYROLL_ACTION_ID NUMBER

Payroll Action Id
CHANGE_DATE DATE

Date as of which the change is applicable
Query Text

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


SELECT ASSIGNMENT_ID
,      PAYROLL_ID
,      CHANGE_TYPE
,      PROCESSED_FLAG
,      REFERENCE_ID
,      ACTION_TYPE
,      REQUEST_ID
,      CHK_ASG_END_DATE_FLAG
,      PAYROLL_ACTION_ID
,      CHANGE_DATE
FROM PSP.PSP_ENC_CHANGED_ASSIGNMENTS;

Dependencies

[top of page]

PSP.PSP_ENC_CHANGED_ASSIGNMENTS does not reference any database object

PSP.PSP_ENC_CHANGED_ASSIGNMENTS is referenced by following:

SchemaPSP
ViewPSP_ENC_CHANGED_ASSIGNMENTS#