PJC_ALLOC_RUNS_ALL
PA_ALLOC_RUNS_ALL stores all the information for an allocation run.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_ALLOC_RUNS_ALL_PK |
RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | Allocation run identification number | |
| RULE_ID | NUMBER | 18 | Yes | Allocation rule identification number | |
| RUN_PERIOD | VARCHAR2 | 20 | Run period name | ||
| EXPND_ITEM_DATE | DATE | Yes | Expenditure item date for an allocation run | ||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Denomination currency code | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| FIXED_AMOUNT | NUMBER | Fixed amount | |||
| POOL_PERCENT | NUMBER | Allocation percentage specified at rule level | |||
| PERIOD_TYPE | VARCHAR2 | 2 | Period type of GL (General Ledger) or PA (Oracle Projects) | ||
| SOURCE_AMOUNT_TYPE | VARCHAR2 | 4 | If the period type is PA , source_amount_type can be ITD or PTD. If the period type is GL, source_amount_type can be FYTD, QTD, or PTD | ||
| SOURCE_BALANCE_CATEGORY | VARCHAR2 | 1 | Source balance category. It can only be A(actuals) | ||
| SOURCE_BALANCE_TYPE | VARCHAR2 | 30 | Source balance type. If the source category is actual , then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST or TOT_BILLABLE_BURDENED_COST | ||
| ALLOC_RBS_HEADER_ID | NUMBER | 18 | Alloc RBS Header Id ***** | ||
| AUTO_RELEASE_FLAG | VARCHAR2 | 1 | The flag indicates whether to create expenditure items automatically. Y means release automatically | ||
| ALLOCATION_METHOD | VARCHAR2 | 1 | Allocation method. It can be F(full) or I(incremental) | ||
| DUP_TARGETS_FLAG | VARCHAR2 | 1 | The flag indicates whether to allow duplicate target projects and tasks.Y means to allow duplicate target projects and tasks | ||
| TARGET_EXP_TYPE_CLASS | VARCHAR2 | 30 | Expenditure type class of allocation transactions | ||
| TARGET_EXP_ORG_ID | NUMBER | 18 | Expenditure organization of allocation transactions | ||
| TARGET_EXP_TYPE_ID | NUMBER | 18 | Expenditure type of allocation transactions ***** | ||
| TARGET_COST_TYPE | VARCHAR2 | 1 | Cost type of allocation transactions. It can be R (raw) or B (burdened) | ||
| OFFSET_EXP_TYPE_CLASS | VARCHAR2 | 30 | Expenditure type class of offset transactions | ||
| OFFSET_EXP_ORG_ID | NUMBER | 18 | Expenditure organization id of offset transactions | ||
| OFFSET_EXP_TYPE_ID | NUMBER | 18 | Expenditure type of allocation transactions ***** | ||
| OFFSET_COST_TYPE | VARCHAR2 | 1 | Cost type of offset transactions. It can be B (burdened) or R (raw) | ||
| OFFSET_METHOD | VARCHAR2 | 1 | Offset method. It can be N (none) , A (source project and task), B (source project, use client extension for task), C (specific project and task) or D(use client extension for project and task) | ||
| OFFSET_PROJECT_ID | NUMBER | 18 | Offset project id | ||
| OFFSET_TASK_ID | NUMBER | 18 | Offset task id | ||
| RUN_STATUS | VARCHAR2 | 3 | Allocation run status. It can be DF (draft failure) , DS (draft success), RF (release failure), RV (run reverse) or RS (release success) | ||
| BASIS_METHOD | VARCHAR2 | 2 | Basis method. It can be S(spread evenly) ,P(prorated),C(client extension),FS(fixed and spread evenly) or FP(fixed and prorated) | ||
| BASIS_RELATIVE_PERIOD | NUMBER | Relative basis period | |||
| BASIS_AMOUNT_TYPE | VARCHAR2 | 4 | If the period type is PA , source_amount_type can be ITD or PTD. If the period type is GL, source_amount_type can be FYTD, QTD, or PTD | ||
| BASIS_BALANCE_CATEGORY | VARCHAR2 | 1 | Basis balance category. it can be A (actuals) or B (budgets) | ||
| BASIS_BALANCE_TYPE | VARCHAR2 | 30 | Basis balance type. If basis category is actual , then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST, TOT_BILLABLE_BURDENED_COST, TOT_QUANTITY or TOT_LABOR_HOURS. If the basis category is budget, then bud | ||
| BASIS_RBS_HEADER_ID | NUMBER | 18 | Basis RBS Header Id ***** | ||
| FISCAL_YEAR | NUMBER | Fiscal year of the run period | |||
| QUARTER | NUMBER | Quarter number of the run period | |||
| PERIOD_NUM | NUMBER | Period number | |||
| TARGET_EXP_GROUP_ID | NUMBER | 18 | Target Exp Group Id ***** | ||
| TOTAL_POOL_AMOUNT | NUMBER | Total source pool amount | |||
| ALLOCATED_AMOUNT | NUMBER | Allocated amount | |||
| TOTAL_ALLOCATED_AMOUNT | NUMBER | Total allocated amount | |||
| TOTAL_OFFSETTED_AMOUNT | NUMBER | Total offsetted amount | |||
| MISSING_SOURCE_PROJ_AMT | NUMBER | Missing source project amount | |||
| MISSING_TARGET_PROJ_AMT | NUMBER | Missing target project amount | |||
| MISSING_OFFSET_PROJ_AMT | NUMBER | Missing offset project amount | |||
| REVERSAL_DATE | DATE | Reversal date if the run is reversed | |||
| DRAFT_REQUEST_ID | NUMBER | 18 | Request id for the draft allocation run | ||
| DRAFT_REQUEST_DATE | DATE | Creation date of request for a draft allocation | |||
| RELEASE_REQUEST_ID | NUMBER | 18 | Request id for the release allocation run | ||
| RELEASE_REQUEST_DATE | DATE | Creation date of request for a release allocation | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LIMIT_TARGET_PROJECTS_CODE | VARCHAR2 | 1 | Yes | Buiseness organization level code that limits the selection of target projects. | |
| BASIS_FIN_PLAN_TYPE_ID | NUMBER | 18 | Fin plan type populated when allocation basis is Fin Plan | ||
| CINT_RATE_NAME_ID | NUMBER | 18 | Interest rate name ID of the Transaction run. | ||
| ALLOC_RBS_VERSION | NUMBER | RBS structure version for allocation source resources. | |||
| BASIS_RBS_VERSION | NUMBER | RBS structure version for allocation basis resources. | |||
| 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. | |
| 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. | ||
| SUB_REQUEST_ID | NUMBER | 18 | Sub request ID for the parallelization process. | ||
| DELETE_FLAG | VARCHAR2 | 1 | Indicate this run record needs to be deleted. | ||
| LD_INTERFACE_ID | NUMBER | 18 | Primary key from the table PJC_LD_XFACT_INT. | ||
| BC_PASS_FLAG | VARCHAR2 | 1 | Indicate budget check status. | ||
| PRIOR_REQUEST_ID | NUMBER | 18 | Prior request ID. | ||
| LD_BATCH_NAME | VARCHAR2 | 200 | Name of the payroll batch imported from the payroll system. | ||
| LD_PERIOD_START_DATE | DATE | Start date of the payroll period for the person. | |||
| LD_PERIOD_END_DATE | DATE | End date of the payroll period for the person. | |||
| LD_PERSON_ID | NUMBER | 18 | Person ID related to the person record for this labor schedule. | ||
| LD_ELEMENT_TYPE | VARCHAR2 | 80 | Name of the pay element for the person. | ||
| LD_ASSIGNMENT_ID | NUMBER | 18 | Assignment ID related to the assignment record for this labor schedule. | ||
| LD_ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Unique identifier of this record in the payroll system. | ||
| PROCESSING_START_DATE | DATE | Processing start date. | |||
| PROCESSING_END_DATE | DATE | Processing end date. | |||
| LD_DAILY_RATE | NUMBER | Person assignment daily rate. | |||
| REVERSE_REQUEST_ID | NUMBER | 18 | Reversal request ID. | ||
| BASIS_RELATIVE_FISCAL_YEAR | NUMBER | Derived fiscal year based on the relative basis period. | |||
| BASIS_RELATIVE_QUARTER_NUM | NUMBER | Derived quarter number based on the relative basis period. | |||
| BASIS_RELATIVE_PERIOD_NUM | NUMBER | Derived period number based on the relative basis period. | |||
| BASIS_RELATIVE_PERIOD_NAME | VARCHAR2 | 20 | Derived period name based on the relative basis period. | ||
| BASIS_RELATIVE_START_DATE | DATE | Derived basis period start date based on the relative basis period. | |||
| BASIS_RELATIVE_END_DATE | DATE | Derived basis period end date based on the relative basis period. | |||
| PRIOR_OFFSET_AMOUNT | NUMBER | Total prior offset allocation amount for a given rule. | |||
| NO_BASIS_AMOUNT_FLAG | VARCHAR2 | 1 | Error flag indicating no basis amount exists. | ||
| OVERRIDEN_BASIS_METHOD | VARCHAR2 | 20 | Overridden basis method if no basis exists and the profile Allocation Method for Zero-Basis Amounts is set to Spread Evenly. | ||
| LD_ELEMENT_TYPE_ID | NUMBER | 18 | Pay element type ID. | ||
| TOTAL_PRIOR_ALLOC_AMOUNT | NUMBER | Total cost allocated in the prior run. | |||
| REMNANT_AMOUNT | NUMBER | Fractional amount that was not naturally allocated in the current run. This amount will get added to one of the targets, typically the largest target, to ensure the allocation is in balance. | |||
| PAYROLL_LOAD_REQUEST_ID | NUMBER | 18 | The Oracle Payroll request identifier used to load data into the Oracle Labor Distribution interface table. | ||
| DOCUMENT_ID | NUMBER | 18 | The unique identifier of the transaction document that defines the source of the Labor Distribution interface data. | ||
| PAYROLL_ID | NUMBER | 18 | The payroll identifier associated with the interfaced cost. | ||
| PAYROLL_NAME | VARCHAR2 | 80 | The name of the payroll associated with the interfaced cost. | ||
| OCCUR_PAY_PERIOD_START_DATE | DATE | The start date of the payroll period during which the cost was generated. | |||
| OCCUR_PAY_PERIOD_END_DATE | DATE | The end date of the payroll period during which the cost was generated. | |||
| PAYROLL_EFFECTIVE_DATE | DATE | The date the payroll cost was generated. | |||
| PAYROLL_REL_ACTION_ID | NUMBER | 18 | The unique payroll relationship identifier of the cost. This identifier is used to gather accounting information associated with the cost. | ||
| COST_ACTION_TYPE | VARCHAR2 | 30 | The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost. | ||
| COST_ID | NUMBER | 18 | The unique identifier of the cost. This identifier is used to gather accounting information associated with the cost. | ||
| COST_ALLOCATION_KEYFLEX_ID | NUMBER | 18 | The unique identifier of the cost allocation flex field associated with the cost. | ||
| COST_ACTION_ID | NUMBER | 18 | The unique identifier of the payroll cost action used to get accounting information associated with the cost. | ||
| RUN_ACTION_ID | NUMBER | 18 | The unique identifier of the payroll run action used to get accounting information associated with the cost. | ||
| NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Flag that indicates whether the run is fully reversed. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_ALLOC_RUNS_ALL | pjo_plan_types_b | BASIS_FIN_PLAN_TYPE_ID |
| pjc_alloc_exceptions | pjc_alloc_runs_all | RUN_ID |
| pjc_alloc_txn_details | pjc_alloc_runs_all | RUN_ID |
| pjc_alloc_run_source_det | pjc_alloc_runs_all | RUN_ID |
| pjc_alloc_missing_costs | pjc_alloc_runs_all | RUN_ID |
| pjc_alloc_run_res_det | pjc_alloc_runs_all | RUN_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_ALLOC_RUNS_ALL_N3 | Non Unique | Default | RUN_PERIOD |
| PJC_ALLOC_RUNS_ALL_N4 | Non Unique | Default | SUB_REQUEST_ID |
| PJC_ALLOC_RUNS_ALL_N5 | Non Unique | Default | RELEASE_REQUEST_ID |
| PJC_ALLOC_RUNS_ALL_N6 | Non Unique | Default | LD_ORIG_TRANSACTION_REFERENCE |
| PJC_ALLOC_RUNS_ALL_N7 | Non Unique | Default | LD_PERSON_ID |
| PJC_ALLOC_RUNS_ALL_N8 | Non Unique | Default | LD_BATCH_NAME |
| PJC_ALLOC_RUNS_ALL_N9 | Non Unique | Default | LD_INTERFACE_ID |
| PJC_ALLOC_RUNS_N1 | Non Unique | Default | DRAFT_REQUEST_ID |
| PJC_ALLOC_RUNS_N2 | Non Unique | Default | RULE_ID, FISCAL_YEAR, QUARTER, PERIOD_NUM |
| PJC_ALLOC_RUNS_U1 | Unique | Default | RUN_ID |