PJC_AWARD_DISTRIBUTIONS
PJC_AWARD_DISTRIBUTIONS is added as an table to load rows from different sub-ledger modules which use Award distribution feature.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJC_AWARD_DISTRIBUTIONS_PK |
AWARD_DISTRIBUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AWARD_DISTRIBUTION_ID | NUMBER | 18 | Yes | System generated identifier that uniquely identifies a row. | |
| AWARD_DISTRIBUTION_BATCH_ID | NUMBER | 18 | Yes | System generated identifier that uniquely identifies an instance of the ADL engine call. | |
| AWARD_DISTRIBUTION_STATUS | VARCHAR2 | 30 | Yes | Status of Award distribution activity. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROJECT_ID | NUMBER | 18 | Project Identifier of the transaction. | ||
| TASK_ID | NUMBER | 18 | Identifier of the project task to which the transaction is charged. | ||
| ACCT_RAW_COST | NUMBER | Raw cost in functional currency. You must provide a value for this attribute for project cost transactions that are accounted externally in a third party source application. | |||
| DENOM_RAW_COST | NUMBER | Amount to be distributed by award distribution engine. | |||
| ACCT_BURDENED_COST | NUMBER | Burdened cost in functional currency. | |||
| DENOM_BURDENED_COST | NUMBER | Total transaction cost including raw and burden costs for a project cost transaction in the transaction currency. | |||
| QUANTITY | NUMBER | Quantity provided for the transaction. You must provide a value for quantity when the expenditure type associated to the project cost transaction is rate-based. | |||
| DISTRIBUTE_PATTERN_ID | NUMBER | 18 | System generated identifier that uniquely identifies the resulting action used for distribution. | ||
| DISTRIBUTE_PATTERN_SET_ID | NUMBER | 18 | System generated identifier that uniquely identifies the distribution set of the resulting action used for distribution. | ||
| CALLING_MODE | VARCHAR2 | 30 | Identifier of the Calling Mode. The values are 'BATCH', 'ONLINE'. | ||
| PROCESS_GROUP_ID | NUMBER | 18 | Identifier of the groups the transactions to be processed as a single unit. | ||
| PROCESS_REQUEST_ID | NUMBER | 18 | Request identifier of the ESS job. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| TRANSACTION_NUMBER | VARCHAR2 | 240 | Alphanumeric transaction number that uniquely identifies the sub ledger transaction within the application. | ||
| SOURCE_LINE_ID_1 | VARCHAR2 | 30 | Invoking source table row identifier 1. | ||
| SOURCE_LINE_ID_2 | VARCHAR2 | 30 | Invoking source table row identifier 2. | ||
| SOURCE_LINE_ID_3 | VARCHAR2 | 30 | Invoking source table row identifier 3. | ||
| SOURCE_LINE_ID_4 | VARCHAR2 | 30 | Invoking source table row identifier 4. | ||
| SOURCE_LINE_ID_5 | VARCHAR2 | 30 | Invoking source table row identifier 5. | ||
| SOURCE_LINE_ID_6 | VARCHAR2 | 30 | Invoking source table row identifier 6. | ||
| ACCRUAL_FLAG | VARCHAR2 | 1 | Indicates if the transaction belongs to an expenditure batch that will accrue cost in a period and automatically reverse them in the next period. A value of True means that the transaction is an accrual item and a value of False means that the transaction is not an accrual item. | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Functional currency code of the transaction. | ||
| ACCT_EXCHANGE_RATE | NUMBER | Exchange rate for the transaction. You must provide a value for this attribute when the transaction currency is different from the provider ledger currency. | |||
| ACCT_RATE_DATE | DATE | Conversion rate date for the transaction. You must provide a value for this attribute when the transaction currency is different from the provider ledger currency. | |||
| ACCT_RATE_DATE_TYPE | VARCHAR2 | 30 | Conversion rate type for the transaction. You must provide a value for this attribute when the transaction currency is different from the provider ledger currency. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Specifies if the transaction is billable. A value of True means that the transaction is billable and a value of False means that the transaction is not billable. | ||
| BUDGET_DATE | DATE | Date for which funds must be reserved for the transaction. | |||
| BUDGETARY_CONTROL_VAL_STATUS | VARCHAR2 | 120 | Budgetary control validation status at the transaction level. | ||
| BURDEN_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the burden cost associated with the transaction. You must provide a value for this attribute for Third Party Source when Import burden cost amounts is enabled. | ||
| BURDEN_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the burden cost credit account. You must provide a value for this attribute for Third Party Source when Import burden cost amounts is enabled. | ||
| BURDEN_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the burden cost associated with the transaction. You must provide a value for this attribute forThird Party Source when Import burden cost amounts is enabled. | ||
| BURDEN_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the burden cost debit account. You must provide a value for this attribute for Third Party Source when Import burden cost amounts is enabled. | ||
| BURDENED_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the burdened cost associated with the transaction. The burdened cost includes the total of the raw and burden cost. You must provide a value for this attribute for Third Party Source when Import burdened cost amounts is enabled. | ||
| BURDENED_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the burdened cost credit account. You must provide a value for this attribute for Third Party Source when Import burdened cost amounts is enabled. | ||
| BURDENED_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the burdened cost associated with the transaction. The burdened cost includes the total of the raw and burden cost. You must provide a value for this attribute for Third Party Source when Import burdened cost amounts is enabled. | ||
| BURDENED_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the burdened cost debit account. You must provide a value for this attribute for Third Party Source when Import burdened cost amounts is enabled. | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | Identifier of the expenditure business unit to which the transaction belongs. You must provide a value for either this attribute or Business Unit. | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Specifies if the transaction is capitalizable. A value of True means that the transaction is capitalizable and a value of False means that the transaction is not capitalizable. | ||
| CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. | ||
| DATA_SET_ID | NUMBER | 18 | Identifies the budgetary transaction or group of transactions processed in a run. | ||
| DESTINATION_TYPE_CODE | VARCHAR2 | 30 | The destination type code for a purchase requisition. Examples include Expense,Inventory. | ||
| DOC_ENTRY_CODE | VARCHAR2 | 30 | Internally used Code to identify DOC_ENTRY_ID. | ||
| DOC_ENTRY_ID | NUMBER | 18 | Identifier of the document entry used to capture the transaction. You must provide a value for either this attribute or Document Entry Name or Document Entry Code. | ||
| DOCUMENT_CODE | VARCHAR2 | 20 | Internally used code to identify DOCUMENT_ID. | ||
| DOCUMENT_ID | NUMBER | 18 | Identifier of the document used to capture the transaction. The document must be active on the expenditure item date. | ||
| EXPENDITURE_ITEM_DATE | DATE | Date on which the transaction was recorded. | |||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Identifier of the expenditure organization to which the transaction is charged. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the expenditure type. | ||
| HCM_ASSIGNMENT_ID | NUMBER | 18 | Identifier of the human resources assignment of the person that incurred the transaction that was charged to the project for labor cost transactions. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifier of the inventory item for the transaction. | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the non labor resource utilized when incurring the transaction charge. | ||
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | Identifier of the organization that owns the non labor resource incurring the transaction charge. | ||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Original transaction reference of the transaction. | ||
| PERSON_ID | NUMBER | 18 | Identifier that uniquely identifies the person who is associated with the transaction if it is a labor cost transaction or expense report transaction. | ||
| PERSON_JOB_ID | NUMBER | 18 | Identifier of the job that is being performed by the person that incurred the transaction that was charged to the task. | ||
| PERSON_TYPE_CODE | VARCHAR2 | 30 | The type used to classify the person in human resources. | ||
| PRBS_ELEMENT_ID | NUMBER | 18 | Planning resource breakdown structure element identifier of the planning resource for the transaction. | ||
| PRVDR_GL_DATE | DATE | The date used to determine the accounting period for a transaction. You must provide a value for this attribute for project cost transactions that are accounted externally in a third party source application. | |||
| PRVDR_PA_DATE | DATE | Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date. | |||
| RAW_COST_CR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the credit amount for the raw cost associated with the transaction. You must provide a value for this attribute when raw costs are accounted in the third party source application. | ||
| RAW_COST_CR_CCID | NUMBER | 18 | Code combination identifier of the raw cost credit account. You must provide a value for this attribute when raw costs are accounted in the third party source application. | ||
| RAW_COST_DR_ACCOUNT | VARCHAR2 | 2000 | The ledger account that receives the debit amount for the raw cost associated with the transaction. You must provide a value for this attribute when raw costs are accounted in the third party source application. | ||
| RAW_COST_DR_CCID | NUMBER | 18 | Code combination identifier of the raw cost debit account. You must provide a value for this attribute when raw costs are accounted in the third party source application. | ||
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | 120 | The transaction reference for the original transaction that is reversed. You must provide a value for this attribute when the unmatched negative transaction flag value is true. | ||
| SYSTEM_LINKAGE | VARCHAR2 | 30 | System Linkage or Expenditure Type Class of the transaction. | ||
| TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | Code of the Transaction Source. | ||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Invoking source transaction identifier. | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Transaction accumulation header identifier. | ||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | The transaction currency code from the invoking source. | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | 30 | Code that identifies the unit of measure for the item that is requested, ordered, or supplied. | ||
| UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is the reversal of a matched transaction. Provide a value of True when the transaction is not a reversal of the matched transaction and a value of False when the transaction is a reversal of the matched transaction. If a value of False is provided, you must also provide a value for the attribute Reversed Original Transaction Reference. | ||
| USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | User defined attributes for Cost Collection Widget. | ||
| VENDOR_ID | NUMBER | 18 | Invoking source identifier of the vendor. | ||
| WORK_TYPE_ID | NUMBER | 18 | Identifier of the work type for the transaction. | ||
| CONTRACT_ID | NUMBER | 18 | Identifier of the contract for the transaction of a sponsored project. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | Identifier of the funding source of a transaction for a sponsored project. | ||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | Functional conversion rate type for the transaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_AWARD_DISTRIBUTIONS_N1 | Non Unique | Default | AWARD_DISTRIBUTION_BATCH_ID, AWARD_DISTRIBUTION_STATUS |
| PJC_AWARD_DISTRIBUTIONS_N2 | Non Unique | Default | PROCESS_REQUEST_ID, AWARD_DISTRIBUTION_STATUS |
| PJC_AWARD_DISTRIBUTIONS_N3 | Non Unique | Default | PROCESS_GROUP_ID, REQUEST_ID, AWARD_DISTRIBUTION_STATUS |
| PJC_AWARD_DISTRIBUTIONS_U1 | Unique | Default | AWARD_DISTRIBUTION_ID |