CN_REPOSITORIES_ALL_B
CN_REPOSITORIES stores default, control, and option information you provide to customize Oracle Sales Compensation to your company's needs. CN_REPOSITORIES corresponds to the System Parameters form.
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CN_REPOSITORIES_ALL_B_PK |
REPOSITORY_ID, ORG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPOSITORY_ID | NUMBER | 18 | Yes | Primary key | |
| CUSTOM_ROLLUP_PROCEDURE | VARCHAR2 | 100 | CUSTOM ROLLUP PL/SQL PROCEDURE NAME | ||
| HR_SUPER_HIERARCHY_DEPTH | NUMBER | 18 | Depth of HR supervisor hierarchy considered by seeded approval flow. | ||
| ANALYST_HIERARCHY_DEPTH | NUMBER | 18 | Depth of analyst hierarchy considered by approval process for the seeded flow. | ||
| CALENDAR_ID | NUMBER | 18 | CALENDAR id. | ||
| PERIOD_TYPE_ID | NUMBER | 18 | Period type id. | ||
| MAX_PMT_APPR_AMT | NUMBER | maximum amount for payment auto approval | |||
| HCM_FETCH_DATE | TIMESTAMP | Indicates the last time participant updates or terminates were fetched from HCM for this Business Unit | |||
| MIN_PMT_APPR_AMT | NUMBER | minimum amount for payment auto approval | |||
| FUNCTIONAL_CURRENCY | VARCHAR2 | 10 | FUNCTIONAL CURRENCY | ||
| PROCESS_CURRENCY | VARCHAR2 | 30 | USED IN TRANSACTION PROCESSING | ||
| CN_CONVERSION_TYPE | NUMBER | 18 | Conversion Type | ||
| COLL_CONV_TYPE | NUMBER | 18 | COLLECTION CONVERSION TYPE | ||
| ENABLE_NEGATIVE_PAY | VARCHAR2 | 1 | ENABLE NEGATIVE PAY | ||
| ANALYST_SECURITY | VARCHAR2 | 20 | Analyst Security by business unit or by participant hierarchy | ||
| PAYMENT_CONV_TYPE | NUMBER | 18 | PAYMENT CONVERSION TYPE | ||
| PAYMENT_DATE_CONV | VARCHAR2 | 240 | DAY ON WHICH CONVERSION SHOULD BE APPLIED WHETHER TRX DATE OR PAYMENT DATE | ||
| RESET_BAL_YEAR | VARCHAR2 | 20 | RESET THE BALANCES EACH YEAR | ||
| CUSTOM_TARGET_INCENTIVE | VARCHAR2 | 10 | CUSTOM_TARGET_INCENTIVE | ||
| CN_CUST_PLAN_COMP_FLAG | VARCHAR2 | 20 | The default value for the CUSTOMIZED_FLAG attribute that will apply to the plan component at the participant plan level. Derived from CN_CUST_PLAN_COMP_OPTION. | ||
| CN_CUST_PLAN_COMP_OPTION | VARCHAR2 | 30 | The default value for the CUSTOMIZED_OPTION attribute that will apply to the plan component at the participant plan level. It will affect any future added plan components. | ||
| CN_COMM_RATE_PRECISION | NUMBER | 18 | Commission Rate Preference | ||
| AUTO_NOTES_PLAN_RULE | VARCHAR2 | 10 | AUTO_NOTES_PLAN_RULE | ||
| PLAN_APPROVAL_STATUS | VARCHAR2 | 20 | PLAN_APPROVAL_STATUS | ||
| PAYSHEETAPPROVAL_STATUS | VARCHAR2 | 20 | PAYSHEET APPROVAL STATUS | ||
| ENABLE_CLASSIFY | VARCHAR2 | 10 | ENALBE CLASSIFICATION | ||
| CLASSIFY_TRANSACTION | VARCHAR2 | 20 | CLASSIFY TRANSACTION | ||
| ENABLE_CREDIT | VARCHAR2 | 20 | ENABLE CREDIT | ||
| SRP_ROLLUP_FLAG | VARCHAR2 | 1 | Flag to indicate whether transactions should rollup the management hierarchy during calculation | ||
| ROLLUP_USING | VARCHAR2 | 240 | ROLLUP USING | ||
| AGGR_TRANS_ROLLUP | VARCHAR2 | 20 | AGGREGATE TRANSACTION ROLLUP | ||
| CN_CUSTOM_AGGR_TRX | VARCHAR2 | 20 | cn_custom_aggr_trx | ||
| CLASSIFY_BATCH_OPTION | VARCHAR2 | 20 | CLASSIFICATION BATCH OPTION | ||
| CLASSIFY_BATCH_SIZE | NUMBER | 18 | CLASSIFICATION BATCH SIZE | ||
| TRX_ROLLUP_METHOD | VARCHAR2 | 30 | Transaction rollup method. | ||
| ROLLUP_BATCH_SIZE | NUMBER | 18 | rollup batch size | ||
| BATCH_RUNNER_STATUS | NUMBER | 18 | BATCH RUNNER STATUS | ||
| PAY_PART_BATCH_SIZE | NUMBER | 18 | PAY PARTICIPANT BATCH SIZE | ||
| PARTICIPANT_BATCH_SIZE | NUMBER | 18 | PARTICIPANT BATCH SIZE | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| 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. | |
| STATUS | VARCHAR2 | 1 | Yes | System status | |
| 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. | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| APPLICATION_ID | NUMBER | 18 | Application unique identifier | ||
| COMMISSION_STATEMENT | VARCHAR2 | 240 | COMMISSION_STATEMENT FOR REPORT | ||
| REPORT_HIERARCHY_ID | NUMBER | 18 | REPORTING HIERARCHY ID | ||
| CN_DISPLAY_DRAW | VARCHAR2 | 240 | CN_DISPLAY_DRAW | ||
| YTD_SUMMARY | VARCHAR2 | 240 | YTD SUMMARY FOR REPORT | ||
| ATTAINMENT_SUMMARY | VARCHAR2 | 240 | ATTAINMENT_SUMMARY FOR REPORT | ||
| CREDIT_DETAILS | VARCHAR2 | 240 | CREDIT DETAILS FOR REPORT | ||
| EARNING_DETAILS | VARCHAR2 | 240 | EARNING DETAILS FOR REPORT | ||
| PAYMENT_DETAILS | VARCHAR2 | 240 | PAYMENT_DETAILS FOR REPORT | ||
| APPLICATION_TYPE | VARCHAR2 | 10 | Not currently used | ||
| REPOSITORY_TYPE | VARCHAR2 | 15 | Not currently used. | ||
| COLL_CAN_TRX_ZERO | VARCHAR2 | 1 | COLL_CAN_TRX_ZERO | ||
| PLAN_IMPORT_RESOLVE | VARCHAR2 | 20 | Column used to resolve the conflict during the import of Compensation Plan | ||
| PLAN_APPROVAL_ENABLE_FLAG | VARCHAR2 | 1 | To indicate status of plan approval feature for the given BU | ||
| DEFAULT_PLAN_DOC_TEMPLATE | VARCHAR2 | 150 | Stores the Plan Document Template Name which would be the default template for all the compensation plans in the BU unless the different template is chosen at the compensation plan level. | ||
| PAYMENT_HOME_CURRENCY_AMOUNT | VARCHAR2 | 30 | Stores option to convert the payment processing amount to the participant currency in effect as of the incentive earning event date or their current home currency. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ROLE_ASGN_REVIEW_NEW | VARCHAR2 | 20 | New participant auto approval | ||
| ROLE_ASGN_REVIEW_OLD | VARCHAR2 | 20 | Existing participant auto approval | ||
| ENABLE_PARTICIPANT_TERMINATE | VARCHAR2 | 1 | Indicates if automated participant termination processing is enabled. | ||
| COMP_END_DATE_PERIOD_OPTIONS | VARCHAR2 | 30 | The lookup code that represents the options for determining the compensation end date period when participants are terminated. | ||
| COMP_END_DATE_PERIOD_COUNT | NUMBER | 18 | The number of periods used to derive the compensation end date when participants are terminated. | ||
| COMP_PLAN_ASSIGN_TERMINATE | VARCHAR2 | 30 | The lookup code that represents how the plan assignment end date is determined when participants are terminated. | ||
| PAYMENT_PLAN_ASSIGN_TERMINATE | VARCHAR2 | 30 | The lookup code that represents how the payment plan assignment end date is determined when participants are terminated. | ||
| TRX_CALC_METHOD | VARCHAR2 | 30 | Specifies the batch processing option to be used for calculation. | ||
| CALC_BATCH_SIZE | NUMBER | 18 | Maximum number of calc batches allowed to run at the same time. | ||
| WORKER_INFORMATION | NUMBER | Will specify the minimum value of the available workers for the organization. This will increase in step value of 1000 across organization . Hence range of available workers will be 1000 | |||
| DISABLE_INCR_CALCULATION | VARCHAR2 | 1 | This flag is used to determine whether Incremental Calc is Runnable for this BU | ||
| ALLOW_FUTURE_DATED_PAYBATCH | VARCHAR2 | 1 | This flag is used to determine whether to allow Future Dated PayBatch Creation for this BU | ||
| PAYMENT_LOOKBACK | VARCHAR2 | 30 | This column is used to determine the option chosen for payment write off. | ||
| PAYSHEET_VISIBILITY | VARCHAR2 | 60 | This column controls the visibility of paysheets to analysts. | ||
| PARALLEL_BU_ID | NUMBER | 18 | Specifies the identifier for org_id used for parallel crediting for creating dynamic indexes. | ||
| CALC_PROCESS_ORDER | VARCHAR2 | 30 | User selection to specify an attribute column in the transaction to order transactions which have the same source_event_date for calculation | ||
| IMP_SRP_FUTURE_HIRE_DATE_FLAG | VARCHAR2 | 1 | This flag is used to determine whether future hire date participants can be imported | ||
| IMP_NUM_DAYS_BEFORE_HIRE_DATE | NUMBER | 4 | This flag is used to determine how many days before the hire date can a participant be imported | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CN_REPOSITORIES_ALL_B | cn_calendars_b | CALENDAR_ID |
| CN_REPOSITORIES_ALL_B | cn_period_types_b | PERIOD_TYPE_ID |
| cn_attribute_config_all | cn_repositories_all_b | ORG_ID |
| cn_repositories_all_tl | cn_repositories_all_b | REPOSITORY_ID, ORG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_REPOSITORIES_ALL_B_U1 | Unique | Default | REPOSITORY_ID, ORG_ID, ORA_SEED_SET1 |
| CN_REPOSITORIES_ALL_B_U11 | Unique | Default | REPOSITORY_ID, ORG_ID, ORA_SEED_SET2 |
| CN_REPOSITORIES_ALL_B_U2 | Unique | Default | ORG_ID, ORA_SEED_SET1 |
| CN_REPOSITORIES_ALL_B_U21 | Unique | Default | ORG_ID, ORA_SEED_SET2 |