LaborSchedulesCostslaborSchedulesCostDistributions
The Labor Schedule Cost Distributions resource used to see the distributions associated to a project, task, or raw labor cost.
Columns
| Name | Type | Description |
| LaborSchedulesCostsLdInterfaceId [KEY] | Long | The unique identifier of the labor cost. |
| RunTargetId [KEY] | Long | Primary key identifier. |
| VersionId | Long | Concatenated foreign key with line_num back to personAssignmentLaborSchedules.distributionRules REST service |
| VersionName | String | Labor schedule version for this cost distribution. |
| VersionStartDate | Date | The start date of the labor schedule version. |
| VersionEndDate | Date | The end date of the labor schedule version. |
| LineNumber | Decimal | Labor schedule distribution line number for this cost distribution. |
| ContractId | Long | Identifier of contract, used with Oracle Contract Billing or Oracle Grants Management. |
| ContractName | String | Name associated to the contract ID. |
| ContractNumber | String | Number associated to the contract ID. |
| ContractLineId | Long | Tracks contract line information. Not used currently. |
| ProjectId | Long | Identifier of the project for this distribution rule, if it's a project distribution. |
| ProjectName | String | Name of the project associated to this distribution if it's a project distribution. |
| ProjectNumber | String | Number of the project associated to this distribution if it's a project distribution. |
| TaskId | Long | Identifier of the task for this distribution rule, if it's a project distribution. |
| TaskName | String | Name of the task associated to this distribution if it's a project distribution. |
| TaskNumber | String | Task number associated with this distribution. |
| ExpenditureTypeId | Long | Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenditureTypeName | String | Name of the expenditure type for this cost distribution. |
| ExpenditureItemDate | Date | Date on which a project-related transaction is incurred. |
| LinePercent | Decimal | The percentage for this distribution rule, to be applied to the total cost for distribution. |
| WorkTypeId | Long | Identifier for project-related classification of the worked performed. |
| PersonId | Long | Person identifier associated to the cost. |
| PersonName | String | Person name associated to the cost. |
| PersonNumber | String | Person number associated to the cost. |
| PersonEmail | String | Email associated to the cost. |
| AssignmentId | Long | Assignment identifier associated to the cost. |
| AssignmentName | String | Assignment name associated to the cost. |
| AssignmentNumber | String | Assignment number associated to the cost. |
| ExpenditureOrganizationId | Long | Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
| ExpenditureOrganizationName | String | Name for expenditure organization. |
| TransactionReference | String | Transaction number associated to the cost for reference in accounting. |
| OriginalTransactionReference | String | A unique identifier for this cost from the generating source. This field should be used to connect the cost and all distributed costs on the labor schedules cost distributions rest service, including any adjustments that have been done. |
| BillableFlag | Bool | Identifies if the charge is billable or not. |
| CapitalizableFlag | Bool | Information that indicates if a project-related item is eligible for capitalization. |
| GLAccountCombinationId | Long | The GL Account code combination identifier, if the rule is set to a GL account. |
| GLAccount | String | GL Account for this distribution, if the rule is to a GL account. |
| FundingSourceId | String | Identifier of the funding source for this distribution. |
| FundingSourceName | String | Funding source name. |
| FundingSourceNumber | String | Funding source number associated to this distribution. |
| FundingAllocationId | Long | Specifies the name of the project funding override. Not used currently. |
| DifferentialDistributionFlag | Bool | Identifies this cost distribution as the differential to sum up to one hundred percent of the labor cost, if labor schedule is less than one hundred percent. |
| ProcessingStartDate | Date | Date used to drive the start date of the cost and the daily rate to calculation. |
| ProcessingEndDate | Date | Date used to drive the end date of the cost and the daily rate to calculation. |
| PayPeriodStartDate | Date | Pay period start date associated to cost. |
| PayPeriodEndDate | Date | Pay period end date associated to cost. |
| PayElement | String | Pay element associated to the cost. |
| ExpenditureItemId | Long | Identifier of the expenditure created for this cost distribution. |
| TotalAllocation | Decimal | Total allocation amount for this distribution. |
| ErrorExistsFlag | Bool | Identifies whether this cost has errors to resolve. |
| FundsStatus | String | Identifies whether this cost passed or failed funds checking. |
| OrganizationId | Long | The business unit identifier derived from the person assignment. |
| LdInterfaceId | Long | The unique identifier of the labor cost. This value can be used to connect the labor schedule costs and distributions rest services to get all distributions excluding the original distributions that were adjusted. To get all distributions including all adjustment records use the original reference value. |
| CreatedBy | String | Created By |
| CreationDate | Datetime | Creation Date |
| LastUpdatedBy | String | Last Updated Date |
| LastUpdateDate | Datetime | Last Updated By |
| LaborScheduleTypeCode | String | The code of the type from the labor schedule that created this distribution |
| LaborScheduleType | String | The name for the type from the labor schedule that created this distribution. |
| LaborSchedulePayElementId | Long | The payroll element identifier from the labor schedule that created this distribution. Applies to labor schedules of type element. |
| LaborSchedulePayElement | String | The payroll element code from the labor schedule that created this distribution. Applies to labor schedules of type element. |
| LaborSchedulePayElementName | String | The payroll element name from the labor schedule that created this distribution. Applies to labor schedules of type element. |
| LegislativeDataGroupId | Long | Legislative data group identifier. |
| LegislativeDataGroupName | String | Legislative data group name. |
| LaborScheduleAllocationId | Long | Foreign key identifier of the set of segments associated with a unique payroll costing instance and precedence combination. |
| LaborScheduleAllocInstCode | String | The key flexfield structure instance code associated with the labor schedule used to distribute this cost. |
| LaborScheduleAllocInstName | String | The key flexfield structure instance name associated with the labor schedule used to distribute this cost. |
| Precedence | Int | Payroll costing configuration labor schedule precedence used to distribute this cost. |
| LaborScheduleSegmentConcatenation | String | Concatenated segment values from the payroll costing configuration labor schedule used to distribute this cost. |
| LaborScheduleSegment1 | String | Segment 1 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment2 | String | Segment 2 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment3 | String | Segment 3 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment4 | String | Segment 4 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment5 | String | Segment 5 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment6 | String | Segment 6 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment7 | String | Segment 7 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment8 | String | Segment 8 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment9 | String | Segment 9 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment10 | String | Segment 10 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment11 | String | Segment 11 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment12 | String | Segment 12 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment13 | String | Segment 13 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment14 | String | Segment 14 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment15 | String | Segment 15 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment16 | String | Segment 16 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment17 | String | Segment 17 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment18 | String | Segment 18 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment19 | String | Segment 19 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment20 | String | Segment 20 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment21 | String | Segment 21 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment22 | String | Segment 22 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment23 | String | Segment 23 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment24 | String | Segment 24 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment25 | String | Segment 25 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment26 | String | Segment 26 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment27 | String | Segment 27 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment28 | String | Segment 28 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment29 | String | Segment 29 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| LaborScheduleSegment30 | String | Segment 30 of the payroll costing configuration values from the labor schedule used to distribute this cost. |
| TimeCardDistribution | String | Indicates whether payroll costs are distributed to projects using existing time cards in Project Costing as the distribution basis. The valid values are Y (Yes) and N (No). |
| TimeCardDistMessageType | String | Code that indicates the type of message, such as Error or Information, that's returned when the payroll cost distribution to time cards couldn't complete successfully. The list of valid values is defined in the lookup type MESSAGE_TYPE. |
| TimeCardDistMessageName | String | Name of the message that's returned when the payroll cost distribution to time cards couldn't complete successfully. |
| TimeCardDistMessageNumber | Int | Number of the message that's returned when the payroll cost distribution to time cards couldn't complete successfully. |
| TimeCardDistMessageText | String | Text of the message that's returned when the payroll cost distribution to time cards couldn't complete successfully. |
| TimeCardDistMessageDetails | String | User details of the message that's returned when the payroll cost distribution to time cards couldn't complete successfully. |
| AssignmentDepartmentId | Long | Department identifier of the person assignment associated with the payroll cost distribution. |
| AssignmentDepartmentName | String | Department name of the person assignment associated with the payroll cost distribution. |
| AssignmentBusinessUnitName | String | Business unit name of the person assignment associated with the payroll cost distribution. |
| LaborScheduleDepartmentId | Long | Department identifier of the labor schedule associated with the payroll cost distribution. |
| LaborScheduleDepartmentName | String | Department name of the labor schedule associated with the payroll cost distribution. |
| LaborScheduleIncludeChildNodes | String | Include child nodes flag of the labor schedule associated with the payroll cost distribution. |
| LaborScheduleBusinessUnitName | String | Business unit name of the labor schedule associated with the payroll cost distribution. |
| LaborScheduleBusinessUnitId | Long | Business unit identifier of the labor schedule associated with the payroll cost distribution. |
| AwardId | Long | A finder used to filter data using Finder column. Finds labor schedule costs associated with the award identifier passed. |
| AwardNumber | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the award number passed. |
| BatchName | String | A finder used to filter data using Finder column. Finds labor schedule costs with the associated batch name. |
| ConcatenatedSegments | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the concatenated payroll costing segments passed. |
| DepartmentId | Long | A finder used to filter data using Finder column. Finds labor schedule costs associated with the department identifier passed. |
| DepartmentName | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the department name passed. |
| Finder | String | Finder criteria used to filter labor schedule cost distributions based on specific search parameters and conditions. |
| PayElementId | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the pay element type identifier passed. |
| PayPeriodStartFrom | Date | A finder used to filter data using Finder column. The pay period start date for the labor cost. |
| PayPeriodStartTo | Date | A finder used to filter data using Finder column. The pay period start date for the labor cost. |
| PayrollId | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the payroll identifier passed. |
| PayrollName | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the payroll name passed. |
| StatusCode | String | A finder used to filter data using Finder column. Finds labor schedule costs associated to the status code passed. |
| StatusSummary | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the status summary passed. |
| StatusSummaryCode | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the status summary code passed. |
| TransactionSource | String | A finder used to filter data using Finder column. Finds labor schedule costs associated with the transaction source code passed. |