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

TABLE: PSP.PSP_DISTRIBUTION_LINES

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


PSP_DISTRIBUTION_LINES stores the distributed Oracle Payroll and
non-Oracle payroll sublines that are not yet transferred to General
Ledger, Grants Accounting, or Project Accounting.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_DISTRIBUTION_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISTRIBUTION_LINE_ID
PSP_DISTRIBUTION_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_SUB_LINE_ID
PSP_DISTRIBUTION_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUMMARY_LINE_ID
PSP_DISTRIBUTION_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUSPENSE_ORG_ACCOUNT_ID
Columns
Name Datatype Length Mandatory Comments
DISTRIBUTION_LINE_ID NUMBER (10) Yes Distribution line identifier
DISTRIBUTION_DATE DATE
Yes Distribution date
EFFECTIVE_DATE DATE
Yes Accounting date for transferring to General Ledger and expenditure item date for transferring to Grants Accounting
DISTRIBUTION_AMOUNT NUMBER
Yes Distribution amount
STATUS_CODE VARCHAR2 (1) Yes Indicates the status of the distribution lines. N indicates New, S indicates Summarized, and A indicates Accepted by General Ledger or Grants Accounting.
DEFAULT_REASON_CODE VARCHAR2 (1)
Reason code for using the default account
SUSPENSE_REASON_CODE VARCHAR2 (50)
Reason code for using the suspense account
EFFORT_REPORT_ID NUMBER (9)
Effort report identifier
PAYROLL_SUB_LINE_ID NUMBER (10) Yes Payroll subline identifier
SCHEDULE_LINE_ID NUMBER (9)
Schedule line identifier
DEFAULT_ORG_ACCOUNT_ID NUMBER (9)
Default organization account identifier
SUSPENSE_ORG_ACCOUNT_ID NUMBER (9)
Suspense organization account identifier
ELEMENT_ACCOUNT_ID NUMBER (9)
Global element account identifier
ORG_SCHEDULE_ID NUMBER (9)
Organization schedule identifier
GL_PROJECT_FLAG VARCHAR2 (1)
Indicates whether the distribution line points to a General Ledger or Grants Accounting schedule line. G indicates a General Ledger schedule line and P indicates a Grants Accounting, POETA, schedule line.
REVERSAL_ENTRY_FLAG VARCHAR2 (1)
Y indicates that the record is created for sending balancing transactions to General Ledger. NULL or N indicates that it is a normal distribution line.
PRE_DISTRIBUTION_RUN_FLAG VARCHAR2 (1)
Y indicates predistribution run and NULL indicates a distribution run.
SUMMARY_LINE_ID NUMBER (10)
Summary line identifier
SET_OF_BOOKS_ID NUMBER (15) Yes Foreign key to GL_SETS_OF_BOOKS
VERSION_NUM NUMBER (2)
Effort report version number
USER_DEFINED_FIELD VARCHAR2 (30)
User populates this field through user extension
AUTO_EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type based on auto-population rules
AUTO_GL_CODE_COMBINATION_ID NUMBER (15)
General Ledger Code Combination based on auto-population rules
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
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
CAP_EXCESS_DIST_LINE_ID NUMBER (10)
Distribution Line Identifier carrying excess salary cap amount
CAP_EXCESS_GLCCID NUMBER (15)
GL Acct holding the excess salary cap amount
CAP_EXCESS_AWARD_ID NUMBER (15)
Award holding the excess salary cap amount
CAP_EXCESS_PROJECT_ID NUMBER (15)
Project holding the excess salary cap amount
CAP_EXCESS_TASK_ID NUMBER (15)
Task holding the excess salary cap amount
CAP_EXCESS_EXP_ORG_ID NUMBER (15)
Exp Org holding the excess salary cap amount
CAP_EXCESS_EXP_TYPE VARCHAR2 (30)
Exp Type holding the excess salary cap amount
FUNDING_SOURCE_CODE VARCHAR2 (30)
Funding Source Code
ANNUAL_SALARY_CAP NUMBER

Annual Salary cap amount
SUSPENSE_AUTO_GLCCID NUMBER

GL Account derived from Auto Pop rules at suspense level
SUSPENSE_AUTO_EXP_TYPE VARCHAR2 (30)
Exp Type derived from Auto Pop rules at suspense level
ADJ_ACCOUNT_FLAG VARCHAR2 (2)
Flag
Query Text

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


SELECT DISTRIBUTION_LINE_ID
,      DISTRIBUTION_DATE
,      EFFECTIVE_DATE
,      DISTRIBUTION_AMOUNT
,      STATUS_CODE
,      DEFAULT_REASON_CODE
,      SUSPENSE_REASON_CODE
,      EFFORT_REPORT_ID
,      PAYROLL_SUB_LINE_ID
,      SCHEDULE_LINE_ID
,      DEFAULT_ORG_ACCOUNT_ID
,      SUSPENSE_ORG_ACCOUNT_ID
,      ELEMENT_ACCOUNT_ID
,      ORG_SCHEDULE_ID
,      GL_PROJECT_FLAG
,      REVERSAL_ENTRY_FLAG
,      PRE_DISTRIBUTION_RUN_FLAG
,      SUMMARY_LINE_ID
,      SET_OF_BOOKS_ID
,      VERSION_NUM
,      USER_DEFINED_FIELD
,      AUTO_EXPENDITURE_TYPE
,      AUTO_GL_CODE_COMBINATION_ID
,      BUSINESS_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CAP_EXCESS_DIST_LINE_ID
,      CAP_EXCESS_GLCCID
,      CAP_EXCESS_AWARD_ID
,      CAP_EXCESS_PROJECT_ID
,      CAP_EXCESS_TASK_ID
,      CAP_EXCESS_EXP_ORG_ID
,      CAP_EXCESS_EXP_TYPE
,      FUNDING_SOURCE_CODE
,      ANNUAL_SALARY_CAP
,      SUSPENSE_AUTO_GLCCID
,      SUSPENSE_AUTO_EXP_TYPE
,      ADJ_ACCOUNT_FLAG
FROM PSP.PSP_DISTRIBUTION_LINES;

Dependencies

[top of page]

PSP.PSP_DISTRIBUTION_LINES does not reference any database object

PSP.PSP_DISTRIBUTION_LINES is referenced by following:

SchemaPSP
ViewPSP_DISTRIBUTION_LINES#