Placement2
Stores a supplemental placement schema for environments that require extended placement attributes. This table supports advanced reporting and workflow logic by capturing data elements that extend the core placement model.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
Identifies the unique identifier (Id) for the Placement2 record. This value establishes the primary reference used in financial processing, placement management, and system integrations. |
| Changesapproved | Int | False |
Captures the number of approved placement changes that is recorded in the Placement2 record. This value supports audit tracking and reflects completed modifications. |
| Changeswaitingapproval | Int | False |
Captures the number of placement changes that is waiting for approval in the Placement2 record. This value supports workflow routing and pending-action monitoring. |
| Expiringcredentials | Int | False |
Records the count of credentials that are nearing expiration for the Placement2 record. This value assists compliance tracking and proactive renewal processes. |
| Incompleterequirements | Int | False |
Captures the number of incomplete requirements that is associated with the Placement2 record. This value supports onboarding management and prevents incomplete placements from progressing. |
| ApprovingClientContactId | Int | False |
Identifies the approving client contact Id that is associated with the Placement2 record. This value designates the client contact responsible for authorizing changes or confirming placement details. |
| BackupApprovingClientContactId | Int | False |
Identifies the backup approving client contact Id that is linked to the Placement2 record. This value supports secondary approval routing when the primary approver is unavailable. |
| BillingContactId | Int | False |
Identifies the billing contact Id that is associated with the Placement2 record. This value determines who receives billing inquiries and financial communications related to the placement. |
| BillingFrequency | String | False |
Specifies the billing frequency that is applied to the Placement2 record. This value determines the cadence of invoice generation and revenue recognition. |
| BillRate | Double | False |
Captures the bill rate that is assigned to the Placement2 record. This value determines the hourly or periodic amount invoiced to the client. |
| BonusPackage | String | False |
Describes the bonus package that is associated with the Placement2 record. This information supports compensation planning and defines additional benefits offered as part of the placement. |
| BranchID | Int | False |
Identifies the branch Id that is connected to the Placement2 record. This value establishes regional or organizational ownership for reporting and operational workflows. |
| CandidateId | Int | False |
Identifies the candidate Id that is associated with the Placement2 record. This value links the placement to the worker fulfilling the assignment. |
| CanEnterTime | Bool | False |
Returns a value of 'true' when the Placement2 record allows the candidate to enter time. It returns a value of 'false' when time entry is restricted or managed externally. |
| ClientCompanyId | Int | False |
Identifies the client company Id that is associated with the Placement2 record. This value links the placement to the company receiving services. |
| Comments | String | False |
Records comments that are stored in the Placement2 record. This information supports internal communication and documents placement-specific notes. |
| ContactId | Int | False |
Identifies the contact Id that is linked to the Placement2 record. This value identifies the primary client contact responsible for coordination or communication. |
| CostCenter | String | False |
Specifies the cost center that is assigned to the Placement2 record. This value supports financial allocation and internal accounting processes. |
| DateAdded | Datetime | False |
Captures the date the Placement2 record is added to the system. This value supports historical tracking and time-based reporting. |
| DateLastModified | Datetime | False |
Captures the date the Placement2 record is last modified. This value supports audit history, data governance, and change monitoring. |
| DaysGuaranteed | Int | False |
Specifies the number of guaranteed days that is associated with the Placement2 record. This value supports financial commitments and contractual terms of service. |
| DaysproRated | Int | False |
Captures the number of prorated days that is calculated for the Placement2 record. This value supports billing adjustments and partial-period compensation. |
| EffectiveDate | Datetime | False |
Specifies the effective date that is assigned to the Placement2 record. This value determines when the placement terms activate within payroll and billing workflows. |
| EffectivedateClient | Datetime | False |
Captures the effective date that is recorded for the client in the Placement2 record. This value supports client-specific scheduling and contract enforcement. |
| EmployeeType | String | False |
Specifies the employee type that is assigned to the Placement2 record. This value identifies the worker classification used for payroll, billing, and compliance. |
| Employment | String | False |
Describes the employment designation that is associated with the Placement2 record. This value supports categorization of the work arrangement for reporting and contractual alignment. |
| HoursofOperation | String | False |
Captures the hours of operation that are recorded in the Placement2 record. This information supports scheduling expectations and timekeeping controls. |
| HoursPerDay | Double | False |
Specifies the number of hours per day that is defined for the Placement2 record. This value supports payroll calculations and work-schedule management. |
| HousingManager | Int | False |
Identifies the housing manager Id that is associated with the Placement2 record. This value supports coordination of housing services when lodging is required for the assignment. |
| HousingStatus | String | False |
Specifies the housing status that is assigned to the Placement2 record. This value supports operational planning and determines whether housing resources are active, pending, or not applicable. |
| InvoiceGrouping | String | False |
Specifies the invoice grouping method that is applied to the Placement2 record. This value determines how billable items are combined during invoice generation. |
| JobId | Int | False |
Identifies the job Id that is associated with the Placement2 record. This value links the placement to its originating job order. |
| JobDuration | Double | False |
Captures the job duration that is determined for the Placement2 record. This value supports schedule planning, forecasting, and assignment management. |
| LastApprovedPlacementChangeRequestId | Int | False |
Identifies the last approved placement change request Id that is linked to the Placement2 record. This value supports audit tracking and connects the record to its most recent approved modification. |
| LocationId | Int | False |
Identifies the location Id that is associated with the Placement2 record. This value determines the worksite location used for scheduling, compliance, and client reporting. |
| MarkUp | Double | False |
Captures the markup percentage that is applied to the Placement2 record. This value supports billing calculations and determines the rate differential between pay and bill amounts. |
| MigrateGUID | String | False |
Captures the globally unique migration Id that is assigned to the Placement2 record. This value supports data migration integrity and ensures consistent record tracking across environments. |
| OptionsPackage | String | False |
Specifies the options package that is associated with the Placement2 record. This information supports compensation structuring and defines optional components included in the placement terms. |
| OtherHourlyFee | Double | False |
Captures the additional hourly fee that is applied to the Placement2 record. This value supports premium billing arrangements or supplemental charges. |
| OtherHourlyFeeComments | String | False |
Records comments about the additional hourly fee that is associated with the Placement2 record. This information provides context for billing adjustments and internal approvals. |
| OtmarkUp | Double | False |
Captures the overtime markup percentage that is applied to the Placement2 record. This value supports payroll and billing calculations for overtime hours. |
| OverTimebillrate | Double | False |
Specifies the overtime bill rate that is assigned to the Placement2 record. This value determines the rate invoiced to the client for overtime work. |
| OverTimepayrate | Double | False |
Specifies the overtime pay rate that is assigned to the Placement2 record. This value determines the rate paid to the candidate for verified overtime hours. |
| OvertimeExemption | Int | False |
Identifies the overtime exemption classification that is associated with the Placement2 record. This value supports compliance tracking and determines how overtime rules apply under labor regulations. |
| OwnerId | Int | False |
Identifies the owner Id that is assigned to the Placement2 record. This value designates the user responsible for managing the placement lifecycle and overseeing related activities. |
| PayRate | String | False |
Specifies the pay rate that is assigned to the Placement2 record. This value determines compensation calculations and supports payroll processing. |
| PayUnit | String | False |
Specifies the pay unit that is applied to the Placement2 record. This value defines the measurement basis used for payroll, billing, and reporting. |
| Placementfee | Double | False |
Captures the placement fee that is assessed for the Placement2 record. This value supports revenue calculations and contract enforcement. |
| PlacementfeeFlat | Double | False |
Captures the flat placement fee that is associated with the Placement2 record. This value represents a fixed charge used in contract-based or non-percentage fee models. |
| ProjectCodeList | String | False |
Specifies the project code list that is associated with the Placement2 record. This value supports internal accounting, cost allocation, and multi-project reporting. |
| QuitJob | Bool | False |
Returns a value of 'true' when the Placement2 record indicates that the candidate quit the job. It returns a value of 'false' when the candidate did not separate from the assignment voluntarily. |
| RateEntryType | Bool | False |
Returns a value of 'true' when the Placement2 record uses a rate entry type that triggers alternate processing rules. It returns a value of 'false' when standard rate entry behavior applies. |
| RecruitingmanagercommissionoverRide | Double | False |
Captures the recruiting manager commission override amount that is associated with the Placement2 record. This value supports incentive tracking and commission calculations. |
| ReferralFee | String | False |
Specifies the referral fee arrangement that is associated with the Placement2 record. This value supports financial agreements and identifies whether referral compensation is applicable. |
| ReferralFeeType | String | False |
Specifies the referral fee type that is assigned to the Placement2 record. This value determines how referral payments are classified during revenue processing. |
| ReportedMargin | Double | False |
Captures the reported margin that is calculated for the Placement2 record. This value supports profitability analysis and financial performance reporting. |
| Reportingto | String | False |
Identifies the reporting-to contact that is associated with the Placement2 record. This value determines the supervisory contact responsible for oversight and timecard approvals. |
| Salary | String | False |
Specifies the salary value that is assigned to the Placement2 record. This value supports compensation modeling and applies when the placement uses a salaried pay structure. |
| SalesmanagercommissionoverRide | Double | False |
Captures the sales manager commission override that is associated with the Placement2 record. This value supports commission tracking and revenue allocation. |
| ScheduledEnd | Datetime | False |
Specifies the scheduled end date that is assigned to the Placement2 record. This value determines when the placement is expected to conclude for scheduling and forecasting. |
| ShiftId | Int | False |
Identifies the shift Id that is associated with the Placement2 record. This value determines the assigned work shift used for scheduling, timekeeping, and payroll calculations. |
| StartDate | Datetime | False |
Specifies the start date that is recorded for the Placement2 record. This value determines when the candidate begins the assignment and triggers pay, billing, and scheduling workflows. |
| StatementContactId | Int | False |
Identifies the statement contact Id that is associated with the Placement2 record. This value determines where client statements and billing summaries are directed. |
| Status | String | False |
Specifies the status that is assigned to the Placement2 record. This value indicates the placement's current state within operational, financial, and workflow processes. |
| SubmissionId | Int | False |
Identifies the submission Id that is linked to the Placement2 record. This value connects the placement back to the originating job submission that advanced to hire. |
| TaxRate | Double | False |
Specifies the tax rate that is applied to the Placement2 record. This value supports taxation calculations and financial compliance. |
| TaxState | String | False |
Identifies the tax state that is associated with the Placement2 record. This value determines the jurisdiction used for tax calculations and regulatory reporting. |
| TerminationReason | String | False |
Specifies the termination reason that is recorded for the Placement2 record. This information documents the cause of assignment conclusion for compliance and internal review. |
| UmbrellaCompanyId | Int | False |
Identifies the umbrella company Id that is associated with the Placement2 record. This value supports employer-of-record arrangements and determines which entity manages payroll and compliance. |
| WorkersCompCodeId | Int | False |
Identifies the workers' compensation code Id that is assigned to the Placement2 record. This value determines the insurance classification used for risk assessment and payroll processing. |
| WorkWeekBegin | Int | False |
Specifies the workweek start day that is defined for the Placement2 record. This value determines how weekly time, overtime, and payroll periods are calculated. |