PJF_PRICING_INTG_GT
PJF_PRICING_INTG_GT is the pricing temp rate table. The purpose of the global temp table is to hold all the transaction and contextual attributes required for the rate calculations. Pricing temp table offers a session level purge option so no overhead of data maintenance. The global table enables rate engine independent of a product and support rate integration with online and batch processes. The pricing temp table enables efficient and scalable bulk processing during cost calculation.
Details
-
Schema: FUSION
-
Object owner: PJF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJF_PRICING_INTG_GT_PK |
CURRENT_RUN_ID, SOURCE_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CURRENT_RUN_ID | NUMBER | 18 | Yes | This is an identifier for a set of records that needs Pricing Integrations. ***** | |
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Yes | Source Transaction Identifier. ***** | |
| PROJECT_TYPE_ID | NUMBER | 18 | Yes | Project Type Identifier ***** | |
| PROJECT_ID | NUMBER | 18 | Yes | Project Identifier ***** | |
| TASK_ID | NUMBER | 18 | Yes | Task Identifier ***** | |
| INCURRED_BY_ORG_ID | NUMBER | 18 | Incurred by organization identifier ***** | ||
| OVERRIDE_TO_ORG_ID | NUMBER | 18 | Override to organization Identifier. It contains organization overrides for a person , and expenditure_category or peson only or organization id and expenditure_category or organization id only. ***** | ||
| EXPENDITURE_BU_ID | NUMBER | 18 | Expenditure Business Unit Identifier. This is used to identify the rates at Expenditure Business Unit Level. ***** | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Expenditure Type Identifier ***** | ||
| TRANSACTION_DATE | DATE | Yes | Transaction Date ***** | ||
| PERSON_ID | NUMBER | 18 | Person Incurring the expenditures for labor transactions ***** | ||
| PERSON_JOB_ID | NUMBER | 18 | Person Job incurring the expenses for labor transactions. ***** | ||
| NL_RES_ORGANIZATION_ID | NUMBER | 18 | Non Labor Resource Organization Identifier ***** | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Non Labor Resource Identifier for misc and usage transactions. ***** | ||
| QUANTITY | NUMBER | Quantity ***** | |||
| RESOURCE_CLASS_TYPE | VARCHAR2 | 30 | RESOURCE_CLASS_TYPE ***** | ||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 20 | System Linkage function associated with a transactions. This will help us to identify labor vs. non labor transactions ***** | ||
| CALC_RAW_COST_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates Raw cost calculation is required, raw cost calculated but currency conversion required, cost calculation not required. Possible Values are:Y - Calculate raw cost and convert cost into the required currency C - Raw cost is available and only currency conversion is required N - Raw cost calculation is not required. Note: Flag pricing not required for reversals of the costed expenditure items. Because cost of these items are reversals of the original items.Flag pricing not required for transaction source that import burden cost from external system. Determine the burden cost for these transactions by pro rating the burden cost for transaction source that import burden cost from external system. Flag pricing not required for BTC summarized transactions. ***** | |
| CALC_IND_COST_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates Burden cost calculation is required, Burden cost is calculated but currency conversion pending, Burden cost calculation is not requiredPossible Values are: Y - Calculate raw cost and convert cost into the required currency C - Raw cost is available and only currency conversion is required N - Raw cost calculation is not required.Note: Flag pricing not required for reversals of the costed expenditure items. Because cost of these items are reversals of the original items.Flag pricing not required for transaction source that import burden cost from external system. Determine the burden cost for these transactions by pro rating the burden cost for transaction source that import burden cost from external system. Flag pricing not required for BTC summarized transactions ***** | |
| CALC_REVENUE_FLAG | VARCHAR2 | 1 | Yes | Calculate Revenue Flag Y - Calculate Revenue N- Revenue Calculation Not Required ***** | |
| COST_CALCULATION_STATUS | VARCHAR2 | 1 | Yes | Cost calculation status. PJO will always pass the value as ??P?? or ??I??P ?? cost calculation pendingI ?? Ignore cost calculationY ?? Cost Calculation successfully completedE ?? Cost calculation error out ***** | |
| REV_CALCULATION_STATUS | VARCHAR2 | 1 | Yes | Revenue amount calculation status. PJO will always pass the value as ??P?? or ??I??P ?? Revenue calculation pendingI ?? Ignore Revenue calculationY ?? Revenue Calculation successfully completedE ?? Revenue calculation error out ***** | |
| COST_REJECTION_CODE | VARCHAR2 | 30 | Cost rejection error ***** | ||
| COST_REJECTION_TYPE | VARCHAR2 | 1 | Type of cost rejection errorR ?? Raw cost calculation failedB - Burden cost calculation FailedC ?? Currency conversion failure ***** | ||
| REVENUE_REJECTION_CODE | VARCHAR2 | 30 | Revenue rejection Code ***** | ||
| REVENUE_REJECTION_TYPE | VARCHAR2 | 1 | Type of Revenue rejection CodeR ?? Revenue calculation failedC ?? Currency conversion failure ***** | ||
| PROJ_MAPPED_JOB_ID | NUMBER | 18 | PROJ_MAPPED_JOB_ID ***** | ||
| COST_RATE_MULTIPLIER | NUMBER | COST_RATE_MULTIPLIER ***** | |||
| COMP_DETAILS_ID | NUMBER | 18 | COMP_DETAILS_ID ***** | ||
| ORG_SCHEDULE_RULE_ID | NUMBER | 18 | ORG_SCHEDULE_RULE_ID ***** | ||
| OT_PROJECT_ID | NUMBER | 18 | OT_PROJECT_ID ***** | ||
| OT_TASK_ID | NUMBER | 18 | OT_TASK_ID ***** | ||
| COST_RATE_SCH_TYPE | VARCHAR2 | 30 | COST_RATE_SCH_TYPE ***** | ||
| RATE_SCHEDULE_NAME | VARCHAR2 | 30 | Rate Schedule Name used for raw cost rate calculations. ***** | ||
| RATE_SCHEDULE_TYPE | VARCHAR2 | 30 | Type Of rate Schedule - valid values are EMPLOYEE, JOB, NON LABOR, RESOURCE CLASS ***** | ||
| COMP_RULE_SET_NAME | VARCHAR2 | 30 | COMP_RULE_SET_NAME ***** | ||
| COSTING_METHOD | VARCHAR2 | 30 | COSTING_METHOD ***** | ||
| OVERRIDE_TYPE | VARCHAR2 | 30 | OVERRIDE_TYPE ***** | ||
| RATE_SCHEDULE_ID | NUMBER | 18 | RATE_SCHEDULE_ID ***** | ||
| RATE_SCHEDULE_LINE_ID | NUMBER | 18 | RATE_SCHEDULE_LINE_ID ***** | ||
| DENOM_RAW_COST | NUMBER | DENOM_RAW_COST ***** | |||
| RAW_COST_RATE | NUMBER | RAW_COST_RATE ***** | |||
| EXP_TYPE_COST_RATE_FLAG | VARCHAR2 | 1 | EXP_TYPE_COST_RATE_FLAG ***** | ||
| COST_MARKUP_PERCNT | NUMBER | COST_MARKUP_PERCNT ***** | |||
| IND_AMT_DISPLAY_METHOD | VARCHAR2 | 1 | IND_AMT_DISPLAY_METHOD ***** | ||
| COST_IND_RATE_SCH_ID | NUMBER | 18 | COST_IND_RATE_SCH_ID ***** | ||
| IND_SCH_NAME | VARCHAR2 | 30 | Burden Schedule Name ***** | ||
| IND_RATE_SCH_TYPE | VARCHAR2 | 1 | IND_RATE_SCH_TYPE ***** | ||
| COST_IND_SCH_FIXED_DATE | DATE | COST_IND_SCH_FIXED_DATE ***** | |||
| IND_STRUCTURE_NAME | VARCHAR2 | 30 | IND_STRUCTURE_NAME ***** | ||
| IND_RATE_SCH_REVISION_ID | NUMBER | 18 | IND_RATE_SCH_REVISION_ID ***** | ||
| COST_BASE | VARCHAR2 | 30 | COST_BASE ***** | ||
| IND_COMPILED_SET_ID | NUMBER | 18 | IND_COMPILED_SET_ID ***** | ||
| COMPILED_MULTIPLIER | NUMBER | COMPILED_MULTIPLIER ***** | |||
| IND_COST_RATE | NUMBER | IND_COST_RATE ***** | |||
| DENOM_BURDENED_COST | NUMBER | DENOM_BURDENED_COST ***** | |||
| PJO_TRANSACTION_TYPE | VARCHAR2 | 30 | PJO_TRANSACTION_TYPE ***** | ||
| RATE_BASED_FLAG | VARCHAR2 | 1 | RATE_BASED_FLAG ***** | ||
| PLANNING_CURRENCY_CODE | VARCHAR2 | 15 | PLANNING_CURRENCY_CODE ***** | ||
| OVERRIDE_CURRENCY_CODE | VARCHAR2 | 15 | OVERRIDE_CURRENCY_CODE ***** | ||
| PLANNING_RATE_TYPE | VARCHAR2 | 30 | Planning Rate Type. This column is used to convert the cost/revenue amount into planning currency. | ||
| PLANNING_RATE_DATE | DATE | Planning Rate date. This column is used to convert the cost/revenue amount into planning currency. | |||
| PLANNING_EXCH_RATE | NUMBER | Planning exchange rate. This column is used to convert the cost/revenue amount into planning currency. | |||
| PLANNING_RAW_COST | NUMBER | PLANNING_RAW_COST ***** | |||
| PLANNING_RAW_COST_RATE | NUMBER | PLANNING_RAW_COST_RATE ***** | |||
| PLANNING_BURDENED_COST | NUMBER | PLANNING_BURDENED_COST ***** | |||
| PLANNING_IND_COST_RATE | NUMBER | PLANNING_IND_COST_RATE ***** | |||
| PLANNING_REVENUE_AMOUNT | NUMBER | PLANNING_REVENUE_AMOUNT ***** | |||
| PLANNING_REVENUE_RATE | NUMBER | PLANNING_REVENUE_RATE ***** | |||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | UNIT_OF_MEASURE ***** | ||
| RES_ASSIGNMENT_ID | NUMBER | 18 | RES_ASSIGNMENT_ID ***** | ||
| RES_CLASS_MARKUP_PERCNT | NUMBER | RES_CLASS_MARKUP_PERCNT ***** | |||
| TXN_COST_FOR_REVENUE | NUMBER | TXN_COST_FOR_REVENUE ***** | |||
| REVENUE_AMOUNT | NUMBER | REVENUE_AMOUNT ***** | |||
| REVENUE_MARKUP_PERCNT | NUMBER | REVENUE_MARKUP_PERCNT ***** | |||
| REVENUE_AMOUNT_RATE | NUMBER | REVENUE_AMOUNT_RATE ***** | |||
| REVENUE_CURRENCY_CODE | VARCHAR2 | 15 | REVENUE_CURRENCY_CODE ***** | ||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | DENOM_CURRENCY_CODE ***** | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | ACCT_CURRENCY_CODE ***** | ||
| ACCT_RATE_DATE | DATE | ACCT_RATE_DATE ***** | |||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | ACCT_RATE_TYPE ***** | ||
| ACCT_RAW_COST | NUMBER | ACCT_RAW_COST ***** | |||
| ACCT_BURDENED_COST | NUMBER | ACCT_BURDENED_COST ***** | |||
| ACCT_COST_EXCH_RATE | NUMBER | ACCT_COST_EXCH_RATE ***** | |||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | PROJECT_CURRENCY_CODE ***** | ||
| PROJECT_RATE_DATE | DATE | PROJECT_RATE_DATE ***** | |||
| PROJECT_REV_RATE_DATE | DATE | PROJECT_REV_RATE_DATE ***** | |||
| PROJECT_RATE_TYPE | VARCHAR2 | 30 | PROJECT_RATE_TYPE ***** | ||
| PROJECT_REV_RATE_TYPE | VARCHAR2 | 30 | PROJECT_REV_RATE_TYPE ***** | ||
| PROJECT_RAW_COST | NUMBER | PROJECT_RAW_COST ***** | |||
| PROJECT_BURDENED_COST | NUMBER | PROJECT_BURDENED_COST ***** | |||
| PROJECT_REV_AMOUNT | NUMBER | PROJECT_REV_AMOUNT ***** | |||
| PROJECT_COST_EXCH_RATE | NUMBER | PROJECT_COST_EXCH_RATE ***** | |||
| PROJECT_REV_EXCH_RATE | NUMBER | PROJECT_REV_EXCH_RATE ***** | |||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | PROJFUNC_CURRENCY_CODE ***** | ||
| PROJFUNC_RATE_DATE | DATE | PROJFUNC_RATE_DATE ***** | |||
| PROJFUNC_REV_RATE_DATE | DATE | PROJFUNC_REV_RATE_DATE ***** | |||
| PROJFUNC_RATE_TYPE | VARCHAR2 | 30 | PROJFUNC_RATE_TYPE ***** | ||
| PROJFUNC_REV_RATE_TYPE | VARCHAR2 | 30 | PROJFUNC_REV_RATE_TYPE ***** | ||
| PROJFUNC_RAW_COST | NUMBER | PROJFUNC_RAW_COST ***** | |||
| PROJFUNC_REV_AMOUNT | NUMBER | PROJFUNC_REV_AMOUNT ***** | |||
| PROJFUNC_BURDENED_COST | NUMBER | PROJFUNC_BURDENED_COST ***** | |||
| PROJFUNC_COST_EXCH_RATE | NUMBER | PROJFUNC_COST_EXCH_RATE ***** | |||
| PROJFUNC_REV_EXCH_RATE | NUMBER | PROJFUNC_REV_EXCH_RATE ***** | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | INVENTORY_ITEM_ID ***** | ||
| MFC_COST_TYPE_ID | NUMBER | 18 | MFC_COST_TYPE_ID ***** | ||
| MFC_COST_SOURCE | VARCHAR2 | 30 | MFC_COST_SOURCE ***** | ||
| ITEM_CATEGORY_ID | NUMBER | 18 | ITEM_CATEGORY_ID ***** | ||
| PROCESS_GROUP_ID | NUMBER | 18 | Process Group Identifier. This is used to identify related transactions in the PATI table. ***** | ||
| BURDEN_COST_FLAG | VARCHAR2 | 1 | Flag that indicates whether costs are burdened for projects of this project type ***** | ||
| LABOR_MULTIPLIER_NAME | VARCHAR2 | 30 | Labor Cost Multiplier Name ***** | ||
| ACCT_EXCH_ROUNDING_LIMIT | NUMBER | Accounted transaction currency conversion rounded amount can not exceed this limit ***** | |||
| MSG_TOKEN_NAME1 | VARCHAR2 | 30 | Rejection message code token name ***** | ||
| MSG_TOKEN_NAME2 | VARCHAR2 | 30 | Rejection message code token name ***** | ||
| MSG_TOKEN_NAME3 | VARCHAR2 | 30 | Rejection message code token name ***** | ||
| MSG_TOKEN_VALUE1 | VARCHAR2 | 2000 | Rejection message code token value ***** | ||
| MSG_TOKEN_VALUE2 | VARCHAR2 | 2000 | Rejection message code token value ***** | ||
| MSG_TOKEN_VALUE3 | VARCHAR2 | 2000 | Rejection message code token value ***** | ||
| GL_DATE | DATE | Accounting Date. This is used for currency conversion based on the Business Unit or projects setup. ***** | |||
| REV_RATE_SCHEDULE_ID | NUMBER | 18 | REV_RATE_SCHEDULE_ID | ||
| IMPORT_COST_ACC_FLAG | VARCHAR2 | 3 | Indicator of a transaction is externally accounted or not.If value is N then the transaction is externally *un*accounted else it is externally accounted. _Possible values :_ None (N) Raw (R) Raw and Burden (RN) Raw and Burdened (RB) Raw, Burden, and Burdened (RNB) | ||
| SOURCE_REFERENCE1 | VARCHAR2 | 120 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE2 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE3 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE4 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE5 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE6 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE7 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE8 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| SOURCE_REFERENCE9 | VARCHAR2 | 30 | Additional information about a transaction in the source application. | ||
| MSG_TOKEN_TYPE1 | VARCHAR2 | 30 | Data type of MSG_TOKEN_VALUE1. | ||
| MSG_TOKEN_TYPE2 | VARCHAR2 | 30 | Data type of MSG_TOKEN_VALUE2. | ||
| MSG_TOKEN_TYPE3 | VARCHAR2 | 30 | Data type of MSG_TOKEN_VALUE3. | ||
| CONTRACT_ID | NUMBER | 18 | Identifier of the award. | ||
| SPONSORED_FLAG | VARCHAR2 | 1 | Indicates that project classified under the project type are sponsored projects. | ||
| IGNORE_AWARD_FLAG | VARCHAR2 | 1 | Indicates that award is ignored for sponsored projects. When the value is 'N', the transaction is not processed because project must be associated to an award. When the value is 'Y', the transaction is processed using project-based burden setup. | ||
| RATE_OVERRIDE_ID | NUMBER | 18 | The identifier of the derived rate override. | ||
| PERIODIC_LINE_START_DATE | DATE | Start date of the resource assignment in the period. | |||
| PERIODIC_LINE_END_DATE | DATE | End date of the resource assignment in the period. | |||
| PARENT_SOURCE_TXN_ID | NUMBER | 18 | Source transaction identifier of the parent resource assignment in the period. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Unique identifier of the project role. |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| PJF_PRICING_INTG_GT_N1 | Non Unique | CURRENT_RUN_ID | Obsolete |
| PJF_PRICING_INTG_GT_N2 | Non Unique | CURRENT_RUN_ID, CALC_IND_COST_FLAG, COST_CALCULATION_STATUS | |
| PJF_PRICING_INTG_GT_N3 | Non Unique | CURRENT_RUN_ID, CALC_REVENUE_FLAG, REV_CALCULATION_STATUS | |
| PJF_PRICING_INTG_GT_N4 | Non Unique | CURRENT_RUN_ID, COST_CALCULATION_STATUS, RESOURCE_CLASS_TYPE | |
| PJF_PRICING_INTG_GT_U1 | Unique | CURRENT_RUN_ID, SOURCE_TRANSACTION_ID |